Search results

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

Status: Open.

#281 In polardb/polardbx-sql;

· Jasper0209 opened on May 13, 2026

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

Status: Open.

#280 In polardb/polardbx-sql;

· Jasper0209 opened on May 13, 2026

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

Status: Open.

#279 In polardb/polardbx-sql;

· 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

Status: Open.

#278 In polardb/polardbx-sql;

· 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

Status: Open.

#277 In polardb/polardbx-sql;

· 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

Status: Open.

#276 In polardb/polardbx-sql;

· 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

Status: Open.

#275 In polardb/polardbx-sql;

· Jasper0209 opened on May 13, 2026

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

Status: Open.

#274 In polardb/polardbx-sql;

· 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

Status: Open.

#273 In polardb/polardbx-sql;

· Jasper0209 opened on May 13, 2026

Logic Error: NoREC Test - COUNT(*) vs SUM(CASE...) produces inconsistent results with RIGHT JOIN + LEFT JOIN

Status: Open.

#272 In polardb/polardbx-sql;

· Jasper0209 opened on May 13, 2026

Logic Error: semantically equivalent scalar expressions yield different result sets in WHERE clause involving RPAD()

Status: Open.

#271 In polardb/polardbx-sql;

· Jasper0209 opened on May 13, 2026

Polardb crashes when executing a complex SQL query containing LATERAL subqueries and REGEXP_INSTR

Status: Open.

#270 In polardb/polardbx-sql;

· Jasper0209 opened on May 13, 2026