Re: [sqlite] bug: explain Rewind Le

2017-11-01 Thread Egor Shalashnikov
Thank you for checking the issue. It seems I use an outdated version 3.11.0: $ uname -a Linux chrx 4.8.17-galliumos #1 SMP PREEMPT galliumos4 Thu Feb 23 02:27:28 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux $ sqlite3 --version 3.11.0 2016-02-15 17:29:24 3d862f207e3adc00f78066799ac5a8c282430a5f Regards

Re: [sqlite] bug: explain Rewind Le

2017-11-01 Thread Egor Shalashnikov
Yes, absolutely correct On Nov 1, 2017 10:55 AM, "Clemens Ladisch" wrote: > Egor Shalashnikov wrote: > > create table t(n number, v varchar2(10)); > > insert into t values (1, 'one') > > explain select * from t where 0 < n; > > If you omit the EXPLAIN, is the code executed correctly? > > > addr

Re: [sqlite] bug: explain Rewind Le

2017-11-01 Thread Clemens Ladisch
Egor Shalashnikov wrote: > create table t(n number, v varchar2(10)); > insert into t values (1, 'one') > explain select * from t where 0 < n; If you omit the EXPLAIN, is the code executed correctly? > addr opcode p1p2p3p4 p5 comment > - -

[sqlite] bug: explain Rewind Le

2017-10-31 Thread Egor Shalashnikov
create table t(n number, v varchar2(10)); insert into t values (1, 'one') explain select * from t where 0 < n; addr opcode p1p2p3p4 p5 comment - - -- - 0 Init 0 110