[MCOL-1342] A restriction for allowed length of the table and column names is not implemented Created: 2018-04-16  Updated: 2023-10-26  Resolved: 2018-06-13

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.1.4
Fix Version/s: 1.1.5

Type: Bug Priority: Minor
Reporter: Elena Kotsinova (Inactive) Assignee: Elena Kotsinova (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS 7, PDI 8


Issue Links:
PartOf
is part of MCOL-1262 PDI CS naming conventions support Closed
Sprint: 2018-08, 2018-09, 2018-10, 2018-11, 2018-12

 Description   

1. Start spoon tool and create a new transformation
2. Create some input
3. Add MariaDB ColumnStore Bulk Loader module and connect it with the input module.
4. Specify the settings and start to map inputs.
5. For table name insert string longer that 64 chars.
6. Click SQL button to generate an SQL for creation of this table.
7. Execute the script.

Results:
Error while executing: CREATE TABLE ...
(conn=73) Incorrect table name 'S1234567890123456789012345678901234567890123456789012345678901234567890'

Additional Notes:
A similar error appears when table column is longer than 64 chars as this is specified in ColumnStore Naming conventions.

Expected:
Do not allow entering of such long strings,
OR
Add message about allowed length of the names in the error message.



 Comments   
Comment by Jens Röwekamp (Inactive) [ 2018-04-19 ]

restricted table and column length to 64

Comment by Elena Kotsinova (Inactive) [ 2018-06-13 ]

Name of the column is truncated to 64 chars

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