1. 22 3月, 2023 1 次提交
    • 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
  2. 04 3月, 2022 1 次提交
  3. 31 5月, 2021 1 次提交