On 6/13/2013 8:29 PM, Igor Tandetnik wrote:
The column addition should have failed, unless you are using WAL in which case changes made by the writer are not visible to outstanding readers. A useful test would be to prepare the statement, then get column count (without ever stepping), then add the column, then get column count again. Or alternatively, step then reset then add the column. The bottom line is, schema change should occur while the statement is not active for the experiment to be meaningful.
Actually, I think you need to step once after the change for the statement to realize the schema has changed, and recompile. So the sequence should be:
1. Start with inactive statement (either never stepped, or reset) 2. Get column count 3. Add a column 4. Step once; the statement should recompile at this point 5. Get column count - it should differ from that of step 2. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
