[#MDEV-16161] Syntax error reserverd keyword

[MDEV-16161] Syntax error reserverd keyword Created: 2018-05-14 Updated: 2018-05-14 Resolved: 2018-05-14
Status:	Closed
Project:	MariaDB Server
Component/s:	Data Definition - Alter Table
Affects Version/s:	10.3.4
Fix Version/s:	N/A

Type:

Bug

Priority:

Major

Reporter:

rvdgijp

Assignee:

Unassigned

Resolution:

Duplicate

Votes:

Labels:

None

Issue Links:

Duplicate
duplicates	~~MDEV-13508~~	ALTER TABLE that renames columns and ...	Closed

Description

Script below fails on column name 'public', works fine in 10.2
Code is used in https://releases.openstack.org/queens/#queens-neutron

CREATE TABLE `firewall_rules_v2` (

  `public` tinyint(1) DEFAULT NULL,

  CONSTRAINT `CONSTRAINT_1` CHECK (`public` in (0,1)));

ALTER TABLE firewall_rules_v2 CHANGE `public` shared BOOL NULL;

ERROR 1054 (42S22): Unknown column 'public' in 'CHECK'

Comments

Comment by Elena Stepanova [ 2018-05-14 ]

Please use a newer 10.3 version. The problem was fixed in 10.2.13 and 10.3.5 in the scope of ~~MDEV-13508~~.

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