--- /home/sanja/maria/git/10.4/mysql-test/main/cast.result	2023-10-12 21:10:39.670952976 +0200

+++ /home/sanja/maria/git/10.4/mysql-test/main/cast.reject	2023-10-12 21:12:36.415207337 +0200

@@ -402,7 +402,7 @@

 cast(_latin1'test' as char character set latin2)

 test

 select cast(_koi8r'����' as char character set cp1251);

-cast(_koi8r'\xD4\xC5\xD3\xD4' as char character set cp1251)

+cast(_koi8r'ÔÅÓÔ' as char character set cp1251)

 ����

 create table t1 select cast(_koi8r'����' as char character set cp1251) as t;

 show create table t1;

@@ -418,15 +418,15 @@

 cast(_latin1'a  ' AS char(2)) as c4,

 hex(cast(_latin1'a'   AS char(2))) as c5;

 c1	c2	c3	c4	c5

-ab	a 	ab	a 	6100

+ab	a 	ab	a 	61

 Warnings:

-Warning	1292	Truncated incorrect BINARY(2) value: 'abc'

-Warning	1292	Truncated incorrect BINARY(2) value: 'a  '

+Warning	1292	Truncated incorrect CHAR(2) value: 'abc'

+Warning	1292	Truncated incorrect CHAR(2) value: 'a  '

 select cast(1000 as CHAR(3));

 cast(1000 as CHAR(3))

 100

 Warnings:

-Warning	1292	Truncated incorrect BINARY(3) value: '1000'

+Warning	1292	Truncated incorrect CHAR(3) value: '1000'

 SET STATEMENT sql_mode = 'NO_ENGINE_SUBSTITUTION' FOR

 create table t1 select

 cast(_latin1'ab'  AS char)    as c1,

@@ -521,9 +521,9 @@

 aab	aab

 aaa	aaa

 Warnings:

-Warning	1292	Truncated incorrect BINARY(2) value: 'aaa'

-Warning	1292	Truncated incorrect BINARY(2) value: 'aab'

-Warning	1292	Truncated incorrect BINARY(2) value: 'aac'

+Warning	1292	Truncated incorrect CHAR(2) value: 'aaa'

+Warning	1292	Truncated incorrect CHAR(2) value: 'aab'

+Warning	1292	Truncated incorrect CHAR(2) value: 'aac'

 SELECT a, CAST(a AS UNSIGNED) FROM t1 ORDER BY CAST(a AS CHAR) ;

 a	CAST(a AS UNSIGNED)

 aaa	3

@@ -535,9 +535,9 @@

 aab	aa

 aac	aa

 Warnings:

-Warning	1292	Truncated incorrect BINARY(2) value: 'aaa'

-Warning	1292	Truncated incorrect BINARY(2) value: 'aab'

-Warning	1292	Truncated incorrect BINARY(2) value: 'aac'

+Warning	1292	Truncated incorrect CHAR(2) value: 'aaa'

+Warning	1292	Truncated incorrect CHAR(2) value: 'aab'

+Warning	1292	Truncated incorrect CHAR(2) value: 'aac'

 DROP TABLE t1;

 select date_add(cast('2004-12-30 12:00:00' as date), interval 0 hour);

 date_add(cast('2004-12-30 12:00:00' as date), interval 0 hour)

@@ -819,19 +819,19 @@

 drop table t1;

 select collation(cast("a" as char(10) binary));

 collation(cast("a" as char(10) binary))

-latin1_bin

+latin1_swedish_ci

 select collation(cast("a" as char(10) charset utf8 binary));

 collation(cast("a" as char(10) charset utf8 binary))

-utf8_bin

+utf8_general_ci

 select collation(cast("a" as char(10) ascii binary));

 collation(cast("a" as char(10) ascii binary))

-latin1_bin

+latin1_swedish_ci

 select collation(cast("a" as char(10) binary charset utf8));

 collation(cast("a" as char(10) binary charset utf8))

-utf8_bin

+utf8_general_ci

 select collation(cast("a" as char(10) binary ascii));

 collation(cast("a" as char(10) binary ascii))

-latin1_bin

+latin1_swedish_ci

 #

 # MDEV-11030 Assertion `precision > 0' failed in decimal_bin_size

 #

@@ -1323,9 +1323,9 @@

 DROP TABLE t1;

 SELECT CAST(-1e0 AS UNSIGNED);

 CAST(-1e0 AS UNSIGNED)

-0

+18446744073709551615

 Warnings:

-Note	1916	Got overflow when converting '-1' to UNSIGNED BIGINT. Value truncated

+Note	1105	Cast to unsigned converted negative integer to it's positive complement

 CREATE TABLE t1 (a BIGINT UNSIGNED);

 INSERT INTO t1 VALUES (-1e0);

 Warnings: