Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue with explain insert stmt #1466

Closed
adizaimi opened this issue Mar 4, 2019 · 0 comments
Closed

Issue with explain insert stmt #1466

adizaimi opened this issue Mar 4, 2019 · 0 comments

Comments

@adizaimi
Copy link

adizaimi commented Mar 4, 2019

basic71866> create table t2(i int)$$
[create table t2(i int)] rc 0
basic71866> insert into t2 values(1)
(rows inserted=1)
[insert into t2 values(1)] rc 0
basic71866> explain insert into t2 values(1)
(addr=11, opcode='Goto', p1=0, p2=1, p3=0, p4='', p5='00', comment='')
[explain insert into t2 values(1)] rc 0

what it should be is more like this:

> sqlite3 
SQLite version 3.16.2 2017-01-06 16:32:41
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table t2(i int);
sqlite> explain insert into t2 values(1);
addr  opcode         p1    p2    p3    p4             p5  comment      
----  -------------  ----  ----  ----  -------------  --  -------------
0     Init           0     7     0                    00  Start at 7   
1     OpenWrite      0     2     0     1              00  root=2 iDb=0; t2
2     NewRowid       0     1     0                    00  r[1]=rowid   
3     Integer        1     2     0                    00  r[2]=1       
4     MakeRecord     2     1     3     D              00  r[3]=mkrec(r[2])
5     Insert         0     3     1     t2             1b  intkey=r[1] data=r[3]
6     Halt           0     0     0                    00               
7     Transaction    0     1     1     0              01  usesStmtJournal=0
8     Goto           0     1     0                    00 
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants