Artifact
a58e792e607b1e1fb41d06beba7d4a8d8bd0a759d9fd9db85635fab8667d999e:
Ticket change
[a58e792e60]
- Ticket [8d015d929f]
tdbc::sqlite3 driver doesn't resolve duplicate names status still Deferred with 3 other changes
by
kbk
2019-09-13 17:15:05.
D 2019-09-13T17:15:05.870
J icomment You\sgive\sas\sexample\sthe\squery:\r\n\r\n \s \sSELECT\r\n \s \s \s \sfix_date,\r\n \s \s \s \shome.tea_name,\r\n \s \s \s \saway.tea_name\r\n \s \sFROM\r\n \s \sfixtures\r\n \s \sJOIN\r\n \s \steams\sAS\shome\sON\shome.tea_id\s=\sfix_home\r\n \s \sJOIN\r\n \s \steams\sAS\saway\sON\saway.tea_id\s=\sfix_away\r\n\r\nThe\sway\sto\swork\saround\sit\sis\sto\smake\ssure\sthat\sall\sthe\scolumn\snames\sreturned\sare\sdistinct.\r\n\r\n\s\sSELECT\sfix_date,\shome.tea_name\sAS\shometeam,\saway.tea_name\sAS\sawayteam\r\n\s\sFROM\sfixtures\r\n\s\sJOIN\steams\sAS\shome\sON\shome.tea_id\s=\sfix_home\r\n\s\sJOIN\steams\sAS\saway\sON\saway.tea_id\s=\sfix_away\r\n\r\nNow\syou\sdon't\shave\sa\sname\scollision\sand\syou\swon't\shave\sa\sproblem\swith\sone\s'tea_name'\soverwriting\sanother.
J login kbk
J mimetype text/x-fossil-plain
K 8d015d929f6294e2f77e7c580cb86e182f5508b5
U kbk
Z 28de481f4fbb0567026aade41e64a69f
