|
MariaDB [test]> CREATE TABLE t1 (d DATE, v TINYINT(1) AS (d >= CURDATE()));
|
Query OK, 0 rows affected (0.21 sec)
|
|
MariaDB [test]> INSERT INTO t1 (d) VALUES (CURDATE());
|
Query OK, 1 row affected (0.04 sec)
|
|
OK
|
MariaDB [test]> SELECT * FROM t1;
|
+------------+------+
|
| d | v |
|
+------------+------+
|
| 2017-10-11 | 1 |
|
+------------+------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> SELECT d, v FROM t1;
|
+------------+------+
|
| d | v |
|
+------------+------+
|
| 2017-10-11 | 1 |
|
+------------+------+
|
1 row in set (0.00 sec)
|
MariaDB [test]> SET timestamp = @@timestamp + 3600*24;
|
Query OK, 0 rows affected (0.00 sec)
|
|
First one is not OK
|
MariaDB [test]> SELECT * FROM t1;
|
+------------+------+
|
| d | v |
|
+------------+------+
|
| 2017-10-11 | 1 |
|
+------------+------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> SELECT d, v FROM t1;
|
+------------+------+
|
| d | v |
|
+------------+------+
|
| 2017-10-11 | 0 |
|
+------------+------+
|
1 row in set (0.00 sec)
|
|
Test case
|
CREATE TABLE t1 (d DATE, v TINYINT(1) AS (d >= CURDATE()));
|
INSERT INTO t1 (d) VALUES (CURDATE());
|
SELECT * FROM t1;
|
SELECT d, v FROM t1;
|
SET timestamp = @@timestamp + 3600*24;
|
SELECT * FROM t1;
|
SELECT d, v FROM t1;
|
|
DROP TABLE t1;
|
|