-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.1, 10.2, 10.3
-
Fix Version/s: 10.3.7
-
Component/s: Data types, Stored routines
-
Labels:None
DROP TABLE IF EXISTS t1; |
DELIMITER $$
|
BEGIN NOT ATOMIC |
DECLARE var TEXT CHARACTER SET utf8; |
CREATE TABLE t1 AS SELECT var; |
END; |
$$
|
DELIMITER ;
|
SHOW CREATE TABLE t1; |
+-------+---------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+---------------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`var` mediumtext CHARACTER SET utf8 DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+---------------------------------------------------------------------------------------------------------------+
|
Notice, the column data type in the table does not match the variable data type.
The expected data type for t1.var should be TEXT CHARACTER SET utf8 rather than MEDIUMTEXT CHARACTER SET utf8.
- blocks
-
MDEV-4912 Data type plugin API version 1
-
- Closed
-
- relates to
-
MDEV-13232 Assertion `(&(&share->intern_lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&share->intern_lock)->m_mutex)->thread)' failed in _ma_state_info_write
-
- Closed
-