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

Cursor protocol cuts result for procedure analyse()

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 11.0(EOL), 11.1(EOL), 11.2(EOL)
    • 10.5, 10.6
    • None
    • None

    Description

      If ENUM in procedure analyse() contains more than 58 characters, it is truncated:

      Testcase:

      create table t1 (v varchar(128));
      insert into t1 values ('1111111111111111111111111111111111111111111111111111111112345');
      select * from t1 procedure analyse();
      drop table t1;
      

      Expected result:

      Field_name	Min_value	Max_value	Min_length	Max_length	Empties_or_zeros	Nulls	Avg_value_or_avg_length	Std	Optimal_fieldtype
      test.t1.v	1111111111111111111111111111111111111111111111111111111112345	1111111111111111111111111111111111111111111111111111111112345	61	61	0	0	61.0000	NULL	ENUM('1111111111111111111111111111111111111111111111111111111112345') NOT NULL
      

      Actual result:

      Field_name	Min_value	Max_value	Min_length	Max_length	Empties_or_zeros	Nulls	Avg_value_or_avg_length	Std	Optimal_fieldtype
      test.t1.v	1111111111111111111111111111111111111111111111111111111112345	1111111111111111111111111111111111111111111111111111111112345	61	61	0	0	61.0000	NULL	ENUM('1111111111111111111111111111111111111111111111111111111112
      

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              lstartseva Lena Startseva
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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