Re: [sqlite] PRAGMA table_info could not update schema

On 21 August 2017 at 17:25, Clemens Ladisch wrote: > 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 warni

Re: [sqlite] PRAGMA table_info could not update schema

t: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 sam

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 shell

[sqlite] PRAGMA table_info could not update schema

I find that `PRAGMA table_info(tableName)` will not check the expired schema which is modified by other sqlite connections. 1. Open conn 1 and conn 2. 2. Run a SQL to load the schema for conn 2 3. Change the schema using conn 1 by create-table-statement. 4. Get the schema using conn 2 by table_i