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
    • 10.4
    • 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

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            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.