On Sun, Sep 14, 2014 at 12:18 AM, Lea Verou <[email protected]> wrote: > Per the 3.7.11 changelog [1], queries of the form SELECT max(x), y FROM > table return the value of y from the same row that contains the maximum x > value. However, this: > > select y from (SELECT max(x), y FROM table); > > would not return the same y rows. This would work as expected: > > select m, y from (SELECT max(x) as m, y FROM table); >
I'm not sure if this qualifies as a "bug" or not, since the behavior is unspecified in the official documentation. Nevertheless, it is now fixed on trunk. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
