• G
    New features · bacd5fac
    guangshu.wgs 提交于
    1. Support for multiple-cluster Proxyro passwords
    2. Support for rich client capabilities
    3. Support for specifying Server IP routing
    4. Support for the Latin1 character set
    5. Support for transparently passing connection attributes with special prefixes
    6. Support for distributed transaction routing
    7. Support for MySQL binlog
    8. Support for read-write separation and transaction splitting
    9. Support for mapping VIPs to Cluster/Tenant through means other than MetaDB
    10. Support for global-level weak-read and read-only configuration parameters
    11. Support for GIS, JSON data types
    12. Support for IPv6
    13. Support for accurately routing access to the sys tenant OceanBase library in QA Mode
    14. Support for ROWID routing under PS
    15. Support for multi-column partition key routing
    16. Support for obtaining column default value routing
    17. Support for calculating expressions such as nvl, sysdate, mod,  to_char, and substr
    18. Support for is null and is not null routing
    19. Support for XA Start statement hold
    20. 【OB Sharding】Support for rolling upgrades
    21. 【OB Sharding】Support for SHOW TOPOLOGY syntax
    22. 【OB Sharding】Added hint support for session stickiness: route to the previous non-scan-all statement shard
    23. 【OB Sharding】Support for information_schema.partitions and information_schema.coulmns
    24. 【OB Sharding】Support for SQL-level timeout control
    25. 【OB Sharding】Single-shard support for SQL syntax: batch update, batch delete, batch insert
    
    Improvements
    1. RTO optimization, less than 8S
    2. OB 2.0 protocol optimization, reducing synchronous statements
    3. OBProxy actively disconnects and sends Error packets to the client
    4. Supports global-level PS cache
    5. client_sock_option_flag_out default value is changed from 2 to 3
    6. obproxy_error.log will print OBServer TraceId
    7. Memory optimization, including connection memory and PS memory
    8. RTO probe optimization, considering it normal when receiving Handshake packets
    9. The default character encoding in HandShake packets is changed to 46
    10. New enable_binlog_service configuration item, default false, indicating whether to enable binlog function
    11. 【OB Sharding】Log optimization
    12. 【OB Sharding】insert/update/delete statements support multi-table syntax
    13. 【OB Sharding】scan_all optimization
    14. 【OB Sharding】Black screen DDL optimization
    
    Bug fixes
    1. Fixed Core issue when accessing partitioned tables with RowID
    2. Fixed issue where deleting text ps under Client 2.0 protocol does not return anything
    3. Fixed issue where executing text ps under Client 2.0 protocol, then executing sql normally causes "requestId mismatch" error
    4. Fixed issue where erroneous format of err packet in internal SQL causes client to hang
    5. Fixed issue where enabling v2 protocol causes "4016" error and disconnection
    6. Fixed issue where enabling "enable_ob_protocol_v2_with_client=true" causes disconnection during secondary sql routing
    7. Fixed issue where connection id mismatch causes proxy disconnection
    8. Fixed issue where enabling compression protocol causes disconnection
    9. Fixed issue where using COM_CHANGE_USER command with username not in user_name@tenant_name format causes inability to use
    10. Fixed issue where date type is inaccurately routed in certain scenarios
    11. Fixed Core issue caused by abnormal to_timestamp parameter
    12. Fixed Core issue caused by executing anonymous blocks in ODC
    13. Fixed remote routing issue with to_date function
    14. Fixed routing inaccuracy issue with timestamp with local time zone type list partitioning under Oracle mode
    15. Fixed Core issue caused by some keywords not having pointers set
    16. Fixed issue where detection optimization causes inability to whiteness
    17. Fixed issue where SSL configuration retrieval fails
    18. Fixed issue where enabling CPU resource isolation on public cloud causes inability to connect to cluster
    19. Fixed issue where using int form for vid configuration does not take effect
    20. Fixed issue with substr() causing index out of bounds
    21. Fixed partition calculation error with range partitioning under "where c1 >20" condition
    22. Fixed issue where type conversion fails and causes inability to route when there are NULL values in list and list column partitioning
    23. Fixed Core issue introduced by global PS
    24. Fixed issue where autocommit flag in OK packet returned by set autocommit=0 is still 1
    25. Fixed issue where some fields in RespResult are not initialized in constructor, causing abnormal disconnection when used
    26. Fixed issue where XA_START hold&sync PS 2-in-1 protocol supports complex parameter types
    27. Fixed issue where XA_START hold&sync synchronous process cannot accept multiple OB20 packets
    28. Fixed obproxy Core issue at oceanbase::obproxy::proxy::ObProxyExprCalculator::calc_partition_id_with_rowid_str
    29. Fixed obproxy Core issue at oceanbase::obproxy::proxy::ObProto20Utils::analyze_compressed_packet_header
    30. Fixed obproxy Core issue where old database saved in proxy session is used, causing obproxy core at oceanbase::common::ObLogger::log_message_kv
    31. Fixed obproxy Core dump at oceanbase::obproxy::proxy::ObMysqlSM::setup_error_transfer
    32. Fixed obproxy binary Core dump at obproxy/obutils/ob_proxy_sql_parser.cpp:890
    33. Fixed obproxy Core dump at oceanbase::obproxy::proxy::ObMysqlSM::tunnel_handler_response_transfered
    34. Fixed Core issue with oceanbase::obproxy::proxy::ObMysqlTransact::is_internal_request
    35. Fixed odp Core issue with expression mod() calculation at oceanbase::obproxy::opsql::ObProxyExprMod::calc
    36. Fixed obproxy Core issue at oceanbase::obproxy::proxy::ObMysqlVCTable::cleanup_entry
    37. Fixed obproxy Core issue at oceanbase::obproxy::proxy::ObMysqlTransact::is_internal_request
    38. Fixed Core issue at oceanbase::obproxy::proxy::ObProxyPartMgr::get_first_part at obproxy/proxy/route/obproxy_part_mgr.cpp
    39. Fixed obproxy core issue at ObCongestionEntry::to_string in obproxy/obutils/ob_congestion_entry.cpp
    40. Fixed a disconnect issue when executing insert statement with "binary" keyword in the "values" clause in OB Sharding
    41. Fixed an issue in OB Sharding where the "case when" condition in the "where" clause is incorrectly identified as a sharding parameter
    42. Fixed a core issue in OB Sharding when using unsupported expressions in the "order by" or "group by" clause
    bacd5fac
.secignore 5.7 KB