mirror of
https://github.com/MariaDB/server.git
synced 2025-07-20 02:08:15 +02:00
453a86f68e
This commit: - fixes a couple of bugs in check_join_cache_usage(); - separates a part of opt_hints.test to a new file opt_hints_join_cache.test; - add a batch of test cases run against different join_cache_level settings.
18 lines
812 B
PHP
18 lines
812 B
PHP
EXPLAIN SELECT * FROM t12, t13
|
|
WHERE t12.a=t13.a AND (t13.b+1 <= t12.b+1);
|
|
--echo --------------------------------------------
|
|
EXPLAIN SELECT /*+ BKA() */ * FROM t12, t13
|
|
WHERE t12.a=t13.a AND (t13.b+1 <= t12.b+1);
|
|
--echo --------------------------------------------
|
|
EXPLAIN SELECT /*+ BNL() */ * FROM t12, t13
|
|
WHERE t12.a=t13.a AND (t13.b+1 <= t12.b+1);
|
|
--echo --------------------------------------------
|
|
EXPLAIN SELECT /*+ NO_BKA() */ * FROM t12, t13
|
|
WHERE t12.a=t13.a AND (t13.b+1 <= t12.b+1);
|
|
--echo --------------------------------------------
|
|
EXPLAIN SELECT /*+ NO_BNL() */ * FROM t12, t13
|
|
WHERE t12.a=t13.a AND (t13.b+1 <= t12.b+1);
|
|
--echo --------------------------------------------
|
|
EXPLAIN SELECT /*+ NO_BKA() NO_BNL() */ * FROM t12, t13
|
|
WHERE t12.a=t13.a AND (t13.b+1 <= t12.b+1);
|
|
|