| /sqlite-3.40.0/ext/fts5/test/ |
| H A D | fts5af.test | 97 4.1 {X o o o o o X o o} {[X] o o o o o [X]...} 101 5.1 {X o o o o X o o o} {[X] o o o o [X] o...} 106 6.1 {X o o o X o o o} {[X] o o o [X] o o...} 107 6.2 {o X o o o X o o o} {o [X] o o o [X] o...} 109 6.4 {o o o o o o o o X o o o X o} {...o [X] o o o [X] o} 110 6.5 {o o o o o o o o o X o o o X} {...o o [X] o o o [X]} 112 7.1 {X o o X o o o o o} {[X] o o [X] o o o...} 113 7.2 {o X o o X o o o o} {o [X] o o [X] o o...} 115 7.4 {o o o o o o o o X o o X o o} {...o [X] o o [X] o o} 116 7.5 {o o o o o o o o o X o o X o} {...o o [X] o o [X] o} [all …]
|
| /sqlite-3.40.0/test/ |
| H A D | whereJ.test | 495 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 94','0 94',X'0308015f'); 496 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 189','0 189',X'03080200be'); 497 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 284','0 284',X'0308020120'); 498 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 379','0 379',X'030802017f'); 499 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 474','0 474',X'03080201de'); 500 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 569','0 569',X'030802023d'); 501 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 664','0 664',X'030802029f'); 502 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','846 1','0 759','0 759',X'03080202fe'); 503 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','3 1','846 847','1 847',X'0301024500e6'); 504 INSERT INTO sqlite_stat4 VALUES('cx','c_leid','1 1','849 849','2 849',X'03010246027e'); [all …]
|
| H A D | skipscan6.test | 41 …7151 196859 196859 32 1','0 15043 15043 92468 92499','0 19 286 81846 92499',X'0609010804031552977B… 84 …','good','197030 196859 32 1','15086 15086 92511 92536','19 25 81644 92536',X'05010904031552977BD7… 85 …od','14972 14687 1 1','289878 289878 299457 299457','199 244 267460 299457',X'050209040301344F7E56… 86 …d','19600 19313 22 1','327127 327127 346222 346243','261 319 306884 346243',X'0502090403018A49503B… 87 …d','25666 25047 15 1','352087 352087 372692 372706','266 327 325601 372706',X'050209040301914C2DD2… 88 …d','42392 42327 26 1','378657 378657 382547 382572','268 331 333529 382572',X'05020904030193533B2F… 89 …d','24619 24513 11 1','457872 457872 461748 461758','286 358 399322 461758',X'050209040301A752B155… 90 …d','18969 18730 15 1','482491 482491 501105 501119','287 360 433605 501119',X'050209040301A8494AF3… 91 …','119710 119603 1 1','576500 576500 598915 598915','404 505 519877 598915',X'05020904030247539A7A… 92 …d','11955 11946 1 1','889796 889796 898373 898373','938 1123 794694 898373',X'050209040304EF4DF9C4… [all …]
|
| H A D | e_update.test | 532 1 "UPDATE t7 SET s = q LIMIT 5" {1 2 3 4 5 X X X X X} 533 2 "UPDATE t7 SET s = r WHERE q>2 LIMIT 4" {1 2 three four five six X X X X} 543 3 "UPDATE t7 SET s = 'X' LIMIT -1" {X X X X X X X X X X} 552 1 "UPDATE t7 SET s = q ORDER BY r LIMIT 3" {X X X 4 5 X X 8 X X} 553 2 "UPDATE t7 SET s = r ORDER BY r DESC LIMIT 2" {X two three 4 5 X X 8 X X} 556 X "UPDATE t7 SET s = 'X'" {X X X X X X X X X X} 565 1 "UPDATE t7 SET s = q ORDER BY q LIMIT 3 OFFSET 2" {X X 3 4 5 X X X X X} 566 2 "UPDATE t7 SET s = q ORDER BY q DESC LIMIT 2, 3 " {X X 3 4 5 6 7 8 X X} 568 X "UPDATE t7 SET s = 'X'" {X X X X X X X X X X} 580 1 "UPDATE t7 SET s = q LIMIT 4, 2" {X X X X 5 6 X X X X} [all …]
|
| H A D | like3.test | 82 } {'abc' 'abd' 'abe' X'616263' X'616264' X'616265'} 85 } {X'616265' X'616264' X'616263' 'abe' 'abd' 'abc'} 88 } {X'616265' X'616264' X'616263' 'abe' 'abd' 'abc'} 91 } {'abc' 'abd' 'abe' X'616263' X'616264' X'616265'} 94 } {'abc' 'abd' 'abe' X'616263' X'616264' X'616265'} 101 } {'abc' 'abd' 'abe' X'616263' X'616264' X'616265'} 104 } {X'616265' X'616264' X'616263' 'abe' 'abd' 'abc'} 107 } {X'616265' X'616264' X'616263' 'abe' 'abd' 'abc'} 110 } {'abc' 'abd' 'abe' X'616263' X'616264' X'616265'} 113 } {'abc' 'abd' 'abe' X'616263' X'616264' X'616265'}
|
| H A D | fts3sort.test | 84 unset -nocomplain X 86 set A($X(docid)) [array get X] 89 unset -nocomplain X 91 set B($X(docid)) [array get X] 94 unset -nocomplain X 96 set C($X(docid)) [array get X] 99 unset -nocomplain X 101 set D($X(docid)) [array get X] 111 unset -nocomplain X 112 db eval "$query" X { [all …]
|
| H A D | fts3first.test | 45 INSERT INTO x1(docid,a,b,c) VALUES(4, 'N J C Y N', 'R U D X V', 'B O U A Q'); 46 INSERT INTO x1(docid,a,b,c) VALUES(5, 'Q L X L U', 'I F N X S', 'U Q A N Y'); 47 INSERT INTO x1(docid,a,b,c) VALUES(6, 'M R G U T', 'U V I Q P', 'X Y D L S'); 48 INSERT INTO x1(docid,a,b,c) VALUES(7, 'D Y P O I', 'X J P K R', 'V O T H V'); 50 INSERT INTO x1(docid,a,b,c) VALUES(9, 'Z P F N P', 'W A X D U', 'V A E Q A'); 54 INSERT INTO x1(docid,a,b,c) VALUES(13, 'X S B X Y', 'U D N D P', 'X Z Y G F'); 56 INSERT INTO x1(docid,a,b,c) VALUES(15, 'C E U C C', 'W F M N M', 'T Z U X T'); 101 2 {^X} {{[X] Y D L S} {[X] J P K R} {[X] S B X Y}} 102 3 {^X Y} {{[X] [Y] D L S} {D [Y] P O I...[X] J P K R} {[X] S B X [Y]}} 123 2 {^X} { [all …]
|
| H A D | fts4content.test | 105 INSERT INTO t2 VALUES('T F T J F F Y V F W N X K Q A Y L X W G'); -- 11 107 INSERT INTO t2 VALUES('B W L T F S G X D P H N G M R I O A X I'); -- 13 223 INSERT INTO ft3(rowid, x, y) VALUES(13, 'L X N N X', 'R R N S T'); 317 } {0 X'000000'} 320 } {0 X'000000'} 330 } {0 X'05182B'} 335 } {0 X'05182B'} 339 } {1 X'05' 2 X'05' 3 X'04' 4 X'05' 5 X'05'} 345 } {0 X'05182B' 1 X'05' 2 X'05' 3 X'04' 4 X'05' 5 X'05'} 351 } {0 X'000000'} [all …]
|
| H A D | blob.test | 33 set blob [execsql {SELECT X'01020304';}] 55 catchsql {SELECT X'01020k304', 100} 56 } {1 {unrecognized token: "X'01020k304'"}} 58 catchsql {SELECT X'01020, 100} 59 } {1 {unrecognized token: "X'01020, 100"}} 61 catchsql {SELECT X'01020 100'} 62 } {1 {unrecognized token: "X'01020 100'"}} 64 catchsql {SELECT X'01001'} 65 } {1 {unrecognized token: "X'01001'"}} 90 INSERT INTO t1 VALUES(X'123456', x'7890ab'); [all …]
|
| H A D | nulls1.test | 306 INSERT INTO t1(x) VALUES('X'); 312 INSERT INTO t2(c,d) VALUES(5,'X'),(6,'Y'),(7,'Z'),(3,'A'),(4,'B'); 316 UPDATE t2 SET d='X'; 333 } {X 3 X | X 4 X | X 5 X | X 7 X | X {} X | {} {} {} | Y {} {} |} 337 } {X 3 X | X 4 X | X 5 X | X 7 X | X {} X | {} {} {} | Y {} {} |}
|
| H A D | skipscan5.test | 154 'ydkgu' 'zdb' X'' 155 X'0a' X'203f6429f1f33f' X'23858e324545e0362b' 156 X'3f9f8a' X'516f7ddd4b' X'68f1df0930ac6b' 157 X'9ea60d' X'a06f' X'aefd342a39ce36df' 158 X'afaa020fe2' X'be201c' X'c47d97b209601e45' 173 3 "b < X'5555'" {/*SCAN t3*/} 174 4 "b > X'5555'" {/*ANY(a) AND b>?*/}
|
| H A D | selectA.test | 48 INSERT INTO t2 VALUES(5.2e6, 'X', 'x'); 52 } {{} U u mad Z z hare m M 5200000.0 X x -23 Y y} 71 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M} 77 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M} 83 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M} 89 } {hare m M abc e e mad Z z hello d D 5200000.0 X x 9.9 b B 1 a a -23 Y y {} C c {} U u} 95 } {{} C c {} U u -23 Y y 1 a a 9.9 b B 5200000.0 X x hello d D mad Z z abc e e hare m M} 101 } {{} C c {} U u 5200000.0 X x -23 Y y mad Z z 1 a a 9.9 b B hello d D abc e e hare m M} 107 } {1 a a 9.9 b B {} C c hello d D abc e e hare m M {} U u 5200000.0 X x -23 Y y mad Z z} 113 } {mad Z z -23 Y y 5200000.0 X x {} U u hare m M abc e e hello d D {} C c 9.9 b B 1 a a} [all …]
|
| H A D | dbpage.test | 40 } {1 X'53514C6974' 2 X'0500000001' 3 X'0D0000004E' 4 X'0D00000016'} 43 } {2 X'0500000001'} 46 } {4 X'0D00000016'} 59 } {1 X'53514C6974' 2 X'0D00000001'} 79 } {1 X'53514C6974' 2 X'0500000001' 3 X'0D0000004E' 4 X'0000000000'}
|
| /sqlite-3.40.0/src/ |
| H A D | parse.y | 70 #define yytestcase(X) testcase(X) argument 375 sqlite3AddDefaultValue(pParse,p,X.z,X.z+X.n); in id() 399 autoinc(X) ::= . {X = 0;} in autoinc() argument 400 autoinc(X) ::= AUTOINCR. {X = 1;} in autoinc() argument 671 as(X) ::= AS nm(Y). {X = Y;} 672 as(X) ::= ids(X). 673 as(X) ::= . {X.n = 0; X.z = 0;} 748 dbnm(A) ::= DOT nm(X). {A = X;} 1086 expr(A) ::= LP expr(X) RP. {A = X;} 1104 term(A) ::= NULL|FLOAT|BLOB(X). {A=tokenExpr(pParse,@X,X); /*A-overwrites-X*/} [all …]
|
| H A D | sqliteInt.h | 459 # define TESTONLY(X) X argument 473 # define VVA_ONLY(X) X argument 508 # define ALWAYS(X) (X) argument 509 # define NEVER(X) (X) argument 523 # define OK_IF_ALWAYS_TRUE(X) (X) argument 596 #define likely(X) (X) argument 597 #define unlikely(X) (X) argument 1108 #define ArraySize(X) ((int)(sizeof(X)/sizeof(X[0]))) argument 1113 #define IsPowerOfTwo(X) (((X)&((X)-1))==0) argument 1691 #define HI(X) ((u64)(X)<<32) argument [all …]
|
| H A D | mutex.h | 57 #define sqlite3_mutex_alloc(X) ((sqlite3_mutex*)8) argument 58 #define sqlite3_mutex_free(X) argument 59 #define sqlite3_mutex_enter(X) argument 60 #define sqlite3_mutex_try(X) SQLITE_OK argument 61 #define sqlite3_mutex_leave(X) argument 62 #define sqlite3_mutex_held(X) ((void)(X),1) argument 63 #define sqlite3_mutex_notheld(X) ((void)(X),1) argument 64 #define sqlite3MutexAlloc(X) ((sqlite3_mutex*)8) argument 67 #define MUTEX_LOGIC(X) argument 69 #define MUTEX_LOGIC(X) X argument
|
| H A D | btree.h | 350 # define sqlite3BtreeSeekCount(X) 0 argument 383 # define sqlite3BtreeEnter(X) argument 384 # define sqlite3BtreeEnterAll(X) argument 385 # define sqlite3BtreeSharable(X) 0 argument 386 # define sqlite3BtreeEnterCursor(X) argument 387 # define sqlite3BtreeConnectionCount(X) 1 argument 402 # define sqlite3BtreeLeave(X) argument 403 # define sqlite3BtreeLeaveCursor(X) argument 404 # define sqlite3BtreeLeaveAll(X) argument 406 # define sqlite3BtreeHoldsMutex(X) 1 argument [all …]
|
| /sqlite-3.40.0/ext/fts5/ |
| H A D | fts5parse.y | 60 #define yytestcase(X) testcase(X) argument 82 input ::= expr(X). { sqlite3Fts5ParseFinished(pParse, X); } 100 colset(A) ::= LCP colsetlist(X) RCP. { A = X; } in colset() 101 colset(A) ::= STRING(X). { in colset() 104 colset(A) ::= MINUS STRING(X). { in colset() 111 colsetlist(A) ::= STRING(X). { in colsetlist() 129 expr(A) ::= LP expr(X) RP. {A = X;} in expr() 130 expr(A) ::= exprlist(X). {A = X;} in expr() 132 exprlist(A) ::= cnearset(X). {A = X;} in exprlist() 137 cnearset(A) ::= nearset(X). { in cnearset() [all …]
|
| /sqlite-3.40.0/ext/session/ |
| H A D | sessionF.test | 55 {INSERT t2 0 X. {} {i 2 t two}} 56 {INSERT t1 0 X. {} {i 1 t one}} 57 {INSERT t3 0 X. {} {i 3 t three}} 64 {INSERT t1 0 X. {} {i 1 t one}} 65 {INSERT t2 0 X. {} {i 2 t two}} 75 {INSERT t2 0 X. {} {i 2 t two}} 76 {INSERT t1 0 X. {} {i 1 t one}} 106 {INSERT t3 0 X. {} {i 6 t six}} 116 {INSERT t3 0 X. {} {i 6 t six}} 124 {INSERT t3 0 X. {} {i 6 t six}} [all …]
|
| H A D | sessionwor.test | 44 {INSERT t1 0 X. {} {t one t two}} 62 {DELETE t1 0 X. {t one t four} {}} 79 {INSERT t1 0 X. {} {i 1 t two}} 85 {UPDATE t1 0 X. {i 1 t two} {{} {} t three}} 97 {DELETE t1 0 X. {i 1 t four} {}} 109 {INSERT t2 0 X. {} {i 1 t one}} 110 {INSERT t2 0 X. {} {i 2 t two}} 111 {INSERT t2 0 X. {} {i 3 t three}} 116 {INSERT t3 0 X. {} {i 1 t one}} 117 {INSERT t3 0 X. {} {i 2 t two}} [all …]
|
| H A D | sessionB.test | 63 {UPDATE t1 0 X..X {i 5 {} {} {} {} i 8} {{} {} {} {} i 14 {} {}}} 64 {INSERT t1 0 X..X {} {t w t x t y t z}} 65 {DELETE t1 0 X..X {i 1 {} {} {} {} i 4} {}} 75 {DELETE t1 0 X..X {i 5 {} {} {} {} i 8} {}} 76 {DELETE t1 0 X..X {t w {} {} {} {} t z} {}} 77 {DELETE t1 0 X..X {i 9 {} {} {} {} i 12} {}} 84 {INSERT t1 0 X..X {} {f 4.2 n {} n {} b abcd}} 85 {INSERT t1 0 X..X {} {b abcd n {} n {} f 4.2}} 93 {UPDATE t1 0 X..X {b abcd {} {} {} {} f 4.2} {{} {} i 45 {} {} {} {}}} 107 {DELETE t1 0 X..X {f 4.2 {} {} {} {} b abcd} {}} [all …]
|
| H A D | session1.test | 86 {INSERT t1 0 X. {} {i 1 t Sukhothai}} 88 {INSERT t1 0 X. {} {i 3 t Thonburi}} 93 {DELETE t1 0 X. {i 3 t Thonburi} {}} 105 {DELETE t1 0 X. {i 3 t Thonburi} {}} 110 {INSERT t1 0 X. {} {i 3 t Thonburi}} 133 {INSERT t1 0 X. {} {i 20 t Thapae}} 141 {DELETE t1 0 X. {i 20 t Thapae} {}} 170 {DELETE t1 0 X. {i 2 t Surin} {}} 171 {DELETE t1 0 X. {i 20 t Thapae} {}} 477 {INSERT t1 0 X. {} {t two i 2}} [all …]
|
| /sqlite-3.40.0/ext/rbu/ |
| H A D | rbu5.test | 223 INSERT INTO t1 VALUES(-582327,X'7A267A',X'7E6B3CFE5CB9','zacuzilrok',-196478); 226 INSERT INTO t1 VALUES(-629138,632630.29,X'28D6',-774501,X'819BBBFC65'); 227 INSERT INTO t1 VALUES(-828110,-54379.24,-881121.44,X'',X'8D5A894F0D'); 230 INSERT INTO t2 VALUES(-65174,X'AC1DBFFE27310F',-194471.08,347988,X'84041BA6F9BDDE86A8'); 238 INSERT INTO t2 VALUES(763908,NULL,'xgslzcpvwfknbr',X'75',X'668146'); 244 INSERT INTO t2 VALUES(222916.23,'idh',X'472C517405',X'E3',X'7C4F31824669'); 247 INSERT INTO t2 VALUES(X'0EFB4DC50693',-175590.83,X'1779E253CAB5B1789E',X'BC6903',NULL); 256 INSERT INTO t1 VALUES(-863931,-1386.26,X'2A058540C2FB5C',NULL,X'F9D5990A'); 257 INSERT INTO t1 VALUES(673696,X'97301F0AC5735F44B5',X'440C',227999.92,-709599.79); 258 INSERT INTO t1 VALUES(-243640,NULL,-71718.11,X'1EEFEB38',X'8CC7C55D95E142FBA5'); [all …]
|
| /sqlite-3.40.0/ext/lsm1/test/ |
| H A D | lsm1_simple.test | 36 } {8 'banjo' X'333231' NULL 12 NULL 3.25 -559281390 15 11 22 33} 39 } {8 X'08' X'2162616E6A6F1633323105' 12 X'0C' X'05320000000000000A401FFB42ABE9DB' 15 X'0F' X'4284C6… 44 } {8 'banjo' X'333231' NULL 12 NULL 3.25 -559281390 15 11 22 34.0} 49 } {8 'banjo' X'333231' NULL 15 11 22 34.0 123456789 NULL 3.25 -559281390} 52 } {X'FB075BCD15' 0x75bcd15} 57 } {8 'banjo' X'333231' NULL 123456789 NULL 3.25 -559281390} 87 } {'12' NULL 3.25 -559281390 | '15' 11 22 33 | '8' 'banjo' X'333231' NULL |} 90 } {'12' X'3132' X'05320000000000000A401FFB42ABE9DB' | '15' X'3135' X'4284C6' | '8' X'38' X'2162616E… 93 } {'12' X'3132' X'05320000000000000A401FFB42ABE9DB'}
|
| /sqlite-3.40.0/ext/fts3/ |
| H A D | fts3Int.h | 82 #define SizeofArray(X) ((int)(sizeof(X)/sizeof(X[0]))) argument 123 # define testcase(X) argument 158 # define ALWAYS(X) (1) argument 159 # define NEVER(X) (0) argument 161 # define ALWAYS(X) ((X)?1:(assert(0),0)) argument 162 # define NEVER(X) ((X)?(assert(0),1):0) argument 164 # define ALWAYS(X) (X) argument 165 # define NEVER(X) (X) argument 195 # define TESTONLY(X) X argument 197 # define TESTONLY(X) argument
|