[MDEV-6085] ALTER TABLE looses the connection string - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0.10
Fix Version/s: 10.0.11
Component/s: None
Labels:
- plugins

Description

After creating a table with a connection string, if ALTER TABLE is used, the connection string is lost. For instance:

CREATE TABLE t1 ENGINE=CONNECT TABLE_TYPE=ODBC tabname='lite' CONNECTION='Driver=SQLite3 ODBC Driver;Database=test.sqlite3;NoWCHAR=yes' CHARSET=utf8 DATA_CHARSET=utf8;

SHOW CREATE TABLE t1;

CREATE TABLE `t1` (

  `ID` int(9) DEFAULT NULL,

  `nom` varchar(12) NOT NULL,

  `nais` datetime DEFAULT NULL,

  `rem` varchar(32) DEFAULT NULL

) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='Driver=SQLite3 ODBC Driver;Database=test.sqlite3;NoWCHAR=yes' `TABLE_TYPE`='ODBC' `TABNAME`='lite' `DATA_CHARSET`='utf8'

Now if I do:

ALTER TABLE t1 MODIFY COLUMN nom VARCHAR(13) NOT NULL;

SHOW CREATE TABLE t1;

CREATE TABLE `t1` (

  `ID` int(9) DEFAULT NULL,

  `nom` varchar(13) NOT NULL,

  `nais` datetime DEFAULT NULL,

  `rem` varchar(32) DEFAULT NULL

) ENGINE=CONNECT DEFAULT CHARSET=utf8 `TABLE_TYPE`='ODBC' `TABNAME`='lite' `DATA_CHARSET`='utf8';

This has not been reported before CONNECT was implemented because the only other engine using connection string was FEDERATED(X) that does not support ALTER TABLE.

Attachments

Activity

People

Assignee:: Sergei Golubchik

Reporter:: Olivier Bertrand

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2014-04-13 23:53

Updated:: 2014-05-06 22:44

Resolved:: 2014-05-06 22:44

Git Integration

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

MariaDB Server