From 35cbbd4d70e300d25077ece1971c9f7266f347e9 Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Mon, 1 Jun 2020 10:35:01 +0400 Subject: MDEV-20809 EXTRACT from INET6 value does not produce any warnings Disallowing EXTRACT(xxx FROM inet6arg) as fix time. Adding a new method Type_handler::can_return_extract_source(). --- mysql-test/main/row.test | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'mysql-test/main/row.test') diff --git a/mysql-test/main/row.test b/mysql-test/main/row.test index 80c61c414bf..d78d61b078a 100644 --- a/mysql-test/main/row.test +++ b/mysql-test/main/row.test @@ -314,3 +314,21 @@ SELECT (1,null) NOT IN ((2,2),(3,3)), (1,null) NOT IN ((2,2)), (1,null) NOT IN ( --echo # --echo # End of 10.1 tests --echo # + + +--echo # +--echo # Start of 10.5 tests +--echo # + +--echo # +--echo # MDEV-20809 EXTRACT from INET6 value does not produce any warnings +--echo # + +CREATE TABLE t1 (a GEOMETRY); +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT EXTRACT(DAY FROM a) FROM t1; +DROP TABLE t1; + +--echo # +--echo # End of 10.5 tests +--echo # -- cgit v1.2.1