[#MDEV-12831] CREATE TABLE t1 (<defs>) SELECT... does not preserve new CHECK constraint

[MDEV-12831] CREATE TABLE t1 (<defs>) SELECT... does not preserve new CHECK constraint Created: 2017-05-17 Updated: 2023-04-27
Status:	Open
Project:	MariaDB Server
Component/s:	Data types
Affects Version/s:	10.2, 10.3
Fix Version/s:	10.4

Type:

Bug

Priority:

Major

Reporter:

Alexander Barkov

Assignee:

Michael Widenius

Resolution:

Unresolved

Votes:

Labels:

datatype

Issue Links:

Epic Link:

Data type cleanups

Description

DROP TABLE IF EXISTS t1,t2;

CREATE TABLE t1 (a INT CHECK(a=1));

CREATE TABLE t2 (a INT CHECK(a=2)) AS SELECT * FROM t1;

SHOW CREATE TABLE t2;

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

| Table | Create Table                                                                                          |

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

| t2    | CREATE TABLE `t2` (

  `a` int(11) DEFAULT NULL CHECK (`a` = 1)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

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

The expected CHECK clause for t2.a should be a=2 rather a=1.

Generated at Thu Feb 08 08:00:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.