blob: 906e16867cd73d85d9fea47f33ab1d28bd0ab788 (
plain)
1
2
3
4
5
6
7
8
9
|
SET sql_mode=ORACLE;
#
# MDEV-11275 sql_mode=ORACLE: CAST(..AS VARCHAR(N))
#
SELECT CAST(123 AS VARCHAR(10)) FROM DUAL;
CAST(123 AS VARCHAR(10))
123
SELECT CAST(123 AS VARCHAR) FROM DUAL;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') FROM DUAL' at line 1
|
