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] -----------------------------------------------------------------------------