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 /plugin/type_inet/mysql-test/type_inet | |
| 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 'plugin/type_inet/mysql-test/type_inet')
| -rw-r--r-- | plugin/type_inet/mysql-test/type_inet/type_inet6.result | 9 | ||||
| -rw-r--r-- | plugin/type_inet/mysql-test/type_inet/type_inet6.test | 12 |
2 files changed, 21 insertions, 0 deletions
diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet6.result b/plugin/type_inet/mysql-test/type_inet/type_inet6.result index 15c8dbf8ca9..edcdc64dade 100644 --- a/plugin/type_inet/mysql-test/type_inet/type_inet6.result +++ b/plugin/type_inet/mysql-test/type_inet/type_inet6.result @@ -1977,3 +1977,12 @@ SELECT MIN(a), MAX(a) FROM t1 GROUP BY id; MIN(a) MAX(a) fff:: 8888:: DROP TABLE t1; +# +# MDEV-20809 EXTRACT from INET6 value does not produce any warnings +# +CREATE TABLE t1 (a INET6); +SELECT EXTRACT(DAY FROM a) FROM t1; +ERROR HY000: Illegal parameter data type inet6 for operation 'extract(day)' +DROP TABLE t1; +SELECT EXTRACT(DAY FROM CAST('::' AS INET6)); +ERROR HY000: Illegal parameter data type inet6 for operation 'extract(day)' diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet6.test b/plugin/type_inet/mysql-test/type_inet/type_inet6.test index 8559748c7dd..92ca0d95644 100644 --- a/plugin/type_inet/mysql-test/type_inet/type_inet6.test +++ b/plugin/type_inet/mysql-test/type_inet/type_inet6.test @@ -1445,3 +1445,15 @@ CREATE TABLE t1 (id INT, a INET6) ENGINE=MyISAM; INSERT INTO t1 VALUES (1, 'fff::'),(1, '8888::'); SELECT MIN(a), MAX(a) FROM t1 GROUP BY id; DROP TABLE t1; + + +--echo # +--echo # MDEV-20809 EXTRACT from INET6 value does not produce any warnings +--echo # + +CREATE TABLE t1 (a INET6); +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT EXTRACT(DAY FROM a) FROM t1; +DROP TABLE t1; +--error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION +SELECT EXTRACT(DAY FROM CAST('::' AS INET6)); |