mariadb/mysql-test/suite
bsrikanth-mariadb 67b320b413 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-06-28 07:35:07 -04:00
..
archive Merge remote-tracking branch 'github/bb-11.4-release' into bb-11.8-serg 2025-04-27 19:40:00 +02:00
atomic Fix the test: changing charset should be dome when we can not skip the test. 2025-05-09 07:36:15 +02:00
binlog MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
binlog_encryption MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
client Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00
compat mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
csv mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
encryption mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
engines MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
events MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
federated MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
funcs_1 cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
funcs_2 Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
galera MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
galera_3nodes Merge branch '11.8' into 12.0 2025-06-18 07:50:39 +02: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-36132 Substitute vcol expressions with indexed vcol fields in ORDER BY and GROUP BY 2025-07-22 10:44:12 +10:00
handler mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
heap Merge branch '11.4' into 11.7 2025-02-06 16:46:36 +01:00
innodb cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
innodb_fts mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
innodb_gis mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07: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 Merge branch '11.8' into 12.0 2025-05-22 09:22:55 +02:00
large_tests
maria MDEV-24 Segmented key cache for Aria 2025-06-25 17:59:45 +03:00
mariabackup mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
merge mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07: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 cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07: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-9804 Implement a caching_sha2_password plugin 2025-07-27 13:57:06 +02:00
roles MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
rpl MDEV-35617: DROP USER should leave no active session for that user 2025-07-16 09:14:33 +07:00
s3 Merge branch '11.8' into 12.0 2025-06-18 07:50:39 +02:00
sql_sequence cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
storage_engine mariadb-test: wait on disconnect 2025-07-16 09:14:33 +07:00
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-06-28 07:35:07 -04:00
sysschema MDEV-34888 Implement SEMIJOIN() and SUBQUERY() hints 2025-05-05 12:02:47 +07:00
unit
vcol MDEV-36132 Substitute vcol expressions with indexed vcol fields in ORDER BY and GROUP BY 2025-07-22 10:44:12 +10:00
versioning cleanup: disconnect before DROP USER 2025-07-16 09:14:33 +07:00
wsrep Fix typos in mysql-test/ 2025-04-29 13:53:16 +10:00