diff options
| author | Alexander Barkov <bar@mariadb.org> | 2017-03-19 23:39:42 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-03-19 23:39:42 +0400 |
| commit | 552072e4d11c97e5d5c9a34aefcb052791209865 (patch) | |
| tree | edd32e09988d6625f693ddd653b9e7d9975bcdcb /mysql-test/r/gis.result | |
| parent | 7d0c354f5c354b45f9d9dadf2ff5ea02ba0b1071 (diff) | |
| download | mariadb-git-552072e4d11c97e5d5c9a34aefcb052791209865.tar.gz | |
MDEV-12239 Add Type_handler::Item_sum_{sum|avg|variance}_fix_length_and_dec()
Diffstat (limited to 'mysql-test/r/gis.result')
| -rw-r--r-- | mysql-test/r/gis.result | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result index 649c3aba32f..484d2ba4277 100644 --- a/mysql-test/r/gis.result +++ b/mysql-test/r/gis.result @@ -3749,5 +3749,34 @@ ERROR HY000: Illegal parameter data type geometry for operation 'ceiling' SELECT FLOOR(POINT(1,1)); ERROR HY000: Illegal parameter data type geometry for operation 'floor' # +# MDEV-12239 Add Type_handler::Item_sum_{sum|avg|variance}_fix_length_and_dec() +# +CREATE TABLE t1 (a GEOMETRY); +SELECT SUM(POINT(1,1)) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'sum' +SELECT SUM(a) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'sum' +SELECT SUM(COALESCE(a)) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'sum' +SELECT AVG(POINT(1,1)) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'avg' +SELECT AVG(a) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'avg' +SELECT AVG(COALESCE(a)) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'avg' +SELECT VARIANCE(POINT(1,1)) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'variance(' +SELECT VARIANCE(a) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'variance(' +SELECT VARIANCE(COALESCE(a)) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'variance(' +SELECT STDDEV(POINT(1,1)) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'std(' +SELECT STDDEV(a) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'std(' +SELECT STDDEV(COALESCE(a)) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'std(' +DROP TABLE t1; +# # End of 10.3 tests # |