[MCOL-716] support non alphanumeric characters for table and column names Created: 2017-05-11  Updated: 2018-02-13  Resolved: 2018-02-13

Status: Closed
Project: MariaDB ColumnStore
Component/s: DDLProc
Affects Version/s: 1.0.8
Fix Version/s: 1.2.0

Type: New Feature Priority: Major
Reporter: David Thompson (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: community

Epic Link: ColumnStore Compatibility Improvements
Sprint: 2018-03, 2018-04

 Description   

Currently columnstore restricts object names to be alphanumeric and underscore, i.e. "A-Z a-z 0-9 _". This precludes use of accented characters for europeans and most non roman languages from using a more natural name.

Created from: https://mariadb.com/kb/en/mariadb/object-name-naming-rule/



 Comments   
Comment by Roman [ 2018-01-26 ]

It occures, that major DDL/DML functions support a subset of UTF-8(according with this) for table/column identifiers and only 'ALTER TABLE RENAME' doesn't support it because the mariadb plugin function ha_calpont_impl_rename_table_() replaces the initial query. I changed this and also replace push_warning() arguments according with recomendations given in server_code/sql/sql_error.cc to avoid possible sigabort.

Kindly take a look at the tiny functional tests results.

Comment by Andrew Hutchings (Inactive) [ 2018-01-29 ]

For QA: Please see Roman's tests.

Comment by Daniel Lee (Inactive) [ 2018-02-13 ]

Build verified: Github source 1.2.0-1

/root/columnstore/mariadb-columnstore-server
commit 960853c58bcfd0b92a48fca6f823e0b43fce17a8
Author: david hill <david.hill@mariadb.com>
Date: Mon Nov 20 20:42:55 2017 -0600

Update README.md

diff --git a/README.md b/README.md
index 1e4a6c6..5d12495 100644
— a/README.md
+++ b/README.md
@@ -273,7 +273,7 @@ apt-get install expect perl openssl file sudo libdbi-perl libboost-all-dev libre
These packages need to be installed:

```bash
-apt-get install expect perl openssl file sudo libdbi-perl libboost-all-dev libreadline-dev rsync net-tools libsnappy1v5
+apt-get install expect perl openssl file sudo libdbi-perl libboost-all-dev libreadline-dev rsync net-tools libsnappy1v5 libreadline5
```

    1. For SUSE 12

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit ad2f469811d9bfc989174da13343e72ee2599af2
Merge: 070fc37 7c0086c
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Wed Feb 7 10:24:23 2018 +0200

Merge pull request #399 from drrtuy/MCOL-876

MCOL-876. CS now supports RENAME TABLE sql statement.

Verified test cases in mentioned test results, as well as additional tests using Asian characters.

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