On Mon, Mar 10, 2014 at 12:52 PM, Dariusz Wawer <[email protected]>wrote:
> yes, that is what is written in the documentation at > https://www.sqlite.org/c3ref/column_name.html and it is what I have read > first when trying to find an answer. It provides a solution, but it does > not answer the question. It answers 2 of the 4: - Where does the difference come from? - Is this intentional? The docs make clear that it IS intentional and that any result is unspecified if you do not provide AS. If you don't provide an AS, the implementation is free to return "abc" for every single column name. The remaining questions: - How are view selects handled differently than table selects? - If so, then what is the reasoning behind it? This is not explained, but it's quite possibly that way so that the implementation has some leeway in how it works. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
