It's great idea for reproducing with two command-line shells. Of cource, it can be reproduced with shells and here is the test code.
Note that you should really care the order for running code. ``` Command-line shell 1: $ sqlite3 SQLite version 3.16.0 2016-11-04 19:09:39 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite .open testschema Command-line Shell 2: $ sqlite3 SQLite version 3.16.0 2016-11-04 19:09:39 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite .open testschema sqlite SELECT * FROM sqlite_master; Command-line shell 1: sqlite CREATE TABLE test1 (i INTEGER); sqlite PRAGMA table_info(test1); 0|i|INTEGER|0||0 Command-line shell 2: sqlite PRAGMA table_info(test1); // test1 is already created but can't be reached. sqlite SELECT * FROM sqlite_master; table|test1|test1|2|CREATE TABLE test1 (i INTEGER) sqlite PRAGMA table_info(test1); 0|i|INTEGER|0||0 ``` Original Message Sender:Clemens ladischclem...@ladisch.de Recipient:sqlite-userssqlite-us...@mailinglists.sqlite.org Date:Monday, Aug 21, 2017 17:25 Subject:Re: [sqlite] PRAGMA table_info could not update schema sanhua.zh wrote: I find that `PRAGMA table_info(tableName)` will not check the expired schema which is modified by other sqlite connections. Here is the sample code: That code is incomplete and buggy. (Heed the compiler warnings!) Anyway, I can reproduce this with two command-line shells: 1 2 ============================ ================== select * from sqlite_master; create table t(x); pragma table_info(t); Regards, Clemens _______________________________________________ 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
