mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-11-05 13:26:14 +01:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/storage/spider
History
Exact
Yuchen Pei c1d5bfbafc
 MDEV-36454 MDEV-35452 Fix spider view protocol test failures caused by tampering of order by items 
With view protocol, a SELECT statement is transformed into two
statements:

1. CREATE OR REPLACE VIEW mysqltest_tmp_v AS SELECT ...
2. SELECT * FROM mysqltest_tmp_v

The first statement reconstructed the query, which is executed in the
second statement.

The reconstruction often replaces aliases in ORDER BY by the original
item.

For example, in the test spider/bugfix.mdev_29008 the query

SELECT MIN(t2.a) AS f1, t1.b AS f2 FROM tbl_a AS t1 JOIN tbl_a AS t2 GROUP BY f2 ORDER BY f1, f2;

is transformed to

"select min(`t2`.`a`) AS `f1`,`t1`.`b` AS `f2` from (`auto_test_local`.`tbl_a` `t1` join `auto_test_local`.`tbl_a` `t2`) group by `t1`.`b` order by min(`t2`.`a`),`t1`.`b`"

In such cases, spider constructs different queries to execute at the
data node. So we disable view protocol for such queries.
2025-04-03 18:09:17 +11:00
..
mysql-test/spider MDEV-36454 MDEV-35452 Fix spider view protocol test failures caused by tampering of order by items 2025-04-03 18:09:17 +11:00
CMakeLists.txt MDEV-26912 Spider: Remove dead code related to Oracle OCI 2024-10-15 14:30:40 +11:00
configure.in MDEV-4438 - Spider storage engine 2013-06-27 15:18:48 +04:00
ha_spider.cc MDEV-34849 Spider: do not change the first byte of a connection key 2025-01-22 11:20:06 +11:00
ha_spider.h MDEV-28526 Spider: remove conn_kind member variables 2025-01-22 11:20:06 +11:00
spd_conn.cc MDEV-34849 Clean up spider_check_trx_and_get_conn() 2025-01-22 11:20:07 +11:00
spd_conn.h MDEV-28526 Spider: remove conn_kind member variables 2025-01-22 11:20:06 +11:00
spd_copy_tables.cc MDEV-28526 Spider: remove conn_kind member variables 2025-01-22 11:20:06 +11:00
spd_copy_tables.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
spd_db_conn.cc MDEV-35874 Spider: add missing skips when fetching results 2025-02-26 15:45:17 +11:00
spd_db_conn.h MDEV-28526 Spider: remove conn_kind member variables 2025-01-22 11:20:06 +11:00
spd_db_include.cc MDEV-26178 spider: delete spd_environ.h 2024-09-10 11:15:18 +10:00
spd_db_include.h MDEV-28526 Spider: remove conn_kind member variables 2025-01-22 11:20:06 +11:00
spd_db_mysql.cc MDEV-36324 MDEV-35452 Missing appending FROM ... in spider_mbase_handler::append_key_select 2025-04-02 15:45:30 +11:00
spd_db_mysql.h MDEV-36324 MDEV-35452 Missing appending FROM ... in spider_mbase_handler::append_key_select 2025-04-02 15:45:30 +11:00
spd_direct_sql.cc MDEV-35807 Case-insensitive wrappers in spider 2025-02-26 15:46:05 +11:00
spd_direct_sql.h Merge branch '5.5' into 10.1 2019-05-11 22:19:05 +03:00
spd_err.h MDEV-33490 MENT-1504 Fix some english strings in spider. 2024-06-04 12:25:08 +10:00
spd_group_by_handler.cc MDEV-36307 MDEV-35452 Do not create spider group by handler when dealing with derived tables or view and at least one select item is constant 2025-04-02 15:45:23 +11:00
spd_group_by_handler.h MDEV-26345 Spider GBH should execute original queries on the data node 2024-10-15 15:36:12 +11:00
spd_i_s.cc MDEV-26178 spider: delete spd_environ.h 2024-09-10 11:15:18 +10:00
spd_include.h MDEV-34849 Clean up spider_check_trx_and_get_conn() 2025-01-22 11:20:07 +11:00
spd_init_query.h MDEV-33538 make auxiliary spider plugins init depend on actual spider 2024-05-03 14:47:54 +10:00
spd_malloc.cc MDEV-26178 spider: delete spd_environ.h 2024-09-10 11:15:18 +10:00
spd_malloc.h MDEV-20179 Server hangs on shutdown during installation of Spider (#1368) 2019-07-30 06:16:48 +09:00
spd_param.cc MDEV-35064 Reduce the default spider connect retry counts to 2 2024-11-27 10:25:14 +11:00
spd_param.h MDEV-27643 Spider: remove #ifdef HA_CAN_BULK_ACCESS 2024-09-10 11:19:19 +10:00
spd_ping_table.cc MDEV-28526 Spider: remove conn_kind member variables 2025-01-22 11:20:06 +11:00
spd_ping_table.h Merge 10.2 into 10.3 2019-05-14 17:18:46 +03:00
spd_sys_table.cc MDEV-34716 spider: some trivial cleanups and documentation 2024-10-15 11:04:27 +11:00
spd_sys_table.h Merge branch '10.4' into 10.5 2024-04-16 11:04:14 +02:00
spd_table.cc MDEV-35807 Case-insensitive wrappers in spider 2025-02-26 15:46:05 +11:00
spd_table.h MDEV-34348: my_hash_get_key fixes 2024-11-23 08:14:22 -07:00
spd_trx.cc MDEV-35807 Removed an unused function spider_cmp_trx_alter_table 2025-02-26 15:46:04 +11:00
spd_trx.h MDEV-35807 Removed an unused function spider_cmp_trx_alter_table 2025-02-26 15:46:04 +11:00
spd_udf.cc MDEV-35735: UBSAN: spider udf functions mismatch with UDF defination 2025-01-12 13:40:18 +11:00
spd_udf.def MDEV-4438 - Spider storage engine 2013-06-27 15:18:48 +04:00
spd_udf.h MDEV-35735: UBSAN: spider udf functions mismatch with UDF defination 2025-01-12 13:40:18 +11:00
spider.cnf Unify config syntax in default files 2020-08-01 10:31:41 +10:00