[MDEV-26262] frm is reported corrupted after ER_EXPRESSION_REFERS_TO_UNINIT_FIELD - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL)
Fix Version/s: 10.2.41, 10.3.32, 10.4.22, 10.5.13, 10.6.5, 10.7.1
Component/s: Virtual Columns
Labels:
None

CREATE TABLE t1 (a INT,b INT AS (b is NULL) VIRTUAL);

Leads to:

10.7.0 71ed8c136fa203b9b3a678a6d5cc72235ef73ef7 (Debug)
10.7.0-dbg>CREATE TABLE t1 (a INT,b INT AS (b is NULL) VIRTUAL);
ERROR 4029 (01000): Expression for field `b` is referring to uninitialized field `b`

Yet;

10.7.0 71ed8c136fa203b9b3a678a6d5cc72235ef73ef7 (Debug)
2021-07-28 20:18:44 4 [ERROR] mysqld: Incorrect information in file: './test/t1.frm'

May only be a cosmetic issue (i.e. the error in the error log should not be shown as the table is never created successfully).

If no underlying bug, propose to not show (i.e. prevent) any error in error log (so as to not confuse DBA's).

duplicates

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

Estimated:

Remaining:

Logged:

2d 55m

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