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

Add the word "bytes" to the message on Error 1815

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Trivial
    • Resolution: Fixed
    • None
    • 22.08.1
    • None
    • CentOS 7
      MariaDB-server 10.5.8_5-1

    Description

      When the 8000 byte varchar column limit is exceeded, the error message reads:

      MariaDB [test]> alter table products add column testchar varchar(2001) character set utf8mb4;
      ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed:  AlterTableProcessor::addColumn char, varchar and varbinary length may not exceed 8000
      

      If this could just specify the units like this:

      MariaDB [test]> alter table products add column testchar varchar(2001) character set utf8mb4;
      ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed:  AlterTableProcessor::addColumn char, varchar and varbinary length may not exceed 8000 bytes
      

      it would save a lot of confusion for users, as can be seen in the associated support case.

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            toddstoffel Todd Stoffel (Inactive)
            juan.vera Juan
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.