My previous explain outputs were probably not quite right. With the
following code inside the previously posted trigger:
INSERT INTO deltas(
id,
change_id,
function
)
VALUES(
nextval('deltas'),
NEW.change_id,
'update_project'
);
I
On Mon Nov 20, 2017 at 11:04:01AM +, Hick Gunter wrote:
>
> Can you provide the original SQL (both for the INSERT and the CREATE
> TRIGGER) and the explain output (SQLite byte code, i.e .explain
> followed by explain )?
Here is the trigger code:
CREATE TABLE func_update_project(
I was unable to replicate a double call of the udf using the sql you provided.
Can you provide the original SQL (both for the INSERT and the CREATE TRIGGER)
and the explain output (SQLite byte code, i.e .explain followed by explain
)?
-Ursprüngliche Nachricht-
Von: sqlite-users
3 matches
Mail list logo