Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.4
-
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;
|