Re: [sqlite] Sqlite3.6 Command-line delete/update not working with large db file(>280GB)

On 13 Oct 2017, at 2:19am, Fiona wrote: > Thanks a lot! Yes, that's the situation. I'm using WHERE clause in my > UPDATE/DELETE sentences, and I'm pretty sure the syntax and my shell are not > the problem, because there has no retrun of error, and I also test the same >

Re: [sqlite] Sqlite3.6 Command-line delete/update not working with large db file(>280GB)

>> This suggests INSERT works but UPDATE and DELETE does not. Is this >> correct ? Thanks a lot! Yes, that's the situation. I'm using WHERE clause in my UPDATE/DELETE sentences, and I'm pretty sure the syntax and my shell are not the problem, because there has no retrun of error, and I also

Re: [sqlite] Sqlite3.6 Command-line delete/update not working with large db file(>280GB)

Could you provide a little more clarification on what you're doing? Are you trying to use the CLI the Python script is doing inserts? When you try to do an update or delete with the CLI does it hang and not complete, or does it happily continue on and let you keep going? If you do ".changes

[sqlite] Possible bug with strftime('%s') < strftime('%s')

This has not much to do with the original question, but as physicist I cannot resist: National institutes (NIST in the US, NPL in the UK, PTB in Germany, to name just a few) provide reference times in UTC, which are distributed nowadays also via the internet, e.g. the NTP protocol. Therefore

Re: [sqlite] [EXTERNAL] Trigger Question

At the bottom of http://www.sqlite.org/lang_createtrigger.html you can find the raise function info and decide which of ignore, rollback, abort or fail works best for you. Descriptions here: http://www.sqlite.org/lang_conflict.html Insert the priority 0 row first, then do something like...

Re: [sqlite] Sqlite3.6 Command-line delete/update not working with large db file(>280GB)

On 12 Oct 2017, at 10:41am, Fiona wrote: > Now I have a db file of about 289GB in size, when I updata/delete with > command-line, the data is not changed/deleted at all, and no error ever > returned, while insert is still working. You say that the data is not changed,

[sqlite] Sqlite3.6 Command-line delete/update not working with large db file(>280GB)

Here is the specifics of my problem: ubuntu, sqlite 3.6.20 I have only two tables, each with primary key and index, I use python code to insert/update these two data, one table have a column with large blob data. Now I have a db file of about 289GB in size, when I updata/delete with

[sqlite] Bug report in sqlite/shell.c:3766 tableColumnList

Hi guys, A bug exists in sqlite/shell.c:3766 tableColumnList in the newest tarball. Here is the url of the proof of concept: https://github.com/Ha0Team/crash-of-sqlite3/blob/master/poc.md Thanks. ___ sqlite-users mailing list

Re: [sqlite] [EXTERNAL] Trigger Question

INSTEAD OF triggers are only allowed on views. From the documentation I would suggest using a BEFORE trigger and calling RAISE() in the trigger program. I expect RAISE(IGNORE) to silently abort the calling statement. -Ursprüngliche Nachricht- Von: sqlite-users

[sqlite] Trigger Question

I'm setting up a resource string to drop, recreate, and repopulate a table to use as a type of default values for colors on the UI. Essentially a default set of priority levels and FG/BG colors associated with that priority color. The table schema is as such: CREATE TABLE [ColorScheme](