On Mon, Mar 10, 2014 at 11:53 AM, Dariusz Wawer <[email protected]>wrote:
> When I obtain the column name through sqlite3_column_name() I get > different results for query on view (ALIAS.COLUMN) than for query on table > (COLUMN). The alias is included in column name for view query but not in > table query, even though it is explicitely specified. > > Where does the difference come from? How are view selects handled > differently than table selects? Is this intentional? If so, then what is > the reasoning behind it? > The column name returned is ALWAYS UNDEFINED unless you use an "AS" clause to name it. If you do not use an "AS" clause then it is perfectly legal for sqlite3 to return anything it wants for the column names. -- ----- 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
