Op 6 sep 2015, om 03:17 heeft Scott Robison het volgende geschreven:
>
> select * from (select a as b from c) where b is something
>
Still column expressions are called mutiple times.

SQLite 3.8.11 2015-07-27 13:49:41  
b8e92227a469de677a66da62e4361f099c0b79d0
create table c(a)
;
explain query plan
select 1 from (select (select a from c) as b) where b>0
;
1|0|0|EXECUTE SCALAR SUBQUERY 2
2|0|0|SCAN TABLE c
1|0|0|EXECUTE SCALAR SUBQUERY 3
3|0|0|SCAN TABLE c
0|0|0|SCAN SUBQUERY 1

Reply via email to