[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 Update README.md diff --git a/README.md b/README.md ```bash
/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine Merge pull request #399 from drrtuy/ Verified test cases in mentioned test results, as well as additional tests using Asian characters. |