And which commands will check whether the schema is expired. As far as I know, SELECT command will but PRAGMA table_info will not do this.
Original Message Sender:Simon slavinslav...@bigfraud.org Recipient:SQLite mailing listsqlite-us...@mailinglists.sqlite.org Date:Monday, Aug 21, 2017 11:47 Subject:Re: [sqlite] SQLite's Results Are Expired While Schema Is Changed ! On 21 Aug 2017, at 3:22am, sanhua.zh sanhua...@foxmail.com wrote: If so, who or which doc can tell me that which SQL will or will not update the schema ? Commands with CREATE, DROP, or ALTER update schema. Simon. _______________________________________________ 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