Hello Dr. Hipp,
On Nov 20, 2004, at 02:36, D. Richard Hipp wrote:
To be honest, I'm not sure the test suite checks the case where you explicitly declare ROWID INTEGER PRIMARY KEY. But I did just try this myself and I cannot seem to reproduce the problem. Can anybody else get it to fail?
It's a weird case...
If I use sqlite (the tool), it works fine. In my app, 6 of out 7 tables are created well. But somehow, the 'address' table gets reordered. I received an email from two QuickLite users telling me about that. So this seems to be reproducible.
I'm going to log every time I call CREATE TABLE and I will extract right away the string from sqlite_master. This way it would be a lot clearer. I'll do that right now.
Regards,
-- Tito
