Re: [sqlite] PRAGMA short_column_names ignored when GROUP BY is used

2014-05-27 Thread Simon Slavin
On 26 May 2014, at 3:06pm, sbmzhcn 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 th

Re: [sqlite] PRAGMA short_column_names ignored when GROUP BY is used

2014-05-27 Thread sbmzhcn
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] PRAGMA short_column_names ignored when GROUP BY is used

2007-04-17 Thread Samuel R. Neff
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 --