Re: [sqlite] PRAGMA short_column_names ignored when GROUP BY is used
Seems no solution? if use sqlite 3, PRAGMA short_column_name=ON run correctly -- View this message in context: http://sqlite.1065341.n5.nabble.com/PRAGMA-short-column-names-ignored-when-GROUP-BY-is-used-tp22272p75842.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] PRAGMA short_column_names ignored when GROUP BY is used
On 26 May 2014, at 3:06pm, sbmzhcn sbmz...@gmail.com wrote: Seems no solution? if use sqlite 3, PRAGMA short_column_name=ON run correctly Please note that this PRAGMA is deprecated and you should not be creating new code that depends on it. If you want a column to have a specific name then declare the name in your SELECT command: SELECT myCol AS setColName FROM myTable Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] PRAGMA short_column_names ignored when GROUP BY is used
It looks like short_column_names pragma is ignored when GROUP BY is used in a query. Is this considered expected behavior? I hope not.. :-) Thanks, Sam sqlite pragma short_column_names; short_column_names -- 1 sqlite pragma full_column_names; full_column_names - 0 sqlite select u.userid from users u limit 1; UserID -- 1 sqlite select u.userid from users u group by u.userid limit 1; u.userid -- 1 sqlite --- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -