[MDEV-22502] MDB crashes in CREATE TABLE AS SELECT when the precision of returning type = 0. - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: 10.5.4, 10.1.46, 10.2.33, 10.3.24, 10.4.14
Component/s: Data types
Labels:
None

MDB crashes trying to execute CTAS with decimal column which precision is 0.

MariaDB [test]> create table t42(d decimal(5,5));

Query OK, 0 rows affected (0.015 sec)

MariaDB [test]> insert into t42 values (0.55555);

Query OK, 1 row affected (0.004 sec)

MariaDB [test]> select * from t42;

+---------+

| d       |

+---------+

| 0.55555 |

+---------+

1 row in set (0.001 sec)

MariaDB [test]> select truncate(d,0) from t42;

+---------------+

| truncate(d,0) |

+---------------+

|             0 |

+---------------+

1 row in set (0.001 sec)

MariaDB [test]> create table t43 as select truncate(d,0) from t42;

ERROR 2013 (HY000): Lost connection to MySQL server during query

relates to

MCOL-641 Full DECIMAL support in ColumnStore

MDEV-12059 Assertion `precision > 0' failed with a window function or window aggregate function

MDEV-15874 CREATE TABLE creates extra transaction

MDEV-20754 Assertion `precision > 0' failed in decimal_bin_size upon SELECT with GROUP BY and/or ORDER BY

MDEV-21789 Assertion `precision > 0' failed in decimal_bin_size upon SELECT with GROUP BY, IFNULL, DIV

MCOL-641 Full DECIMAL support in ColumnStore

(1 relates to)

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.