Debian Codegraph @

mysql-test/suite/vcol/r/vcol_utf32.result

raw
1 #
2 # MDEV-27966 Assertion `fixed()' failed and Assertion `fixed == 1' failed, both in Item_func_concat::val_str on SELECT after INSERT with collation utf32_bin on utf8_bin table
3 #
4 SET NAMES utf8mb3;
5 SET sql_mode='';
6 CREATE TABLE t (c1 INT,c2 CHAR AS (CONCAT ('',DAYNAME ('')))) COLLATE utf8_bin ENGINE=InnoDB;
7 Warnings:
8 Warning 1286 Unknown storage engine 'InnoDB'
9 Warning 1266 Using storage engine MyISAM for table 't'
10 INSERT INTO t VALUES (0,0),(0,0),(0,0),(0,0),(0,0),(0,0),(0,0),(0,0),(0,0);
11 Warnings:
12 Warning 1906 The value specified for generated column 'c2' in table 't' has been ignored
13 Warning 1292 Incorrect datetime value: ''
14 Warning 1906 The value specified for generated column 'c2' in table 't' has been ignored
15 Warning 1292 Incorrect datetime value: ''
16 Warning 1906 The value specified for generated column 'c2' in table 't' has been ignored
17 Warning 1292 Incorrect datetime value: ''
18 Warning 1906 The value specified for generated column 'c2' in table 't' has been ignored
19 Warning 1292 Incorrect datetime value: ''
20 Warning 1906 The value specified for generated column 'c2' in table 't' has been ignored
21 Warning 1292 Incorrect datetime value: ''
22 Warning 1906 The value specified for generated column 'c2' in table 't' has been ignored
23 Warning 1292 Incorrect datetime value: ''
24 Warning 1906 The value specified for generated column 'c2' in table 't' has been ignored
25 Warning 1292 Incorrect datetime value: ''
26 Warning 1906 The value specified for generated column 'c2' in table 't' has been ignored
27 Warning 1292 Incorrect datetime value: ''
28 Warning 1906 The value specified for generated column 'c2' in table 't' has been ignored
29 Warning 1292 Incorrect datetime value: ''
30 SET collation_connection='utf32_bin';
31 INSERT INTO t VALUES (0,0),(0,0),(0,0),(0,0),(0,0),(0,0),(0,0),(0,0),(0,0);
32 ERROR HY000: Illegal mix of collations (utf8mb3_bin,COERCIBLE) and (utf32_bin,COERCIBLE) for operation 'concat'
33 SELECT * FROM t;
34 ERROR HY000: Illegal mix of collations (utf8mb3_bin,COERCIBLE) and (utf32_bin,COERCIBLE) for operation 'concat'
35 DROP TABLE t;
36 SET sql_mode=DEFAULT;
37 SET NAMES utf8mb3;