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
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.
_
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
--
3 matches
Mail list logo