Mariadb
MariaDB Spider Engine UDF spider_bg_direct_sql 找不到 TEMPORARY 表
我正在 MariaDB 中測試 Spider 引擎。在 mariadb-10.1.12-linux-x86_64 版本中，UDF 可以工作，但是有一些問題，所以我想升級到更新的版本。但是，mariadb-10.2.18-linux-x86_64,mariadb-10.3.12-linux-x86_64,mariadb-10.3.9-linux-x86_64,mariadb-10.4.1-linux-x86_64 Spider UDF
spider_bg_direct_sql找不到TEMPORARY表即使我可以在 UDF 之外選擇該臨時表。有誰知道如何解決這個問題？
CREATE TEMPORARY TABLE test.test1( `IMSI` VARCHAR(20) NOT NULL, `DATA_DATE` DATE NOT NULL, `PU_ID` MEDIUMINT(9) NOT NULL DEFAULT 0, `DATA_DATE_TS` INT(11) NOT NULL, `TECH_MASK` TINYINT(2) NOT NULL, PRIMARY KEY (`IMSI`,`DATA_DATE`,`PU_ID`,`DATA_DATE_TS`,`TECH_MASK`) ) SELECT * FROM test.test1 #this command can find a table SELECT spider_bg_direct_sql('select * from `gt_global_imsi`.`table_imsi_pu` ' , 'test.test1' , 'srv "PU1", port "3308"' )錯誤資訊
錯誤程式碼：12703
找不到臨時表“test.test1”
我的蜘蛛設置：
Variable_name Value spider_auto_increment_mode -1 spider_bgs_first_read -1 spider_bgs_mode -1 spider_bgs_second_read -1 spider_bka_engine spider_bka_mode -1 spider_bka_table_name_type -1 spider_block_size 16384 spider_bulk_size -1 spider_bulk_update_mode -1 spider_bulk_update_size -1 spider_casual_read -1 spider_conn_recycle_mode 0 spider_conn_recycle_strict 0 spider_conn_wait_timeout 10 spider_connect_error_interval 1 spider_connect_mutex OFF spider_connect_retry_count 1000 spider_connect_retry_interval 1000 spider_connect_timeout -1 spider_crd_bg_mode -1 spider_crd_interval -1 spider_crd_mode -1 spider_crd_sync -1 spider_crd_type -1 spider_crd_weight -1 spider_delete_all_rows_type -1 spider_direct_dup_insert -1 spider_direct_order_limit -1 spider_dry_access OFF spider_error_read_mode -1 spider_error_write_mode -1 spider_first_read -1 spider_force_commit 1 spider_general_log OFF spider_index_hint_pushdown OFF spider_init_sql_alloc_size -1 spider_internal_limit -1 spider_internal_offset -1 spider_internal_optimize -1 spider_internal_optimize_local -1 spider_internal_sql_log_off -1 spider_internal_unlock OFF spider_internal_xa OFF spider_internal_xa_id_type 0 spider_internal_xa_snapshot 0 spider_load_crd_at_startup -1 spider_load_sts_at_startup -1 spider_local_lock_table OFF spider_lock_exchange OFF spider_log_result_error_with_sql 0 spider_log_result_errors 0 spider_low_mem_read -1 spider_max_connections 0 spider_max_order -1 spider_multi_split_read -1 spider_net_read_timeout -1 spider_net_write_timeout -1 spider_ping_interval_at_trx_start 3600 spider_quick_mode -1 spider_quick_page_size -1 spider_read_only_mode -1 spider_remote_access_charset spider_remote_autocommit -1 spider_remote_default_database spider_remote_sql_log_off -1 spider_remote_time_zone spider_remote_trx_isolation -1 spider_reset_sql_alloc -1 spider_same_server_link OFF spider_second_read -1 spider_select_column_mode -1 spider_selupd_lock_mode -1 spider_semi_split_read -1 spider_semi_split_read_limit -1 spider_semi_table_lock 1 spider_semi_table_lock_connection -1 spider_semi_trx ON spider_semi_trx_isolation -1 spider_skip_default_condition -1 spider_skip_parallel_search -1 spider_split_read -1 spider_store_last_crd -1 spider_store_last_sts -1 spider_sts_bg_mode -1 spider_sts_interval -1 spider_sts_mode -1 spider_sts_sync -1 spider_support_xa ON spider_sync_autocommit ON spider_sync_trx_isolation ON spider_table_crd_thread_count 10 spider_table_init_error_interval 1 spider_table_sts_thread_count 10 spider_udf_ct_bulk_insert_interval -1 spider_udf_ct_bulk_insert_rows -1 spider_udf_ds_bulk_insert_rows -1 spider_udf_ds_table_loop_mode -1 spider_udf_ds_use_real_table -1 spider_udf_table_lock_mutex_count 20 spider_udf_table_mon_mutex_count 20 spider_use_all_conns_snapshot OFF spider_use_consistent_snapshot OFF spider_use_default_database ON spider_use_flash_logs OFF spider_use_handler -1 spider_use_pushdown_udf -1 spider_use_snapshot_with_flush_tables 0 spider_use_table_charset -1 spider_version 3.3.13 spider_xa_register_mode 1
CREATE TEMPORARY TABLE創建一個僅對一個連接可見的表。很可能，通過 UDF 會失去該上下文，從而不會讓您看到它。我建議創建一個永久表，可能具有可預測的表名（例如添加 pid）；但最終要堅持
DROP下去。
此錯誤已在 10.3.13 修復。