Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL), 10.3(EOL)
Description
CREATE OR REPLACE TABLE t1 (a DOUBLE(255,4),b DOUBLE(255,3)); |
CREATE OR REPLACE TABLE t2 AS SELECT COALESCE(a,b) FROM t1; |
SHOW CREATE TABLE t2; |
+-------+---------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+---------------------------------------------------------------------------------------------------------+
|
| t2 | CREATE TABLE `t2` (
|
`COALESCE(a,b)` double(256,4) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+---------------------------------------------------------------------------------------------------------+
|
Notice, a column of an impossible type double(256,4) was created.
If I try to create a column of the same type directly, I correctly get an error:
CREATE OR REPLACE TABLE t1 (a DOUBLE(256,4)); |
ERROR 1439 (42000): Display width out of range for 'a' (max = 255)
|
Attachments
Issue Links
- blocks
-
MDEV-4912 Data type plugin API version 1
-
- Closed
-
Activity
| Status | Open [ 1 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2017-04-27 11:41:03.0 | 2017-04-27 11:41:03.614 |
| Fix Version/s | 10.3.1 [ 22532 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 80488 ] | MariaDB v4 [ 152023 ] |