diff options
author | Alexander Barkov <bar@mariadb.com> | 2020-06-01 10:35:01 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2020-06-01 10:35:01 +0400 |
commit | 35cbbd4d70e300d25077ece1971c9f7266f347e9 (patch) | |
tree | 56da16d18bebf1c64b43cd87f33d79c747ee2df4 /mysql-test/main/row.test | |
parent | f67522ede66bfccb90d80f4f3e41209997862fef (diff) | |
download | mariadb-git-35cbbd4d70e300d25077ece1971c9f7266f347e9.tar.gz |
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().
Diffstat (limited to 'mysql-test/main/row.test')
-rw-r--r-- | mysql-test/main/row.test | 18 |
1 files changed, 18 insertions, 0 deletions
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 # |