Issues

• CREATE VIEW over an ENUM column returns PXC-4700 but still commits a usable view

  polardb/polardbx-sql#297 · Filter by author 123lpygithub opened on Aug 19, 2026

• Index on DOUBLE Column Causes Wrong Results with semijoin=off IN Subquery

  polardb/polardbx-sql#296 · Filter by author ZyanNo1 opened on Jul 15, 2026

• Prefix Index Scan Returns Wrong Results for Unicode String Range Comparison

  polardb/polardbx-sql#295 · Filter by author ZyanNo1 opened on Jul 13, 2026

• BITMAP Index Scan Returns Wrong Results for FLOAT Column with BETWEEN Operator

  polardb/polardbx-sql#294 · Filter by author ZyanNo1 opened on Jul 12, 2026

• DECIMAL长度计算问题

  polardb/polardbx-sql#293 · Filter by author Rgsygfh opened on Jul 8, 2026

• Equivalent view extraction retags signed -1 as unsigned max across a view boundary

  polardb/polardbx-sql#292 · Filter by author 123lpygithub opened on Jun 29, 2026

• Equivalent view extraction rounds VAR_SAMP results

  polardb/polardbx-sql#291 · Filter by author 123lpygithub opened on Jun 29, 2026

• Equivalent view extraction retags UNION ALL integer payload as ENUM text

  polardb/polardbx-sql#290 · Filter by author 123lpygithub opened on Jun 29, 2026

• WITH + duplicated GROUP BY key leaks hidden ORDER BY column into the result set

  polardb/polardbx-sql#289 · Filter by author 123lpygithub opened on Jun 29, 2026

• Equivalent view extraction retags UNION ALL constant 1 as a BIT(1) byte

  polardb/polardbx-sql#288 · Filter by author 123lpygithub opened on Jun 29, 2026

• Extracting a TINYBLOB arm into a view re-encodes byte 0x80 during UNION ALL in polardbx-sql

  polardb/polardbx-sql#287 · Filter by author 123lpygithub opened on Jun 29, 2026

• CREATE VIEW over a TINYBLOB column reports ERR_CONVERTOR but it actually creates a usable view in polardbx-sql

  polardb/polardbx-sql#286 · Filter by author 123lpygithub opened on Jun 29, 2026

• CAST('0000-00-00' AS DATE) Has Inconsistent Semantics and Incorrectly Equals Every Non-NULL SET Value

  polardb/polardbx-sql#285 · Filter by author fyr03 opened on May 23, 2026

• INSERT IGNORE Invalid DATE Yields Context-Dependent NULL / 0000-00-00 Semantics

  polardb/polardbx-sql#284 · Filter by author fyr03 opened on May 23, 2026

• VARCHAR IN (SELECT YEAR_col) Produces Plan-Dependent Wrong Results on SINGLE Tables

  polardb/polardbx-sql#283 · Filter by author fyr03 opened on May 22, 2026

• Logic Error: TLP Test - COUNT(*) returns 100, while equivalent TLP-partitioned queries return 200 under RIGHT JOIN with LATERAL subqueries

  polardb/polardbx-sql#282 · Filter by author Jasper0209 opened on May 14, 2026

• Logic Error: Incorrect row count in PolarDB when using LATERAL derived table with DISTINCT and CASE

  polardb/polardbx-sql#281 · Filter by author Jasper0209 opened on May 13, 2026

• Logic Error: LEFT JOIN ON FALSE causes incorrect NULL comparison result in PolarDB

  polardb/polardbx-sql#280 · Filter by author Jasper0209 opened on May 13, 2026

• Logic Error: EXISTS subquery treated as constant TRUE yields different result than literal TRUE

  polardb/polardbx-sql#279 · Filter by author Jasper0209 opened on May 13, 2026

• Logic Error: DQE Test - Inconsistent behavior between SELECT and DELETE/UPDATE for the same predicate involving EXISTS and LEFT JOIN subqueries

  polardb/polardbx-sql#278 · Filter by author Jasper0209 opened on May 13, 2026

• Logic Error: DQE Test - Inconsistent row counts between SELECT and DELETE with the same EXISTS predicate involving a lateral subquery

  polardb/polardbx-sql#277 · Filter by author Jasper0209 opened on May 13, 2026

• Logic Error: TLP Test - COUNT(*) returns 20, while equivalent TLP-partitioned queries return 0 under RIGHT JOIN with LATERAL subqueries

  polardb/polardbx-sql#276 · Filter by author Jasper0209 opened on May 13, 2026

• Logic Error: TLP Test - COUNT(*) on orders returns 5, but equivalent TLP-style with complex NULLIF and CASE expressions return 10

  polardb/polardbx-sql#275 · Filter by author Jasper0209 opened on May 13, 2026

• PolarDB crashes (Docker container exits) when executing a complex SQL query with nested JOINs, LATERAL subqueries, and EXIST

  polardb/polardbx-sql#274 · Filter by author Jasper0209 opened on May 13, 2026

• Logic Error: NoREC Test - COUNT(*) and SUM(CASE WHEN ...) return inconsistent results with string-length expression and NULL-sensitive

  polardb/polardbx-sql#273 · Filter by author Jasper0209 opened on May 13, 2026