Details
Major Description
|
10.3 1766a1 |
gcol.gcol_supported_sql_funcs_innodb 'innodb' w5 [ fail ] |
Test ended at 2022-03-10 16:22:50 |
|
|
CURRENT_TEST: gcol.gcol_supported_sql_funcs_innodb
|
--- /usr/share/mysql-test/suite/gcol/r/gcol_supported_sql_funcs_innodb.result 2022-03-10 15:37:04.000000000 +0000
|
+++ /dev/shm/var/5/log/gcol_supported_sql_funcs_innodb.reject 2022-03-10 16:22:50.664671851 +0000
|
@@ -2898,10 +2898,13 @@
|
`b` varchar(1024) GENERATED ALWAYS AS (des_encrypt(des_decrypt(`a`,'adf'),'adf')) VIRTUAL |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
insert into t1 values ('MySQL',default); |
+Warnings:
|
+Warning 1108 Incorrect parameters to procedure 'des_encrypt' |
select * from t1; |
a b
|
-MySQL �w2��
|
-���
|
+MySQL NULL |
+Warnings:
|
+Warning 1108 Incorrect parameters to procedure 'des_encrypt' |
drop table t1; |
# INET_ATON(), INET_NTOA()
|
set sql_warnings = 1; |
|
|
mysqltest: Result length mismatch
|
Same with gcol.gcol_supported_sql_funcs_myisam.
An easy way to fix it would be to disable the tests in FIPS mode, e.g. by something like
diff --git a/mysql-test/suite/gcol/inc/gcol_supported_sql_funcs_main.inc b/mysql-test/suite/gcol/inc/gcol_supported_sql_funcs_main.inc
|
index 88268ddd6c4..3f48f86ce7c 100644
|
--- a/mysql-test/suite/gcol/inc/gcol_supported_sql_funcs_main.inc
|
+++ b/mysql-test/suite/gcol/inc/gcol_supported_sql_funcs_main.inc
|
@@ -12,6 +12,9 @@
|
# Change Date: #
|
# Change: #
|
################################################################################
|
+
|
+--source include/have_des.inc
|
+
|
set time_zone="+03:00";
|
--echo #
|
--echo # NUMERIC FUNCTIONS
|
(I didn't check whether this exact patch does the trick, but anyway – by adding have_des.inc somewhere in these tests).
If that's okay, I can do it.
However, there was a talk about reshuffling the tests to extract des_encrypt|decrypt into a separate test file, so maybe the above isn't good enough.