Clemens Ladisch wrote: > Peter Otten wrote: >> select * from (select alpha from demo union all select alpha from demo) >> order by alpha decltype: (null) >> >> select * from (select alpha from demo union all select alpha from demo) >> decltype: custom >> >> Even taking http://sqlite.org/c3ref/column_decltype.html >> """ >> If this statement is a SELECT statement and the Nth column of the >> returned result set of that SELECT is a table column (not an expression >> or subquery) then the declared type of the table column is returned. If >> the Nth column of the result set is an expression or subquery, then a >> NULL pointer is returned. >> """ >> into account I would have expected either NULL or "custom" for both >> queries. > > The first query uses a temporary table for sorting. The column in that > temporary table does not have a declared type. > > The second query returns the values directly from the underlying table > column, so the declared type is also from that table.
Thank you. Is there a way around that limitation? PS: The bug reporter has since confirmed that her code used to work with sqlite 3.3.4. Where can I download historical versions of sqlite to look into that myself? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
