Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL)
-
None
Description
SET sql_mode=''; |
SELECT 1e14 DIV 2 AS c1, '' DIV 2 AS c2; |
CREATE OR REPLACE TABLE t1 AS SELECT 1e14 DIV 2 AS c1, '' DIV 2 AS c2; |
SELECT * FROM t1; |
SHOW CREATE TABLE t1; |
+----------------+------+
|
| c1 | c2 |
|
+----------------+------+
|
| 50000000000000 | 0 |
|
+----------------+------+
|
+------------+------+
|
| c1 | c2 |
|
+------------+------+
|
| 2147483647 | 0 |
|
+------------+------+
|
+-------+-------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-------------------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`c1` int(4) DEFAULT NULL,
|
`c2` int(0) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+-------------------------------------------------------------------------------------------------------------------+
|
Notice:
- The value of c1 in the second result is wrong. It should be 50000000000000.
- The data type for t1.c1 is wrong. It should be approximately bigint(14).
- The data type for t1.c2 is wrong. It should be at least int(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