Yuriy Kaminskiy wrote: > Yuriy Kaminskiy wrote: >> When WHERE condition is constant, there are no need to evaluate and check it >> for >> each row. It works, but only partially: > ... >> [In fact, you can move out out loop not only *whole* constant WHERE, but also >> all constant AND terms of WHERE, like this: >> SELECT * FROM t WHERE const1 AND notconst AND const2 -> >> SELECT * FROM (SELECT * FROM t WHERE notconst) WHERE const1 AND const2 >> I'll take a shot on that later.] > > Here it goes. > > Prerequisite: previous patch. > Passes quick regression test (make test). > Possible problem: short-circuits evaluation. Should not be problem, IMO, as > only > constants references? Please verify.
Ping. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users