Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11
-
None
-
Can result in unexpected behaviour
Description
10.11.19-dbg>CREATE TABLE t (pk INT PRIMARY KEY, a VARBINARY(10) NOT NULL DEFAULT '', v TINYINT AS (a & 65536) VIRTUAL, KEY(v)) ENGINE=InnoDB;
|
Query OK, 0 rows affected (0.009 sec)
|
|
|
10.11.19-dbg> INSERT IGNORE INTO t (pk) VALUES (1);
|
Query OK, 1 row affected, 1 warning (0.001 sec)
|
|
|
10.11.19-dbg> CHECK TABLE t EXTENDED;
|
+--------+-------+----------+---------------------------------------+
|
| Table | Op | Msg_type | Msg_text |
|
+--------+-------+----------+---------------------------------------+
|
| test.t | check | Warning | Truncated incorrect DECIMAL value: '' |
|
| test.t | check | status | OK |
|
+--------+-------+----------+---------------------------------------+
|
2 rows in set (0.000 sec)
|
Plain check table t; is clean but with extended we see a warning
10.11.19-dbg> CHECK TABLE t ;
|
+--------+-------+----------+----------+
|
| Table | Op | Msg_type | Msg_text |
|
+--------+-------+----------+----------+
|
| test.t | check | status | OK |
|
+--------+-------+----------+----------+
|
1 row in set (0.000 sec)
|