1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
#
# Start of 10.7 tests
#
#
# MDEV-27015 Assertion `!is_null()' failed in FixedBinTypeBundle<FbtImpl>::Fbt FixedBinTypeBundle<FbtImpl>::Field_fbt::to_fbt()
#
CREATE TABLE t1 (i6 INET6, a1 TIME, a2 VARCHAR(10));
INSERT INTO t1 VALUES ('::','09:43:12','uw'), ('70:ef59::46:c7b:f:678:bd9f','00:00:00','a');
SELECT GROUP_CONCAT(IF(a1, i6, a2) ORDER BY 1) FROM t1;
GROUP_CONCAT(IF(a1, i6, a2) ORDER BY 1)
::
Warnings:
Warning 1292 Incorrect inet6 value: 'a'
DROP TABLE t1;
CREATE TABLE t1 (i6 inet6, a2 varchar(10));
INSERT INTO t1 VALUES ('::','uw'), (null,'a');
SELECT group_concat(coalesce(i6, a2) ORDER BY 1) FROM t1;
group_concat(coalesce(i6, a2) ORDER BY 1)
::
Warnings:
Warning 1292 Incorrect inet6 value: 'a'
DROP TABLE t1;
CREATE TABLE t1 (a INET6);
INSERT INTO t1 VALUES();
SELECT JSON_ARRAYAGG(a ORDER BY a DESC) FROM t1;
JSON_ARRAYAGG(a ORDER BY a DESC)
[null]
DROP TABLE t1;
CREATE TABLE t1 (i6 INET6, a1 INT, a2 VARCHAR(10));
INSERT INTO t1 VALUES ('::',1,'uw'), ('70:ef59::46:c7b:f:678:bd9f',0,'a');
SELECT GROUP_CONCAT(IF(a1, i6, a2) ORDER BY 1) FROM t1;
GROUP_CONCAT(IF(a1, i6, a2) ORDER BY 1)
::
Warnings:
Warning 1292 Incorrect inet6 value: 'a'
DROP TABLE t1;
CREATE TABLE t1 (i6 INET6, a2 VARCHAR(10));
INSERT INTO t1 VALUES ('::',''), (NULL,NULL);
SELECT GROUP_CONCAT(COALESCE(i6, a2) ORDER BY 1) FROM t1;
GROUP_CONCAT(COALESCE(i6, a2) ORDER BY 1)
::
DROP TABLE t1;
CREATE TABLE t1 (i6 INET6, a2 VARCHAR(10));
INSERT INTO t1 VALUES ('::',''), (NULL,NULL);
SELECT GROUP_CONCAT(DISTINCT COALESCE(i6, a2)) FROM t1;
GROUP_CONCAT(DISTINCT COALESCE(i6, a2))
::
DROP TABLE t1;
#
# End of 10.7 tests
#
|