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

main.ctype_binary failed in buildbot with 1406: Data too long for column

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.4(EOL)
    • 10.4(EOL)
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-x86/builds/19289

      10.4 e8b05ce503dffc2d95d1583b7c89403d

      main.ctype_binary                        w1 [ fail ]
              Test ended at 2020-09-25 14:03:37
       
      CURRENT_TEST: main.ctype_binary
      mysqltest: In included file "./include/ctype_numconv.inc": 
      included from /usr/share/mysql/mysql-test/main/ctype_binary.test at line 9:
      At line 216: query 'create table t1 as select concat(rand()) as c1' failed: 1406: Data too long for column 'c1' at row 1
       
      The result from queries just before the failure was:
      < snip >
      hex(concat(round(0.5)))
      31
      create table t1 as select concat(round(0.5)) as c1;
      show create table t1;
      Table	Create Table
      t1	CREATE TABLE `t1` (
        `c1` varbinary(3) DEFAULT NULL
      ) ENGINE=MyISAM DEFAULT CHARSET=latin1
      drop table t1;
      select hex(concat(sign(0.5)));
      hex(concat(sign(0.5)))
      31
      create table t1 as select concat(sign(0.5)) as c1;
      show create table t1;
      Table	Create Table
      t1	CREATE TABLE `t1` (
        `c1` varbinary(2) DEFAULT NULL
      ) ENGINE=MyISAM DEFAULT CHARSET=latin1
      drop table t1;
      create table t1 as select concat(rand()) as c1;
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.