sqlite madness
ActivePublic

Authored by bcs on May 31 2016, 11:47 PM.
sqlite> explain create table if not exists fucknuts (fuck int);
addr opcode p1 p2 p3 p4 p5 comment
---- ------------- ---- ---- ---- ------------- -- -------------
0 Init 0 2 0 00 Start at 2
1 Halt 0 0 0 00
2 Transaction 0 0 1 0 01 usesStmtJournal=0
3 Goto 0 1 0 00
sqlite> explain create table if not exists fucknuts2 (fucky int);
addr opcode p1 p2 p3 p4 p5 comment
---- ------------- ---- ---- ---- ------------- -- -------------
0 Init 0 30 0 00 Start at 30
1 ReadCookie 0 3 2 00
2 If 3 5 0 00
3 SetCookie 0 2 4 00
4 SetCookie 0 5 1 00
5 CreateTable 0 2 0 00 r[2]=root iDb=0
6 OpenWrite 0 1 0 5 00 root=1 iDb=0
7 NewRowid 0 1 0 00 r[1]=rowid
8 Blob 6 3 0 00 r[3]= (len=6)
9 Insert 0 3 1 08 intkey=r[1] data=r[3]
10 Close 0 0 0 00
11 Close 0 0 0 00
12 Null 0 4 5 00 r[4..5]=NULL
13 OpenWrite 1 1 0 5 00 root=1 iDb=0; sqlite_master
14 Explain 0 0 0 SEARCH TABLE sqlite_master USING INTEGER PRIMARY KEY (rowid=?) 00
15 MustBeInt 1 18 0 00
16 NotExists 1 18 1 00 intkey=r[1]; pk
17 Rowid 1 5 0 00 r[5]=rowid
18 IsNull 5 26 0 00 if r[5]==NULL goto 26
19 String8 0 6 0 table 00 r[6]='table'
20 String8 0 7 0 fucknuts2 00 r[7]='fucknuts2'
21 String8 0 8 0 fucknuts2 00 r[8]='fucknuts2'
22 Copy 2 9 0 00 r[9]=r[2]
23 String8 0 10 0 CREATE TABLE fucknuts2 (fucky int) 00 r[10]='CREATE TABLE fucknuts2 (fucky int)'
24 MakeRecord 6 5 11 BBBDB 00 r[11]=mkrec(r[6..10])
25 Insert 1 11 5 00 intkey=r[5] data=r[11]
26 Close 1 0 0 00
27 SetCookie 0 1 2 00
28 ParseSchema 0 0 0 tbl_name='fucknuts2' AND type!='trigger' 00
29 Halt 0 0 0 00
30 Transaction 0 1 1 0 01 usesStmtJournal=0
31 TableLock 0 1 1 sqlite_master 00 iDb=0 root=1 write=1
32 Goto 0 1 0 00
bcs created this paste.May 31 2016, 11:47 PM
bcs created this object in space S3 Anonymous.
bcs created this object with visibility "Public (No Login Required)".