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

ERROR 1118 (42000): Row size too large... within SELECT statement.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 1.0.9
    • Icebox
    • MariaDB Server
    • None
    • AWS CentOS 7

    Description

      The maximum of all selected fields within the SELECT statement has a limit in 65535 bytes. It is not a common ERROR 1118 (42000), it is not file format related and can't be reproduced on the regular MariaDB with the same InnoDB_version. It seems that you materialize the SELECT output into TEMP table or something like this, not sure.

      The issue can be easily reproduced in following ways:

      1.

      select * from (select cast(123 AS CHAR(21845)) as f,cast(123 AS CHAR(21845)) as g,cast(123 AS CHAR(21845)) as h) m1;
      

      2.

      CREATE TABLE `t1` (
        `c1` varchar(32765) NOT NULL,
        `c2` varchar(32766) NOT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
       
      insert into t1 select '123','123';
       
      select c1,c2,c1 from t1;
       
      ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
      

      The same perfectly works on 10.1.22-MariaDB.

      Attachments

        Issue Links

          Activity

            People

              LinuxJedi Andrew Hutchings (Inactive)
              Serhii.Kushnir Serhii Kushnir
              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.