SQLite Forum

Timeline
Login

6 forum posts by user chrisbrody

2021-09-01
16:02 Reply: Lua db:close deletes WAL file (artifact: 0b93a16e64 user: chrisbrody)

I don't think this pitfall is obvious enough for new users, especially for new users that are using SQLite from multiple languages as in the OP.

I don't even see this info here: https://www.sqlite.org/quirks.html

2021-08-02
17:05 Reply: ALTER TABLE DROP COLUMN corrupts data (artifact: 8f5073c5a9 user: chrisbrody)

FYI it looks to me like this fix was in 3.35.5 as well: https://sqlite.org/releaselog/3_35_5.html

2021-07-27
23:11 Reply: Searching in text columns with Unicode folding (artifact: 524c146fbf user: chrisbrody)

FYI I made a very simple library for a good customer to add EU accent-enabled UPPER and LOWER functions: https://github.com/brodybits/sqlite3-eu

It is possible to use the library to either add separate EU-enabled UPPER & LOWER functions, like UPPER_EU & LOWER_EU, or overwrite the existing UPPER & LOWER functions.

For the sake of Unicode folding beginners like myself, you should be able to do the case-insensitive LIKE condition in a statement like this:

SELECT rowid, name FROM t1 WHERE LOWER_EU(name2) LIKE LOWER_EU(?)
2021-07-24
00:10 Reply: ALTER TABLE DROP COLUMN corrupts data (artifact: 983cc93a48 user: chrisbrody)

Thanks. I am sorry to say that I (still) do not see this info in the 3.36.0 release notes, think it could help someone else know that they should consider using 3.36.0 to get the bug fix.

2021-07-23
23:36 Reply: ALTER TABLE DROP COLUMN corrupts data (artifact: e6a6b862d6 user: chrisbrody)

Thanks. I did not see this info in the SQLite 3.36.0 release notes, and the ticket in https://www.sqlite.org/src/tktview?name=c88f3036a2 seems to be still open. Am I missing anything?

22:31 Reply: ALTER TABLE DROP COLUMN corrupts data (artifact: 6485501bbe user: chrisbrody)

Hello is there anything we can do to help get this resolved?

I would also be grateful if there could be a flag such as SQLITE_OMIT_DROP_COLUMN.

Thanks!