mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-12-29 23:55:43 +01:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/federated
History
Exact
Dave Gosselin 5001300bd4 MDEV-30469 Support ORDER BY and LIMIT for multi-table DELETE, index hints for single-table DELETE 
We now allow multitable queries with order by and limit, such as:
  delete t1.*, t2.* from t1, t2 order by t1.id desc limit 3;
To predict what rows will be deleted, run the equivalent select:
  select t1.*, t2.* from t1, t2 order by t1.id desc limit 3;
Additionally, index hints are now supported with single table delete statements:
  delete from t2 use index(xid) order by (id) limit 2;

This approach changes the multi_delete SELECT result interceptor to use a temporary
table to collect row ids pertaining to the rows that will be deleted, rather than
directly deleting rows from the target table(s).  Row ids are collected during
send_data, then read during send_eof to delete target rows.  In the event that the
temporary table created in memory is not big enough for all matching rows, it is
converted to an aria table.

Other changes:
  - Deleting from a sequence now affects zero rows instead of emitting an error

Limitations:
  - The federated connector does not create implicit row ids, so we to use a key
  when conditionally deleting.  See the change in federated_maybe_16324629.test
2025-02-05 10:12:27 -05:00
..
include mysql-5.5.28 2012-10-16 13:04:42 +02:00
assisted_discovery.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
assisted_discovery.test MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
combinations MDEV-3860 backport --plugin-load-add (and related mysql-test changes) 2012-12-15 18:24:11 +01:00
disabled.def 5.5-merge 2011-07-02 22:08:51 +02:00
error_on_close-8313.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
error_on_close-8313.test MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
error_row_number.result MDEV-26654 ROW_NUMBER is wrong upon INSERT into Federated table 2021-10-26 17:29:40 +02:00
error_row_number.test MDEV-26654 ROW_NUMBER is wrong upon INSERT into Federated table 2021-10-26 17:29:40 +02:00
federated.result MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
federated.test fix tests for solaris - different errno numbers and/or different errno messages 2014-02-06 16:28:05 +01:00
federated_archive.result MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
federated_archive.test Bug #12876932 - INCORRECT SELECT RESULT ON FEDERATED TABLE 2012-07-26 15:09:22 +05:30
federated_bug_13118.result MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
federated_bug_13118.test Bug #12876932 - INCORRECT SELECT RESULT ON FEDERATED TABLE 2012-07-26 15:09:22 +05:30
federated_bug_25714.result MDEV-31857 enable --ssl-verify-server-cert by default 2024-02-04 22:19:15 +01:00
federated_bug_25714.test MDEV-31857 enable --ssl-verify-server-cert by default 2024-02-04 22:19:15 +01:00
federated_bug_32426.result MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
federated_bug_32426.test Merge MySQL 5.1.66 -> MariaDB 5.1.65 2012-11-06 11:52:55 +02:00
federated_bug_35333.result Post MDEV-11902 Fix test failures in maria and myisam storage engines 2017-03-03 20:12:48 +02:00
federated_bug_35333.test Merge branch '5.5' into 10.0 2017-03-03 01:37:54 +02:00
federated_bug_585688.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
federated_bug_585688.test Merge MySQL 5.1.66 -> MariaDB 5.1.65 2012-11-06 11:52:55 +02:00
federated_debug-master.opt fixes for opensolaris compilation failures 2012-01-05 18:56:31 +01:00
federated_debug.result MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
federated_debug.test MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
federated_innodb.result MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
federated_innodb.test Bug #12876932 - INCORRECT SELECT RESULT ON FEDERATED TABLE 2012-07-26 15:09:22 +05:30
federated_maybe_16324629.result MDEV-30469 Support ORDER BY and LIMIT for multi-table DELETE, index hints for single-table DELETE 2025-02-05 10:12:27 -05:00
federated_maybe_16324629.test MDEV-30469 Support ORDER BY and LIMIT for multi-table DELETE, index hints for single-table DELETE 2025-02-05 10:12:27 -05:00
federated_partition-slave.opt Applied patch for lp:585688 "maridb crashes in federatedx code" from lp:~atcurtis/maria/federatedx: 2011-02-10 22:40:59 +02:00
federated_partition.result MDEV-19123 Change default charset from latin1 to utf8mb4 2024-07-11 10:21:07 +04:00
federated_partition.test Merge 10.2 into 10.3 2021-08-18 12:26:58 +03:00
federated_server.result MDEV-34716 Allow arbitrary options in CREATE SERVER 2024-10-15 10:50:22 +11:00
federated_server.test MDEV-29668 SUPER should not allow actions that have fine-grained dedicated privileges 2023-02-06 14:31:48 +01:00
federated_transactions.result MDEV-6720 - enable connection log in mysqltest by default 2016-03-31 10:11:16 +04:00
federated_transactions.test Merge MySQL 5.1.66 -> MariaDB 5.1.65 2012-11-06 11:52:55 +02:00
federated_type_inet6.result MDEV-20806 Federated does not work with INET6, returns NULL with warning ER_TRUNCATED_WRONG_VALUE 2019-10-12 07:25:53 +04:00
federated_type_inet6.test MDEV-20806 Federated does not work with INET6, returns NULL with warning ER_TRUNCATED_WRONG_VALUE 2019-10-12 07:25:53 +04:00
federatedx.result Merge branch 'bb-11.5-release' into bb-11.6-release 2024-08-06 17:28:38 +02:00
federatedx.test Do a proper cleanup in testcase for MDEV-30569 2023-02-15 13:33:59 +03:00
federatedx_create_handlers.result MariaDB 11.4.4 release 2024-11-08 07:17:00 +01:00
federatedx_create_handlers.test Merge 11.4 into 11.6 2024-10-03 16:09:56 +03:00
federatedx_versioning.result MDEV-35308 NO_KEY_OPTIONS SQL mode has no effect on engine key options 2024-11-05 14:00:52 -08:00
federatedx_versioning.test MDEV-28632 Change default of explicit_defaults_for_timestamp to ON 2022-08-10 15:03:22 +02:00
have_federatedx.inc MDEV-16342 SHOW ENGINES: MyISAM description is useless 2018-06-11 09:57:54 +02:00
have_federatedx.opt 10.0-base merge (roles) 2013-10-29 15:08:44 +01:00
indexes.result MDEV-27398 DESC index causes wrong (empty) result on Federated tables 2022-01-26 18:43:06 +01:00
indexes.test MDEV-27398 DESC index causes wrong (empty) result on Federated tables 2022-01-26 18:43:06 +01:00
my.cnf test.cnf files should !include default_my.cnf 2024-02-03 11:22:20 +01:00
net_thd_crash-12725.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
net_thd_crash-12725.test MDEV-12725 select on federated table crashes server 2017-08-08 22:49:09 +02:00
net_thd_crash-12951.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
net_thd_crash-12951.test MDEV-14272 Mariadb crashes with signal 11 when using federatedx engine and galera 2017-12-28 02:13:25 +01:00
optimizer.result MDEV-14907 FEDERATEDX doesn't respect DISTINCT 2022-01-05 16:52:39 +02:00
optimizer.test MDEV-14907 FEDERATEDX doesn't respect DISTINCT 2022-01-05 16:52:39 +02:00
rpl.result test cases for MySQL bugs 2022-01-21 16:02:34 +01:00
rpl.test federated.rpl failed if federatedx was not compiled 2022-03-01 11:36:39 +02:00
suite.pm allow suite.pm to skip combinations that originate from test/include files. 2012-02-07 16:22:36 +01:00
timestamps.result MDEV-16157 federated corrupts timestamps 2018-05-17 15:33:39 +02:00
timestamps.test MDEV-16157 federated corrupts timestamps 2018-05-17 15:33:39 +02:00
update.result MDEV-32984 Update federated table and column privileges 2024-01-10 10:16:20 +01:00
update.test MDEV-32984 Update federated table and column privileges 2024-01-10 10:16:20 +01:00