Home
last modified time | relevance | path

Searched refs:CAST (Results 1 – 25 of 64) sorted by relevance

123

/sqlite-3.40.0/test/
H A Dcast.test25 # Tests for the CAST( AS blob), CAST( AS text) and CAST( AS numeric) built-ins
241 execsql {SELECT CAST(CAST(9223372036854774800 AS real) AS integer)}
253 execsql {SELECT CAST(CAST(-9223372036854774800 AS real) AS integer)}
266 execsql {SELECT CAST(CAST('9223372036854774800' AS real) AS integer)}
280 execsql {SELECT CAST(CAST('-9223372036854774800' AS real) AS integer)}
296 SELECT CAST(CAST(x'39323233333732303336383534373734383030' AS real)
342 SELECT CAST(a AS integer), a, CAST(a AS real), a FROM t1;
395 SELECT CAST('-' AS NUMERIC);
401 SELECT CAST('+' AS NUMERIC);
404 SELECT CAST('/' AS NUMERIC);
[all …]
H A De_expr.test730 49 "CAST ( EXPR AS integer )"
731 50 "CAST ( EXPR AS 'abcd' )"
1431 typeof(CAST(X'555655' as TEXT)), CAST(X'555655' as TEXT),
1432 typeof(CAST('1.23abc' as REAL)), CAST('1.23abc' as REAL),
1433 typeof(CAST(4.5 as INTEGER)), CAST(4.5 as INTEGER)
1707 CAST(' ' AS NUMERIC)
1726 SELECT typeof(CAST(x AS NUMERIC)), CAST(x AS NUMERIC)||'' FROM t1;
1755 1 { CAST(123 AS BLOB) } 1
1756 2 { CAST('' AS BLOB) } 0
1757 3 { CAST('abcd' AS BLOB) } 1
[all …]
H A Dboundary3.test308 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
315 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
355 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
362 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)
402 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
409 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
511 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
518 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)
605 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
612 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)
[all …]
H A Dintreal.test53 SELECT substr(a,1,4) FROM t2 WHERE a = CAST(836627109860825358 AS REAL);
58 SELECT substr(a,1,4) FROM t2 WHERE a = CAST(836627109860825358 AS REAL);
70 SELECT * FROM t1 WHERE (t1.c1 = CAST(8366271098608253588 AS REAL));
74 SELECT * FROM t0, t1 WHERE (t1.c1 = CAST(8366271098608253588 AS REAL));
80 t1.c1 >= CAST(8366271098608253588 AS REAL)
81 AND t1.c1 <= CAST(8366271098608253588 AS REAL)
H A Dlike2.test24 INSERT INTO t1(x,y) VALUES(1,CAST(x'01' AS TEXT));
25 INSERT INTO t1(x,y) VALUES(2,CAST(x'02' AS TEXT));
26 INSERT INTO t1(x,y) VALUES(3,CAST(x'03' AS TEXT));
27 INSERT INTO t1(x,y) VALUES(4,CAST(x'04' AS TEXT));
28 INSERT INTO t1(x,y) VALUES(5,CAST(x'05' AS TEXT));
29 INSERT INTO t1(x,y) VALUES(6,CAST(x'06' AS TEXT));
30 INSERT INTO t1(x,y) VALUES(7,CAST(x'07' AS TEXT));
31 INSERT INTO t1(x,y) VALUES(8,CAST(x'08' AS TEXT));
32 INSERT INTO t1(x,y) VALUES(9,CAST(x'09' AS TEXT));
33 INSERT INTO t1(x,y) VALUES(10,CAST(x'0a' AS TEXT));
[all …]
H A Denc3.test64 SELECT CAST(a AS text) FROM t2 WHERE CAST(a AS text) LIKE 'abc%';
69 SELECT CAST(x'61006200630064006500' AS text);
75 WHERE CAST(a AS text) LIKE CAST(x'610062002500' AS text);
H A Dnan.test97 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
103 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
109 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
115 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
121 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
127 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
132 SELECT CAST(x AS text), typeof(x) FROM t1;
250 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
255 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
308 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
[all …]
H A Dwindow3.test2001 SELECT group_concat(CAST(b AS TEXT), '.') OVER win2
4461 SELECT group_concat(CAST(b AS TEXT), '.') OVER win2
6095 SELECT group_concat(CAST(b AS TEXT), '.') OVER win2
8153 SELECT group_concat(CAST(b AS TEXT), '.') OVER win2
10319 SELECT group_concat(CAST(b AS TEXT), '.') OVER win2
11934 SELECT group_concat(CAST(b AS TEXT), '.') OVER win2
13984 SELECT group_concat(CAST(b AS TEXT), '.') OVER win2
15717 SELECT group_concat(CAST(b AS TEXT), '.') OVER win2
17107 SELECT group_concat(CAST(b AS TEXT), '.') OVER win2
19237 SELECT group_concat(CAST(b AS TEXT), '.') OVER win2
[all …]
H A Dindexexpr2.test260 SELECT a, b FROM x1 WHERE CAST(b AS INTEGER) = 123;
263 CREATE INDEX x1i ON x1( CAST(b AS INTEGER) );
264 SELECT a, b FROM x1 WHERE CAST(b AS INTEGER) = 123;
267 SELECT a, b FROM x1 WHERE CAST(b AS INTEGER) = 123;
271 SELECT a, b FROM x1 WHERE CAST(b AS TEXT) = 123;
274 CREATE INDEX x1i2 ON x1( CAST(b AS TEXT) );
275 SELECT a, b FROM x1 WHERE CAST(b AS TEXT) = 123;
278 SELECT a, b FROM x1 WHERE CAST(b AS TEXT) = 123;
H A Dbadutf2.test71 set sql "SELECT '$hstr'=CAST(x'$uval' AS text) AS x;"
76 set sql "SELECT CAST('$hstr' AS blob)=x'$uval' AS x;"
82 set sql "SELECT hex(CAST(x'$uval' AS text)) AS x;"
87 set sql "SELECT hex(CAST(x'$uval' AS text)) AS x;"
H A Dfuzz.test86 SELECT CAST(zeroblob(1000) AS text);
181 SELECT hex(CAST(zeroblob(1000) AS integer))
241 ORDER BY CAST(-56.1 AS blob) ASC
256 )), CAST(456 AS integer), -2147483647
258 SELECT DISTINCT -456, CAST(1 AS integer) ISNULL
262 GROUP BY CAST(CAST('experiments' AS blob) AS blob)
H A Dtkt2822.test89 SELECT a, CAST (b AS TEXT), c FROM t1
106 SELECT a, CAST (b AS TEXT) AS x, c FROM t1
122 SELECT a, CAST (b AS TEXT) AS x, c FROM t1
125 ORDER BY CAST (b AS TEXT);
145 SELECT a AS b, CAST (b AS TEXT) AS a, c FROM t1
155 SELECT a AS b, CAST (b AS TEXT) AS a, c FROM t1
169 SELECT a, CAST (b AS TEXT) AS x, c FROM t1
172 ORDER BY CAST (b AS INTEGER);
H A Daltertab3.test434 CAST(CAST(CAST(CAST(CAST(CAST(CAST(CAST(CAST(CAST(CAST(RIGHT
666 …+ 0xa ISNULL WHEN NOT + 0x9 THEN t0.c1 ELSE CURRENT_TIME LIKE CAST (t0.c1 REGEXP '-([1…
H A Dzeroblob.test156 # Check various CAST(...) operations on zeroblob.
160 SELECT CAST (zeroblob(100) AS REAL);
165 SELECT CAST (zeroblob(100) AS INTEGER);
170 SELECT CAST (zeroblob(100) AS TEXT);
175 SELECT CAST(zeroblob(100) AS BLOB);
H A Dfuzz_common.tcl78 {CAST([Expr $c] AS blob)} \
79 {CAST([Expr $c] AS text)} \
80 {CAST([Expr $c] AS integer)} \
81 {CAST([Expr $c] AS real)} \
H A Datof1.test51 set y [db eval {SELECT $x=CAST(quote($x) AS real)}]
53 db eval {SELECT real2hex($x) a, real2hex(CAST(quote($x) AS real)) b} {}
56 db eval {SELECT CAST(quote($x) AS real) c} {}
H A Dfuzz2.test92 …CAST ( "AAAAAA" . "AAAAAA" . "AAAAAA" AS AAAAAA ) ORDER BY , , IS NULL ASC , ~ AND DESC LIMIT ( ( …
95 …CAST ( "AAAAAA" . "AAAAAA" . "AAAAAA" AS AAAAAA ) ORDER BY , , IS NULL ASC , ~ AND DESC LIMIT ( ( …
H A Dnumcast.test38 db eval {SELECT CAST($str AS real)}
41 db eval {SELECT CAST($str AS integer)}
H A Daffinity2.test65 CREATE INDEX ii ON ttt(CAST(c0 AS NUMERIC));
69 SELECT * FROM ttt WHERE CAST(c0 AS NUMERIC) > c1 GROUP BY rowid;
72 SELECT * FROM ttt INDEXED BY ii WHERE CAST(c0 AS NUMERIC) > c1 GROUP BY rowid;
H A Dfunc3.test160 SELECT likely(CAST(1 AS INT))=='1';
163 SELECT unlikely(CAST(1 AS INT))=='1';
166 SELECT likelihood(CAST(1 AS INT),0.5)=='1';
H A Dtkt3527.test60 CAST(Element.Code AS VARCHAR(50)) AS ElemId,
73 CAST(ElemOr.CodeOr AS VARCHAR(50)) AS ElemId,
H A Dfilter2.tcl105 string_agg(CAST(b AS TEXT), '_') FILTER (WHERE b%2!=0),
106 string_agg(CAST(b AS TEXT), '_') FILTER (WHERE b%2!=1),
H A Dfilter2.test116 group_concat(CAST(b AS TEXT), '_') FILTER (WHERE b%2!=0),
117 group_concat(CAST(b AS TEXT), '_') FILTER (WHERE b%2!=1),
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5unicode3.test87 SELECT count(*), min(i) FROM ii WHERE fts5_fold(i)!=CAST(tcl_fold(i) AS int);
97 WHERE fts5_fold(i,1)!=CAST(tcl_fold(i,1) AS int);
107 WHERE fts5_fold(i,2)!=CAST(tcl_fold(i,2) AS int);
117 WHERE fts5_isalnum(i)!=CAST(tcl_isalnum(i) AS int);
/sqlite-3.40.0/tool/
H A Dmkkeywordhash.c77 # define CAST 0 macro
79 # define CAST 0x00000020 macro
192 { "CAST", "TK_CAST", CAST, 5 },

123