Lines Matching refs:value
33 SELECT CASE WHEN value%3!=0 THEN value END, value, value
34 FROM nums WHERE value<=20;
150 INSERT INTO t2(a,b) SELECT value, value FROM nums WHERE value<1000;
218 INSERT INTO t3 SELECT value, value FROM nums WHERE value<200;
223 # unable to insert a duplicate row a-value that is not 999.
306 CREATE INDEX i8c ON t8b(y) WHERE x = 'value';
312 INSERT INTO t8b VALUES('value', 1);
314 INSERT INTO t8b VALUES('value', 3);
319 SELECT * FROM t8a LEFT JOIN t8b ON (x = 'value' AND y = a)
327 SELECT * FROM t8a LEFT JOIN t8b ON (x = 'value' AND y = a)
329 1 one value 1
331 3 three value 3