Works for me building the sqlite3 command line tool from the prerelease snapshot, on both Mac and Windows.
SQLite version 3.15.0 2016-10-12 15:15:30 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .read test.sql select sqlite_source_id(); 2016-10-12 15:15:30 61f0526978af667781c57bcc87510e4524efd0d8 create table i (id integer primary key autoincrement, flags integer); insert into i values (1,1),(2,1),(3,1),(4,1),(5,5),(6,6),(7,4); create table m (id integer); insert into m values (1),(2),(3),(4),(5),(6),(7); SELECT id FROM i WHERE id IN (SELECT id FROM m) ORDER BY flags DESC; 6 5 7 1 2 3 4 SELECT id FROM i WHERE id IN (SELECT id FROM m) ORDER BY flags DESC limit 3; 6 5 7 > On 13/10/2016, at 5:11 AM, Richard Hipp <d...@sqlite.org> wrote: > > On 10/11/16, Keith Medcalf <kmedc...@dessus.com> wrote: >> >> #define SQLITE_ENABLE_EXPLAIN_COMMENTS 1 >> >> makes it work properly. neither NDEBUG nor SQLITE_DEBUG explicitly defined. >> >> Over to Richard ... > > Should now be fixed on trunk and in the latest Prerelease Snapshot at > https://sqlite.org/download.html > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users