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 now see the below explain output with its two Function0 optcodes
where I believe there should only be one.
140 Insert 0 26 15 bifcodes
05
141 Program 12 142 56 program
00
142 ResetCount 0 0 0
00
143 OpenWrite 4 124 0 3
00
144 OpenWrite 5 125 0 k(2,,)
00
145 String8 0 68 0 deltas
00
146 Function0 1 68 64 nextval(1)
01
147 NotNull 64 149 0
00
148 Integer -1 64 0
00
149 MustBeInt 64 0 0
00
150 String8 0 69 0 deltas
00
151 Function0 1 69 65 nextval(1)
01
152 Copy 65 70 0
00
153 Param 8 66 0
00
154 Copy 66 71 0
00
155 String8 0 67 0 update_project
00
156 Copy 67 72 0
00
157 Affinity 65 3 0 DDB
00
158 Program 60 247 73 program
00
--
Mark Lawrence
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
