Lines Matching refs:date

12 # focus of this file is testing date and time functions used in
19 # Skip this whole file if date and time functions are omitted
28   CREATE TABLE t1(x, y, CHECK( date(x) BETWEEN '2017-07-01' AND '2017-07-31' ));
33 } {1 {non-deterministic use of date() in a CHECK constraint}}
39 } {1 {CHECK constraint failed: date(x) BETWEEN '2017-07-01' AND '2017-07-31'}}
44   CREATE TABLE t1(x, y, z AS (date()));
46 } {1 {non-deterministic use of date() in a generated column}}
51   CREATE INDEX t2y ON t2(date(y));
55 } {1 {non-deterministic use of date() in an index}}
93     WHERE date(b) BETWEEN '2017-06-01' AND '2017-08-31';
94 } {1 {non-deterministic use of date() in an index}}
98     WHERE date(b) BETWEEN '2017-06-01' AND '2017-08-31';
102 } {1 {non-deterministic use of date() in an index}}