Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.2.29, 10.3.20, 10.4.12, 10.5.1
-
None
Description
Consider the example run with MDB 10.4.11.
|
|
MariaDB [test]> create table t1 (si smallint) engine=columnstore;
|
Query OK, 0 rows affected (0.480 sec)
|
|
|
MariaDB [test]> drop table t1;
|
Query OK, 0 rows affected (0.354 sec)
|
|
|
MariaDB [test]> create table t1 (si smallint);
|
Query OK, 0 rows affected (0.020 sec)
|
|
|
MariaDB [test]> insert into t1 values (-8.76221);
|
Query OK, 1 row affected (0.004 sec)
|
|
|
MariaDB [test]> select conv(si, 16, 8) from t;
|
+------------------------+
|
| conv(si, 16, 8) |
|
+------------------------+
|
| 1777777777777777777767 |
|
+------------------------+
|
1 row in set (0.001 sec)
|
MariaDB [test]> create table t2 as select conv(si, 16, 8) from t;
|
Query OK, 1 row affected, 1 warning (0.028 sec)
|
Records: 1 Duplicates: 0 Warnings: 1
|
MariaDB [test]> show warnings;
|
+---------+------+------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+------------------------------------------------------+
|
| Warning | 1265 | Data truncated for column 'conv(si, 16, 8)' at row 1 |
|
+---------+------+------------------------------------------------------+
|
1 row in set (0.000 sec)
|
MariaDB [test]> show create table t2
|
-> ;
|
+-------+----------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------------------+
|
| t2 | CREATE TABLE `t2` (
|
`conv(si, 16, 8)` varchar(21) CHARACTER SET utf8 DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+----------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
MariaDB [test]> select length(conv(si, 16, 8)) from t;
|
+-------------------------+
|
| length(conv(si, 16, 8)) |
|
+-------------------------+
|
| 22 |
|
+-------------------------+
|
1 row in set (0.001 sec)
|
MDB 10.4.12 and 10.5 both return an error on CREATE..AS SELECT.
MariaDB [test]> create table t1 (si smallint) engine=columnstore;
|
Query OK, 0 rows affected (0.480 sec)
|
|
|
MariaDB [test]> drop table t1;
|
Query OK, 0 rows affected (0.354 sec)
|
|
|
MariaDB [test]> create table t1 (si smallint);
|
Query OK, 0 rows affected (0.020 sec)
|
|
|
MariaDB [test]> insert into t1 values (-8.76221);
|
Query OK, 1 row affected (0.004 sec)
|
|
|
MariaDB [test]> create table t2 as select conv(si, 16, 8) from t1;
|
ERROR 1406 (22001): Data too long for column 'conv(si, 16, 8)' at row 1
|
MariaDB [test]> select length(conv(si, 16, 8)) from t1;
|
+-------------------------+
|
| length(conv(si, 16, 8)) |
|
+-------------------------+
|
| 22 |
|
+-------------------------+
|
1 row in set (0.001 sec)
|
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
| Assignee | Roman [ drrtuy ] | Alexander Barkov [ bar ] |
| Assignee | Alexander Barkov [ bar ] | Roman [ drrtuy ] |
| Fix Version/s | 10.4.13 [ 24223 ] | |
| Fix Version/s | 10.5.2 [ 24030 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Roman [ drrtuy ] | Alexander Barkov [ bar ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Alexander Barkov [ bar ] | Roman [ drrtuy ] |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 104417 ] | MariaDB v4 [ 157377 ] |