Sorry, in my previous email, I meant to say that my subtype setting is *not* getting preserved when my query includes GROUP BY or ORDER BY.
From: Sharon Casaletto <shar...@tibco.com> Date: Thursday, August 31, 2017 at 6:23 AM To: <sqlite-users@mailinglists.sqlite.org> Cc: Sharon Casaletto <shar...@tibco.com> Subject: sqlite3_value_subtype setting not preserved with GROUP BY or ORDER BY Hi, I've implemented a virtual table and in my xColumn() method I'm using sqlite3_value_subtype() to indicate when my SQLITE_TEXT columns need some different processing when I'm retrieving the columns of my query results. I've found that the subtype setting is getting preserved for some reason when my query includes GROUP BY or ORDER BY. Any ideas why this could be happening? Is this the expected behavior? I'm running SQLite version 3.19.3. Thanks Sharon Casaletto _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
