1--echo # 2--echo # Start of 10.3 tests 3--echo # 4 5 6--echo # 7--echo # MDEV-13965 Parameter data type control for Item_longlong_func 8--echo # 9 10--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 11SELECT ROW(1,1) | 1; 12--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 13SELECT 1 | ROW(1,1); 14 15--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 16SELECT ROW(1,1) & 1; 17--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 18SELECT 1 & ROW(1,1); 19 20--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 21SELECT ROW(1,1) << 1; 22--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 23SELECT 1 << ROW(1,1); 24 25--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 26SELECT ROW(1,1) >> 1; 27--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 28SELECT 1 >> ROW(1,1); 29 30--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 31SELECT ~ROW(1,1); 32 33--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 34SELECT TO_SECONDS(ROW(1,1)); 35 36--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 37SELECT TIMESTAMPDIFF(SECOND,ROW(1,1), 1); 38--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 39SELECT TIMESTAMPDIFF(SECOND,1, ROW(1,1)); 40 41--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 42SELECT INET_ATON(ROW(1,1)); 43 44--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 45SELECT LAST_INSERT_ID(ROW(1,1)); 46 47 48--echo # 49--echo # MDEV-13967 Parameter data type control for Item_long_func 50--echo # 51 52--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 53SELECT STRCMP(ROW(1,1),''); 54--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 55SELECT STRCMP('',ROW(1,1)); 56 57--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 58SELECT CHAR_LENGTH(ROW(1,1)); 59 60--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 61SELECT OCTET_LENGTH(ROW(1,1)); 62 63--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 64SELECT UNCOMPRESSED_LENGTH(ROW(1,1)); 65 66--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 67SELECT COERCIBILITY(ROW(1,1)); 68 69--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 70SELECT ASCII(ROW(1,1)); 71 72--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 73SELECT CRC32(ROW(1,1)); 74 75--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 76SELECT ORD(ROW(1,1)); 77 78--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 79SELECT SIGN(ROW(1,1)); 80 81--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 82SELECT LOCATE(ROW(1,1),'a',1); 83 84--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 85SELECT LOCATE('a',ROW(1,1),1); 86 87--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 88SELECT LOCATE('a','a',ROW(1,1)); 89 90--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 91SELECT BIT_COUNT(ROW(1,1)); 92 93--error ER_OPERAND_COLUMNS 94SELECT BENCHMARK(1, ROW(1,1)); 95 96--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 97SELECT BENCHMARK(ROW(1,1),''); 98 99--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 100SELECT SLEEP(ROW(1,1)); 101 102--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 103SELECT GET_LOCK('x', ROW(1,1)); 104 105--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 106SELECT GET_LOCK(ROW(1,1),'x'); 107 108--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 109SELECT PERIOD_ADD(ROW(1,1),1); 110--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 111SELECT PERIOD_ADD(1,ROW(1,1)); 112 113--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 114SELECT PERIOD_DIFF(ROW(1,1),1); 115--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 116SELECT PERIOD_DIFF(1,ROW(1,1)); 117 118--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 119SELECT TO_DAYS(ROW(1,1)); 120 121--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 122SELECT DAYOFMONTH(ROW(1,1)); 123 124--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 125SELECT DAYOFYEAR(ROW(1,1)); 126 127--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 128SELECT QUARTER(ROW(1,1)); 129 130--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 131SELECT YEAR(ROW(1,1)); 132 133--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 134SELECT YEARWEEK(ROW(1,1)); 135 136--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 137SELECT WEEK(ROW(1,1)); 138--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 139SELECT WEEK(ROW(1,1),1); 140--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 141SELECT WEEK(1,ROW(1,1)); 142 143--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 144SELECT HOUR(ROW(1,1)); 145 146--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 147SELECT MINUTE(ROW(1,1)); 148 149--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 150SELECT SECOND(ROW(1,1)); 151 152--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 153SELECT MICROSECOND(ROW(1,1)); 154 155--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 156SELECT JSON_DEPTH(ROW(1,1)); 157 158--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 159SELECT JSON_LENGTH(ROW(1,1)); 160 161--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 162SELECT JSON_LENGTH('json', ROW(1,1)); 163 164--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 165SELECT JSON_LENGTH(ROW(1,1), ROW(1,1)); 166 167--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 168SELECT REGEXP_INSTR(ROW(1,1),''); 169--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 170SELECT REGEXP_INSTR('',ROW(1,1)); 171 172--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 173SELECT FIND_IN_SET(ROW(1,1),''); 174--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 175SELECT FIND_IN_SET('',ROW(1,1)); 176 177--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 178SELECT RELEASE_LOCK(ROW(1,1)); 179 180--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 181SELECT IS_FREE_LOCK(ROW(1,1)); 182 183--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION 184SELECT IS_USED_LOCK(ROW(1,1)); 185 186--echo # 187--echo # End of 10.3 tests 188--echo # 189