sqlite-utils icon indicating copy to clipboard operation
sqlite-utils copied to clipboard

Query with duplicate output column names drop/overwrites duplicate colums

Open andig opened this issue 1 year ago • 0 comments

Consider this join query:

select d1.*, d2.* from delta d1 inner join delta d2 where d1.new==d2.old

This will result in column names from d1, d2 to be duplicated. Unfortunately, running this query via sqlite-utils, only one set of output columns is returned, probably being overridden in the map.

andig avatar Apr 03 '24 09:04 andig