Home
last modified time | relevance | path

Searched refs:tab1 (Results 1 – 6 of 6) sorted by relevance

/sqlite-3.40.0/test/
H A Dcapi2.test698 } [list {main tab1 col2} {main tab1 col1}]
701 } [list {main tab1 col2} {main tab1 col1}]
706 } [list {main tab1 col2} {main tab1 col1}]
709 } [list {main tab1 col2} {main tab1 col1}]
712 } [list {main tab1 col2} {main tab1 col1}]
715 } [list {main tab1 col1} {main tab1 col2}]
718 } [list {main tab1 col1} {main tab1 col2}]
729 } [list {main tab1 col2} {main tab1 col1}]
732 } [list {main tab1 col2} {main tab1 col1}]
735 } [list {main tab1 col2} {main tab1 col1}]
[all …]
H A Dtkt2141.test29 CREATE TABLE tab1 (t1_id integer PRIMARY KEY, t1_desc);
30 INSERT INTO tab1 VALUES(1,'rec 1 tab 1');
36 FROM tab1 t1 LEFT JOIN tab2 t2 ON t1.t1_id = t2.t2_id_t1
45 FROM tab1 t1 LEFT JOIN tab2 t2 ON t1.t1_id = t2.t2_id_t1
54 FROM tab1 t1 LEFT JOIN tab2 t2
H A Dtkt3522.test37 CREATE TABLE tab1(col0 INTEGER);
39 SELECT cor0.* FROM tab1 NATURAL JOIN tab2 AS cor0;
H A Dindex.test254 execsql {CREATE TABLE tab1(a int)}
256 execsql {EXPLAIN CREATE INDEX idx1 ON tab1(a)}
258 execsql {SELECT name FROM sqlite_master WHERE tbl_name='tab1'}
259 } {tab1}
261 execsql {CREATE INDEX idx1 ON tab1(a)}
262 execsql {SELECT name FROM sqlite_master WHERE tbl_name='tab1' ORDER BY name}
263 } {idx1 tab1}
H A Dinsert.test426 CREATE TABLE tab1( value INTEGER);
427 INSERT INTO tab1 (value, _rowid_) values( 11, 1);
428 INSERT INTO tab1 (value, _rowid_) SELECT 22,999;
429 SELECT * FROM tab1;
/sqlite-3.40.0/src/
H A Dselect.c3008 int tab1, tab2; in multiSelect() local
3019 tab1 = pParse->nTab++; in multiSelect()
3023 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, tab1, 0); in multiSelect()
3031 sqlite3SelectDestInit(&intersectdest, SRT_Union, tab1); in multiSelect()
3068 sqlite3VdbeAddOp2(v, OP_Rewind, tab1, iBreak); VdbeCoverage(v); in multiSelect()
3070 iStart = sqlite3VdbeAddOp2(v, OP_RowData, tab1, r1); in multiSelect()
3074 selectInnerLoop(pParse, p, tab1, in multiSelect()
3077 sqlite3VdbeAddOp2(v, OP_Next, tab1, iStart); VdbeCoverage(v); in multiSelect()
3080 sqlite3VdbeAddOp2(v, OP_Close, tab1, 0); in multiSelect()