1--echo #
2--echo # Start of 10.5 tests
3--echo #
4
5--echo #
6--echo # MDEV-20175 Move Type_handler_row from Type_collection_std to Type_collection_row
7--echo #
8
9--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
10SELECT LEAST(ROW(1,1), ROW(1,1));
11--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
12SELECT GREATEST(ROW(1,1), ROW(1,1));
13
14--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
15SELECT LEAST(ROW(1,1), 1);
16--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
17SELECT GREATEST(ROW(1,1), 1);
18
19--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
20SELECT LEAST(1, ROW(1,1));
21--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
22SELECT GREATEST(1, ROW(1,1));
23
24
25--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
26SELECT ROW(1,1) + ROW(1,1);
27--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
28SELECT 1 + ROW(1,1);
29--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
30SELECT ROW(1,1) + 1;
31
32--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
33SELECT ROW(1,1) - ROW(1,1);
34--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
35SELECT 1 - ROW(1,1);
36--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
37SELECT ROW(1,1) - 1;
38
39--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
40SELECT ROW(1,1) * ROW(1,1);
41--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
42SELECT 1 * ROW(1,1);
43--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
44SELECT ROW(1,1) * 1;
45
46--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
47SELECT ROW(1,1) / ROW(1,1);
48--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
49SELECT 1 / ROW(1,1);
50--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
51SELECT ROW(1,1) / 1;
52
53--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
54SELECT ROW(1,1) % ROW(1,1);
55--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
56SELECT 1 % ROW(1,1);
57--error ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION
58SELECT ROW(1,1) % 1;
59
60--echo #
61--echo # End of 10.5 tests
62--echo #
63