Supporting newly added Datatype, Function, Keyword, Variables, User privileges in MariaDB

[sibwy]

Datatype:

1. UUID [added in v10.7.0]
2. INT1 [synonym for TINYINT]
3. INT2 [synonym for SMALLINT]
4. INT3 [synonym for MEDIUMINT]
5. INT4 [synonym for INT]
6. INT8 [synonym for BIGINT]

MariaDB Function:

1. CHR(N)
2. JSON_ARRAYAGG(column_or_expression) [added in v10.5.0]
3. JSON_OBJECTAGG(key, value) [added in v10.5.0]
4. JSON_TABLE(json_doc,
   context_path COLUMNS (column_list)
   ) [AS] alias [added in v10.6.0]
5. ADD_MONTHS(date, months) [added in v10.6.1]
6. TO_CHAR(expr[, fmt]) [added in v10.6.1]
7. SYS_GUID() [added in v10.6.1]
8. JSON_EQUALS(json1, json2) [added in v10.7.0]
9. JSON_NORMALIZE(json) [added in v10.7.0]
10. NATURAL_SORT_KEY(str) [added in v10.7.0]
11. SFORMAT [added in v10.7.0] - This function takes an input string. For e.g., SELECT SFORMAT("The answer is {}.", 42);
12. CRC32(expr) [<= MariaDB v10.7]
13. CRC32([par,]expr) [from MariaDB v10.8]
14. JSON_OVERLAPS(json_doc1, json_doc2) [added in v10.9]
15. RANDOM_BYTES(length) [added in v10.10.0]
16. FORMAT_PICO_TIME(time_val) [added in v11.0.2]
17. JSON_SCHEMA_VALID(schema, json) [added in v11.1.0]
18. JSON_OBJECT_FILTER_KEYS(obj, array_keys) [added in v11.2.0]
19. JSON_OBJECT_TO_ARRAY(Obj) [added in v11.2.0]
20. JSON_ARRAY_INTERSECT(arr1, arr2) [added in v11.2.0]
21. KDF(key_str, salt [, {info | iterations} [, kdf_name [, width ]]]) [added in v11.3.0]

MariaDB System Variables:

1. alter_algorithm [added in v10.3.7]
2. bind_address [added in v10.3.3]
3. binlog_file_cache_size [added in v10.3.3]
4. gtid_pos_auto_engines [added in v10.3.1]
5. column_compression_threshold [added in v10.3.2]
6. column_compression_zlib_level [added in v10.3.2]
7. column_compression_zlib_strategy [added in v10.3.2]
8. column_compression_zlib_wrap [added in v10.3.2]
9. idle_readonly_transaction_timeout [added in v10.3.0]
10. idle_transaction_timeout [added in v10.3.0]
11. idle_write_transaction_timeout [added in v10.3.0]
12. in_predicate_conversion_threshold [added in v10.3.18]
13. innodb_encrypt_temporary_ables [added in v10.3.17]
14. innodb_instant_alter_column_allowed [added in v10.3.23]
15. log_disabled_statements [added in v10.3.1]
16. log_slow_disabled_statements [added in v10.3.1]
17. rpl_semi_sync_master_enabled [added in v10.3.3]
18. rpl_semi_sync_master_timeout [added in v10.3.3]
19. rpl_semi_sync_master_trace_level [added in v10.3.3]
20. rpl_semi_sync_master_wait_no_slave [added in v10.3.3]
21. rpl_semi_sync_master_wait_point [added in v10.3.3]
22. secure_timestamp [added in v10.3.7]
23. slave_transaction_retry_errors [added in v10.3.3]
24. slave_transaction_retry_interval [added in v10.3.3]
25. system_versioning_alter_history [added in v10.3.4]
26. system_versioning_asof [added in v10.3.4]
27. system_versioning_innodb_algorithm_simple [added in v10.3.4]
28. tcp_keepalive_interval [added in v10.3.3]
29. tcp_keepalive_probes [added in v10.3.3]
30. tcp_keepalive_time [added in v10.3.3]
31. version_source_revision [added in v10.3.2]
32. wsrep_certification_rules [added in v10.3.13]
33. wsrep_reject_queries [added in v10.3.6]
34. analyze_sample_percentage [added in v10.4.3]
35. default_password_lifetime [added in v10.4.3]
36. disconnect_on_expired_password [added in v10.4.3]
37. gtid_cleanup_batch_size [added in v10.4.1]
38. innodb_encrypt_temporary_ables [added in v10.4.7]
39. innodb_instant_alter_column_allowed [added in v10.4.13]
40. max_password_errors [added in v10.4.2]
41. optimizer_trace [added in v10.4.3]
42. optimizer_trace_max_mem_size [added in v10.4.3]
43. tcp_nodelay [added in v10.4.0]
44. tls_version [added in v10.4.6]
45. wsrep_certification_rules [added in v10.4.3]
46. wsrep_trx_fragment_size [added in v10.4.2]
47. wsrep_trx_fragment_unit [added in v10.4.2]
48. binlog_row_metadata [added in v10.5.0]
49. innodb_instant_alter_column_allowed [added in v10.5.3]
50. innodb_lru_flush_size [added in v10.5.7]
51. innodb_max_purge_lag_wait [added in v10.5.7]
52. optimizer_max_sel_arg_weight [added in v10.5.9]
53. performance_schema_events_transactions_history_long_size [added in v10.5.2]
54. performance_schema_events_transactions_history_size [added in v10.5.2]
55. performance_schema_max_index_stat [added in v10.5.2]
56. performance_schema_max_memory_classes [added in v10.5.2]
57. performance_schema_max_metadata_locks [added in v10.5.2]
58. performance_schema_max_prepared_statement_instances [added in v10.5.2]
59. performance_schema_max_program_instances [added in v10.5.2]
60. performance_schema_max_sql_text_length [added in v10.5.2]
61. performance_schema_max_statement_stack [added in v10.5.2]
62. performance_schema_max_table_lock_stat [added in v10.5.2]
63. require_secure_transport [added in v10.5.2]
64. s3_access_key [added in v10.5]
65. s3_block_size [added in v10.5]
66. s3_bucket [added in v10.5]
67. s3_debug [added in v10.5]
68. s3_host_name [added in v10.5]
69. s3_pagecache_age_threshold [added in v10.5]
70. s3_pagecache_buffer_size [added in v10.5]
71. s3_pagecache_division_limit [added in v10.5]
72. s3_pagecache_file_hash_size [added in v10.5]
73. s3_protocol_version [added in v10.5]
74. s3_region [added in v10.5]
75. s3_secret_key [added in v10.5]
76. sql_if_exists [added in v10.5.2]
77. thread_pool_dedicated_listener [added in v10.5.0]
78. thread_pool_exact_stats [added in v10.5.0]
79. binlog_alter_two_phase [added in v10.8.1]
80. innodb_log_file_buffering [added in v10.8.4]
81. rocksdb_log_dir [added in v10.9.1]
82. wsrep_status_file [added in v10.9.1]
83. slave_max_statement_time [added in v10.10]
84. allow_suspicious_udfs [added in v10.10.1]
85. optimizer_extra_pruning_depth [added in v10.10.1]
86. skip_grant_tables [added in v10.10.1]
87. slave_max_statement_time [added in v10.10.1]
88. wsrep_allowlist [added in v10.10.1]
89. log_slow_min_examined_row_limit [added in v10.11.0]
90. log_slow_query [added in v10.11.0]
91. log_slow_query_file [added in v10.11.0]
92. log_slow_query_time [added in v10.11.0]
93. log_slow_query_time [added in v10.11.0]
94. system_versioning_insert_history [added in v10.11.0]
95. innodb_data_file_buffering [added in v11.0.1]
96. innodb_data_file_write_through [added in v11.0.1]
97. innodb_log_file_write_through [added in v11.0.1]
98. transaction_isolation [added in v11.1.0]
99. transaction_read_only [added in v11.1.0]
100. binlog_do_db [added in v11.2.0]
101. binlog_ignore_db [added in v11.2.0]
102. binlog_row_event_max_size [added in v11.2.0]
103. block_encryption_mode [added in v11.2.0]
104. character_set_collations [added in v11.2.0]
105. innodb_truncate_temporary_tablespace_now [added in v11.3.0]
106. redirect_url [added in v11.3.0]
107. binlog_gtid_index [added in v11.4.0]
108. binlog_gtid_index_page_size [added in v11.4.0]
109. binlog_index_span_min [added in v11.4.0]
110. max_binlog_total_size [added in v11.4.0]
111. slave_connections_needed_for_purge [added in v11.4.0]

MariaDB Status Variables:

1. max_used_connections_time [added in v11.0.2]

Keywords:

1. SQL_BEFORE_GTIDS
2. SQL_AFTER_GTIDS

User Privileges:

1. Split 'SUPER' privilege to smaller privileges (MDEV-21743) [added in v10.5]

• BINLOG ADMIN
• BINLOG REPLAY
• CONNECTION ADMIN
• FEDERATED ADMIN
• READ_ONLY ADMIN
• REPLICATION MASTER ADMIN
• REPLICATION SLAVE ADMIN
• SET USER

2. The 'REPLICATION CLIENT' privilege was renamed to 'BINLOG MONITOR' [added in v10.5]
3. The 'SHOW MASTER STATUS' statement was renamed to 'SHOW BINLOG STATUS' (MDEV-21743) [added in v10.5]