Lines Matching refs:main
27 CREATE TABLE main.t1(a INTEGER PRIMARY KEY, b TEXT, c BLOB);
31 CREATE TABLE main.x1(a INTEGER PRIMARY KEY, b TEXT, c BLOB);
35 INSERT INTO main.t1 VALUES(1, 'main one', X'0101');
36 INSERT INTO main.t1 VALUES(2, 'main two', X'0102');
37 INSERT INTO main.t1 VALUES(3, 'main three', X'0103');
38 INSERT INTO main.t1 VALUES(4, 'main four', X'0104');
39 INSERT INTO main.t1 VALUES(5, 'main five', X'0105');
41 INSERT INTO main.x1 VALUES(1, 'x main one', X'000101');
42 INSERT INTO main.x1 VALUES(2, 'x main two', X'000102');
43 INSERT INTO main.x1 VALUES(3, 'x main three', X'000103');
44 INSERT INTO main.x1 VALUES(4, 'x main four', X'000104');
45 INSERT INTO main.x1 VALUES(5, 'x main five', X'000105');
86 do_test 1.1.1 { read_blob main t1 b 1 } "main one"
87 do_test 1.1.2 { read_blob main t1 c 1 } "\01\01"
93 do_test 1.2.1 { read_blob main t1 b 4 } "main four"
94 do_test 1.2.2 { read_blob main t1 c 4 } "\01\04"
100 do_test 1.3.1 { read_blob main x1 b 2 } "x main two"
101 do_test 1.3.2 { read_blob main x1 c 2 } "\00\01\02"
111 # keyword in the ATTACH statement. For the main database file, the
112 # database name is "main". For TEMP tables, the database name is "temp".
115 # for the main db, for TEMP tables and for those in attached databases
141 sqlite3_blob_open db main x1 c $iRow $flags B
245 test_blob_open 2 main tt1 x 1 0 SQLITE_ERROR "no such table: main.tt1"
248 test_blob_open 3 main t2 y 1 0 SQLITE_ERROR \
252 test_blob_open 4 main t1 z 2 0 SQLITE_ERROR "no such column: \"z\""
255 test_blob_open 5 main t1 y 6 0 SQLITE_ERROR "no such rowid: 6"
259 test_blob_open 6 main t1 x 2 0 SQLITE_ERROR "cannot open value of type null"
260 test_blob_open 7 main t1 y 1 0 SQLITE_ERROR "cannot open value of type integer"
261 test_blob_open 8 main t1 y 3 0 SQLITE_ERROR "cannot open value of type real"
272 test_blob_open 8.1.1 main t3 a 1 0 SQLITE_OK "not an error"
273 test_blob_open 8.1.2 main t3 b 1 0 SQLITE_OK "not an error"
274 test_blob_open 8.1.3 main t3 c 1 0 SQLITE_OK "not an error"
275 test_blob_open 8.1.4 main t3 d 1 0 SQLITE_OK "not an error"
276 test_blob_open 8.1.5 main t3 e 1 0 SQLITE_OK "not an error"
277 test_blob_open 8.1.6 main t3 f 1 0 SQLITE_OK "not an error"
280 test_blob_open 8.2.1 main t3 a 1 8 SQLITE_ERROR $cannot
281 test_blob_open 8.2.2 main t3 b 1 8 SQLITE_ERROR $cannot
282 test_blob_open 8.2.3 main t3 c 1 8 SQLITE_OK "not an error"
283 test_blob_open 8.2.4 main t3 d 1 8 SQLITE_OK "not an error"
284 test_blob_open 8.2.5 main t3 e 1 8 SQLITE_ERROR $cannot
285 test_blob_open 8.2.6 main t3 f 1 8 SQLITE_ERROR $cannot
296 test_blob_open 9.1 main c1 b 45 0 SQLITE_OK "not an error"
297 test_blob_open 9.2 main c1 b 45 1 SQLITE_OK "not an error"
299 test_blob_open 9.3 main c1 b 45 0 SQLITE_OK "not an error"
300 test_blob_open 9.4 main c1 b 45 1 SQLITE_ERROR \
317 sqlite3_blob_open db main t1 x 1 0 B
320 list [catch {sqlite3_blob_open $B main t1 x 1 0 B2} msg] $msg
328 list [catch {sqlite3_blob_open db main {} x 1 0 B} msg] $msg
372 sqlite3_blob_open db main b1 b 2 0 B
389 sqlite3_blob_open db main b1 b 3 0 B
406 sqlite3_blob_open db main b1 b 6 0 B
423 sqlite3_blob_open db main b2 b 2 1 B
440 sqlite3_blob_open db main b2 b 3 1 B
457 sqlite3_blob_open db main b2 b 6 1 B
484 sqlite3_blob_open db main b3 y 22 1 B
524 sqlite3_blob_open db main c2 j 10 1 B
525 sqlite3_blob_open db main c2 j 11 1 B2