Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1342

A restriction for allowed length of the table and column names is not implemented

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.1.4
    • Fix Version/s: 1.1.5
    • Component/s: Pentaho Kettle Adapter
    • Labels:
      None
    • Environment:
      CentOS 7, PDI 8
    • 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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              elena.kotsinova Elena Kotsinova
              Reporter:
              elena.kotsinova Elena Kotsinova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

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