On Fri, 24 May 2013 12:30:58 +0000 (UTC) ven...@intouchmi.com wrote: > I was hoping that by making the exact same query to build a temporary > table, SQLite would go through the same procedure thereby loading the > temp table in the same order that stepping would have generated. If > this hope is faulty, it would be interesting to know why.
By the rules of SQL, a SELECT statement is a table expression. ORDER BY, though, does not yield a table expression; it converts a table expression into a cursor. Only table expressions can be inserted. That makes sense if you consider that tables have no order. Irrespective of SELECT and ORDER BY, if you just inserted the rows one by one in the "right" order, would you expect SELECT to return them in that same order? --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
