On Thu, 8 Jan 2015 08:42:25 +0000 Hick Gunter <h...@scigames.at> wrote:
> It is legal and well defined in SQLite. See the explain output below. > This is because of the well-documented feature of SQLite that columns > that are neither GROUPED BY nor aggregated will have a defined value. OK, understood, "in SQLite". Thanks. UIUC, I wouldn't call it "well" defined because of the effect of the ungrouped column: > the b value returned for each a will be (an arbitrary one) so two SELECTs taking advantage of this aspect of SQLite may return different results for the same data. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users