[PostGIS] #5547: postgis 3.4 not using gist index when concatinating string in st_geomfromtext

[PostGIS]

#5547: postgis 3.4 not using gist index when concatinating string in
st_geomfromtext
-------------------------+---------------------------
  Reporter:  tomwlane    |      Owner:  pramsey
      Type:  defect      |     Status:  closed
  Priority:  medium      |  Milestone:  PostGIS 3.3.6
 Component:  postgis     |    Version:  3.4.x
Resolution:  worksforme  |   Keywords:
-------------------------+---------------------------
Changes (by pramsey):

 * status:  new => closed
 * resolution:   => worksforme

Comment:

 {{{
 # explain select count(*) from ldb_000b21a_e where
 st_intersects(st_geomfromtext(concat('POINT(' || 8978052 || ' ' || 2146588
 || ')')), geom);
                                           QUERY PLAN
 ----------------------------------------------------------------------------------------------
  Aggregate  (cost=22.06..22.07 rows=1 width=8)
    ->  Index Scan using geom_x on ldb_000b21a_e  (cost=0.91..22.06 rows=1
 width=0)
          Index Cond: (geom && st_geomfromtext(concat('POINT(8978052
 2146588)'::text)))
          Filter: st_intersects(st_geomfromtext(concat('POINT(8978052
 2146588)'::text)), geom)
 (4 rows)

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5547#comment:8>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.