In my example I have AS clause so rule 1. sqlite select statement is correct or name is correct.
sqlite create table as statement create table with different name that select statement return Problem is different result or name. Richard Hipp je 22.12.2017 ob 19:27 napisal:
These are the rules that SQLite uses to name a column in the result set: (1) If there is an AS clause, use it. (2) If the result-set value comes from a table column (even indirectly, such as through a subquery, but not if the value is altered by an expression) then use the name of the column as it appears in the original CREATE TABLE statement for the table. (3) Otherwise, name the result-set column using the SQL text in the SELECT statement. What set of rules are you proposing that we should use instead?
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users