[MDEV-15962] Column-level CHECK constraint on timestamp column causes ER_EXPRESSION_REFERS_TO_UNINIT_FIELD - Jira

XML

Word

Printable

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.4(EOL)
Component/s: Data Definition - Alter Table, Data Definition - Create Table, Server
Labels:
None

10.2 469a4b02ce
MariaDB [test]> CREATE TABLE t1 (t TIMESTAMP CHECK(t>'2018-01-01 00:00:00'));
ERROR 4029 (01000): Expression for field `t` is refering to uninitialized field `t`

Datetime works all right.

MariaDB [test]> CREATE TABLE t1 (t DATETIME CHECK(t>'2018-01-01 00:00:00'));

Query OK, 0 rows affected (0.39 sec)

Table-level CHECK also works all right:

MariaDB [test]> CREATE TABLE t2 (t TIMESTAMP, CHECK(t>'2018-01-01 00:00:00'));

Query OK, 0 rows affected (0.19 sec)

relates to

MDEV-18278 Misleading error message in error log upon failed table creation

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.