[sqlite] Automatic column aliasing, SELECT vs VALUES

2015-06-17 Thread Jean Chevalier
Most interestingly, a case of duplicate column names check that seems to have slipped through the net allowing a table to have three columns named the same, but only if they're empty and the user has used a different delimiter set each time (which by the way is discouraged and we should stick to

[sqlite] Automatic column aliasing, SELECT vs VALUES

2015-06-17 Thread Jean Chevalier
I read that VALUES(expr-list) means the same as SELECT(expr-list), but apparently not with regards to the metadata that's sent out along with the values. If I issue these two commands, in one case I end up with column names "", ":1", ":2" (sequential), and in the other I end up with "1", "2",