Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-31370

some coloums‘ length of varchar is reduced from 200 to 20,run create table sql raises exception

    XMLWordPrintable

Details

    Description

      some coloums‘ length of varchar is reduced from 200 to 20,run create table sql raises exception like 'ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.'.

      while on the same instance and the same ddl sql, the difference is some coloums‘ length of varchar is 200 not reduced ,run create table sql success.

      I except that the reduced varchar sql runs sucess as well as the not reduced.
      I am trapped with the sitiuation

      Attachments

        Activity

          People

            Unassigned Unassigned
            jjs Wenwen Jing
            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.