Home
last modified time | relevance | path

Searched refs:v0 (Results 1 – 23 of 23) sorted by relevance

/sqlite-3.40.0/test/
H A DwindowD.test20 CREATE VIEW v0(c0, c1)
26 SELECT ('500') IS (v0.c1) FROM v0;
32 SELECT (('500') IS (v0.c1)) FROM v0, t0;
38 SELECT (('500') IS (v0.c1)) IS FALSE FROM v0;
44 SELECT * FROM v0;
50 SELECT * FROM v0 WHERE ('500' IS v0.c1) IS FALSE;
H A Dunionall.test406 CREATE VIEW v0(c0) AS SELECT CAST(t0.c0 AS INTEGER) FROM t0;
414 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
417 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
420 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
424 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
427 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
430 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
434 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
437 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
440 …SELECT * FROM (SELECT t1.a, t1.b, t0.c0 AS c, v0.c0 AS d FROM t0 LEFT JOIN v0 ON v0.c0>'0',t1) WHE…
H A DwhereL.test133 CREATE VIEW v0(c0) AS SELECT CAST(0 AS INT) FROM t0;
134 SELECT 200, * FROM t0, v0 WHERE 0 = t0.c0 AND t0.c0 = v0.c0;
137 SELECT 200, * FROM t0, v0 WHERE t0.c0 = 0 AND t0.c0 = v0.c0;
140 SELECT 200, * FROM t0, v0 WHERE 0 = t0.c0 AND v0.c0 = t0.c0;
143 SELECT 200, * FROM t0, v0 WHERE t0.c0 = 0 AND v0.c0 = t0.c0;
H A Dtkt-18458b1a.test36 CREATE VIEW v0(c0, c1) AS SELECT DISTINCT t0.c0, 'a' FROM t0;
40 SELECT count(*) FROM v0 WHERE c1 >= c0;
44 SELECT count(*) FROM v0 WHERE NOT NOT (c1 >= c0);
48 SELECT count(*) FROM v0 WHERE ((c1 >= c0) OR 0+0);
H A Djoin2.test320 CREATE VIEW v0(c0) AS SELECT CAST(t0.c0 AS INTEGER) FROM t0;
325 SELECT typeof(c0), c0 FROM v0 WHERE c0>='0'
329 SELECT * FROM t0, v0 WHERE v0.c0 >= '0';
333 SELECT * FROM t0 LEFT JOIN v0 WHERE v0.c0 >= '0';
337 SELECT * FROM t0 LEFT JOIN v0 ON v0.c0 >= '0';
341 SELECT * FROM t0 LEFT JOIN v0 ON v0.c0 >= '0' WHERE TRUE
H A DtriggerG.test81 CREATE VIEW v0(a) AS SELECT 1234;
82 CREATE TRIGGER t0001 INSTEAD OF DELETE ON v0 BEGIN
87 SELECT a FROM v0;
90 DELETE FROM v0;
H A Dminmax4.test226 CREATE VIEW v0(c0, c1) AS
230 SELECT c0, c1 FROM v0;
233 SELECT v0.c0, MIN(v0.c1) FROM v0;
H A Dnulls1.test261 CREATE TABLE v0 (c1, c2, c3);
262 CREATE INDEX v3 ON v0 (c1, c2, c3);
266 INSERT INTO sqlite_stat1 VALUES('v0','v3','648 324 81');
271 INSERT INTO v0 VALUES
287 SELECT c1, c2, ifnull(c3, 'NULL') FROM v0
295 SELECT c1, c2, ifnull(c3, 'NULL') FROM v0
297 } {SEARCH v0 USING COVERING INDEX v3 (ANY(c1) AND c2=?)}
H A DjoinH.test64 CREATE VIEW v0(c0) AS SELECT FALSE;
68 SELECT * FROM t0 LEFT OUTER JOIN t1 ON v0.c0 INNER JOIN v0 INNER JOIN t2 ON (t2.c2 NOT NULL);
H A Dselect4.test1014 CREATE VIEW v0(v0) AS WITH v0 AS(SELECT 0 v0) SELECT(SELECT min(v0) OVER()) FROM v0 GROUP BY v0;
1015 SELECT *FROM v0 v1 JOIN v0 USING(v0) WHERE datetime(v0) = (v0.v0)AND v0 = 10;
H A Din6.test93 CREATE TABLE v0(v1);
95 INSERT INTO v0 VALUES(0);
97 SELECT quote(v5) FROM v0 LEFT JOIN v3 ON v4 = NULL AND v5 IN(0);
H A Djoin.test941 CREATE VIEW v0 AS SELECT a FROM t1 LEFT JOIN t0;
946 SELECT * FROM v0 WHERE NOT(v0.a IS FALSE);
954 SELECT NOT(v0.a IS FALSE) FROM v0
963 CREATE VIEW v0(c) AS SELECT t2.b FROM t1 LEFT JOIN t2;
967 SELECT * FROM v0 WHERE v0.c NOTNULL NOTNULL;
1047 CREATE VIEW v0(c0) AS SELECT 0 GROUP BY 1;
1048 SELECT t0.c0, v0.c0, vt0.name
1049 FROM v0, t0 LEFT JOIN pragma_table_info('t0') AS vt0
1051 WHERE v0.c0 == 0;
1085 CREATE VIEW v0 AS SELECT (NULL AND 5) as c0 FROM t0;
[all …]
H A Dcse.test195 CREATE TABLE v0(v1 VARCHAR0);
196 INSERT INTO v0 VALUES(2), (3);
197 SELECT 0 IN(SELECT v1) FROM v0 WHERE v1 = 2 OR(SELECT v1 LIMIT 0);
H A Dview.test719 CREATE VIEW v0(c0, c1) AS SELECT t0.c0, AVG(t0.c1) FROM t0;
723 SELECT c0, typeof(c0), c1, typeof(c1) FROM v0;
729 do_execsql_test view-27.2 { SELECT c0<c1 FROM v0 } 1
730 do_execsql_test view-27.3 { SELECT c1<c0 FROM v0 } 0
732 SELECT 1 FROM v0 WHERE c1<c0
735 SELECT 1 FROM v0 WHERE c0<c1
755 CREATE VIEW v0(c0) AS SELECT t0.c0 FROM t0;
H A Djoin8.test429 CREATE VIEW v0 AS SELECT 'xyz' AS d;
430 SELECT * FROM v0 RIGHT JOIN t1 ON t1.a<>'' INNER JOIN t0 ON t0.c<>'';
431 SELECT * FROM v0 RIGHT JOIN t1 ON t1.a<>'' INNER JOIN t0 ON t0.c<>'' WHERE b ISNULL;
635 CREATE VIEW v0(y) AS SELECT x FROM t1;
640 SELECT * FROM t2 JOIN v0 ON z<>'bbb' RIGHT JOIN t1 ON z<>'ccc';
643 SELECT * FROM t2 JOIN v0 ON z<>'bbb' RIGHT JOIN t1 ON z<>'ccc' ORDER BY z;
646 SELECT 99 as "m" FROM t2 JOIN v0 ON z<>'bbb' RIGHT JOIN t1 ON z<>'ccc';
649 SELECT 99 as "m" FROM t2 JOIN v0 ON z<>'bbb' RIGHT JOIN t1 ON z<>'ccc' ORDER BY z;
653 FROM (SELECT 99 as "m" FROM t2 JOIN v0 ON z<>'' RIGHT JOIN t1 ON z<>'') AS "t3";
657 FROM (SELECT 99 as "m" FROM t2 JOIN v0 ON z<>'' RIGHT JOIN t1 ON z<>'' ORDER BY z) AS "t3";
H A Daltertab3.test538 CREATE TABLE v0 (a);
552 ALTER TABLE v0 RENAME TO t3 ;
559 CREATE TABLE v0 (v1);
562 ( SELECT v1 AS PROMO_REVENUE FROM v2 JOIN v0 USING ( VALUE ) ) AND 0 )
568 ALTER TABLE v0 RENAME TO x ;
574 0 AND (SELECT rowid FROM v0)
581 ALTER TABLE v0 RENAME TO xyz;
H A Dselect7.test213 CREATE VIEW v0 as SELECT x, y FROM t01 UNION SELECT x FROM t02;
214 EXPLAIN QUERY PLAN SELECT * FROM v0 WHERE x='0' OR y;
H A Daltertab.test803 CREATE VIEW v0 AS
810 SELECT * FROM v0
818 SELECT sql FROM sqlite_schema WHERE name='v0'
819 } {{CREATE VIEW v0 AS
H A Dwindow1.test1358 CREATE VIEW v0(c) AS SELECT max((SELECT count(a)OVER(ORDER BY 1))) FROM t0;
1359 SELECT c FROM v0 WHERE c BETWEEN 10 AND 20;
1362 DROP VIEW v0;
1363 CREATE VIEW v0(c) AS SELECT max((SELECT count(a)OVER(ORDER BY 1234))) FROM t0;
1364 SELECT c FROM v0 WHERE c BETWEEN -10 AND 20;
1870 CREATE TABLE v0 ( v1 INTEGER PRIMARY KEY ) ;
1871 INSERT INTO v0 VALUES ( 10 ) ;
1872 SELECT DISTINCT v1, lead(v1) OVER() FROM v0 GROUP BY v1 ORDER BY 2;
H A Din5.test257 CREATE VIEW v0(c0) AS SELECT LOWER(CAST('1e500' AS TEXT)) FROM t0;
H A Dsqllimits1.test724 CREATE TABLE v0(a);
725 INSERT INTO v0 VALUES(1);
/sqlite-3.40.0/ext/rtree/
H A Drtree1.test729 CREATE VIEW v0(x) AS SELECT DISTINCT rt0.b FROM rt0;
730 SELECT v0.x FROM v0, rt0;
733 SELECT v0.x FROM v0, rt0 WHERE v0.x = rt0.b;
/sqlite-3.40.0/src/
H A Dfunc.c2143 double v0, ans; in math1Func() local
2148 v0 = sqlite3_value_double(argv[0]); in math1Func()
2150 ans = x(v0); in math1Func()
2165 double v0, v1, ans; in math2Func() local
2172 v0 = sqlite3_value_double(argv[0]); in math2Func()
2175 ans = x(v0, v1); in math2Func()