Error on st_intersects from postgis 3.4.3 upgrade

[lpofredc]

What is the bug or the crash?

When querying db, in some conditions st_union(ARRAY(...)) return a geometry with SRID 0 which raise a postgis Error.

Steps to reproduce the issue

select
	*
from
	(
	select
		obs.*
from
		src_lpodatas.v_c_observations obs
	left join taxonomie.taxref t on
		obs.cd_nom = t.cd_nom
	where
		is_valid
		and ST_intersects(obs.geom,
		(
	select
		ST_union(
			array[ST_transform(ST_PolygonFromText('Polygon ((4.26869195749907782 44.60729476349695943, 4.32826202363760348 44.60671480457767046, 4.32469941884767817 44.57158586432351655, 4.27308307503084706 44.57084020285586234, 4.27308307503084706 44.57084020285586234, 4.26869195749907782 44.60729476349695943))', 4326), 2154)]) as geom ))
		and (type_geom in ('ST_Point', 'ST_MultiPoint')) ) as "subQuery_0"
limit 1
;

Error:
SQL Error [XX000]: ERROR: ST_Intersects: Operation on mixed SRID geometries (Point, 2154) != (Polygon, 0)

Error position:

Versions

QGIS 3.34, Postgis 3.4.3

Supported QGIS version

• I'm running a supported QGIS version according to the official roadmap.

New profile

• I tried with a new QGIS profile

Additional context

No response