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/t | |
| 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/t')
| -rw-r--r-- | mysql-test/t/gis.test | 38 | ||||
| -rw-r--r-- | mysql-test/t/select.test | 1 |
2 files changed, 39 insertions, 0 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index c486484f0d2..1d86a64fc59 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -1915,6 +1915,44 @@ SELECT CEILING(POINT(1,1)); --error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION SELECT FLOOR(POINT(1,1)); + +--echo # +--echo # MDEV-12239 Add Type_handler::Item_sum_{sum|avg|variance}_fix_length_and_dec() +--echo # + +CREATE TABLE t1 (a GEOMETRY); + +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT SUM(POINT(1,1)) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT SUM(a) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT SUM(COALESCE(a)) FROM t1; + +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT AVG(POINT(1,1)) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT AVG(a) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT AVG(COALESCE(a)) FROM t1; + +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT VARIANCE(POINT(1,1)) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT VARIANCE(a) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT VARIANCE(COALESCE(a)) FROM t1; + +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT STDDEV(POINT(1,1)) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT STDDEV(a) FROM t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT STDDEV(COALESCE(a)) FROM t1; + +DROP TABLE t1; + + --echo # --echo # End of 10.3 tests --echo # diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index a0caf4992bf..e8d5f9fa445 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -4427,6 +4427,7 @@ DROP TABLE t1; --echo # Bug #57203 Assertion `field_length <= 255' failed. --echo # +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION SELECT coalesce((avg(distinct (geomfromtext("point(25379 -22010)"))))) UNION ALL SELECT coalesce((avg(distinct (geomfromtext("point(25379 -22010)"))))) |