mariadb/mysql-test/suite
bsrikanth-mariadb 71dba7d642 MDEV-36483: store ddls in the optimizer trace
This feature stores the ddls of the tables/views that are used in
a query, to the optimizer trace. It is currently controlled by a
system variable store_ddls_in_optimizer_trace, and is not enabled
by default. All the ddls will be stored in a single json array, with each
element having table/view name, and the associated create definition
of the table/view.

The approach taken is to read global query_tables from the thd->lex,
and read them in reverse. Create a record with table_name, ddl of
the table and add the table_name to the hash,
along with dumping the information to the trace.
dbName_plus_tableName is used as a key,
and the duplicate entries are not added to the hash.

The main suite tests are also run with the feature enabled, and they
all succeed.
2025-05-26 14:10:45 -04:00
..
archive MDEV-36050 DATA/INDEX DIRECTORY handling is inconsistent 2025-04-18 09:41:23 +02:00
atomic Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
binlog MDEV-36566 SELECT create_temporary_table_binlog_formats should show exactly what it is SET to 2025-04-30 12:33:24 +02:00
binlog_encryption Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
client Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
compat MDEV-36716 A case expression with ROW arguments in THEN crashes 2025-05-05 19:44:04 +04:00
csv Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
encryption Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
engines MDEV-36503 add Pad_attribute column to INFORMATION_SCHEMA.COLLATIONS 2025-05-19 17:07:18 +04:00
events Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
federated Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
funcs_1 MDEV-36503 add Pad_attribute column to INFORMATION_SCHEMA.COLLATIONS 2025-05-19 17:07:18 +04:00
funcs_2 Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
galera MDEV-34822 addendum: minor test corrections after fix 2025-05-05 20:06:00 +02:00
galera_3nodes Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
galera_3nodes_sr Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
galera_sr Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
gcol MDEV-33281 Optimizer hints Cleanup: fix formatting, rename objects 2025-05-05 12:02:47 +07:00
handler Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
heap Merge branch '11.4' into 11.7 2025-02-06 16:46:36 +01:00
innodb MDEV-36503 add Pad_attribute column to INFORMATION_SCHEMA.COLLATIONS 2025-05-19 17:07:18 +04:00
innodb_fts Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
innodb_gis Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
innodb_i_s
innodb_zip Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
jp Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
json MDEV-33281 Optimizer hints Cleanup: fix formatting, rename objects 2025-05-05 12:02:47 +07:00
large_tests fix failing large_tests.maria_recover_encrypted 2024-04-22 18:38:39 +02:00
maria remove features that were deprecated in 10.5 2025-04-29 16:53:02 +02:00
mariabackup Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
merge Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
mtr/t Remove dates from all rdiff files 2025-01-05 16:40:11 +02:00
mtr2
multi_source MDEV-35304: Fix multi_source.connects_tried 2025-04-29 11:00:37 -06:00
optimizer_unfixed_bugs
parts Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
perfschema increase tolerance in socket_summary_check.inc 2025-04-29 16:53:02 +02:00
perfschema_stress remove features that were deprecated in 10.5 2025-04-29 16:53:02 +02:00
period Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
plugins MDEV-12182 post-merge 2025-05-02 13:56:25 +02:00
roles fix error messages 2025-05-02 13:56:25 +02:00
rpl MDEV-36735 rpl.rpl_drop_temp Result Content Mismatch Failure 2025-05-20 12:54:18 +03:00
s3 Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
sql_sequence MDEV-35866 CHECK TABLE get number of rows without HA_STATS_RECORDS_IS_EXACT 2025-05-05 11:36:56 +10:00
storage_engine
stress MDEV-34453 Trying to read 16384 bytes at 70368744161280 outside the bounds of the file: ./ibdata1 2024-09-20 20:26:43 +05:30
sys_vars MDEV-36483: store ddls in the optimizer trace 2025-05-26 14:10:45 -04:00
sysschema MDEV-34888 Implement SEMIJOIN() and SUBQUERY() hints 2025-05-05 12:02:47 +07:00
unit Merge branch '11.4' into 11.5 2024-08-05 17:50:18 +02:00
vcol Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
versioning Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
wsrep Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00