Hello, On 2018-01-05 21:56, David Raymond wrote:
sqlite> explain select id from tbl where id = null; addr opcode p1 p2 p3 p4 p5 comment ---- ------------- ---- ---- ---- ------------- -- ------------- 0 Init 0 8 0 00 Start at 8 1 OpenRead 0 3 0 0 00 root=3 iDb=0; tbl 2 Explain 0 0 0 SEARCH TABLE tbl USING INTEGER PRIMARY KEY (rowid=?) 00 3 Null 0 1 0 00 r[1]=NULL 4 SeekRowid 0 7 1 00 intkey=r[1]; pk 5 Copy 1 2 0 00 r[2]=r[1] 6 ResultRow 2 1 0 00 output=r[2] 7 Halt 0 0 0 00 8 Transaction 0 0 2 0 01 usesStmtJournal=0 9 Goto 0 1 0 00 Run Time: real 0.000 user 0.000000 sys 0.000000
??? My 3.21 checks if NULL is NULL and exits: 2 Null 0 1 3 IsNull 1 9 ... 9 Halt 0 0 -- best regards Cezary H. Noweta _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
