On Thu, 28 Mar 2024 at 04:34, Regina Obe <l...@pcorp.us> wrote: > The issue can be exercised without postgis installed as follows: > > > CREATE TABLE edge_data AS > SELECT i AS edge_id, i + 1 AS start_node, i + 2 As end_node > FROM generate_series(1,10) AS i; > > WITH edge AS ( > SELECT start_node, end_node > FROM edge_data > WHERE edge_id = 1 > ) > SELECT start_node id FROM edge UNION > SELECT end_node FROM edge;
Thanks for the report. There's some discussion about this in [1] along with a proposed way to fix it. The proposed fix does alter the function signature of an important and externally visible planner function, so will be waiting for some feedback on that before moving ahead with fixing. [1] https://www.postgresql.org/message-id/242fc7c6-a8aa-2daf-ac4c-0a231e261...@gmail.com David
