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
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
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
> - -
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
4 matches
Mail list logo