[MDEV-17681] main.ctype_ucs failed in buildbot with Data too long for column Created: 2018-11-12  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

kvm-deb-xenial-aarch64


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-aarch64/builds/1064

main.ctype_ucs                           w2 [ fail ]
 
        Test ended at 2018-10-31 16:00:28
 
 
 
CURRENT_TEST: main.ctype_ucs
 
mysqltest: In included file "/usr/share/mysql/mysql-test/include/ctype_numconv.inc": 
included from /usr/share/mysql/mysql-test/t/ctype_ucs.test at line 792:
 
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)))
 
0031
 
create table t1 as select concat(round(0.5)) as c1;
 
show create table t1;
 
Table	Create Table
 
t1	CREATE TABLE `t1` (
 
  `c1` varchar(3) CHARACTER SET ucs2 DEFAULT NULL
 
) ENGINE=MyISAM DEFAULT CHARSET=latin1
 
drop table t1;
 
select hex(concat(sign(0.5)));
 
hex(concat(sign(0.5)))
 
0031
 
create table t1 as select concat(sign(0.5)) as c1;
 
show create table t1;
 
Table	Create Table
 
t1	CREATE TABLE `t1` (
 
  `c1` varchar(21) CHARACTER SET ucs2 DEFAULT NULL
 
) ENGINE=MyISAM DEFAULT CHARSET=latin1
 
drop table t1;
 
create table t1 as select concat(rand()) as c1;



 Comments   
Comment by Anel Husakovic [ 2018-11-14 ]

Hi,
I couldn't reproduce this error on this architecture.

cat /etc/os-release*

NAME="Ubuntu"

VERSION="16.04.5 LTS (Xenial Xerus)"

ID=ubuntu

ID_LIKE=debian

uname -a*

Linux scw-95fca6 4.4.114-mainline-rev1 #1 SMP Thu Feb 1 16:23:12 UTC 2018 aarch64 aarch64 aarch64 GNU/Linux

./mysqld -V
./mysqld Ver 10.2.19-MariaDB-debug for Linux on aarch64 (Source distribution)

./mtr main.ctype_ucs

Logging: ./mtr main.ctype_ucs

vardir: /home/anel/workspace/server/mysql-test/var

Removing old var directory...

Creating var directory '/home/anel/workspace/server/mysql-test/var'...

Checking supported features...

MariaDB Version 10.2.19-MariaDB-debug

- SSL connections supported

- binaries are debug compiled

Collecting tests...

Installing system database...

==============================================================================

TEST RESULT TIME (ms) or COMMENT

--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019

main.ctype_ucs [ pass ] 2815

--------------------------------------------------------------------------

The servers were restarted 0 times

Spent 2.815 of 10 seconds executing testcases

Completed: All 1 tests were successful.

```

Generated at Thu Feb 08 08:38:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.