[PostGIS] #5625: gardentester producting invalid SQL, not outputting args to functions

PostGIS trac at osgeo.org
Tue Nov 28 16:59:50 PST 2023


#5625: gardentester producting invalid SQL, not outputting args to functions
--------------------------+---------------------------
 Reporter:  robe          |      Owner:  robe
     Type:  defect        |     Status:  assigned
 Priority:  blocker       |  Milestone:  PostGIS 3.5.0
Component:  QA/testsuite  |    Version:  master
 Keywords:                |
--------------------------+---------------------------
 I think via all the testing the garden tester sql generation got botched.

 It's producing invalid sql such as this:


 {{{
 SELECT ST_AddPoint(, , ) As result, ST_AsText(foo1.the_geom) As ref1_geom,
 ST_AsText(foo2.the_geom) As ref2_geom FROM ((SELECT
 ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j*0.05) As the_geom FROM (SELECT
 a*1.11111111 FROM generate_series(-10,50,10) As a) As i(i) CROSS JOIN
 generate_series(40,70, 20) As j ORDER BY i, i*j, j)) As foo1 CROSS JOIN
 ((SELECT ST_Collect(s.the_geom) As the_geom FROM (SELECT
 ST_MakeLine(ST_SetSRID(ST_MakePointM(i - 0.0821,j +
 0.3036,m),4326),ST_SetSRID(ST_MakePointM(j,i,m),4326)) As the_geom FROM
 generate_series(-71,50,15) As i CROSS JOIN generate_series(50,70, 25) As j
 CROSS JOIN generate_series(1,2) As m WHERE NOT(i = j)) As s)) As foo2
 LIMIT 10;
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5625>
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.


More information about the postgis-tickets mailing list