[sqlite] Suggestion for syntax enhancement for virtual tables

For creating temporary virtual tables, currently you need to do: CREATE VIRTUAL TABLE temp.t ... Can this syntax be made to work too (similar to creating regular tables)? CREATE VIRTUAL TEMP TABLE t ... or CREATE TEMP VIRTUAL TABLE t ... -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı __

Re: [sqlite] Trigger not working with empty table [reproducible]

On Wed, 31 Dec 2014 22:18:02 -0500 Igor Tandetnik wrote: > Well, the WHEN condition on the trigger is always false when the table > is empty. What else did you expect? > > Perhaps you meant something like > > WHEN new.last_price NOT IN (SELECT last_price ...) Ops, you're right ;). Sor

Re: [sqlite] Trigger not working with empty table [reproducible]

On 12/31/2014 9:48 PM, Dâniel Fraga wrote: 3) create a TRIGGER using INSTEAD OF: CREATE TRIGGER [BTC_BRL-TRIGGER] INSTEAD OF INSERT ON [BTC_BRL-VIEW] WHEN (SELECT last_price FROM [BTC_BRL-VIEW] WHERE last_price != new.last_price) BEGIN INSERT INTO [BTC_BRL] values(new.timestamp,new.las

[sqlite] Trigger not working with empty table [reproducible]

I found a solution to a problem I reported here: http://stackoverflow.com/questions/27711987/sqlite-insert-only-if-price-is-different-from-last-row/ And I notice an SQLite abnormal behaviour (I'm using version 3.8.7.4). Here's how you can reproduce it: 1) create a TABLE a