diff options
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)"))))) |