Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
SQL variable "old" controls boolean server variable old_mode which used in several places.
SQL variable "old_mode" controls set server variable old_behavior.
Make so that SQL "old" variable will set one or several bits in "old_mode" (old_behavior) for compatibility.
Check knowledge base for correspondence description to server behavior (now there told that old_mode replace old but it does not looks like correct)
Attachments
Issue Links
- is part of
-
-
- Closed
-
- relates to
-
MDEV-28029 No warnings if server starts with "--old" option
-
- Closed
-
Activity
Since the "-old" option is deprecated, I think it is need to change option "old" to "-old-mode" in tests. I found this option in tests "main.old-mode" (old-mode-master.opt) and "main.row-checksum-old" (row-checksum-old-master.opt).
Also the option "--old" is set next values for @@OLD_MODE:
SELECT @@OLD_MODE ;
|
+---------------------------------------------------------------------------------+
|
| @@OLD_MODE |
|
+---------------------------------------------------------------------------------+
|
| NO_PROGRESS_INFO,UTF8_IS_UTF8MB3,IGNORE_INDEX_ONLY_FOR_JOIN,COMPAT_5_1_CHECKSUM |
|
+---------------------------------------------------------------------------------+
|
that not all are described in https://mariadb.com/kb/en/old-mode/ (e.g. "IGNORE_INDEX_ONLY_FOR_JOIN", "COMPAT_5_1_CHECKSUM"). It would be nice to update the documentation as well.
lstartseva yes, updating KB shortly.
About some test still using --old , I didn't remove the option file to demonstrate the deprecation warning. --old currently also sets the corresponding old_mode variables so the rest of the test should work fine. Only new addition is that now it also gives warning.
pushed to preview branch: https://github.com/MariaDB/server/tree/preview-10.9-MDEV-24920