894 lines
56 KiB
Markdown
894 lines
56 KiB
Markdown
## Summary
|
|
<!--Explain briefly what goes wrong and explain why you believe this is a bug and not the intended behavior of SQLite (if it is not a crash).-->**No review yet**
|
|
|
|
## Minimized query
|
|
|
|
```sql
|
|
.eqp full
|
|
CREATE TABLE T (
|
|
a TEXT,
|
|
b TEXT,
|
|
c REAL
|
|
);
|
|
INSERT INTO T VALUES ('a','b',CAST(1.5 AS BIGINT)), ('a','c',-2.25), ('b','b',4.75);
|
|
SELECT a,
|
|
SUM(CASE WHEN b='b' THEN c ELSE 0 END) AS d,
|
|
SUM(CASE WHEN b='c' THEN c ELSE 0 END) AS e
|
|
FROM T
|
|
GROUP BY a;
|
|
UPDATE T SET a = '' WHERE a BETWEEN 0 AND 100 RETURNING *;
|
|
REINDEX T;
|
|
INSERT OR REPLACE INTO T VALUES ('', 'x', 'x');
|
|
SELECT MAX(c) OVER (PARTITION BY c ORDER BY c RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE NO OTHERS) FROM T;
|
|
DROP TABLE IF EXISTS T;
|
|
ANALYZE;
|
|
```
|
|
|
|
## Actual output
|
|
|
|
```sql
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 28 0 0 Start at 28
|
|
1 ReadCookie 0 3 2 0
|
|
2 If 3 5 0 0
|
|
3 SetCookie 0 2 4 0
|
|
4 SetCookie 0 5 1 0
|
|
5 CreateBtree 0 2 1 0 r[2]=root iDb=0 flags=1
|
|
6 OpenWrite 0 1 0 5 0 root=1 iDb=0
|
|
7 NewRowid 0 1 0 0 r[1]=rowid
|
|
8 Blob 6 3 0 0 r[3]= (len=6)
|
|
9 Insert 0 3 1 8 intkey=r[1] data=r[3]
|
|
10 Close 0 0 0 0
|
|
11 Close 0 0 0 0
|
|
12 Null 0 4 5 0 r[4..5]=NULL
|
|
13 Noop 2 0 4 0
|
|
14 OpenWrite 1 1 0 5 0 root=1 iDb=0; sqlite_master
|
|
15 SeekRowid 1 17 1 0 intkey=r[1]
|
|
16 Rowid 1 5 0 0 r[5]=[P2]=PX rowid of P1
|
|
17 IsNull 5 25 0 0 if r[5]==NULL goto 25
|
|
18 String8 0 6 0 table 0 r[6]='table'
|
|
19 String8 0 7 0 T 0 r[7]='T'
|
|
20 String8 0 8 0 T 0 r[8]='T'
|
|
21 SCopy 2 9 0 0 r[9]=r[2]
|
|
22 String8 0 10 0 CREATE TABLE T (
|
|
a TEXT,
|
|
b TEXT,
|
|
c REAL
|
|
) 0 r[10]='CREATE TABLE T (
|
|
a TEXT,
|
|
b TEXT,
|
|
c REAL
|
|
)'
|
|
23 MakeRecord 6 5 4 BBBDB 0 r[4]=mkrec(r[6..10])
|
|
24 Insert 1 4 5 0 intkey=r[5] data=r[4]
|
|
25 SetCookie 0 1 1 0
|
|
26 ParseSchema 0 0 0 tbl_name='T' AND type!='trigger' 0
|
|
27 Halt 0 0 0 0
|
|
28 Transaction 0 1 0 0 1 usesStmtJournal=1
|
|
29 Goto 0 1 0 0
|
|
QUERY PLAN
|
|
`--SCAN 3 CONSTANT ROWS
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 23 0 0 Start at 23
|
|
1 InitCoroutine 5 16 2 0
|
|
2 String8 0 2 0 a 0 r[2]='a'
|
|
3 String8 0 3 0 b 0 r[3]='b'
|
|
4 Real 0 4 0 1.5 0 r[4]=1.5
|
|
5 Cast 4 68 0 0 affinity(r[4])
|
|
6 Yield 5 0 0 0
|
|
7 String8 0 2 0 a 0 r[2]='a'
|
|
8 String8 0 3 0 c 0 r[3]='c'
|
|
9 Real 0 4 0 -2.25 0 r[4]=-2.25
|
|
10 Yield 5 0 0 0
|
|
11 String8 0 2 0 b 0 r[2]='b'
|
|
12 String8 0 3 0 b 0 r[3]='b'
|
|
13 Real 0 4 0 4.75 0 r[4]=4.75
|
|
14 Yield 5 0 0 0
|
|
15 EndCoroutine 5 0 0 0
|
|
16 OpenWrite 0 2 0 3 0 root=2 iDb=0; T
|
|
17 Yield 5 22 0 0
|
|
18 NewRowid 0 1 0 0 r[1]=rowid
|
|
19 MakeRecord 2 3 6 BBE 0 r[6]=mkrec(r[2..4])
|
|
20 Insert 0 6 1 T 57 intkey=r[1] data=r[6]
|
|
21 Goto 0 17 0 0
|
|
22 Halt 0 0 0 0
|
|
23 Transaction 0 1 1 0 1 usesStmtJournal=0
|
|
24 Goto 0 1 0 0
|
|
QUERY PLAN
|
|
|--SCAN T
|
|
`--USE TEMP B-TREE FOR GROUP BY
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 57 0 0 Start at 57
|
|
1 SorterOpen 1 3 0 k(1,B) 0
|
|
2 Integer 0 7 0 0 r[7]=0; clear abort flag
|
|
3 Null 0 10 10 0 r[10..10]=NULL
|
|
4 Gosub 9 53 0 0
|
|
5 OpenRead 0 2 0 3 0 root=2 iDb=0; T
|
|
6 Rewind 0 14 0 0
|
|
7 Column 0 0 12 0 r[12]=T.a
|
|
8 Column 0 1 13 0 r[13]=T.b
|
|
9 Column 0 2 14 0 r[14]=T.c
|
|
10 RealAffinity 14 0 0 0
|
|
11 MakeRecord 12 3 15 0 r[15]=mkrec(r[12..14])
|
|
12 SorterInsert 1 15 0 0 key=r[15]
|
|
13 Next 0 7 0 1
|
|
14 OpenPseudo 2 15 3 0 3 columns in r[15]
|
|
15 SorterSort 1 56 0 0 GROUP BY sort
|
|
16 SorterData 1 15 2 0 r[15]=data
|
|
17 Column 2 0 11 0 r[11]=[P3]=PX cursor P1 column P2
|
|
18 Compare 10 11 1 k(1,B) 0 r[10] <-> r[11]
|
|
19 Jump 20 24 20 0
|
|
20 Move 11 10 1 0 r[10]=r[11]
|
|
21 Gosub 8 46 0 0 output one row
|
|
22 IfPos 7 56 0 0 if r[7]>0 then r[7]-=0, goto 56; check abort flag
|
|
23 Gosub 9 53 0 0 reset accumulator
|
|
24 Column 2 1 17 0 r[17]=T.b
|
|
25 Ne 18 29 17 BINARY-8 82 if r[17]!=r[18] goto 29
|
|
26 Column 2 2 16 0 r[16]=T.c
|
|
27 RealAffinity 16 0 0 0
|
|
28 Goto 0 30 0 0
|
|
29 Integer 0 16 0 0 r[16]=0
|
|
30 AggStep 0 16 2 sum(1) 1 accum=r[2] step(r[16])
|
|
31 Column 2 1 17 0 r[17]=T.b
|
|
32 Ne 19 36 17 BINARY-8 82 if r[17]!=r[19] goto 36
|
|
33 Column 2 2 16 0 r[16]=T.c
|
|
34 RealAffinity 16 0 0 0
|
|
35 Goto 0 37 0 0
|
|
36 Integer 0 16 0 0 r[16]=0
|
|
37 AggStep 0 16 3 sum(1) 1 accum=r[3] step(r[16])
|
|
38 If 6 40 0 0
|
|
39 Column 2 0 1 0 r[1]=T.a
|
|
40 Integer 1 6 0 0 r[6]=1; indicate data in accumulator
|
|
41 SorterNext 1 16 0 0
|
|
42 Gosub 8 46 0 0 output final row
|
|
43 Goto 0 56 0 0
|
|
44 Integer 1 7 0 0 r[7]=1; set abort flag
|
|
45 Return 8 0 0 0
|
|
46 IfPos 6 48 0 0 if r[6]>0 then r[6]-=0, goto 48; Groupby result generator entry point
|
|
47 Return 8 0 0 0
|
|
48 AggFinal 2 1 0 sum(1) 0 accum=r[2] N=1
|
|
49 AggFinal 3 1 0 sum(1) 0 accum=r[3] N=1
|
|
50 Copy 1 20 2 0 r[20..22]=r[1..3]
|
|
51 ResultRow 20 3 0 0 output=r[20..22]
|
|
52 Return 8 0 0 0 end groupby result generator
|
|
53 Null 0 1 5 0 r[1..5]=NULL
|
|
54 Integer 0 6 0 0 r[6]=0; indicate accumulator empty
|
|
55 Return 9 0 0 0
|
|
56 Halt 0 0 0 0
|
|
57 Transaction 0 0 1 0 1 usesStmtJournal=0
|
|
58 String8 0 18 0 b 0 r[18]='b'
|
|
59 String8 0 19 0 c 0 r[19]='c'
|
|
60 Goto 0 1 0 0
|
|
a|1.0|-2.25
|
|
b|4.75|0
|
|
QUERY PLAN
|
|
`--SCAN T
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 41 0 0 Start at 41
|
|
1 Null 0 1 2 0 r[1..2]=NULL
|
|
2 OpenEphemeral 1 0 1 0 nColumn=0
|
|
3 OpenRead 0 2 0 1 0 root=2 iDb=0; T
|
|
4 Rewind 0 11 0 0
|
|
5 Column 0 0 10 0 r[10]=T.a
|
|
6 Lt 12 10 10 BINARY-8 82 if r[10]<r[12] goto 10
|
|
7 Gt 13 10 10 BINARY-8 82 if r[10]>r[13] goto 10
|
|
8 Rowid 0 2 0 0 r[2]=[P2]=PX rowid of P1
|
|
9 Insert 1 1 2 0 intkey=r[2] data=r[1]
|
|
10 Next 0 5 0 1
|
|
11 OpenWrite 0 2 0 3 0 root=2 iDb=0; T
|
|
12 Rewind 1 33 0 0
|
|
13 Rowid 1 2 0 0 r[2]=[P2]=PX rowid of P1
|
|
14 NotExists 0 32 2 0 intkey=r[2]
|
|
15 Column 0 0 3 0 r[3]=T.a
|
|
16 Column 0 1 4 0 r[4]=T.b
|
|
17 Column 0 2 5 0 r[5]=T.c
|
|
18 RealAffinity 5 0 0 0
|
|
19 Copy 2 6 0 0 r[6]=r[2]
|
|
20 String8 0 7 0 0 r[7]=''
|
|
21 Column 0 1 8 0 r[8]=T.b
|
|
22 Column 0 2 9 0 r[9]=T.c
|
|
23 RealAffinity 9 0 0 0
|
|
24 MakeRecord 7 3 14 BBE 0 r[14]=mkrec(r[7..9])
|
|
25 Insert 0 14 6 T 5 intkey=r[6] data=r[14]
|
|
26 SCopy 7 15 0 0 r[15]=r[7]
|
|
27 SCopy 8 16 0 0 r[16]=r[8]
|
|
28 SCopy 9 17 0 0 r[17]=r[9]
|
|
29 MakeRecord 15 3 18 0 r[18]=mkrec(r[15..17])
|
|
30 NewRowid 3 19 0 0 r[19]=rowid
|
|
31 Insert 3 18 19 0 intkey=r[19] data=r[18]
|
|
32 Next 1 13 0 0
|
|
33 FkCheck 0 0 0 0
|
|
34 Rewind 3 40 0 0
|
|
35 Column 3 0 15 0 r[15]=[P3]=PX cursor P1 column P2
|
|
36 Column 3 1 16 0 r[16]=[P3]=PX cursor P1 column P2
|
|
37 Column 3 2 17 0 r[17]=[P3]=PX cursor P1 column P2
|
|
38 ResultRow 15 3 0 0 output=r[15..17]
|
|
39 Next 3 35 0 0
|
|
40 Halt 0 0 0 0
|
|
41 Transaction 0 1 1 0 1 usesStmtJournal=0
|
|
42 Integer 0 12 0 0 r[12]=0
|
|
43 Integer 100 13 0 0 r[13]=100
|
|
44 OpenEphemeral 3 3 0 0 nColumn=3
|
|
45 Goto 0 1 0 0
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 1 0 0 Start at 1
|
|
1 Halt 0 0 0 0
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 9 0 0 Start at 9
|
|
1 OpenWrite 0 2 0 3 0 root=2 iDb=0; T
|
|
2 String8 0 2 0 0 r[2]=''
|
|
3 String8 0 3 0 x 0 r[3]='x'
|
|
4 String8 0 4 0 x 0 r[4]='x'
|
|
5 NewRowid 0 1 0 0 r[1]=rowid
|
|
6 MakeRecord 2 3 5 BBE 0 r[5]=mkrec(r[2..4])
|
|
7 Insert 0 5 1 T 57 intkey=r[1] data=r[5]
|
|
8 Halt 0 0 0 0
|
|
9 Transaction 0 1 1 0 1 usesStmtJournal=0
|
|
10 Goto 0 1 0 0
|
|
QUERY PLAN
|
|
|--CO-ROUTINE (subquery-2)
|
|
| |--SCAN T
|
|
| `--USE TEMP B-TREE FOR ORDER BY
|
|
`--SCAN (subquery-2)
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 116 0 0 Start at 116
|
|
1 Null 0 1 0 0 r[1]=NULL
|
|
2 InitCoroutine 3 26 3 0 (subquery-2)
|
|
3 SorterOpen 6 6 0 k(2,B,B) 0
|
|
4 OpenRead 0 2 0 3 0 root=2 iDb=0; T
|
|
5 Rewind 0 17 0 0
|
|
6 Column 0 2 6 0 r[6]=T.c
|
|
7 RealAffinity 6 0 0 0
|
|
8 Column 0 2 7 0 r[7]=T.c
|
|
9 RealAffinity 7 0 0 0
|
|
10 Column 0 2 4 0 r[4]=T.c
|
|
11 RealAffinity 4 0 0 0
|
|
12 Column 0 2 5 0 r[5]=T.c
|
|
13 RealAffinity 5 0 0 0
|
|
14 MakeRecord 4 4 9 0 r[9]=mkrec(r[4..7])
|
|
15 SorterInsert 6 9 4 4 0 key=r[9]
|
|
16 Next 0 6 0 1
|
|
17 OpenPseudo 7 10 6 0 6 columns in r[10]
|
|
18 SorterSort 6 25 0 0
|
|
19 SorterData 6 10 7 0 r[10]=data
|
|
20 Column 7 1 8 0 r[8]=[P3]=PX cursor P1 column P2
|
|
21 Column 7 3 7 0 r[7]=[P3]=PX cursor P1 column P2
|
|
22 Column 7 2 6 0 r[6]=[P3]=PX cursor P1 column P2
|
|
23 Yield 3 0 0 0
|
|
24 SorterNext 6 19 0 0
|
|
25 EndCoroutine 3 0 0 0
|
|
26 OpenEphemeral 1 3 0 0 nColumn=3
|
|
27 OpenDup 2 1 0 0
|
|
28 OpenDup 3 1 0 0
|
|
29 OpenDup 4 1 0 0
|
|
30 Null 0 11 11 0 r[11..11]=NULL
|
|
31 Integer 1 12 0 0 r[12]=1
|
|
32 Integer 1 13 0 0 r[13]=1
|
|
33 Integer 0 14 0 0 r[14]=0
|
|
34 OpenDup 8 1 0 0
|
|
35 InitCoroutine 3 0 3 0
|
|
36 Yield 3 68 0 0 next row of
|
|
37 Copy 6 16 0 0 r[16]=r[6]
|
|
38 Copy 7 17 0 0 r[17]=r[7]
|
|
39 Copy 8 18 0 0 r[18]=r[8]
|
|
40 MakeRecord 16 3 19 0 r[19]=mkrec(r[16..18])
|
|
41 Compare 16 11 1 k(1,B) 0 r[16] <-> r[11]
|
|
42 Jump 43 45 43 0
|
|
43 Gosub 25 69 0 0 call flush_partition
|
|
44 Copy 16 11 0 0 r[11]=r[16]
|
|
45 NewRowid 2 20 0 0 r[20]=rowid
|
|
46 Insert 2 19 20 0 intkey=r[20] data=r[19]
|
|
47 Ne 12 57 20 0 if r[20]!=r[12] goto 57
|
|
48 Null 0 1 0 0 r[1]=NULL
|
|
49 Rewind 3 1 0 0
|
|
50 Rewind 1 1 0 0
|
|
51 Rewind 4 1 0 0
|
|
52 Copy 17 21 0 0 r[21]=r[17]
|
|
53 Copy 21 22 0 0 r[22]=r[21]
|
|
54 Copy 21 23 0 0 r[23]=r[21]
|
|
55 Copy 21 24 0 0 r[24]=r[21]
|
|
56 Goto 0 67 0 0
|
|
57 Compare 21 17 1 k(1,B) 0 r[21] <-> r[17]
|
|
58 Jump 59 67 59 0
|
|
59 Copy 17 21 0 0 r[21]=r[17]
|
|
60 AddImm 14 1 0 0 r[14]=r[14]+1
|
|
61 Next 4 63 0 0
|
|
62 Goto 0 67 0 0
|
|
63 Column 4 1 27 0 r[27]=[P3]=PX cursor P1 column P2
|
|
64 Compare 24 27 1 k(1,B) 0 r[24] <-> r[27]
|
|
65 Jump 66 60 66 0
|
|
66 Copy 27 24 0 0 r[24]=r[27]
|
|
67 Goto 0 36 0 0
|
|
68 Integer 109 25 0 0 r[25]=109
|
|
69 Rewind 2 106 0 0
|
|
70 AddImm 14 1 0 0 r[14]=r[14]+1
|
|
71 Next 4 73 0 0
|
|
72 Goto 0 77 0 0
|
|
73 Column 4 1 27 0 r[27]=[P3]=PX cursor P1 column P2
|
|
74 Compare 24 27 1 k(1,B) 0 r[24] <-> r[27]
|
|
75 Jump 76 70 76 0
|
|
76 Copy 27 24 0 0 r[24]=r[27]
|
|
77 Rowid 1 27 0 0 r[27]=[P2]=PX rowid of P1
|
|
78 Column 1 1 29 0 r[29]=[P3]=PX cursor P1 column P2
|
|
79 Null 0 1 0 0 r[1]=NULL
|
|
80 SeekGE 8 87 13 0 key=r[13]
|
|
81 Rowid 8 28 0 0 r[28]=[P2]=PX rowid of P1
|
|
82 Gt 14 87 28 0 if r[28]>r[14] goto 87
|
|
83 Column 8 2 26 0 r[26]=[P3]=PX cursor P1 column P2
|
|
84 CollSeq 0 0 0 BINARY-8 0
|
|
85 AggStep 0 26 1 max(1) 1 accum=r[1] step(r[26])
|
|
86 Next 8 81 0 0
|
|
87 AggFinal 1 1 0 max(1) 0 accum=r[1] N=1
|
|
88 Copy 1 2 0 0 r[2]=r[1]
|
|
89 Null 0 1 0 0 r[1]=NULL
|
|
90 Gosub 15 111 0 0
|
|
91 Next 1 93 0 0
|
|
92 Goto 0 106 0 0
|
|
93 Column 1 1 29 0 r[29]=[P3]=PX cursor P1 column P2
|
|
94 Compare 23 29 1 k(1,B) 0 r[23] <-> r[29]
|
|
95 Jump 96 77 96 0
|
|
96 Copy 29 23 0 0 r[23]=r[29]
|
|
97 AddImm 13 1 0 0 r[13]=r[13]+1
|
|
98 Delete 3 0 0 2
|
|
99 Next 3 101 0 0
|
|
100 Goto 0 105 0 0
|
|
101 Column 3 1 29 0 r[29]=[P3]=PX cursor P1 column P2
|
|
102 Compare 22 29 1 k(1,B) 0 r[22] <-> r[29]
|
|
103 Jump 104 97 104 0
|
|
104 Copy 29 22 0 0 r[22]=r[29]
|
|
105 Goto 0 77 0 0
|
|
106 ResetSorter 1 0 0 0
|
|
107 Integer 1 13 0 0 r[13]=1
|
|
108 Integer 0 14 0 0 r[14]=0
|
|
109 Return 25 0 0 0
|
|
110 Goto 0 115 0 0
|
|
111 Noop 0 0 0 0 inner-loop subroutine
|
|
112 Copy 2 31 0 0 r[31]=r[2]
|
|
113 ResultRow 31 1 0 0 output=r[31]
|
|
114 Return 15 0 0 0 end inner-loop subroutine
|
|
115 Halt 0 0 0 0
|
|
116 Transaction 0 0 1 0 1 usesStmtJournal=0
|
|
117 Goto 0 1 0 0
|
|
-2.25
|
|
1.0
|
|
4.75
|
|
x
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 37 0 0 Start at 37
|
|
1 Null 0 1 0 0 r[1]=NULL
|
|
2 OpenWrite 0 1 0 5 0 root=1 iDb=0; sqlite_master
|
|
3 Rewind 0 11 0 0
|
|
4 Column 0 2 2 0 r[2]=sqlite_master.tbl_name
|
|
5 Ne 3 10 2 BINARY-8 82 if r[2]!=r[3] goto 10
|
|
6 Column 0 0 2 0 r[2]=sqlite_master.type
|
|
7 Eq 4 10 2 BINARY-8 82 if r[2]==r[4] goto 10
|
|
8 Rowid 0 5 0 0 r[5]=sqlite_master.rowid
|
|
9 Delete 0 0 0 2
|
|
10 Next 0 4 0 1
|
|
11 Destroy 2 2 0 0
|
|
12 Null 0 6 7 0 r[6..7]=NULL
|
|
13 OpenEphemeral 2 0 6 0 nColumn=0
|
|
14 IfNot 2 22 1 0
|
|
15 OpenRead 1 1 0 4 0 root=1 iDb=0; sqlite_master
|
|
16 Rewind 1 22 0 0
|
|
17 Column 1 3 13 0 r[13]=sqlite_master.rootpage
|
|
18 Ne 2 21 13 BINARY-8 84 if r[13]!=r[2] goto 21
|
|
19 Rowid 1 7 0 0 r[7]=[P2]=PX rowid of P1
|
|
20 Insert 2 6 7 0 intkey=r[7] data=r[6]
|
|
21 Next 1 17 0 1
|
|
22 OpenWrite 1 1 0 5 0 root=1 iDb=0; sqlite_master
|
|
23 Rewind 2 34 0 0
|
|
24 Rowid 2 7 0 0 r[7]=[P2]=PX rowid of P1
|
|
25 NotExists 1 33 7 0 intkey=r[7]
|
|
26 Column 1 0 8 0 r[8]=sqlite_master.type
|
|
27 Column 1 1 9 0 r[9]=sqlite_master.name
|
|
28 Column 1 2 10 0 r[10]=sqlite_master.tbl_name
|
|
29 Integer 2 11 0 0 r[11]=2
|
|
30 Column 1 4 12 0 r[12]=sqlite_master.sql
|
|
31 MakeRecord 8 5 15 BBBDB 0 r[15]=mkrec(r[8..12])
|
|
32 Insert 1 15 7 0 intkey=r[7] data=r[15]
|
|
33 Next 2 24 0 0
|
|
34 DropTable 0 0 0 T 0
|
|
35 SetCookie 0 1 2 0
|
|
36 Halt 0 0 0 0
|
|
37 Transaction 0 1 1 0 1 usesStmtJournal=1
|
|
38 String8 0 3 0 T 0 r[3]='T'
|
|
39 String8 0 4 0 trigger 0 r[4]='trigger'
|
|
40 Goto 0 1 0 0
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 31 0 0 Start at 31
|
|
1 ReadCookie 0 3 2 0
|
|
2 If 3 5 0 0
|
|
3 SetCookie 0 2 4 0
|
|
4 SetCookie 0 5 1 0
|
|
5 CreateBtree 0 2 1 0 r[2]=root iDb=0 flags=1
|
|
6 OpenWrite 0 1 0 5 0 root=1 iDb=0
|
|
7 NewRowid 0 1 0 0 r[1]=rowid
|
|
8 Blob 6 3 0 0 r[3]= (len=6)
|
|
9 Insert 0 3 1 8 intkey=r[1] data=r[3]
|
|
10 Close 0 0 0 0
|
|
11 Close 0 0 0 0
|
|
12 Null 0 4 5 0 r[4..5]=NULL
|
|
13 Noop 4 0 4 0
|
|
14 OpenWrite 3 1 0 5 0 root=1 iDb=0; sqlite_master
|
|
15 SeekRowid 3 17 1 0 intkey=r[1]
|
|
16 Rowid 3 5 0 0 r[5]=[P2]=PX rowid of P1
|
|
17 IsNull 5 25 0 0 if r[5]==NULL goto 25
|
|
18 String8 0 6 0 table 0 r[6]='table'
|
|
19 String8 0 7 0 sqlite_stat1 0 r[7]='sqlite_stat1'
|
|
20 String8 0 8 0 sqlite_stat1 0 r[8]='sqlite_stat1'
|
|
21 SCopy 2 9 0 0 r[9]=r[2]
|
|
22 String8 0 10 0 CREATE TABLE sqlite_stat1(tbl,idx,stat) 0 r[10]='CREATE TABLE sqlite_stat1(tbl,idx,stat)'
|
|
23 MakeRecord 6 5 4 BBBDB 0 r[4]=mkrec(r[6..10])
|
|
24 Insert 3 4 5 0 intkey=r[5] data=r[4]
|
|
25 SetCookie 0 1 3 0
|
|
26 ParseSchema 0 0 0 tbl_name='sqlite_stat1' AND type!='trigger' 0
|
|
27 OpenWrite 0 2 0 3 16 root=2 iDb=0; sqlite_stat1
|
|
28 LoadAnalysis 0 0 0 0
|
|
29 Expire 0 0 0 0
|
|
30 Halt 0 0 0 0
|
|
31 Transaction 0 1 2 0 1 usesStmtJournal=1
|
|
32 Goto 0 1 0 0
|
|
```
|
|
|
|
## Expectation
|
|
|
|
```sql
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 28 0 0 Start at 28
|
|
1 ReadCookie 0 3 2 0
|
|
2 If 3 5 0 0
|
|
3 SetCookie 0 2 4 0
|
|
4 SetCookie 0 5 1 0
|
|
5 CreateBtree 0 2 1 0 r[2]=root iDb=0 flags=1
|
|
6 OpenWrite 0 1 0 5 0 root=1 iDb=0
|
|
7 NewRowid 0 1 0 0 r[1]=rowid
|
|
8 Blob 6 3 0 0 r[3]= (len=6)
|
|
9 Insert 0 3 1 8 intkey=r[1] data=r[3]
|
|
10 Close 0 0 0 0
|
|
11 Close 0 0 0 0
|
|
12 Null 0 4 5 0 r[4..5]=NULL
|
|
13 Noop 2 0 4 0
|
|
14 OpenWrite 1 1 0 5 0 root=1 iDb=0; sqlite_master
|
|
15 SeekRowid 1 17 1 0 intkey=r[1]
|
|
16 Rowid 1 5 0 0 r[5]= rowid of 1
|
|
17 IsNull 5 25 0 0 if r[5]==NULL goto 25
|
|
18 String8 0 6 0 table 0 r[6]='table'
|
|
19 String8 0 7 0 T 0 r[7]='T'
|
|
20 String8 0 8 0 T 0 r[8]='T'
|
|
21 Copy 2 9 0 0 r[9]=r[2]
|
|
22 String8 0 10 0 CREATE TABLE T (
|
|
a TEXT,
|
|
b TEXT,
|
|
c REAL
|
|
) 0 r[10]='CREATE TABLE T (
|
|
a TEXT,
|
|
b TEXT,
|
|
c REAL
|
|
)'
|
|
23 MakeRecord 6 5 4 BBBDB 0 r[4]=mkrec(r[6..10])
|
|
24 Insert 1 4 5 0 intkey=r[5] data=r[4]
|
|
25 SetCookie 0 1 1 0
|
|
26 ParseSchema 0 0 0 tbl_name='T' AND type!='trigger' 0
|
|
27 Halt 0 0 0 0
|
|
28 Transaction 0 1 0 0 1 usesStmtJournal=1
|
|
29 Goto 0 1 0 0
|
|
QUERY PLAN
|
|
`--COMPOUND QUERY
|
|
|--LEFT-MOST SUBQUERY
|
|
| `--SCAN CONSTANT ROW
|
|
`--UNION ALL
|
|
`--SCAN 2-ROW VALUES CLAUSE
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 37 0 0 Start at 37
|
|
1 InitCoroutine 1 11 2 0
|
|
2 String8 0 4 0 a 0 r[4]='a'
|
|
3 String8 0 5 0 c 0 r[5]='c'
|
|
4 Real 0 6 0 -2.25 0 r[6]=-2.25
|
|
5 Yield 1 0 0 0
|
|
6 String8 0 4 0 b 0 r[4]='b'
|
|
7 String8 0 5 0 b 0 r[5]='b'
|
|
8 Real 0 6 0 4.75 0 r[6]=4.75
|
|
9 Yield 1 0 0 0
|
|
10 EndCoroutine 1 0 0 0
|
|
11 InitCoroutine 14 30 12 0
|
|
12 Explain 12 0 0 COMPOUND QUERY 0
|
|
13 Explain 13 12 0 LEFT-MOST SUBQUERY 0
|
|
14 Explain 14 13 0 SCAN CONSTANT ROW 0
|
|
15 String8 0 11 0 a 0 r[11]='a'
|
|
16 String8 0 12 0 b 0 r[12]='b'
|
|
17 Real 0 13 0 1.5 0 r[13]=1.5
|
|
18 Cast 13 68 0 0 affinity(r[13])
|
|
19 Yield 14 0 0 0
|
|
20 Explain 20 12 0 UNION ALL 0
|
|
21 Explain 21 20 216 SCAN 2-ROW VALUES CLAUSE 0
|
|
22 InitCoroutine 1 0 2 0
|
|
23 Yield 1 29 0 0 next row of 2-ROW VALUES CLAUSE
|
|
24 Copy 4 11 0 2 r[11]=r[4]
|
|
25 Copy 5 12 0 2 r[12]=r[5]
|
|
26 Copy 6 13 0 2 r[13]=r[6]
|
|
27 Yield 14 0 0 0
|
|
28 Goto 0 23 0 0
|
|
29 EndCoroutine 14 0 0 0
|
|
30 OpenWrite 1 2 0 3 0 root=2 iDb=0; T
|
|
31 Yield 14 36 0 0
|
|
32 NewRowid 1 10 0 0 r[10]=rowid
|
|
33 MakeRecord 11 3 15 BBE 0 r[15]=mkrec(r[11..13])
|
|
34 Insert 1 15 10 T 57 intkey=r[10] data=r[15]
|
|
35 Goto 0 31 0 0
|
|
36 Halt 0 0 0 0
|
|
37 Transaction 0 1 1 0 1 usesStmtJournal=0
|
|
38 Goto 0 1 0 0
|
|
QUERY PLAN
|
|
|--SCAN T
|
|
`--USE TEMP B-TREE FOR GROUP BY
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 60 0 0 Start at 60
|
|
1 SorterOpen 1 3 0 k(1,B) 0
|
|
2 Integer 0 2 0 0 r[2]=0; clear abort flag
|
|
3 Null 0 5 5 0 r[5..5]=NULL
|
|
4 Gosub 4 56 0 0
|
|
5 OpenRead 0 2 0 3 0 root=2 iDb=0; T
|
|
6 Explain 6 0 216 SCAN T 0
|
|
7 Rewind 0 16 0 0
|
|
8 Explain 8 0 0 USE TEMP B-TREE FOR GROUP BY 0
|
|
9 Column 0 0 12 0 r[12]= cursor 0 column 0
|
|
10 Column 0 1 13 0 r[13]= cursor 0 column 1
|
|
11 Column 0 2 14 0 r[14]= cursor 0 column 2
|
|
12 RealAffinity 14 0 0 0
|
|
13 MakeRecord 12 3 15 0 r[15]=mkrec(r[12..14])
|
|
14 SorterInsert 1 15 0 0 key=r[15]
|
|
15 Next 0 8 0 1
|
|
16 OpenPseudo 2 15 3 0 3 columns in r[15]
|
|
17 SorterSort 1 59 0 0 GROUP BY sort
|
|
18 SorterData 1 15 2 0 r[15]=data
|
|
19 Column 2 0 6 0 r[6]= cursor 2 column 0
|
|
20 Compare 5 6 1 k(1,B) 0 r[5] <-> r[6]
|
|
21 Jump 22 26 22 0
|
|
22 Gosub 3 48 0 0 output one row of 1
|
|
23 Move 6 5 1 0 r[5]=r[6]
|
|
24 IfPos 2 59 0 0 if r[2]>0 then r[2]-=0, goto 59; check abort flag
|
|
25 Gosub 4 56 0 0 reset accumulator 1
|
|
26 Column 2 1 17 0 r[17]=T.b
|
|
27 Ne 18 31 17 BINARY-8 82 if r[17]!=r[18] goto 31
|
|
28 Column 2 2 16 0 r[16]=T.c
|
|
29 RealAffinity 16 0 0 0
|
|
30 Goto 0 32 0 0
|
|
31 Integer 0 16 0 0 r[16]=0
|
|
32 AggStep 0 16 10 sum(1) 1 accum=r[10] step(r[16])
|
|
33 Column 2 1 17 0 r[17]=T.b
|
|
34 Ne 19 38 17 BINARY-8 82 if r[17]!=r[19] goto 38
|
|
35 Column 2 2 16 0 r[16]=T.c
|
|
36 RealAffinity 16 0 0 0
|
|
37 Goto 0 39 0 0
|
|
38 Integer 0 16 0 0 r[16]=0
|
|
39 AggStep 0 16 11 sum(1) 1 accum=r[11] step(r[16])
|
|
40 If 1 42 0 0
|
|
41 Column 2 0 7 0 r[7]=T.a
|
|
42 Integer 1 1 0 0 r[1]=1; indicate data in accumulator 1
|
|
43 SorterNext 1 18 0 0
|
|
44 Gosub 3 48 0 0 output final row of 1
|
|
45 Goto 0 59 0 0
|
|
46 Integer 1 2 0 0 r[2]=1; set abort flag
|
|
47 Return 3 0 0 0
|
|
48 IfPos 1 50 0 0 if r[1]>0 then r[1]-=0, goto 50; Groupby result generator entry point 1
|
|
49 Return 3 0 0 0
|
|
50 AggFinal 10 1 0 sum(1) 0 accum=r[10] N=1
|
|
51 AggFinal 11 1 0 sum(1) 0 accum=r[11] N=1
|
|
52 Copy 7 20 0 0 r[20]=r[7]
|
|
53 Copy 10 21 1 0 r[21..22]=r[10..11]
|
|
54 ResultRow 20 3 0 0 output=r[20..22]
|
|
55 Return 3 0 0 0 end groupby result generator 1
|
|
56 Null 0 7 11 0 r[7..11]=NULL
|
|
57 Integer 0 1 0 0 r[1]=0; indicate accumulator 1 empty
|
|
58 Return 4 0 0 0
|
|
59 Halt 0 0 0 0
|
|
60 Transaction 0 0 1 0 1 usesStmtJournal=0
|
|
61 Null 0 5 5 0 r[5..5]=NULL
|
|
62 String8 0 18 0 b 0 r[18]='b'
|
|
63 String8 0 19 0 c 0 r[19]='c'
|
|
64 Goto 0 1 0 0
|
|
a|1.0|-2.25
|
|
b|4.75|0
|
|
QUERY PLAN
|
|
`--SCAN T
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 43 0 0 Start at 43
|
|
1 Null 0 1 2 0 r[1..2]=NULL
|
|
2 OpenEphemeral 1 0 1 0 nColumn=0
|
|
3 OpenRead 0 2 0 1 0 root=2 iDb=0; T
|
|
4 Explain 4 0 216 SCAN T 0
|
|
5 Rewind 0 12 0 0
|
|
6 Column 0 0 10 0 r[10]= cursor 0 column 0
|
|
7 Lt 12 11 10 BINARY-8 82 if r[10]<r[12] goto 11
|
|
8 Gt 13 11 10 BINARY-8 82 if r[10]>r[13] goto 11
|
|
9 Rowid 0 2 0 0 r[2]= rowid of 0
|
|
10 Insert 1 1 2 0 intkey=r[2] data=r[1]
|
|
11 Next 0 6 0 1
|
|
12 OpenWrite 0 2 0 3 0 root=2 iDb=0; T
|
|
13 Rewind 1 35 0 0
|
|
14 Rowid 1 2 0 0 r[2]= rowid of 1
|
|
15 NotExists 0 34 2 0 intkey=r[2]
|
|
16 Column 0 0 3 0 r[3]= cursor 0 column 0
|
|
17 Column 0 1 4 0 r[4]= cursor 0 column 1
|
|
18 Column 0 2 5 0 r[5]= cursor 0 column 2
|
|
19 RealAffinity 5 0 0 0
|
|
20 Copy 2 6 0 0 r[6]=r[2]
|
|
21 String8 0 7 0 0 r[7]=''
|
|
22 Column 0 1 8 0 r[8]= cursor 0 column 1
|
|
23 Column 0 2 9 0 r[9]= cursor 0 column 2
|
|
24 RealAffinity 9 0 0 0
|
|
25 MakeRecord 7 3 14 BBE 0 r[14]=mkrec(r[7..9])
|
|
26 Insert 0 14 6 T 5 intkey=r[6] data=r[14]
|
|
27 Copy 7 15 0 0 r[15]=r[7]
|
|
28 Copy 8 16 0 0 r[16]=r[8]
|
|
29 Copy 9 17 0 0 r[17]=r[9]
|
|
30 RealAffinity 17 0 0 0
|
|
31 MakeRecord 15 3 18 0 r[18]=mkrec(r[15..17])
|
|
32 NewRowid 3 19 0 0 r[19]=rowid
|
|
33 Insert 3 18 19 0 intkey=r[19] data=r[18]
|
|
34 Next 1 14 0 0
|
|
35 FkCheck 0 0 0 0
|
|
36 Rewind 3 42 0 0
|
|
37 Column 3 0 15 0 r[15]= cursor 3 column 0
|
|
38 Column 3 1 16 0 r[16]= cursor 3 column 1
|
|
39 Column 3 2 17 0 r[17]= cursor 3 column 2
|
|
40 ResultRow 15 3 0 0 output=r[15..17]
|
|
41 Next 3 37 0 0
|
|
42 Halt 0 0 0 0
|
|
43 Transaction 0 1 1 0 1 usesStmtJournal=0
|
|
44 Integer 0 12 0 0 r[12]=0
|
|
45 Integer 100 13 0 0 r[13]=100
|
|
46 OpenEphemeral 3 3 0 0 nColumn=3
|
|
47 Goto 0 1 0 0
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 2 0 0 Start at 2
|
|
1 Halt 0 0 0 0
|
|
2 Goto 0 1 0 0
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 9 0 0 Start at 9
|
|
1 OpenWrite 0 2 0 3 0 root=2 iDb=0; T
|
|
2 String8 0 2 0 0 r[2]=''
|
|
3 String8 0 3 0 x 0 r[3]='x'
|
|
4 String8 0 4 0 x 0 r[4]='x'
|
|
5 NewRowid 0 1 0 0 r[1]=rowid
|
|
6 MakeRecord 2 3 5 BBE 0 r[5]=mkrec(r[2..4])
|
|
7 Insert 0 5 1 T 57 intkey=r[1] data=r[5]
|
|
8 Halt 0 0 0 0
|
|
9 Transaction 0 1 1 0 1 usesStmtJournal=0
|
|
10 Goto 0 1 0 0
|
|
QUERY PLAN
|
|
|--CO-ROUTINE (subquery-2)
|
|
| |--SCAN T
|
|
| `--USE TEMP B-TREE FOR ORDER BY
|
|
`--SCAN (subquery-2)
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 120 0 0 Start at 120
|
|
1 Null 0 1 0 0 r[1]=NULL
|
|
2 InitCoroutine 3 29 3 0 (subquery-2)
|
|
3 Explain 3 0 0 CO-ROUTINE (subquery-2) 0
|
|
4 SorterOpen 6 6 0 k(2,B,B) 0
|
|
5 OpenRead 0 2 0 3 0 root=2 iDb=0; T
|
|
6 Explain 6 3 216 SCAN T 0
|
|
7 Rewind 0 19 0 0
|
|
8 Column 0 2 6 0 r[6]= cursor 0 column 2
|
|
9 RealAffinity 6 0 0 0
|
|
10 Column 0 2 7 0 r[7]= cursor 0 column 2
|
|
11 RealAffinity 7 0 0 0
|
|
12 Column 0 2 4 0 r[4]= cursor 0 column 2
|
|
13 RealAffinity 4 0 0 0
|
|
14 Column 0 2 5 0 r[5]= cursor 0 column 2
|
|
15 RealAffinity 5 0 0 0
|
|
16 MakeRecord 4 4 9 0 r[9]=mkrec(r[4..7])
|
|
17 SorterInsert 6 9 4 4 0 key=r[9]
|
|
18 Next 0 8 0 1
|
|
19 Explain 19 3 0 USE TEMP B-TREE FOR ORDER BY 0
|
|
20 OpenPseudo 7 10 6 0 6 columns in r[10]
|
|
21 SorterSort 6 28 0 0
|
|
22 SorterData 6 10 7 0 r[10]=data
|
|
23 Column 7 1 8 0 r[8]= cursor 7 column 1;
|
|
24 Column 7 3 7 0 r[7]= cursor 7 column 3;
|
|
25 Column 7 2 6 0 r[6]= cursor 7 column 2;
|
|
26 Yield 3 0 0 0
|
|
27 SorterNext 6 22 0 0
|
|
28 EndCoroutine 3 0 0 0 end (subquery-2)
|
|
29 OpenEphemeral 1 3 0 0 nColumn=3
|
|
30 OpenDup 2 1 0 0
|
|
31 OpenDup 3 1 0 0
|
|
32 OpenDup 4 1 0 0
|
|
33 Null 0 11 11 0 r[11..11]=NULL
|
|
34 Integer 1 12 0 0 r[12]=1
|
|
35 Integer 1 13 0 0 r[13]=1
|
|
36 Integer 0 14 0 0 r[14]=0
|
|
37 OpenDup 8 1 0 0
|
|
38 Explain 38 0 216 SCAN (subquery-2) 0
|
|
39 InitCoroutine 3 0 3 0
|
|
40 Yield 3 72 0 0 next row of
|
|
41 Copy 6 16 0 2 r[16]=r[6]
|
|
42 Copy 7 17 0 2 r[17]=r[7]
|
|
43 Copy 8 18 0 2 r[18]=r[8]
|
|
44 MakeRecord 16 3 19 0 r[19]=mkrec(r[16..18])
|
|
45 Compare 16 11 1 k(1,B) 0 r[16] <-> r[11]
|
|
46 Jump 47 49 47 0
|
|
47 Gosub 25 73 0 0 call flush_partition
|
|
48 Copy 16 11 0 0 r[11]=r[16]
|
|
49 NewRowid 2 20 0 0 r[20]=rowid
|
|
50 Insert 2 19 20 0 intkey=r[20] data=r[19]
|
|
51 Ne 12 61 20 0 if r[20]!=r[12] goto 61
|
|
52 Null 0 1 0 0 r[1]=NULL
|
|
53 Rewind 3 0 0 0
|
|
54 Rewind 1 0 0 0
|
|
55 Rewind 4 0 0 0
|
|
56 Copy 17 21 0 0 r[21]=r[17]
|
|
57 Copy 21 22 0 0 r[22]=r[21]
|
|
58 Copy 21 23 0 0 r[23]=r[21]
|
|
59 Copy 21 24 0 0 r[24]=r[21]
|
|
60 Goto 0 71 0 0
|
|
61 Compare 21 17 1 k(1,B) 0 r[21] <-> r[17]
|
|
62 Jump 63 71 63 0
|
|
63 Copy 17 21 0 0 r[21]=r[17]
|
|
64 AddImm 14 1 0 0 r[14]=r[14]+1
|
|
65 Next 4 67 0 0
|
|
66 Goto 0 71 0 0
|
|
67 Column 4 1 27 0 r[27]= cursor 4 column 1
|
|
68 Compare 24 27 1 k(1,B) 0 r[24] <-> r[27]
|
|
69 Jump 70 64 70 0
|
|
70 Copy 27 24 0 0 r[24]=r[27]
|
|
71 Goto 0 40 0 0
|
|
72 Integer 113 25 0 0 r[25]=113
|
|
73 Rewind 2 110 0 0
|
|
74 AddImm 14 1 0 0 r[14]=r[14]+1
|
|
75 Next 4 77 0 0
|
|
76 Goto 0 81 0 0
|
|
77 Column 4 1 27 0 r[27]= cursor 4 column 1
|
|
78 Compare 24 27 1 k(1,B) 0 r[24] <-> r[27]
|
|
79 Jump 80 74 80 0
|
|
80 Copy 27 24 0 0 r[24]=r[27]
|
|
81 Rowid 1 27 0 0 r[27]= rowid of 1
|
|
82 Column 1 1 29 0 r[29]= cursor 1 column 1
|
|
83 Null 0 1 0 0 r[1]=NULL
|
|
84 SeekGE 8 91 13 0 key=r[13]
|
|
85 Rowid 8 28 0 0 r[28]= rowid of 8
|
|
86 Gt 14 91 28 0 if r[28]>r[14] goto 91
|
|
87 Column 8 2 26 0 r[26]= cursor 8 column 2
|
|
88 CollSeq 0 0 0 BINARY-8 0
|
|
89 AggStep 0 26 1 max(1) 1 accum=r[1] step(r[26])
|
|
90 Next 8 85 0 0
|
|
91 AggFinal 1 1 0 max(1) 0 accum=r[1] N=1
|
|
92 Copy 1 2 0 0 r[2]=r[1]
|
|
93 Null 0 1 0 0 r[1]=NULL
|
|
94 Gosub 15 115 0 0
|
|
95 Next 1 97 0 0
|
|
96 Goto 0 110 0 0
|
|
97 Column 1 1 29 0 r[29]= cursor 1 column 1
|
|
98 Compare 23 29 1 k(1,B) 0 r[23] <-> r[29]
|
|
99 Jump 100 81 100 0
|
|
100 Copy 29 23 0 0 r[23]=r[29]
|
|
101 AddImm 13 1 0 0 r[13]=r[13]+1
|
|
102 Delete 3 0 0 2
|
|
103 Next 3 105 0 0
|
|
104 Goto 0 109 0 0
|
|
105 Column 3 1 29 0 r[29]= cursor 3 column 1
|
|
106 Compare 22 29 1 k(1,B) 0 r[22] <-> r[29]
|
|
107 Jump 108 101 108 0
|
|
108 Copy 29 22 0 0 r[22]=r[29]
|
|
109 Goto 0 81 0 0
|
|
110 ResetSorter 1 0 0 0
|
|
111 Integer 1 13 0 0 r[13]=1
|
|
112 Integer 0 14 0 0 r[14]=0
|
|
113 Return 25 0 0 0
|
|
114 Goto 0 119 0 0
|
|
115 Noop 0 0 0 0 inner-loop subroutine
|
|
116 Copy 2 31 0 0 r[31]=r[2]
|
|
117 ResultRow 31 1 0 0 output=r[31]
|
|
118 Return 15 0 0 0 end inner-loop subroutine
|
|
119 Halt 0 0 0 0
|
|
120 Transaction 0 0 1 0 1 usesStmtJournal=0
|
|
121 Goto 0 1 0 0
|
|
-2.25
|
|
1.0
|
|
4.75
|
|
x
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 37 0 0 Start at 37
|
|
1 Null 0 1 0 0 r[1]=NULL
|
|
2 OpenWrite 0 1 0 5 0 root=1 iDb=0; sqlite_master
|
|
3 Rewind 0 11 0 0
|
|
4 Column 0 2 2 0 r[2]= cursor 0 column 2
|
|
5 Ne 3 10 2 BINARY-8 82 if r[2]!=r[3] goto 10
|
|
6 Column 0 0 2 0 r[2]= cursor 0 column 0
|
|
7 Eq 4 10 2 BINARY-8 82 if r[2]==r[4] goto 10
|
|
8 Rowid 0 5 0 0 r[5]=sqlite_master.rowid
|
|
9 Delete 0 0 0 2
|
|
10 Next 0 4 0 1
|
|
11 Destroy 2 2 0 0
|
|
12 Null 0 6 7 0 r[6..7]=NULL
|
|
13 OpenEphemeral 2 0 6 0 nColumn=0
|
|
14 IfNot 2 22 1 0
|
|
15 OpenRead 1 1 0 4 0 root=1 iDb=0; sqlite_master
|
|
16 Rewind 1 22 0 0
|
|
17 Column 1 3 13 0 r[13]= cursor 1 column 3
|
|
18 Ne 2 21 13 BINARY-8 84 if r[13]!=r[2] goto 21
|
|
19 Rowid 1 7 0 0 r[7]= rowid of 1
|
|
20 Insert 2 6 7 0 intkey=r[7] data=r[6]
|
|
21 Next 1 17 0 1
|
|
22 OpenWrite 1 1 0 5 0 root=1 iDb=0; sqlite_master
|
|
23 Rewind 2 34 0 0
|
|
24 Rowid 2 7 0 0 r[7]= rowid of 2
|
|
25 NotExists 1 33 7 0 intkey=r[7]
|
|
26 Column 1 0 8 0 r[8]= cursor 1 column 0
|
|
27 Column 1 1 9 0 r[9]= cursor 1 column 1
|
|
28 Column 1 2 10 0 r[10]= cursor 1 column 2
|
|
29 Integer 2 11 0 0 r[11]=2
|
|
30 Column 1 4 12 0 r[12]= cursor 1 column 4
|
|
31 MakeRecord 8 5 15 BBBDB 0 r[15]=mkrec(r[8..12])
|
|
32 Insert 1 15 7 0 intkey=r[7] data=r[15]
|
|
33 Next 2 24 0 0
|
|
34 DropTable 0 0 0 T 0
|
|
35 SetCookie 0 1 2 0
|
|
36 Halt 0 0 0 0
|
|
37 Transaction 0 1 1 0 1 usesStmtJournal=1
|
|
38 String8 0 3 0 T 0 r[3]='T'
|
|
39 String8 0 4 0 trigger 0 r[4]='trigger'
|
|
40 Goto 0 1 0 0
|
|
addr opcode p1 p2 p3 p4 p5 comment
|
|
---- ------------- ---- ---- ---- ------------- -- -------------
|
|
0 Init 0 31 0 0 Start at 31
|
|
1 ReadCookie 0 3 2 0
|
|
2 If 3 5 0 0
|
|
3 SetCookie 0 2 4 0
|
|
4 SetCookie 0 5 1 0
|
|
5 CreateBtree 0 2 1 0 r[2]=root iDb=0 flags=1
|
|
6 OpenWrite 0 1 0 5 0 root=1 iDb=0
|
|
7 NewRowid 0 1 0 0 r[1]=rowid
|
|
8 Blob 6 3 0 0 r[3]= (len=6)
|
|
9 Insert 0 3 1 8 intkey=r[1] data=r[3]
|
|
10 Close 0 0 0 0
|
|
11 Close 0 0 0 0
|
|
12 Null 0 4 5 0 r[4..5]=NULL
|
|
13 Noop 4 0 4 0
|
|
14 OpenWrite 3 1 0 5 0 root=1 iDb=0; sqlite_master
|
|
15 SeekRowid 3 17 1 0 intkey=r[1]
|
|
16 Rowid 3 5 0 0 r[5]= rowid of 3
|
|
17 IsNull 5 25 0 0 if r[5]==NULL goto 25
|
|
18 String8 0 6 0 table 0 r[6]='table'
|
|
19 String8 0 7 0 sqlite_stat1 0 r[7]='sqlite_stat1'
|
|
20 String8 0 8 0 sqlite_stat1 0 r[8]='sqlite_stat1'
|
|
21 Copy 2 9 0 0 r[9]=r[2]
|
|
22 String8 0 10 0 CREATE TABLE sqlite_stat1(tbl,idx,stat) 0 r[10]='CREATE TABLE sqlite_stat1(tbl,idx,stat)'
|
|
23 MakeRecord 6 5 4 BBBDB 0 r[4]=mkrec(r[6..10])
|
|
24 Insert 3 4 5 0 intkey=r[5] data=r[4]
|
|
25 SetCookie 0 1 3 0
|
|
26 ParseSchema 0 0 0 tbl_name='sqlite_stat1' AND type!='trigger' 0
|
|
27 OpenWrite 0 2 0 3 16 root=2 iDb=0; sqlite_stat1
|
|
28 LoadAnalysis 0 0 0 0
|
|
29 Expire 0 0 0 0
|
|
30 Halt 0 0 0 0
|
|
31 Transaction 0 1 2 0 1 usesStmtJournal=1
|
|
32 Goto 0 1 0 0
|
|
```
|
|
|
|
## Flag
|
|
|
|
```
|
|
|
|
```
|
|
|