[MCOL-1228] ALTER TABLE...CHANGE COLUMN broken for TEXT data types Created: 2018-02-21  Updated: 2018-03-22  Resolved: 2018-03-22

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: 1.1.2
Fix Version/s: 1.1.4

Type: Bug Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MCOL-1257 ALTER TABLE x ADD column TINYTEXT fails Closed
Relates
relates to MCOL-1179 Pentaho Data Integration / Kettle - B... Closed
Sprint: 2018-05, 2018-06

 Description   

Doing the following will trigger an error:

CREATE TABLE test.tmp3
 
(t TINYTEXT)
 
ENGINE=COLUMNSTORE;
 
 
 
ALTER TABLE test.tmp3 CHANGE COLUMN t t2 TINYTEXT;

The error is:
ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: Changing the datatype of a column is not supported

The cause is typesAreSame() in ddlpackageproc/altertableprocessor.cpp doesn't check for all the TEXT types and fails on the ones it does catch.

 Comments   
Comment by Daniel Lee (Inactive) [ 2018-03-22 ]

Build verified: 1.1.4-1 source

Build verified: 1.1.4-1 source

/root/columnstore/mariadb-columnstore-server
commit 3b5242143b394423dbdf96d888410a3c33f9ff97
Merge: b7d93b7 23900e6
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Wed Mar 7 10:39:40 2018 -0600

Merge pull request #104 from mariadb-corporation/davidhilldallas-patch-3

update version

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 4e167285c6665c9aa0e204eac2de0add61709be4
Merge: 819c69c b800fc7
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Wed Mar 14 13:25:21 2018 -0500

Merge pull request #427 from mariadb-corporation/MCOL-1225

Mcol 1225 - fix mysql/lib library path

commit 8f4f304e22c8629e6b5feb0bb9724b09ae89b787
Merge: acf32cc a2ec28a
Author: sneJ p <sneJ-@users.noreply.github.com>
Date: Thu Mar 22 00:59:01 2018 -0700

Merge pull request #61 from mariadb-corporation/1.1-mergeup-20180322

Merge develop-1.1 into develop

Reproduced issue in 1.1.3-1 and verified fixed in 1.1.4-1 source

MariaDB [mytest]> CREATE TABLE test.tmp3
-> (t TINYTEXT)
-> ENGINE=COLUMNSTORE;
Query OK, 0 rows affected (0.99 sec)

MariaDB [mytest]> ALTER TABLE test.tmp3 CHANGE COLUMN t t2 TINYTEXT;
Query OK, 0 rows affected (0.10 sec)
Records: 0 Duplicates: 0 Warnings: 0

MariaDB [mytest]> use test
Database changed
MariaDB [test]> desc tmp3
-> ;
----------------------------------+

Field Type Null Key Default Extra

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

t2 tinytext YES   NULL  

----------------------------------+
1 row in set (0.00 sec)

Generated at Thu Feb 08 02:27:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.