diff options
| author | Monty <monty@mariadb.org> | 2022-12-28 05:41:41 +0200 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2023-02-10 12:58:50 +0200 |
| commit | 9a4110aa5799d63faced5f986fab9035785a9310 (patch) | |
| tree | 088a18218346042fb60a8b37bf2d2da365e17924 /storage/spider | |
| parent | e3f56254a8f6e03270b73fb9f6fd1aaab1141590 (diff) | |
| download | mariadb-git-9a4110aa5799d63faced5f986fab9035785a9310.tar.gz | |
MDEV-30256 Wrong result (missing rows) upon join with empty table
The problem was an assignment in test_quick_select() that flagged empty
tables with "Impossible where". This test was however wrong as it
didn't work correctly for left join.
Removed the test, but added checking of empty tables in DELETE and UPDATE
to get similar EXPLAIN as before.
The new tests is a bit more strict (better) than before as it catches all
cases of empty tables in single table DELETE/UPDATE.
Diffstat (limited to 'storage/spider')
| -rw-r--r-- | storage/spider/mysql-test/spider/bg/r/spider_fixes.result | 1 | ||||
| -rw-r--r-- | storage/spider/mysql-test/spider/r/spider_fixes.result | 1 |
2 files changed, 0 insertions, 2 deletions
diff --git a/storage/spider/mysql-test/spider/bg/r/spider_fixes.result b/storage/spider/mysql-test/spider/bg/r/spider_fixes.result index a6a7588b014..2f54ef93a13 100644 --- a/storage/spider/mysql-test/spider/bg/r/spider_fixes.result +++ b/storage/spider/mysql-test/spider/bg/r/spider_fixes.result @@ -481,7 +481,6 @@ DELETE FROM t1; Warnings: Error 12702 Remote table 'auto_test_remote.ter1_1' is not found Error 12702 Remote table 'auto_test_remote.ter1_1' is not found -Error 1146 Table 'auto_test_remote.ter1_1' doesn't exist TRUNCATE t1; Warnings: Error 1146 Table 'auto_test_remote.ter1_1' doesn't exist diff --git a/storage/spider/mysql-test/spider/r/spider_fixes.result b/storage/spider/mysql-test/spider/r/spider_fixes.result index 3b9d939393a..5e17e83618e 100644 --- a/storage/spider/mysql-test/spider/r/spider_fixes.result +++ b/storage/spider/mysql-test/spider/r/spider_fixes.result @@ -481,7 +481,6 @@ DELETE FROM t1; Warnings: Error 12702 Remote table 'auto_test_remote.ter1_1' is not found Error 12702 Remote table 'auto_test_remote.ter1_1' is not found -Error 1146 Table 'auto_test_remote.ter1_1' doesn't exist TRUNCATE t1; Warnings: Error 1146 Table 'auto_test_remote.ter1_1' doesn't exist |