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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
|
#
# Start of 10.3 tests
#
#
# MDEV-13965 Parameter data type control for Item_longlong_func
#
SELECT ROW(1,1) | 1;
ERROR HY000: Illegal parameter data type row for operation '|'
SELECT 1 | ROW(1,1);
ERROR HY000: Illegal parameter data type row for operation '|'
SELECT ROW(1,1) & 1;
ERROR HY000: Illegal parameter data type row for operation '&'
SELECT 1 & ROW(1,1);
ERROR HY000: Illegal parameter data type row for operation '&'
SELECT ROW(1,1) << 1;
ERROR HY000: Illegal parameter data type row for operation '<<'
SELECT 1 << ROW(1,1);
ERROR HY000: Illegal parameter data type row for operation '<<'
SELECT ROW(1,1) >> 1;
ERROR HY000: Illegal parameter data type row for operation '>>'
SELECT 1 >> ROW(1,1);
ERROR HY000: Illegal parameter data type row for operation '>>'
SELECT ~ROW(1,1);
ERROR HY000: Illegal parameter data type row for operation '~'
SELECT TO_SECONDS(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'to_seconds'
SELECT TIMESTAMPDIFF(SECOND,ROW(1,1), 1);
ERROR HY000: Illegal parameter data type row for operation 'timestampdiff'
SELECT TIMESTAMPDIFF(SECOND,1, ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'timestampdiff'
SELECT INET_ATON(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'inet_aton'
SELECT LAST_INSERT_ID(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'last_insert_id'
#
# MDEV-13967 Parameter data type control for Item_long_func
#
SELECT STRCMP(ROW(1,1),'');
ERROR HY000: Illegal parameter data type row for operation 'strcmp'
SELECT STRCMP('',ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'strcmp'
SELECT CHAR_LENGTH(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'char_length'
SELECT OCTET_LENGTH(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'octet_length'
SELECT UNCOMPRESSED_LENGTH(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'uncompressed_length'
SELECT COERCIBILITY(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'coercibility'
SELECT ASCII(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'ascii'
SELECT CRC32(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'crc32'
SELECT ORD(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'ord'
SELECT SIGN(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'sign'
SELECT LOCATE(ROW(1,1),'a',1);
ERROR HY000: Illegal parameter data type row for operation 'locate'
SELECT LOCATE('a',ROW(1,1),1);
ERROR HY000: Illegal parameter data type row for operation 'locate'
SELECT LOCATE('a','a',ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'locate'
SELECT BIT_COUNT(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'bit_count'
SELECT BENCHMARK(1, ROW(1,1));
ERROR 21000: Operand should contain 1 column(s)
SELECT BENCHMARK(ROW(1,1),'');
ERROR HY000: Illegal parameter data type row for operation 'benchmark'
SELECT SLEEP(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'sleep'
SELECT GET_LOCK('x', ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'get_lock'
SELECT GET_LOCK(ROW(1,1),'x');
ERROR HY000: Illegal parameter data type row for operation 'get_lock'
SELECT PERIOD_ADD(ROW(1,1),1);
ERROR HY000: Illegal parameter data type row for operation 'period_add'
SELECT PERIOD_ADD(1,ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'period_add'
SELECT PERIOD_DIFF(ROW(1,1),1);
ERROR HY000: Illegal parameter data type row for operation 'period_diff'
SELECT PERIOD_DIFF(1,ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'period_diff'
SELECT TO_DAYS(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'to_days'
SELECT DAYOFMONTH(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'dayofmonth'
SELECT DAYOFYEAR(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'dayofyear'
SELECT QUARTER(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'quarter'
SELECT YEAR(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'year'
SELECT YEARWEEK(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'yearweek'
SELECT WEEK(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'week'
SELECT WEEK(ROW(1,1),1);
ERROR HY000: Illegal parameter data type row for operation 'week'
SELECT WEEK(1,ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'week'
SELECT HOUR(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'hour'
SELECT MINUTE(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'minute'
SELECT SECOND(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'second'
SELECT MICROSECOND(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'microsecond'
SELECT JSON_DEPTH(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'json_depth'
SELECT JSON_LENGTH(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'json_length'
SELECT JSON_LENGTH('json', ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'json_length'
SELECT JSON_LENGTH(ROW(1,1), ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'json_length'
SELECT REGEXP_INSTR(ROW(1,1),'');
ERROR HY000: Illegal parameter data type row for operation 'regexp_instr'
SELECT REGEXP_INSTR('',ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'regexp_instr'
SELECT FIND_IN_SET(ROW(1,1),'');
ERROR HY000: Illegal parameter data type row for operation 'find_in_set'
SELECT FIND_IN_SET('',ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'find_in_set'
SELECT RELEASE_LOCK(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'release_lock'
SELECT IS_FREE_LOCK(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'is_free_lock'
SELECT IS_USED_LOCK(ROW(1,1));
ERROR HY000: Illegal parameter data type row for operation 'is_used_lock'
#
# End of 10.3 tests
#
|
