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

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.1.4
    • 1.1.5
    • None
    • None
    • CentOS 7, PDI 8
    • 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

              elena.kotsinova Elena Kotsinova (Inactive)
              elena.kotsinova Elena Kotsinova (Inactive)
              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.