Details
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.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Assignee | Sergei Golubchik [ serg ] | Elena Stepanova [ elenst ] |
Fix Version/s | 10.2.44 [ 27514 ] | |
Fix Version/s | 10.3.35 [ 27512 ] | |
Fix Version/s | 10.4.25 [ 27510 ] | |
Fix Version/s | 10.5.16 [ 27508 ] | |
Fix Version/s | 10.6.8 [ 27506 ] | |
Fix Version/s | 10.7.4 [ 27504 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.6 [ 24028 ] | |
Fix Version/s | 10.7 [ 24805 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
I've made the change for now (added a check for FIPS). It can always be removed if test re-arranging happens and all DES stuff is moved elsewhere.