diff options
author | Alexander Barkov <bar@mariadb.org> | 2017-03-10 16:12:58 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2017-03-10 16:12:58 +0400 |
commit | a4a48a37c494f9df866ba7194813c0fbb9f36b59 (patch) | |
tree | f9fcd48546357eb6cc41e00b448c111577ef030d /mysql-test/t/gis.test | |
parent | ec8c38a82ec1bb00f681a3f6662bd5c76ebb7c75 (diff) | |
download | mariadb-git-a4a48a37c494f9df866ba7194813c0fbb9f36b59.tar.gz |
MDEV-12199 Split Item_func_{abs|neg|int_val}::fix_length_and_dec() into methods in Type_handler
Diffstat (limited to 'mysql-test/t/gis.test')
-rw-r--r-- | mysql-test/t/gis.test | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index 7d6c3ba9761..d651dde2d2a 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -1880,6 +1880,41 @@ DROP TABLE t1; --error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION SELECT ROUND(POINT(1,1)); + +--echo # +--echo # MDEV-12199 Split Item_func_{abs|neg|int_val}::fix_length_and_dec() into methods in Type_handler +--echo # + +CREATE TABLE t1 (a GEOMETRY); + +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT -a FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT ABS(a) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT CEILING(a) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT FLOOR(a) FROM t1; + +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT -COALESCE(a) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT ABS(COALESCE(a)) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT CEILING(COALESCE(a)) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT FLOOR(COALESCE(a)) FROM t1; +DROP TABLE t1; + +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT -POINT(1,1); +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT ABS(POINT(1,1)); +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT CEILING(POINT(1,1)); +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT FLOOR(POINT(1,1)); + --echo # --echo # End of 10.3 tests --echo # |