Re: [sqlite] Triggers for generated columns?

2019-12-02 Thread Stephen F. Booth
Hi Keith, Thanks for the reply. On Mon, Dec 2, 2019 at 6:31 PM Keith Medcalf wrote: > Well, of course the trigger did not fire. You created an AFTER UPDATE > trigger, but only did an insert. So of course one would not expect the > trigger to fire. You're right- this was a copy/paste error

[sqlite] Triggers for generated columns?

2019-12-02 Thread Stephen F. Booth
I have been trying out generated column support in the 3.31.0 prerelease. Thank you for adding such a useful feature! When I create a trigger for an update of a generated column the trigger is successfully created but it never fires. I could not find any mention in the draft documentation of

Re: [sqlite] Triggers for generated columns?

2019-12-02 Thread Keith Medcalf
On Monday, 2 December, 2019 17:10, Stephen F. Booth wrote: >I have been trying out generated column support in the 3.31.0 prerelease. >Thank you for adding such a useful feature! >When I create a trigger for an update of a generated column the trigger >is successfully created but it never

Re: [sqlite] SIGBUS errors with WAL mode and multiple simultaneous updating clients

2019-12-02 Thread avinash.jha2493
Was this resolved? -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] 1 Writer and 1 Reader in WAL mode in two different processes, but as soon reading is started writer crashes

2019-12-02 Thread avinash.jha2493
The issue appears similar to what was mentioned here: https://github.com/tensorflow/tensorboard/issues/1467 Multiple traces are seen, one of which is as follows: (gdb) bt #0 walRestartLog (pWal=0x2001f78) at sqlite3.c:51561 #1 sqlite3WalFrames (sync_flags=2, isCommit=1, nTruncate=68381,

[sqlite] SQL to SQLIte

2019-12-02 Thread gideon.e
I am having extreme difficulty to convert the above SQL query to SQLite. Can someone please help me. I need to udate the table using the most used text In a column for each row that has the same data. Regards ___ sqlite-users mailing list

Re: [sqlite] SQL to SQLIte

2019-12-02 Thread Simon Slavin
On 2 Dec 2019, at 5:52pm, wrote: > I am having extreme difficulty to convert the above SQL query to SQLite. Please post again, this time with the query. Note that this mailing list strips attachments, so paste the query into your message. ___

Re: [sqlite] SIGBUS errors with WAL mode and multiple simultaneous updating clients

2019-12-02 Thread Richard Hipp
On 12/2/19, avinash.jha2493 wrote: > Was this resolved? What what resolved? There are no known issues in SQLite's WAL mode. In fact, there are no known segfault issues with SQLite. Perhaps there is a problem with tensorflow, but we don't have anything to do with that - you will need to

Re: [sqlite] 1 Writer and 1 Reader in WAL mode in two different processes, but as soon reading is started writer crashes

2019-12-02 Thread Richard Hipp
On 12/2/19, avinash.jha2493 wrote: > > Could someone guide on the next steps, have been playing with pragmas for a > while now, but didn't succeed. > One thing you could do is tell us exactly what version of SQLite you are using so that the line-number information in your stack trace can be

Re: [sqlite] SQL to SQLIte

2019-12-02 Thread Warren Young
On Dec 2, 2019, at 11:22 AM, Simon Slavin wrote: > > Please post again, this time with the query. The table schema might also help: sqlite> .schema TableName ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] 1 Writer and 1 Reader in WAL mode in two different processes, but as soon reading is started writer crashes

2019-12-02 Thread Warren Young
On Dec 2, 2019, at 3:02 AM, avinash.jha2493 wrote: > > The issue appears similar to what was mentioned here: > https://github.com/tensorflow/tensorboard/issues/1467 Yes, and OP posted a reply to his own issue a few days later giving the correct answer: TensorFlow needs to pick one of the two

Re: [sqlite] [EXTERNAL] Slow joining of tables with indexes

2019-12-02 Thread Jonathan Moules
Thanks for the comments. I've done some testing. Results below for those interested. * Unnecessary manual indexes on the Primary Key - good spot, I'd forgotten SQLite does that! * I was indeed using a Hard Disk but that was intentional - this is for customers and I can't know their

[sqlite] Release date of 3.30.1

2019-12-02 Thread tom-sqlite
Hi, The Release date of SQLite 3.30.1 is listed on your website as 2019-10-11, but the SQLite shell, as well as the SQLITE_SOURCE_ID constant, say it is 2019-10-10 20:19:45. Is this a typo on your website? https://sqlite.org/index.html https://sqlite.org/chronology.html SQLite version 3.30.1