What do you want for trigger info?
The following pragma code will return all the data in the currently loaded
schema for all attached databases (table/index/trigger names). It creates a
new pragma called DATABASE_INFO (and table pragme_database_info) that returns
three columns: schema type na
On Thu, Jun 13 2019, Richard Hipp wrote:
> On 6/9/19, Landry Breuil wrote:
>>
>> this broke on sparc64
>>>select 298.2564151;
>> -298.2564151
>>
>
> I cannot reproduce this (perhaps because I do not have access to a
> sparc64 platform running OpenBSD) and do not have any good ideas about
> what m
That is what I use now, together with the select as Hick mentioned.
An other version I played with is two indexes, one unique on (id,
ts_from) to find the last version if eol is not null and one unique on
(id, ts_eol) where eol = null to find the current active version of id.
Beware that in
I trying to reconcile two manually maintained schemas,
one that's custom and drives the database code at runtime,
and another that's the SQLite (DDL) used to instantiate the DBs.
Differences exist, because we humans at not that good at rigour.
These are fairly large and old schemas, > 200 tables,
On 21-6-2019 11:46, Simon Slavin wrote:
> You will note that SQLite is perfectly happy with
>
> CREATE UNIQUE INDEX idx_test_c
>ON test(id, ts_from, ts_eol)
> WHERE ts_eol = NULL
> ;
That is what I use now, together with the select as Hick mentioned.
An other version I played with is two ind
"Expressions in an index may not reference other tables and may not use
subqueries nor functions whose result might change"
max(ts_from) not only depends on every other record in the table, but is also
subject to change dependant on future inserts.
If what you want is a field that contains the
On 21 Jun 2019, at 10:29am, ingo wrote:
> Is this because max() is not deterministic,
> or because current_timestamp is not,
> or both?
The max(). For the reason you identified: it would have to recalculate the
index values for all rows in the table every time any of the rows changed. You
wi
CREATE TABLE test(
id INTEGER NOT NULL,
ts_from TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,
ts_eol TEXT DEFAULT NULL
);
CREATE UNIQUE INDEX idx_test
ON test(id, max(ts_from), ts_eol)
WHERE ts_eol = NULL
;
--Error: misuse of aggregate function max()
Is this because max() is not deter
8 matches
Mail list logo