Home
last modified time | relevance | path

Searched refs:temp (Results 1 – 25 of 141) sorted by relevance

123456

/sqlite-3.40.0/test/
H A De_dropview.test33 INSERT INTO temp.t1 VALUES('a temp', 'b temp');
34 CREATE VIEW temp.v1 AS SELECT * FROM t1;
48 if {$name == "temp"} { set tbl temp.sqlite_master }
60 if {$name == "temp"} { set tbl sqlite_temp_master }
83 2 "DROP VIEW v2" {main.v1 temp.v1 aux.v1 aux.v2 aux.v3}
84 3 "DROP VIEW main.v1" {main.v2 temp.v1 aux.v1 aux.v2 aux.v3}
125 do_execsql_test 3.1.0 { SELECT * FROM temp.v1 } {{a temp} {b temp}}
126 do_execsql_test 3.1.1 { DROP VIEW temp.v1 } {}
127 do_catchsql_test 3.1.2 { SELECT * FROM temp.v1 } {1 {no such table: temp.v1}}
171 3 "DROP VIEW temp.v2" temp.v2
[all …]
H A De_droptrigger.test29 if {$name == "temp"} {
80 {main.tr2 temp.tr1 aux.tr1 aux.tr2 aux.tr3}
82 {main.tr2 temp.tr1 aux.tr1 aux.tr2 aux.tr3}
89 {main.tr1 main.tr2 temp.tr1 aux.tr2 aux.tr3}
91 {main.tr1 main.tr2 temp.tr1 aux.tr2 aux.tr3}
107 4 t1 "DROP TRIGGER tr2" {temp.tr1} {temp.tr1}
111 7 t1 "DROP TRIGGER tr3" {temp.tr1} {temp.tr1}
145 4 t1 "DROP TRIGGER tr2" {temp.tr1} {temp.tr1}
149 7 t1 "DROP TRIGGER tr3" {temp.tr1} {temp.tr1}
172 4 t1 "DROP TRIGGER tr2" {temp.tr1} {temp.tr1}
[all …]
H A Dalterauth2.test67 {SQLITE_READ sqlite_temp_master name temp {}}
68 {SQLITE_READ sqlite_temp_master sql temp {}}
70 {SQLITE_READ sqlite_temp_master type temp {}}
75 {SQLITE_UPDATE sqlite_temp_master sql temp {}}
91 {SQLITE_READ sqlite_temp_master name temp {}}
92 {SQLITE_READ sqlite_temp_master sql temp {}}
93 {SQLITE_READ sqlite_temp_master type temp {}}
96 {SQLITE_UPDATE sqlite_temp_master sql temp {}}
111 {SQLITE_READ sqlite_temp_master name temp {}}
112 {SQLITE_READ sqlite_temp_master sql temp {}}
[all …]
H A De_blobclose.test64 } {main reserved temp closed}
68 } {main reserved temp closed}
72 } {main reserved temp closed}
76 } {main shared temp closed}
80 } {main unlocked temp closed}
85 } {main reserved temp closed}
90 } {main reserved temp closed}
94 } {main unlocked temp closed}
104 } {main reserved temp closed}
108 } {main unlocked temp closed}
[all …]
H A Dattach2.test161 # the lock_status list will not contain an entry for the temp
198 lock_status 4.2.1 db {main shared temp closed file2 unlocked}
206 lock_status 4.3.1 db {main shared temp closed file2 unlocked}
217 lock_status 4.4.1 db {main shared temp closed file2 unlocked}
238 lock_status 4.5.1 db {main shared temp closed file2 unlocked}
251 lock_status 4.6.1.1 db {main shared temp closed file2 shared}
261 lock_status 4.6.2.1 db {main shared temp closed file2 shared}
272 lock_status 4.7.1 db {main shared temp closed file2 shared}
280 lock_status 4.8.1 db {main shared temp closed file2 shared}
290 lock_status 4.9.1 db {main shared temp closed file2 shared}
[all …]
H A Dtemptrigger.test28 # Test case temptrigger-1.* demonstrates a problem with temp triggers
30 # creates a temp trigger, the temp trigger is linked into the shared-cache
32 # it does not recreate the temp trigger belonging to process 1. From the
33 # point of view of process 1, the temp trigger just disappeared.
36 # database and add a temp trigger to it.
39 # that the temp trigger is not fired by statements
142 # Test case temptrigger-3.* demonstrates a problem with temp triggers
149 # temp trigger to a table in 'test2.db'.
151 # temptrigger-3.2: Check that the temp trigger is correctly fired.
207 # Test that creating a temp table after a temp trigger on the same name
[all …]
H A De_resolve.test26 CREATE TABLE temp.n1(x, y); INSERT INTO temp.n1 VALUES('temp', 'n1');
27 CREATE TRIGGER temp.n3 AFTER INSERT ON n1 BEGIN SELECT 1; END;
28 CREATE INDEX temp.n4 ON n1(x, y);
56 # object reference, then SQLite searches the main, temp and all attached
57 # databases for an object with a matching name. The temp database is
63 do_execsql_test 1.1 { SELECT * FROM n1 } {temp n1}
69 # object reference, it must be either "main", or "temp" or the
76 do_execsql_test 2.1.2 { SELECT * FROM temp.n1 } {temp n1}
87 do_execsql_test 3.2 { SELECT * FROM tEmP.n1 } {temp n1}
94 do_catchsql_test 4.1 { SELECT * FROM temp.n2 } {1 {no such table: temp.n2}}
[all …]
H A Dcsv01.test23 CREATE VIRTUAL TABLE temp.t1 USING csv(
42 DROP TABLE temp.t1;
43 CREATE VIRTUAL TABLE temp.t1 USING csv(
60 DROP TABLE temp.t1;
61 CREATE VIRTUAL TABLE temp.t1 USING csv(
78 DROP TABLE temp.t1;
79 CREATE VIRTUAL TABLE temp.t1 USING csv(
100 CREATE VIRTUAL TABLE temp.t2 USING csv(
130 CREATE VIRTUAL TABLE temp.t3 USING csv(
156 CREATE VIRTUAL TABLE temp.t4 USING csv_wr(
[all …]
H A De_blobopen.test47 INSERT INTO temp.t1 VALUES(1, 'temp one', X'0201');
48 INSERT INTO temp.t1 VALUES(2, 'temp two', X'0202');
49 INSERT INTO temp.t1 VALUES(3, 'temp three', X'0203');
50 INSERT INTO temp.t1 VALUES(4, 'temp four', X'0204');
51 INSERT INTO temp.t1 VALUES(5, 'temp five', X'0205');
53 INSERT INTO temp.x2 VALUES(1, 'x temp one', X'000201');
54 INSERT INTO temp.x2 VALUES(2, 'x temp two', X'000202');
56 INSERT INTO temp.x2 VALUES(4, 'x temp four', X'000204');
88 do_test 1.1.3 { read_blob temp t1 b 1 } "temp one"
95 do_test 1.2.3 { read_blob temp t1 b 4 } "temp four"
[all …]
H A Dattach3.test275 } {main temp aux}
287 } {main temp {}}
293 } {main temp}
299 } {main temp {}}
305 } {main temp}
311 } {main temp {}}
317 } {main temp}
323 } {main temp {}}
329 } {main temp}
343 } {main temp {}}
[all …]
H A Dtkt-d82e3f3721.test49 SELECT 'temp', * FROM temp.sqlite_sequence
52 } {main t1 3 temp t2 3}
58 SELECT 'temp', * FROM temp.sqlite_sequence
61 } {main t1 3 temp t2 3}
74 SELECT * FROM temp.t3 JOIN main.t3;
80 SELECT * FROM temp.t3 JOIN main.t3;
H A Dtemptable2.test30 PRAGMA temp.integrity_check;
57 PRAGMA temp.cache_size = 10;
75 do_execsql_test 3.1.4 { PRAGMA temp.integrity_check } {ok}
86 do_execsql_test 3.2.2 { PRAGMA temp.integrity_check } {ok}
93 PRAGMA temp.cache_size = 10;
102 PRAGMA temp.page_count;
122 set n [db one { PRAGMA temp.page_count }]
126 do_execsql_test 4.1.4 { PRAGMA temp.integrity_check } {ok}
133 PRAGMA temp.cache_size = 10;
148 set n [db one { PRAGMA temp.page_count }]
[all …]
H A Dunionvtab.test44 CREATE VIRTUAL TABLE temp.uuu USING unionvtab(
91 CREATE VIRTUAL TABLE temp.opp USING unionvtab(src);
100 CREATE VIRTUAL TABLE temp.qll USING unionvtab(
193 DROP TABLE IF EXISTS temp.a1;
194 CREATE VIRTUAL TABLE temp.a1 USING unionvtab(\"VALUES [join $L ,]\");
199 CREATE VIRTUAL TABLE temp.b1 USING unionvtab(
209 CREATE VIRTUAL TABLE temp.a1 USING unionvtab(`$sql`)
214 CREATE VIRTUAL TABLE temp.b1 USING unionvtab(1, 2, 3, 4)
235 CREATE VIRTUAL TABLE temp.uu USING unionvtab(
336 CREATE VIRTUAL TABLE temp.sl USING unionvtab(
[all …]
H A Dzipfile2.test217 CREATE VIRTUAL TABLE temp.zip USING zipfile('test.zip');
218 INSERT INTO temp.zip (name,data) VALUES ('test1','test');
219 INSERT INTO temp.zip (name,data) VALUES ('test2','test');
222 UPDATE temp.zip SET name='test1' WHERE name='test2'
228 CREATE VIRTUAL TABLE temp.zip USING zipfile('test.zip');
229 INSERT INTO temp.zip (name,data) VALUES ('test','test');
230 UPDATE temp.zip set name=name||'new' where name='test';
231 INSERT INTO temp.zip (name,data) VALUES ('test','test');
232 UPDATE temp.zip set name=name||'new' where name='test';
237 INSERT INTO temp.zip (name,data) VALUES ('test1','test');
[all …]
H A Dpragma2.test139 PRAGMA temp.cache_size=2000;
142 PRAGMA temp.cache_spill;
148 PRAGMA temp.cache_spill;
182 } {main exclusive temp unknown} ;# EXCLUSIVE lock due to cache spill
192 } {0 main reserved temp unknown} ;# No cache spill, so no exclusive lock
207 } {100000 main reserved temp unknown} ;# Big spill threshold -> no excl lock
218 } {50 main exclusive temp unknown} ;# Small cache spill -> exclusive lock
228 } {50 main exclusive temp unknown} ;# Small cache spill -> exclusive lock
243 } {main unlocked temp unknown aux1 reserved}
253 } {main unlocked temp unknown aux1 exclusive}
H A Dauth.test119 } {t1 {} temp {}}
632 } {v1 {} temp {}}
648 } {v1 {} temp {}}
996 } {r1 t1 temp {}}
1032 } {r1 t1 temp {}}
1068 } {r1 t1 temp {}}
1174 } {r1 t1 temp {}}
1202 } {r1 t1 temp {}}
1218 } {r1 t1 temp {}}
1967 } {t3_idx1 {} temp {} sqlite_autoindex_t3_1 {} temp {}}
[all …]
H A Dswarmvtab.test53 CREATE VIRTUAL TABLE temp.s1 USING swarmvtab('SELECT * FROM dir');
62 CREATE VIRTUAL TABLE temp.s1 USING swarmvtab('SELECT * FROM dir');
160 CREATE VIRTUAL TABLE temp.s1 USING swarmvtab('SELECT * FROM dir');
190 CREATE VIRTUAL TABLE temp.x1 USING swarmvtab('SELECT * FROMdir');
193 CREATE VIRTUAL TABLE temp.x1 USING swarmvtab('SELECT * FROMdir', 'fetchdb');
210 CREATE VIRTUAL TABLE temp.xyz USING swarmvtab(
219 CREATE VIRTUAL TABLE temp.xyz USING swarmvtab(
234 CREATE VIRTUAL TABLE temp.xyz USING swarmvtab(
H A Dattach.test64 file tail [sqlite3_db_filename db temp]
157 ATTACH 'test.db' as temp;
159 } {1 {database temp is already in use}}
192 execsql {select * from temp.sqlite_master}
262 } {0 main 1 temp}
317 } {0 main 1 temp 2 db2}
345 } {0 main 1 temp 2 db2}
677 SELECT 'no-op' FROM temp.t6;
686 SELECT 'no-op' || (SELECT * FROM temp.t6);
707 SELECT max(1,x,(SELECT min(x) FROM temp.t6)) FROM t1;
[all …]
H A Dlaststmtchanges.test216 create temp table t0(x);
217 create temp table t1 (k integer primary key);
218 create temp table t2 (k integer primary key);
219 create temp view v1 as select * from t1;
220 create temp view v2 as select * from t2;
221 create temp table n1 (k integer primary key, n);
222 create temp table n2 (k integer primary key, n);
231 create temp trigger r1 instead of insert on v1 for each row begin
241 create temp trigger r2 instead of insert on v2 for each row begin
H A Dbackup2.test94 db restore temp bu1.db
95 dbcksum db temp
100 db backup temp bu2.db
111 set rc [catch {db backup temp bu2.db} res]
123 set rc [catch {db backup temp bu2.db} res]
154 set rc [catch {db restore temp bu3.db} res]
162 set rc [catch {db restore temp bu2.db} res]
H A Dlock7.test34 } {main unlocked temp closed}
37 } {main unlocked temp closed}
48 } {main reserved temp closed}
51 } {main unlocked temp closed}
H A Dalter.test49 set ::temp TEMP
51 set ::temp {}
61 CREATE $::temp TABLE "temp table"(e,f,g UNIQUE);
62 CREATE INDEX i2 ON [temp table](f);
63 INSERT INTO [temp table] VALUES(5,6,7);
68 SELECT * FROM [temp table];
73 CREATE $::temp TABLE objlist(type, name, tbl_name);
80 FROM temp.sqlite_master WHERE NAME!='objlist';
95 table {temp table} {temp table} \
96 index i2 {temp table} \
[all …]
H A Din3.test54 # All of these queries should avoid using a temp-table:
71 # require a temp table.
86 # This should not use a temp-table. Even though the sub-select does
93 # These do use the temp-table. Adding the LIMIT clause means the
104 # Has to use a temp-table because of the compound sub-select.
116 # The first of these queries has to use the temp-table, because the
119 # require a temp-table, because the collation sequences match.
128 # Neither of these queries require a temp-table. The collation sequence
259 # A temp table must be used because t3_i.b is not guaranteed to be unique.
H A Djrnlmode.test39 execsql {PRAGMA temp.journal_mode}
40 set newmode [db one {PRAGMA temp.journal_mode}]
53 PRAGMA temp.journal_mode;
65 PRAGMA temp.journal_mode;
86 PRAGMA temp.journal_mode;
110 PRAGMA temp.journal_mode;
136 PRAGMA temp.journal_mode;
172 PRAGMA temp.journal_mode;
183 PRAGMA temp.journal_mode;
195 PRAGMA temp.journal_mode;
H A Dvacuummem.test26 # If ENABLE_MEMORY_MANAGEMENT is defined, when VACUUM is run the temp db
28 # temp db is configure with a very small cache). When the VACUUM is
29 # finished and the temp db closed, all the page-cache memory currently
30 # assigned to the temp db is freed. If ENABLE_MEMORY_MANAGEMENT is defined

123456