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