diff options
| author | Yuchen Pei <yuchen.pei@mariadb.com> | 2023-04-20 13:07:43 +1000 |
|---|---|---|
| committer | Yuchen Pei <yuchen.pei@mariadb.com> | 2023-04-20 13:07:43 +1000 |
| commit | 5746cad9bde2d3dbfc01a9edb4ae0f19d2243a50 (patch) | |
| tree | 8bb90b23695f46b13fac07676edcdbb908be3b6a | |
| parent | 700c0ae8ae6753544f539c0ff42896d4ac263414 (diff) | |
| download | mariadb-git-5746cad9bde2d3dbfc01a9edb4ae0f19d2243a50.tar.gz | |
MDEV-27095 clean up spd_init_query.h
| -rw-r--r-- | storage/spider/spd_init_query.h | 64 |
1 files changed, 0 insertions, 64 deletions
diff --git a/storage/spider/spd_init_query.h b/storage/spider/spd_init_query.h index 727cfe9334e..5d9e53ada27 100644 --- a/storage/spider/spd_init_query.h +++ b/storage/spider/spd_init_query.h @@ -539,70 +539,6 @@ static LEX_STRING spider_init_queries[] = { " end if;" " end if;" /* - tables for ddl pushdown -*/ -/* - " if @server_name = 'MariaDB' and" - " (" - " @server_major_version > 11" - " )" - " then" - " create table if not exists mysql.spider_rewrite_tables(" - " table_id bigint unsigned not null auto_increment," - " db_name char(64) not null default ''," - " table_name char(64) not null default ''," - " primary key (table_id)," - " unique uk1(db_name, table_name)" - " ) engine=Aria transactional=1 default charset=utf8 collate=utf8_bin;" - " create table if not exists mysql.spider_rewrite_table_tables(" - " table_id bigint unsigned not null," - " partition_id bigint unsigned not null auto_increment," - " partition_method varchar(18) default ''," - " partition_expression varchar(64) default ''," - " subpartition_method varchar(12) default ''," - " subpartition_expression varchar(64) default ''," - " connection_str text not null default ''," - " comment_str text not null default ''," - " primary key (table_id, partition_id)," - " unique uk1(table_id, partition_method, partition_expression," - " subpartition_method, subpartition_expression)" - " ) engine=Aria transactional=1 default charset=utf8 collate=utf8_bin;" - " create table if not exists mysql.spider_rewrite_table_partitions(" - " table_id bigint unsigned not null," - " partition_id bigint unsigned not null," - " partition_ordinal_position bigint unsigned not null auto_increment," - " partition_name varchar(64) not null default ''," - " partition_description varchar(64) not null default ''," - " connection_str text not null default ''," - " comment_str text not null default ''," - " primary key (table_id, partition_id, partition_ordinal_position)," - " unique key uk1 (table_id, partition_id, partition_name)" - " ) engine=Aria transactional=1 default charset=utf8 collate=utf8_bin;" - " create table if not exists mysql.spider_rewrite_table_subpartitions(" - " table_id bigint unsigned not null," - " partition_id bigint unsigned not null," - " partition_ordinal_position bigint unsigned not null," - " subpartition_ordinal_position bigint unsigned not null" - " auto_increment," - " subpartition_name varchar(64) not null default ''," - " subpartition_description varchar(64) not null default ''," - " connection_str text not null default ''," - " comment_str text not null default ''," - " primary key (table_id, partition_id, partition_ordinal_position," - " subpartition_ordinal_position)," - " unique key uk1 (table_id, partition_id, partition_ordinal_position," - " subpartition_name)" - " ) engine=Aria transactional=1 default charset=utf8 collate=utf8_bin;" - " create table if not exists mysql.spider_rewritten_tables(" - " db_name char(64) not null," - " table_name char(64) not null," - " table_id bigint unsigned not null," - " partition_id bigint unsigned not null," - " primary key (db_name, table_name, table_id, partition_id)" - " ) engine=Aria transactional=1 default charset=utf8 collate=utf8_bin;" - " end if;" -*/ -/* Fix for version 3.4 */ " call mysql.spider_fix_one_table('spider_link_mon_servers', 'dsn'," |