[version sqlite-snapshot-201711181730]
I am seeing an error when attempting to insert a row with
SQLITE_DEBUG enabled:
assertion "0" failed: file "sqlite3.c", line 72132, function: valueFromExpr
Running "PRAGMA vdbe_addoptrace=ON" immediately before the insert
produces the following
1 Expire 0 0 0 00
2 Halt 0 0 0 00
0 Init 0 1 0 00 Start at 1
1 OpenWrite 0 4 0 00 root=4 iDb=0
2 NewRowid 0 1 0 00 r[1]=rowid
3 Variable 1 2 0 00 r[2]=parameter(1,)
4 Variable 2 3 0 00 r[3]=parameter(2,)
5 Variable 3 4 0 00 r[4]=parameter(3,)
6 Variable 4 5 0 00 r[5]=parameter(4,)
7 Variable 5 6 0 00 r[6]=parameter(5,)
8 Variable 6 7 0 00 r[7]=parameter(6,)
9 Variable 7 9 0 00 r[9]=parameter(7,)
10 Variable 8 10 0 00 r[10]=parameter(8,)
11 Variable 9 11 0 00 r[11]=parameter(9,)
12 HaltIfNull 1299 2 2 00 if r[2]=null halt
13 HaltIfNull 1299 2 3 00 if r[3]=null halt
14 HaltIfNull 1299 2 4 00 if r[4]=null halt
15 HaltIfNull 1299 2 5 00 if r[5]=null halt
16 HaltIfNull 1299 2 6 00 if r[6]=null halt
17 HaltIfNull 1299 2 7 00 if r[7]=null halt
18 HaltIfNull 1299 2 9 00 if r[9]=null halt
19 HaltIfNull 1299 2 10 00 if r[10]=null halt
20 MakeRecord 2 10 12 00 r[12]=mkrec(r[2..11])
21 Insert 0 12 1 00 intkey=r[1] data=r[12]
0 Init 0 1 0 00 Start at 1
CLEAR
PUSH to 1
1 Param 16 2 0 00
2 Param 21 3 0 00
3 Param 12 4 0 00
4 Param 13 5 0 00
5 Param 14 6 0 00
6 Param 15 7 0 00
7 Param 17 8 0 00
8 Param 19 9 0 00
9 Param 20 10 0 00
POP to 0
10 Function0 511 2 1 00 r[1]=func(r[2])
CLEAR
11 OpenWrite 0 111 0 00 root=111 iDb=0
12 OpenWrite 1 115 0 00 root=115 iDb=0
13 Param 16 11 0 00
14 NotNull 11 0 0 00 if r[11]!=NULL goto 0
15 NewRowid 0 11 0 00 r[11]=rowid
16 MustBeInt 11 0 0 00
17 SoftNull 12 0 0 00 r[12]=NULL
18 String8 0 13 0 00 r[13]=''
19 Param 21 14 0 00
20 Param 18 15 0 00
21 NotNull 15 -4 0 00 if r[15]!=NULL goto -4
PUSH to 1
PUSH to 2
22 String8 0 34 0 00 r[34]=''
23 String8 0 35 0 00 r[35]=''
POP to 1
24 Function0 3 34 15 00 r[15]=func(r[34])
POP to 0
25 Param 19 16 0 00
26 Param 20 17 0 00
PUSH to 1
27 String8 0 36 0 00 r[36]=''
28 Param 20 40 0 00
29 Integer 1000 41 0 00 r[41]=1000
30 Divide 41 40 39 00 r[39]=r[40]/r[41]
31 NotNull 39 -5 0 00 if r[39]!=NULL goto -5
PUSH to 2
PUSH to 3
32 String8 0 42 0 00 r[42]=''
33 String8 0 43 0 00 r[43]=''
34 String8 0 44 0 00 r[44]=''
POP to 2
35 Function0 7 42 41 00 r[41]=func(r[42])
PUSH to 3
36 String8 0 45 0 00 r[45]=''
37 String8 0 46 0 00 r[46]=''
POP to 2
38 Function0 3 45 40 00 r[40]=func(r[45])
39 Subtract 40 41 39 00 r[39]=r[41]-r[40]
POP to 1
40 Integer 3600 40 0 00 r[40]=3600
41 Divide 40 39 37 00 r[37]=r[39]/r[40]
42 Cast 37 68 0 00 affinity(r[37])
PUSH to 2
43 Param 20 41 0 00
44 Integer 1000 48 0 00 r[48]=1000
45 Divide 48 41 47 00 r[47]=r[41]/r[48]
46 NotNull 47 -6 0 00 if r[47]!=NULL goto -6
PUSH to 3
PUSH to 4
47 String8 0 49 0 00 r[49]=''
48 String8 0 50 0 00 r[50]=''
49 String8 0 51 0 00 r[51]=''
POP to 3
50 Function0 7 49 48 00 r[48]=func(r[49])
PUSH to 4
51 String8 0 52 0 00 r[52]=''
52 String8 0 53 0 00 r[53]=''
POP to 3
53 Function0 3 52 41 00 r[41]=func(r[52])
54 Subtract 41 48 47 00 r[47]=r[48]-r[41]
POP to 2
POP to 1
55 Function0 1 47 39 00 r[39]=func(r[47])
PUSH to 2
56 Param 20 56 0 00
57 Integer 1000 57 0 00 r[57]=1000
58 Divide 57 56 55 00 r[55]=r[56]/r[57]
59 NotNull 55 -7 0 00 if r[55]!=NULL goto -7
PUSH to 3
PUSH to 4
60 String8 0 58 0 00 r[58]=''
61 String8 0 59 0 00 r[59]=''
62 String8 0 60 0 00 r[60]=''
POP to 3
63 Function0 7 58 57 00 r[57]=func(r[58])
PUSH to 4
64 String8 0 61 0 00 r[61]=''
65 String8 0 62 0 00 r[62]=''
POP to 3
66 Function0 3 61 56 00 r[56]=func(r[61])
67 Subtract 56 57 55 00 r[55]=r[57]-r[56]
POP to 2
POP to 1
68 Function0 1 55 54 00 r[54]=func(r[55])
69 Integer 3600 56 0 00 r[56]=3600
70 Divide 56 54 48 00 r[48]=r[54]/r[56]
71 Cast 48 68 0 00 affinity(r[48])
72 Integer 3600 56 0 00 r[56]=3600
73 Multiply 56 48 41 00 r[41]=r[56]*r[48]
74 Subtract 41 39 40 00 r[40]=r[39]-r[41]
75 Integer 60 41 0 00 r[41]=60
76 Divide 41 40 38 00 r[38]=r[40]/r[41]
POP to 0
77 Function0 7 36 18 00 r[18]=func(r[36])
78 Null 0 19 0 00 r[19]=NULL
79 Integer -1 20 0 00 r[20]=-1
80 Null 0 21 0 00 r[21]=NULL
81 Param 12 22 0 00
82 Param 13 23 0 00
83 Param 14 24 0 00
84 Param 15 25 0 00
85 Null 0 26 0 00 r[26]=NULL
86 Null 0 27 0 00 r[27]=NULL
87 Param 17 28 0 00
88 Null 0 29 0 00 r[29]=NULL
89 Null 0 30 0 00 r[30]=NULL
90 HaltIfNull 1299 2 13 00 if r[13]=null halt
91 HaltIfNull 1299 2 15 00 if r[15]=null halt
92 HaltIfNull 1299 2 16 00 if r[16]=null halt
93 HaltIfNull 1299 2 17 00 if r[17]=null halt
94 HaltIfNull 1299 2 22 00 if r[22]=null halt
95 HaltIfNull 1299 2 23 00 if r[23]=null halt
96 HaltIfNull 1299 2 24 00 if r[24]=null halt
97 HaltIfNull 1299 2 25 00 if r[25]=null halt
98 HaltIfNull 1299 2 28 00 if r[28]=null halt
99 NotNull 20 -9 0 00 if r[20]!=NULL goto -9
PUSH to 1
100 NotNull 21 -8 0 00 if r[21]!=NULL goto -8
POP to 0
PUSH to 1
101 IsNull 20 -10 0 00 if r[20]==NULL goto -10
PUSH to 2
102 IsNull 21 -8 0 00 if r[21]==NULL goto -8
POP to 1
POP to 0
103 Halt 275 2 0 00
104 NotExists 0 -11 11 00 intkey=r[11]
105 Halt 1555 2 0 00
106 Affinity 12 19 0 00 affinity(r[12..30])
107 Null 0 31 0 00 r[31]=NULL
108 String8 0 41 0 00 r[41]=''
109 Eq 41 -12 13 00 if r[13]==r[41] goto -12
110 SCopy 13 32 0 00 r[32]=r[13]
111 IntCopy 11 33 0 00 r[33]=r[11]
112 MakeRecord 32 2 31 00 r[31]=mkrec(r[32..33])
113 NoConflict 1 -12 32 00 key=r[32]
114 Halt 2067 2 0 00
115 IsNull 14 -13 0 00 if r[14]==NULL goto -13
116 SCopy 14 41 0 00 r[41]=r[14]
117 MustBeInt 41 0 0 00
118 Eq 11 -13 41 00 if r[41]==r[11] goto -13
119 OpenRead 2 111 0 00 root=111 iDb=0
120 NotExists 2 0 41 00 intkey=r[41]
121 Goto 0 -13 0 00
122 FkCounter 0 1 0 00 fkctr[0]+=1
123 Close 2 0 0 00
124 IsNull 20 -14 0 00 if r[20]==NULL goto -14
125 SCopy 20 41 0 00 r[41]=r[20]
126 MustBeInt 41 0 0 00
127 OpenRead 3 153 0 00 root=153 iDb=0
128 NotExists 3 0 41 00 intkey=r[41]
129 Goto 0 -14 0 00
130 FkCounter 1 1 0 00 fkctr[1]+=1
131 Close 3 0 0 00
132 FkIfZero 0 0 0 00 if fkctr[0]==0 goto 0
The error looks like it occurs inside a trigger statement. The database
schema is perhaps a bit large for the mailing list, but I'm happy to
email the database directly to the developers if that is useful.
Anything else I can provide to troubleshoot this further?
--
Mark Lawrence
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
