I am getting a bug in spider. All session variables declared inside MYSQL_THDVAR_INT{} are not accepting signed values. Default value -1 is converting to max signed integer value.
(root@localhost) Thu Jul 7 02:21:06 2011 [xs_midas]>show variables like "%spider%";
+---------------------------------------+----------------------+
| Variable_name | Value |
+---------------------------------------+----------------------+
| spider_auto_increment_mode | 4294967295 |
| spider_bgs_first_read | 18446744073709551615 |
| spider_bgs_mode | 4294967295 |
| spider_bgs_second_read | 18446744073709551615 |
| spider_bka_engine | |
| spider_bka_mode | 4294967295 |
| spider_block_size | 16384 |
| spider_bulk_size | 4294967295 |
| spider_bulk_update_mode | 4294967295 |
| spider_bulk_update_size | 4294967295 |
| spider_conn_recycle_mode | 0 |
| spider_conn_recycle_strict | 0 |
| spider_connect_mutex | OFF |
| spider_connect_retry_count | 1000 |
| spider_connect_retry_interval | 1000 |
| spider_crd_bg_mode | 4294967295 |
| spider_crd_interval | 4294967295 |
| spider_crd_mode | 4294967295 |
| spider_crd_sync | 4294967295 |
| spider_crd_type | 4294967295 |
| spider_crd_weight | 4294967295 |
| spider_direct_dup_insert | 4294967295 |
| spider_direct_order_limit | 18446744073709551615 |
| spider_force_commit | 0 |
| spider_hs_r_conn_recycle_mode | 2 |
| spider_hs_r_conn_recycle_strict | 0 |
| spider_hs_w_conn_recycle_mode | 2 |
| spider_hs_w_conn_recycle_strict | 0 |
| spider_init_sql_alloc_size | 4294967295 |
| spider_internal_limit | 18446744073709551615 |
| spider_internal_offset | 18446744073709551615 |
| spider_internal_optimize | 4294967295 |
| spider_internal_optimize_local | 4294967295 |
| spider_internal_sql_log_off | ON |
| spider_internal_unlock | OFF |
| spider_internal_xa | OFF |
| spider_internal_xa_snapshot | 0 |
| spider_local_lock_table | OFF |
| spider_lock_exchange | OFF |
| spider_low_mem_read | 4294967295 |
| spider_max_order | 4294967295 |
| spider_multi_split_read | 4294967295 |
| spider_net_timeout | 4294967295 |
| spider_ping_interval_at_trx_start | 3600 |
| spider_quick_mode | 4294967295 |
| spider_quick_page_size | 18446744073709551615 |
| spider_remote_access_charset | |
| spider_remote_autocommit | 4294967295 |
| spider_remote_sql_log_off | 4294967295 |
| spider_remote_trx_isolation | 4294967295 |
| spider_reset_sql_alloc | 4294967295 |
| spider_same_server_link | OFF |
| spider_select_column_mode | 4294967295 |
| spider_selupd_lock_mode | 4294967295 |
| spider_semi_split_read | 4294967295 |
| spider_semi_split_read_limit | 18446744073709551615 |
| spider_semi_table_lock | 1 |
| spider_semi_table_lock_connection | 4294967295 |
| spider_semi_trx | ON |
| spider_semi_trx_isolation | 4294967295 |
| spider_skip_default_condition | 4294967295 |
| spider_split_read | 18446744073709551615 |
| spider_sts_bg_mode | 4294967295 |
| spider_sts_interval | 4294967295 |
| spider_sts_mode | 4294967295 |
| spider_sts_sync | 4294967295 |
| spider_support_xa | ON |
| spider_sync_autocommit | ON |
| spider_sync_trx_isolation | ON |
| spider_table_init_error_interval | 1 |
| spider_udf_ct_bulk_insert_interval | 4294967295 |
| spider_udf_ct_bulk_insert_rows | 18446744073709551615 |
| spider_udf_ds_bulk_insert_rows | 18446744073709551615 |
| spider_udf_ds_table_loop_mode | 4294967295 |
| 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_flash_logs | OFF |
| spider_use_handler | 4294967295 |
| spider_use_hs_read | 4294967295 |
| spider_use_hs_write | 4294967295 |
| spider_use_pushdown_udf | 4294967295 |
| spider_use_snapshot_with_flush_tables | 0 |
| spider_use_table_charset | 4294967295 |
+---------------------------------------+----------------------+
85 rows in set (0.00 sec)
Its setting session variable value @@spider_bgs_mode = -1 to 4294967295.
Its setting session variable value @@spider_bgs_mode = 0 to 0.
So I feel some issue with mysql signed integer type.
Can somebody help me sorting out this issue.
Thanks.
Fixed at Spider 2.6's binary.
http://