Home
last modified time | relevance | path

Searched refs:sub (Results 1 – 25 of 68) sorted by relevance

123

/sqlite-3.40.0/src/
H A Dvdbevtab.c44 Mem sub; /* Subprograms */ member
116 sqlite3VdbeMemInit(&pCur->sub, pVTab->db, 1); in bytecodevtabOpen()
127 sqlite3VdbeMemRelease(&pCur->sub); in bytecodevtabCursorClear()
128 sqlite3VdbeMemSetNull(&pCur->sub); in bytecodevtabCursorClear()
168 pCur->showSubprograms ? &pCur->sub : 0, in bytecodevtabNext()
174 sqlite3VdbeMemSetNull(&pCur->sub); in bytecodevtabNext()
H A Dexpr.c3089 pExpr->y.sub.iAddr); in sqlite3CodeRhsOfIN()
3100 pExpr->y.sub.regReturn = ++pParse->nMem; in sqlite3CodeRhsOfIN()
3101 pExpr->y.sub.iAddr = in sqlite3CodeRhsOfIN()
3228 sqlite3VdbeAddOp3(v, OP_Return, pExpr->y.sub.regReturn, in sqlite3CodeRhsOfIN()
3229 pExpr->y.sub.iAddr, 1); in sqlite3CodeRhsOfIN()
3273 sqlite3VdbeAddOp2(v, OP_Gosub, pExpr->y.sub.regReturn, in sqlite3CodeSubselect()
3274 pExpr->y.sub.iAddr); in sqlite3CodeSubselect()
3282 pExpr->y.sub.regReturn = ++pParse->nMem; in sqlite3CodeSubselect()
3283 pExpr->y.sub.iAddr = in sqlite3CodeSubselect()
3359 sqlite3VdbeAddOp3(v, OP_Return, pExpr->y.sub.regReturn, in sqlite3CodeSubselect()
[all …]
/sqlite-3.40.0/ext/fts5/
H A Dextract_api_docs.tcl140 foreach {sub docs} $D {
141 if {[info exists M($sub)]} {
142 set hdr $M($sub)
143 set link " id=$sub"
/sqlite-3.40.0/test/
H A Dselect7.test117 } {1 {sub-select returns 2 columns - expected 1}}
122 } {1 {sub-select returns 2 columns - expected 1}}
127 } {1 {sub-select returns 2 columns - expected 1}}
132 } {1 {sub-select returns 2 columns - expected 1}}
H A Dspeed4.test17 # * sub-selects
80 # speed4-subselect1: A SELECT statement that uses many sub-queries..
149 # Run a SELECT that uses sub-queries 10000 times. A total of 30000 sub-selects.
H A Deqp.test27 # eqp-3.*: Select statements that execute sub-selects.
245 # Test cases eqp-3.* - tests for select statements that use sub-selects.
248 SELECT (SELECT x FROM t1 AS sub) FROM t1;
253 `--SCAN sub
256 SELECT * FROM t1 WHERE (SELECT x FROM t1 AS sub);
261 `--SCAN sub
264 SELECT * FROM t1 WHERE (SELECT x FROM t1 AS sub ORDER BY y);
269 |--SCAN sub
H A DselectD.test156 # the datatypes and affinities of sub-sub-queries are set prior to computing
157 # the datatypes and affinities of the parent sub-queries because the
H A Dspeed4p.explain17 # * sub-selects
80 # speed4p-subselect1: A SELECT statement that uses many sub-queries..
162 # Run a SELECT that uses sub-queries 10000 times. A total of 30000 sub-selects.
H A Dspeed4p.test17 # * sub-selects
80 # speed4p-subselect1: A SELECT statement that uses many sub-queries..
152 # Run a SELECT that uses sub-queries 10000 times. A total of 30000 sub-selects.
H A Drowvalue4.test13 # and sub-selects that return multiple arguments.
24 # * row values or sub-selects that contain/return the wrong number
46 {sub-select returns 3 columns - expected 2}
49 {sub-select returns 3 columns - expected 2}
H A Din.test318 } {1 {sub-select returns 2 columns - expected 1}}
395 } {1 {sub-select returns 2 columns - expected 1}}
402 } {1 {sub-select returns 2 columns - expected 1}}
409 } {1 {sub-select returns 2 columns - expected 1}}
416 } {1 {sub-select returns 2 columns - expected 1}}
482 } {1 {sub-select returns 2 columns - expected 1}}
637 } {1 {sub-select returns 2 columns - expected 1}}
H A Din3.test69 # Because none of the sub-select queries in the following statements
86 # This should not use a temp-table. Even though the sub-select does
104 # Has to use a temp-table because of the compound sub-select.
H A Dreturningfault.test32 faultsim_test_result {1 {sub-select returns 5 columns - expected 1}}
H A Dzipfile2.test179 foreach {tn sub} {
185 set blob [blob [string map [list 504B0506 $sub] $archive2]]
H A Dunionall2.test12 # focus of this file is flattening UNION ALL sub-queries.
H A Dfuzz.test132 # the "b" reference in the other sub-query. When the query was executed,
163 # The [a] reference in the sub-select was causing a problem. Because
H A Drowvalue.test325 set err "sub-select returns $n columns - expected 1"
341 } {1 {sub-select returns 2 columns - expected 1}}
344 } {1 {sub-select returns 2 columns - expected 1}}
676 } {1 {sub-select returns 2 columns - expected 1}}
H A Dtempdb.test62 # Similarly, set $::subj_in_memory if the sub-journal file is expected
H A Dwhere9.test986 # The MULTI-INDEX OR processing evaluates the same WHERE-clause sub-expression
987 # twice. But if that sub-expression contains a UNION ALL SELECT statement
988 # subject to query flattening, the sub-expression might be transformed in a
990 # the second attempt to generate code from the same sub-expression.
991 # The solution is to make a copy of sub-expressions used by MULTI-INDEX OR
H A Dinsert5.test100 # or ORDER BY of a sub-query is no longer supported.
H A Dtkt-a7debbe0.test67 # Result should be 0, as column "xyz" from the sub-query has implicit
/sqlite-3.40.0/tool/
H A Dstack_usage.tcl31 if {[regexp {sub +\$(0x[0-9a-z]+),%[er]sp} $line all xdepth]} {
H A Dbuild-all-msvc.bat13 REM the directory specified on the command line, in sub-directories named for
19 REM for the generated output files, which will be placed in sub-directories
373 REM NOTE: This is the name of the sub-directory where the UCRT libraries may
383 REM NOTE: This is the name of the sub-directory where the Windows 10.0 SDK
555 REM cannot simply be the "lib" sub-directory beneath the location
/sqlite-3.40.0/ext/lsm1/lsm-test/
H A DREADME13 transactions and sub-transactions.
/sqlite-3.40.0/
H A Dsqlite_cfg.h.in108 /* Define to the sub-directory in which libtool stores uninstalled libraries.

123