Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
Description
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 AS SELECT |
CAST(1.1111111111 AS SIGNED) AS c1, |
CAST(1.1111111111 AS UNSIGNED) AS c2; |
DESC t1; |
+-------+---------------------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+---------------------+------+-----+---------+-------+
|
| c1 | bigint(13) | NO | | NULL | |
|
| c2 | bigint(20) unsigned | NO | | NULL | |
|
+-------+---------------------+------+-----+---------+-------+
|
Looks wrong:
- the data type is wrong. It should be int instead of bigint
- the length is too large. It should be around 1.
Attachments
Issue Links
- 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