On Thursday, February 10, 2011 at 9:22 AM, Nißl Reinhard wrote: > Hi, > > I'm sorry Pavel, I think you've got me wrong. > > > It's not "buggy". Name of the column in result set is not defined > > unless you use "as". > Pavel is not wrong. SQLite is not buggy. Your expectation of what it should do is at fault here. > ..
I used to think as you too, but then learned otherwise. The developers simply didn't add the code to dependably determine what the column should be called, because, surprisingly (or not surprisingly, if you think about it a bit), that code would be very complex to cover all the possible cases. The simplest solution is to depend upon AS aliasing, else, do something undependable (to us). Puneet. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
