Home
last modified time | relevance | path

Searched refs:xyz (Results 1 – 25 of 169) sorted by relevance

1234567

/sqlite-3.40.0/test/
H A Dprintf.test23 } {abc: 1 1 1 :xyz}
51 } {abc: 2 2 2 :xyz}
79 } {abc: 5 5 5 :xyz}
107 } {abc: 10 a 12 :xyz}
247 } {abc: 0 0 0 :xyz}
489 } {abc: (0.0) :xyz}
516 } {abc: (0.0) :xyz}
548 } {abc: (1.0) :xyz}
554 } {abc: (1) :xyz}
581 } {abc: (0) :xyz}
[all …]
H A Dtableapi.test34 INSERT INTO xyz VALUES(1,'%q')
44 SELECT * FROM xyz WHERE b='%q'
49 SELECT * FROM xyz
58 SELECT * FROM xyz ORDER BY a
91 INSERT INTO xyz VALUES(51,'%q')
101 INSERT INTO xyz VALUES(52,NULL)
115 SELECT * FROM xyz WHERE a>1000
125 SELECT * FROM xyz WHERE b='%q'
130 SELECT * FROM xyz
139 SELECT * FROM xyz ORDER BY a
[all …]
H A Drowvaluefault.test21 CREATE TABLE xyz(one, two, thr, fou);
22 INSERT INTO xyz VALUES('A', 'A', 'A', 1);
23 INSERT INTO xyz VALUES('B', 'B', 'B', 2);
24 INSERT INTO xyz VALUES('C', 'C', 'C', 3);
25 INSERT INTO xyz VALUES('D', 'D', 'D', 4);
27 CREATE UNIQUE INDEX xyz_one_two ON xyz(one, two);
49 execsql { SELECT fou FROM xyz WHERE (one, two) IN (SELECT one, two FROM xyz) }
56 SELECT fou FROM xyz
65 SELECT fou FROM xyz
73 SELECT fou FROM xyz
[all …]
H A Dmain.test63 db complete {DROP TABLE 'xyz;}
66 db complete {DROP TABLE 'xyz';}
69 db complete {DROP TABLE "xyz;}
72 db complete {DROP TABLE "xyz';}
75 db complete {DROP TABLE "xyz";}
78 db complete {DROP TABLE xyz; hi}
81 db complete {DROP TABLE xyz; }
87 db complete {DROP TABLE xyz; -- hi
358 set xyz 123
360 catchsql {select $::xyz}
[all …]
H A Dprefixes.test32 5 "xyz\u1234xz" "xyz\u1234xy" 5
33 6 "xyz\u1234" "xyz\u1234xy" 4
34 7 "xyz\u1234" "xyz\u1234" 4
35 8 "xyz\u1234xy" "xyz\u1234" 4
36 9 "xyz\u1234xy" "xyz\u1233" 3
37 10 "xyz\u1234xy" "xyz\u1235" 3
H A Daltertrig.test44 UPDATE t1 SET d='xyz' FROM t2, t3;
53 UPDATE t1 SET d='xyz' FROM t2, "t5";
60 UPDATE t1 SET d='xyz' FROM t2, (SELECT * FROM t5);
69 UPDATE t1 SET d='xyz' FROM t2, (SELECT * FROM "t3");
77 UPDATE t1 SET d='xyz' FROM t2, (SELECT * FROM t3)
79 UPDATE t1 SET d='xyz' FROM t2, (SELECT * FROM "t10")
85 UPDATE t1 SET a='xyz' FROM t3, (SELECT * FROM (SELECT e FROM t3))
93 UPDATE t1 SET a='xyz' FROM t3, (SELECT * FROM (SELECT e FROM t3))
95 UPDATE t1 SET a='xyz' FROM t3, (SELECT * FROM (SELECT abc FROM t3))
101 UPDATE t1 SET a='xyz' FROM t3, (SELECT 1 FROM t2 WHERE c)
[all …]
H A Dquote.test24 catchsql {CREATE TABLE '@abc' ( '#xyz' int, '!pqr' text );}
43 SELECT '@abc'.'!pqr', '@abc'.'#xyz'+5 FROM '@abc'
48 SELECT '!pqr', '#xyz'+5 FROM '@abc'
53 SELECT "!pqr", "#xyz"+5 FROM '@abc'
58 SELECT [!pqr], `#xyz`+5 FROM '@abc'
69 execsql {UPDATE '@abc' SET '#xyz'=11}
101 1 { CREATE TABLE xyz(a, b, c CHECK (c!="null") ) } null
111 CREATE TABLE xyz(a, b, c CHECK (c!="null") );
121 INSERT INTO xyz VALUES(1, 2, 3);
124 INSERT INTO xyz VALUES(1, 2, 'null');
[all …]
H A Dtkt-a7debbe0.test30 CREATE TABLE t0(xyz INTEGER);
31 INSERT INTO t0(xyz) VALUES(456);
67 # Result should be 0, as column "xyz" from the sub-query has implicit
70 SELECT xyz==b FROM ( SELECT a, 'xyz' AS xyz FROM t5 ), t5;
73 # Result should be 1, as literal 'xyz' has no collation sequence, so
76 SELECT 'xyz'==b FROM ( SELECT a, 'xyz' AS xyz FROM t5 ), t5;
H A DwindowB.test254 INSERT INTO t1 VALUES('xyz', 222);
255 INSERT INTO t1 VALUES('xyz', 333);
260 } {{} 234 {} 234 0 {} 1 {} 2 {} xyz 555 xyz 555}
266 } {{} 234 {} 234 0 {} 1 {} 2 {} xyz 555 xyz 555}
272 } {{} 234 {} 234 0 {} 1 {} 2 {} xyz 555 xyz 555}
278 } {{} 234 {} 234 0 {} 1 {} 2 {} xyz 555 xyz 555}
315 INSERT INTO t1 VALUES('xyz', 3333);
322 } {{} 46 {} 46 7 {} 7 {} 8 {} 8 {} abc 1004 abc 1004 xyz 3333}
327 } {{} 45 {} 45 7 {} 7 {} 8 {} 8 {} abc 1001 abc 1001 xyz 3333}
333 } {{} 46 {} 46 7 {} 7 {} 8 {} 8 {} abc 1004 abc 1004 xyz 3333}
[all …]
H A Dupsert4.test33 INSERT INTO t1 VALUES(1, NULL, 'xyz') ON CONFLICT DO NOTHING;
89 CREATE TABLE xyz(a INTEGER PRIMARY KEY, b, c, d);
90 CREATE UNIQUE INDEX xyz1 ON xyz(d, c, b COLLATE nocase);
94 CREATE TABLE xyz(a INT PRIMARY KEY, b, c, d);
95 CREATE UNIQUE INDEX xyz1 ON xyz(d, c, b COLLATE nocase);
100 CREATE UNIQUE INDEX xyz1 ON xyz(d, c, b COLLATE nocase);
106 INSERT INTO xyz VALUES(10, 1, 1, 'one');
123 INSERT INTO xyz VALUES(11, 1, 1, 'one') $oc
128 SELECT * FROM xyz;
182 INSERT INTO abc VALUES(3, 'xyz', 3);
[all …]
H A Dschema6.test83 CREATE TABLE t1(xyz INTEGER, abc, PRIMARY KEY(xyz), UNIQUE(abc));
84 INSERT INTO t1(xyz,abc) VALUES(123,'Four score and seven years ago...');
86 CREATE TABLE t1(xyz INTEGER, abc, UNIQUE(abc), PRIMARY KEY(xyz));
87 INSERT INTO t1(xyz,abc) VALUES(123,'Four score and seven years ago...');
124 CREATE TABLE t1(xyz INTEGER, abc, PRIMARY KEY(xyz), UNIQUE(abc))WITHOUT ROWID;
125 INSERT INTO t1(xyz,abc) VALUES(123,'Four score and seven years ago...');
127 CREATE TABLE t1(xyz INTEGER, abc, UNIQUE(abc), PRIMARY KEY(xyz))WITHOUT ROWID;
128 INSERT INTO t1(xyz,abc) VALUES(123,'Four score and seven years ago...');
H A Dindex7.test110 VALUES('abcde',1,101),('abdef',2,102),('xyz',3,103),('abcz',4,104);
303 INSERT INTO t5 VALUES(1, 'xyz');
304 INSERT INTO t4 VALUES('abc', 'not xyz');
305 SELECT * FROM (SELECT * FROM t5 WHERE a=1 AND b='xyz'), t4 WHERE c='abc';
307 1 xyz abc {not xyz}
310 CREATE INDEX i4 ON t4(c) WHERE d='xyz';
313 1 xyz abc {not xyz}
317 INSERT INTO t4 VALUES('def', 'xyz');
318 SELECT * FROM v4 WHERE d='xyz' AND c='def'
320 def xyz
[all …]
H A Dalterqf.test48 5 {CREATE TABLE xyz(a CHECK (a!="str"), b AS (a||"str"))}
49 {CREATE TABLE xyz(a CHECK (a!='str'), b AS (a||'str'))}
63 10 {CREATE TABLE t2(abc, xyz CHECK (xyz != "123"))}
64 {CREATE TABLE t2(abc, xyz CHECK (xyz != '123'))}
97 CHECK (three!="xyz"), CHECK (two!="one")
111 CHECK (three!='xyz'), CHECK ("four"!="one")
H A Dtkt-2d1a5c67d.test98 INSERT INTO t4 VALUES('xyz');
110 execsql { SELECT * FROM t4 WHERE a = 'xyz' }
111 } {xyz}
115 execsql { SELECT * FROM t4 WHERE a = 'xyz' }
116 } {xyz}
125 execsql { SELECT * FROM t4 WHERE a = 'xyz' } db2
126 } {xyz}
H A Dalter.test714 execsql "CREATE TABLE xyz(x UNIQUE)"
715 execsql "ALTER TABLE xyz RENAME TO xyz\u1234abc"
717 } [list xyz\u1234abc]
743 } {0 {xyz abc 1 2}}
758 } {0 {xyz abc 3 4}}
761 } {0 {xyz abc 3 4}}
764 } {0 {xyz abc 3 4}}
779 } {0 {xyz abc 5 6}}
782 } {0 {xyz abc 5 6}}
785 } {0 {xyz abc 5 6}}
[all …]
H A Dregexp1.test229 SELECT 'abc$¢€xyz' REGEXP '^abc\u0024\u00a2\u20acxyz$',
230 'abc$¢€xyz' REGEXP '^abc\u0024\u00A2\u20ACxyz$',
231 'abc$¢€xyz' REGEXP '^abc\x24\xa2\u20acxyz$'
234 SELECT 'abc$¢€xyz' REGEXP '^abc[\u0024][\u00a2][\u20ac]xyz$',
235 'abc$¢€xyz' REGEXP '^abc[\u0024\u00A2\u20AC]{3}xyz$',
236 'abc$¢€xyz' REGEXP '^abc[\x24][\xa2\u20ac]+xyz$'
239 SELECT 'abc$¢€xyz' REGEXP '^abc[^\u0025-X][^ -\u007f][^\u20ab]xyz$'
H A Ddefault.test77 INSERT INTO t3 VALUES(null, 5, 'row1', '5.25', 'xyz', 321, '432');
81 } {1 integer 5 integer row1 text 5.25 real xyz text 321 text 432 integer}
113 UPDATE sqlite_master SET sql='CREATE TABLE t1(a TEXT, b TEXT DEFAULT(:xyz))';
122 CREATE TABLE t2(a TEXT, b TEXT DEFAULT(:xyz));
125 CREATE TABLE t2(a TEXT, b TEXT DEFAULT(abs(:xyz)));
128 CREATE TABLE t2(a TEXT, b TEXT DEFAULT(98+coalesce(5,:xyz)));
H A Dstrict1.test56 INSERT INTO t1(a) VALUES('xyz');
59 INSERT INTO t1(b) VALUES('xyz');
62 INSERT INTO t1(c) VALUES('xyz');
68 INSERT INTO t1(e) VALUES('xyz');
100 INSERT INTO t1(d) VALUES('xyz'),(4),(5.5),(NULL);
102 } {text xyz text 4 text 5.5 null {}}
113 INSERT INTO t1(e) VALUES('xyz');
H A DanalyzeF.test136 UPDATE t1 SET b='xyz' where a>=9998;
140 … x08 500 x09 500 x0a 500 x0b 500 x0c 500 x0d 500 x0e 500 x0f 500 x10 500 x11 500 x12 498 x13 3 xyz}
143 SELECT * FROM t1 WHERE b='xyz' AND b IS NOT NULL ORDER BY +a;
147 SELECT * FROM t1 WHERE b='xyz' AND b IS NOT NULL ORDER BY +a;
148 } {9998 xyz 9998 9999 xyz 9999 10000 xyz 10000}
H A Dtkt3493.test63 SELECT b.val, CASE WHEN b.val = 1 THEN 'xyz' ELSE b.val END AS col1 FROM b;
65 } {1 xyz 2 2}
70 CASE WHEN b.val = 1 THEN 'xyz' ELSE b.val END AS col1
73 } {1 xyz 2 2}
78 CASE WHEN b.val = '1' THEN 'xyz' ELSE b.val END AS col1
81 } {1 xyz 2 2}
H A Dquota2.test80 set ::h1 [sqlite3_quota_fopen quota2a/xyz.txt w+b]
85 } {PWD/quota2a/xyz.txt 4000 7000}
127 } {{*/quota2b/* 5000 0} {*/quota2a/* 4000 4000 {PWD/quota2a/xyz.txt 4000 1 0}}}
137 } {{*/quota2b/* 5000 0} {*/quota2a/* 4000 3500 {PWD/quota2a/xyz.txt 3500 1 0}}}
158 } {{*/quota2b/* 5000 0} {*/quota2a/* 4000 4000 {PWD/quota2a/xyz.txt 4000 0 0}}}
160 sqlite3_quota_remove quota2a/xyz.txt
168 set ::h1 [sqlite3_quota_fopen quota2c/xyz.txt w+b]
H A Dhook.test785 INSERT INTO t1 VALUES('xyz');
787 INSERT main t1 1 1 0 xyz
788 INSERT main t2 1 1 1 xyz
789 INSERT main t3 1 1 2 xyz
790 INSERT main t4 1 1 3 xyz
795 UPDATE main t1 1 1 0 xyz abc
828 INSERT INTO t1 VALUES('xyz');
830 INSERT main t4 1 1 3 xyz
831 INSERT main t3 1 1 2 xyz
832 INSERT main t2 1 1 1 xyz
[all …]
H A Dinsert3.test77 INSERT INTO t1(a) VALUES('xyz');
80 } {5 4 453 2 hello 4 xyz 1}
147 b DEFAULT 'xyz'
152 } {1 xyz}
158 } {1 xyz 2 xyz}
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5rank.test29 CREATE VIRTUAL TABLE xyz USING fts5(z);
33 execsql { INSERT INTO xyz VALUES($doc) }
36 SELECT highlight(xyz, 0, '[', ']') FROM xyz WHERE xyz MATCH 'x' ORDER BY rank
40 SELECT highlight(xyz, 0, '[', ']') FROM xyz
41 WHERE xyz MATCH 'x AND y' ORDER BY rank
106 INSERT INTO y1 VALUES('test xyz');
107 INSERT INTO y1 VALUES('test test xyz test');
108 INSERT INTO y1 VALUES('test test xyz');
128 SELECT rowid FROM y1('test OR xyz') ORDER BY rank
H A Dfts5aa.test369 SELECT NULL, 'xyz xyz xyz xyz xyz xyz'
371 SELECT NULL, 'xyz xyz xyz xyz xyz xyz' FROM d
382 db eval { SELECT * FROM t1 WHERE t1 MATCH 'xyz' } {
396 db eval { SELECT * FROM t1 WHERE t1 MATCH 'xyz' } {
413 UPDATE t1_content SET c1 = 'xyz xyz xyz xyz xyz abc' WHERE rowid = 1;

1234567