Home
last modified time | relevance | path

Searched refs:alias (Results 1 – 24 of 24) sorted by relevance

/sqlite-3.40.0/test/
H A Dalias.test41 do_test alias-1.1 {
51 do_test alias-1.2 {
57 do_test alias-1.3 {
63 do_test alias-1.4 {
69 do_test alias-1.5 {
77 do_test alias-1.6 {
83 #do_test alias-1.7 {
89 do_test alias-1.8 {
95 do_test alias-1.9 {
117 do_test alias-2.1 {
[all …]
H A Dwindow6.test38 set A(%alias) over
47 set A(%alias) filter
59 set A(%alias) alias
77 SELECT sum(%alias.%x) OVER %w FROM %t1 %alias WINDOW %w AS (ORDER BY %y)
81 SELECT sum(%x) %alias FROM %t1
H A Dreturning1.test159 # This is goofy: The RETURNING clause does not honor the alias
163 UPDATE t1 AS alias SET b=123 RETURNING alias.b;
164 } {1 {no such column: alias.b}}
166 UPDATE t1 AS alias SET b=alias.b+1000 RETURNING t1.b;
H A Dprintf2.test19 # EVIDENCE-OF: R-64900-53159 The printf() SQL function is an alias for
89 # EVIDENCE-OF: R-56064-04001 The %p format is an alias for %X.
H A Dalterqf.test57 8 {CREATE VIEW v1 AS SELECT "string"'alias' FROM t1}
58 {CREATE VIEW v1 AS SELECT 'string' 'alias' FROM t1}
H A De_select.test232 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
[all …]
H A Dtestrunner.tcl461 tinterp alias set_test_counter set_test_counter
471 tinterp alias puts_into_caller puts_into_caller
H A Dtkt2822.test33 # but simply x) then look for a column alias with the same
178 # The "ORDER BY b" should match the column alias (rule 2), not the
H A Dupfrom2.test26 # 5.*: Test that specifying the target table name or alias in the FROM
365 "1 {target object/alias may not appear in FROM clause: $nm}"
H A De_createtable.test1729 # the name of one of the tables columns. Return 1 if $col is an alias for
1744 # lower case, then the column becomes an alias for the rowid.
1748 # not become an alias for the rowid and is not classified as an integer
1771 # and a unique index, not as an alias for the rowid.
1809 # cause the column "x" to be an alias for the rowid (an integer primary
1815 # in "x" being an alias for the rowid: CREATE TABLE t(x INTEGER PRIMARY
1832 # using an alias created by an integer primary key.
H A Dfts3b.test139 # fts3 adds a new implicit column, docid, which acts as an alias for
H A De_insert.test357 # keyword REPLACE as an alias for "INSERT OR REPLACE".
362 # EVIDENCE-OF: R-03421-22330 The REPLACE command is an alias for the
H A Dupsert4.test287 # Test references to "excluded". And using an alias in an INSERT
H A Dwhere.test1242 # alias for an expression in the result set, and that expression retrieves
1249 SELECT t1.e AS alias FROM t2, t1 WHERE alias = 1 ;
H A Dindexexpr1.test233 -- The use of the "k" alias in the WHERE clause is technically
H A Dtester.tcl2345 tinterp alias set_test_counter set_test_counter
H A Dshell1.test834 # an INTEGER PRIMARY KEY DESC is not an alias for the rowid.
H A Dfts1porter.test579 alias alia
/sqlite-3.40.0/tool/
H A Dlemon.c2244 const char *alias[MAXRHS]; /* Aliases for each RHS symbol (or NULL) */ member
2397 rp->rhsalias[i] = psp->alias[i]; in parseonetoken()
2428 psp->alias[psp->nrhs] = 0; in parseonetoken()
2464 psp->alias[psp->nrhs-1] = x; in parseonetoken()
/sqlite-3.40.0/ext/wasm/jaccwabyt/
H A Djaccwabyt.md301 generated code includes `p` as an alias for `i`, presumably to mean
/sqlite-3.40.0/
H A Dmanifest737 F test/alias.test 4529fbc152f190268a15f9384a5651bbbabc9d87
/sqlite-3.40.0/src/
H A Dshell.c.in4100 ** no "pk" index if the PRIMARY KEY really is an alias for the ROWID.
4526 ".save ?OPTIONS? FILE Write database to FILE (an alias for .backup ...)",
H A Dsqlite.h.in2470 ** is another alias for the rowid.
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5porter.test297 alias alia alice alic