Lines Matching refs:x

377       x INTEGER CHECK(tointeger(x) IS NOT NULL)
382       INSERT INTO t1 (x) VALUES (NULL);
384   } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
387       INSERT INTO t1 (x) VALUES (NULL);
389   } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
392       INSERT INTO t1 (x) VALUES ('');
394   } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
397       INSERT INTO t1 (x) VALUES ('bad');
399   } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
402       INSERT INTO t1 (x) VALUES ('1234bad');
404   } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
407       INSERT INTO t1 (x) VALUES ('1234.56bad');
409   } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
412       INSERT INTO t1 (x) VALUES (1234);
417       INSERT INTO t1 (x) VALUES (1234.56);
419   } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
422       INSERT INTO t1 (x) VALUES ('1234');
427       INSERT INTO t1 (x) VALUES ('1234.56');
429   } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
432       INSERT INTO t1 (x) VALUES (ZEROBLOB(4));
434   } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
437       INSERT INTO t1 (x) VALUES (X'');
439   } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
442       INSERT INTO t1 (x) VALUES (X'1234');
444   } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
447       INSERT INTO t1 (x) VALUES (X'12345678');
449   } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
452       INSERT INTO t1 (x) VALUES ('1234.00');
457       INSERT INTO t1 (x) VALUES (1234.00);
462       INSERT INTO t1 (x) VALUES ('-9223372036854775809');
468         INSERT INTO t1 (x) VALUES (9223372036854775808);
470     } {1 {CHECK constraint failed: tointeger(x) IS NOT NULL}}
473     SELECT x FROM t1 WHERE x>0 ORDER BY x;
479         x REAL CHECK(toreal(x) IS NOT NULL)
484         INSERT INTO t2 (x) VALUES (NULL);
486     } {1 {CHECK constraint failed: toreal(x) IS NOT NULL}}
489         INSERT INTO t2 (x) VALUES (NULL);
491     } {1 {CHECK constraint failed: toreal(x) IS NOT NULL}}
494         INSERT INTO t2 (x) VALUES ('');
496     } {1 {CHECK constraint failed: toreal(x) IS NOT NULL}}
499         INSERT INTO t2 (x) VALUES ('bad');
501     } {1 {CHECK constraint failed: toreal(x) IS NOT NULL}}
504         INSERT INTO t2 (x) VALUES ('1234bad');
506     } {1 {CHECK constraint failed: toreal(x) IS NOT NULL}}
509         INSERT INTO t2 (x) VALUES ('1234.56bad');
511     } {1 {CHECK constraint failed: toreal(x) IS NOT NULL}}
514         INSERT INTO t2 (x) VALUES (1234);
519         INSERT INTO t2 (x) VALUES (1234.56);
524         INSERT INTO t2 (x) VALUES ('1234');
529         INSERT INTO t2 (x) VALUES ('1234.56');
534         INSERT INTO t2 (x) VALUES (ZEROBLOB(4));
536     } {1 {CHECK constraint failed: toreal(x) IS NOT NULL}}
539         INSERT INTO t2 (x) VALUES (X'');
541     } {1 {CHECK constraint failed: toreal(x) IS NOT NULL}}
544         INSERT INTO t2 (x) VALUES (X'1234');
546     } {1 {CHECK constraint failed: toreal(x) IS NOT NULL}}
549         INSERT INTO t2 (x) VALUES (X'12345678');
551     } {1 {CHECK constraint failed: toreal(x) IS NOT NULL}}
553       SELECT x FROM t2 ORDER BY x;
662     SELECT tointeger(x'[string repeat 01 $i]');
666       SELECT toreal(x'[string repeat 01 $i]');
672   SELECT tointeger(x'0102030405060708');
675   SELECT tointeger(x'0807060504030201');
680     SELECT toreal(x'ffefffffffffffff');
683     SELECT toreal(x'8010000000000000');
686     SELECT toreal(x'c000000000000000');
689     SELECT toreal(x'bff0000000000000');
692     SELECT toreal(x'8000000000000000');
695     SELECT toreal(x'0000000000000000');
698     SELECT toreal(x'3ff0000000000000');
701     SELECT toreal(x'4000000000000000');
704     SELECT toreal(x'0010000000000000');
707     SELECT toreal(x'7fefffffffffffff');
710     SELECT toreal(x'8000000000000001');
713     SELECT toreal(x'800fffffffffffff');
716     SELECT toreal(x'0000000000000001');
719     SELECT toreal(x'000fffffffffffff');
722     SELECT toreal(x'fff0000000000000');
725     SELECT toreal(x'7ff0000000000000');
728     SELECT toreal(x'fff8000000000000');
731     SELECT toreal(x'fff0000000000001');
734     SELECT toreal(x'fff7ffffffffffff');
737     SELECT toreal(x'7ff0000000000001');
740     SELECT toreal(x'7ff7ffffffffffff');
743     SELECT toreal(x'fff8000000000001');
746     SELECT toreal(x'ffffffffffffffff');
749     SELECT toreal(x'7ff8000000000000');
752     SELECT toreal(x'7fffffffffffffff');