id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc 5287,Wrong SRID detected for tables having 2 geometric fields,strk,warmerdam,"A query like ""SELECT g1 FROM ( SELECT * FROM mytable ) foo"", with ""mytable"" having two geometries ""g1"" and ""g2"" with different SRIDS, results in ogr2ogr assuming the wrong SRID for the output geometry, which is as a consequence badly transformed to the output projection. It's also been noted that running the query as a user with NO PERMISSION to read ""geometry_columns"" results in the correct SRID being detected. This has been seen with version 1.10.1, I'm still trying to produce a self-contained test. See also #5131 Origin of the bug report: https://github.com/CartoDB/CartoDB-SQL-API/issues/116 ",defect,closed,normal,1.10.2,OGR_SF,1.10.1,normal,fixed,,