#5625 closed defect (fixed)

gardentester producting invalid SQL, not outputting args to functions

Reported by: robe Owned by: robe
Priority: blocker Milestone: PostGIS 3.5.0
Component: QA/testsuite Version: master
Keywords: Cc:

Description

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;

Change History (1)

comment:1 by Regina Obe <lr@…>, 13 months ago

Resolution: fixed
Status: assignedclosed

In 741f8eb4/git:

FIX FOR gardentest arg inputs

Closes #5625

Note: See TracTickets for help on using tickets.