Lines Matching refs:alias

232   4  "SELECT 'x'||a||'x' alias FROM t1" {xax xbx xcx}
233   5  "SELECT 'x'||a||'x' AS alias FROM t1" {xax xbx xcx}
791 # EVIDENCE-OF: R-43693-30522 If the expression is the alias of a table
814 # EVIDENCE-OF: R-38023-18396 It is an error to use a "*" or "alias.*"
818 # "alias.*" expression in a simple SELECT query that does not have a
837 # the result expression list after substitution of * and alias.*
1721 # integer K then the expression is considered an alias for the K-th
1765 # that corresponds to the alias of one of the output columns, then the
1766 # expression is considered an alias for that column.
1873 # an alias to an expression that has been assigned a collation sequence 
1877 #   In the test 8.10.2, the only result-column expression has no alias. So the
1879 #   the collation sequence. In test 8.10.3, "x" is the alias (as well as the
1880 #   column name), so the ORDER BY expression is interpreted as an alias and the
1894 # column or an alias of an expression that is a column, then the default
1912 # alias, then SQLite searches the left-most SELECT in the compound for a
1915 # alias for the result column that it has been matched against.