polardb/polardbx-sql

View on GitHub

PolarDB-X is a cloud native distributed SQL Database designed for high concurrency, massive storage, complex querying scenarios.

Stars: 1.7k
Forks: 337
Open beginner issues: 0
Indexed issues: 108

Dominant language: Java
License: Apache-2.0
Last GitHub push: Sep 20, 2026
Latest indexed: Sep 20, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: good first issue
PR merge metrics: No merged PRs in 30d

Beginner friendly Everything

Open All

108 open issues indexed

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

Difficulty 4/5 3-5 days Newbie friendliness 45/100

polardb/polardbx-sql#297 · Opened Aug 19, 2026
Index on DOUBLE Column Causes Wrong Results with semijoin=off IN Subquery Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

polardb/polardbx-sql#296 · Opened Jul 15, 2026
Prefix Index Scan Returns Wrong Results for Unicode String Range Comparison Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

polardb/polardbx-sql#295 · Opened Jul 13, 2026
BITMAP Index Scan Returns Wrong Results for FLOAT Column with BETWEEN Operator Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

polardb/polardbx-sql#294 · Opened Jul 12, 2026
DECIMAL长度计算问题 Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

polardb/polardbx-sql#293 · Opened Jul 8, 2026
Equivalent view extraction retags signed `-1` as unsigned max across a view boundary Open

Difficulty 4/5 3-5 days Newbie friendliness 52/100

polardb/polardbx-sql#292 · Opened Jun 29, 2026
Equivalent view extraction rounds VAR_SAMP results Open

Difficulty 3/5 1-2 days Newbie friendliness 55/100

polardb/polardbx-sql#291 · Opened Jun 29, 2026
Equivalent view extraction retags UNION ALL integer payload as ENUM text Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

polardb/polardbx-sql#290 · Opened Jun 29, 2026
`WITH` + duplicated `GROUP BY` key leaks hidden `ORDER BY` column into the result set Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

polardb/polardbx-sql#289 · Opened Jun 29, 2026
Equivalent view extraction retags `UNION ALL` constant `1` as a `BIT(1)` byte Open

Difficulty 4/5 3-5 days Newbie friendliness 52/100

polardb/polardbx-sql#288 · Opened Jun 29, 2026
Extracting a `TINYBLOB` arm into a view re-encodes byte `0x80` during `UNION ALL` in `polardbx-sql` Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

polardb/polardbx-sql#287 · Opened Jun 29, 2026
CREATE VIEW over a TINYBLOB column reports `ERR_CONVERTOR` but it actually creates a usable view in `polardbx-sql` Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

polardb/polardbx-sql#286 · Opened Jun 29, 2026
`CAST('0000-00-00' AS DATE)` Has Inconsistent Semantics and Incorrectly Equals Every Non-`NULL` `SET` Value Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

polardb/polardbx-sql#285 · Opened May 23, 2026
`INSERT IGNORE` Invalid `DATE` Yields Context-Dependent `NULL` / `0000-00-00` Semantics Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

polardb/polardbx-sql#284 · Opened May 23, 2026
`VARCHAR IN (SELECT YEAR_col)` Produces Plan-Dependent Wrong Results on SINGLE Tables Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

polardb/polardbx-sql#283 · Opened May 22, 2026
Logic Error: TLP Test - COUNT(*) returns 100, while equivalent TLP-partitioned queries return 200 under RIGHT JOIN with LATERAL subqueries Open

Difficulty 4/5 3-5 days Newbie friendliness 43/100

polardb/polardbx-sql#282 · Opened May 14, 2026
Logic Error: Incorrect row count in PolarDB when using LATERAL derived table with DISTINCT and CASE Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

polardb/polardbx-sql#281 · Opened May 13, 2026
Logic Error: LEFT JOIN ON FALSE causes incorrect NULL comparison result in PolarDB Open

Difficulty 4/5 3-5 days Newbie friendliness 52/100

polardb/polardbx-sql#280 · Opened May 13, 2026
Logic Error: EXISTS subquery treated as constant TRUE yields different result than literal TRUE Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

polardb/polardbx-sql#279 · Opened May 13, 2026
Logic Error: DQE Test - Inconsistent behavior between SELECT and DELETE/UPDATE for the same predicate involving EXISTS and LEFT JOIN subqueries Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

polardb/polardbx-sql#278 · Opened May 13, 2026
Logic Error: DQE Test - Inconsistent row counts between SELECT and DELETE with the same EXISTS predicate involving a lateral subquery Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

polardb/polardbx-sql#277 · Opened May 13, 2026
Logic Error: TLP Test - COUNT(*) returns 20, while equivalent TLP-partitioned queries return 0 under RIGHT JOIN with LATERAL subqueries Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

polardb/polardbx-sql#276 · Opened May 13, 2026
Logic Error: TLP Test - COUNT(*) on orders returns 5, but equivalent TLP-style with complex NULLIF and CASE expressions return 10 Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

polardb/polardbx-sql#275 · Opened May 13, 2026
PolarDB crashes (Docker container exits) when executing a complex SQL query with nested JOINs, LATERAL subqueries, and EXIST Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

polardb/polardbx-sql#274 · Opened May 13, 2026
Logic Error: NoREC Test - COUNT(*) and SUM(CASE WHEN ...) return inconsistent results with string-length expression and NULL-sensitive Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

polardb/polardbx-sql#273 · Opened May 13, 2026
Logic Error: NoREC Test - COUNT(*) vs SUM(CASE...) produces inconsistent results with RIGHT JOIN + LEFT JOIN Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

polardb/polardbx-sql#272 · Opened May 13, 2026
Logic Error: semantically equivalent scalar expressions yield different result sets in WHERE clause involving RPAD() Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

polardb/polardbx-sql#271 · Opened May 13, 2026
Polardb crashes when executing a complex SQL query containing LATERAL subqueries and REGEXP_INSTR Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

polardb/polardbx-sql#270 · 1 comment · Opened May 13, 2026
Equivalent SQL changes datetime payload from zero value to runtime date after view extraction Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

polardb/polardbx-sql#269 · Opened May 13, 2026
Equivalent SQL returns fewer rows after view extraction Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

polardb/polardbx-sql#268 · Opened May 13, 2026
kylinuxv10 arm 环境下，单机部署失败 Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

polardb/polardbx-sql#267 · 1 comment · Opened Mar 12, 2026
docker部署导入数据占用大量内存，内存不释放 Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

polardb/polardbx-sql#266 · Opened Mar 6, 2026
使用polardbx-connector-java 连接失败 Open

Difficulty 4/5 3-5 days Newbie friendliness 20/100

polardb/polardbx-sql#265 · Opened Mar 4, 2026
[优化建议] PolarDB 增加国密算法（SM3/SM4）支持 Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

polardb/polardbx-sql#264 · 1 reaction · Opened Mar 4, 2026
:after changing MAX to -MIN(-),col_1'svalue unexpectedly changes from 127 to 2009. Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

polardb/polardbx-sql#263 · Opened Jan 27, 2026
after changing FLOOR(pmy83.c3) to FLOOR(FLOOR(pmy83.c3)) in group clause,the col_1's value floating-precision unexpectedly change Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

polardb/polardbx-sql#262 · Opened Jan 20, 2026
after changing SUM(cte.col_2) to -SUM(-cte.col_2),the column value unexpectedly change. Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

polardb/polardbx-sql#261 · Opened Jan 20, 2026
after changing DAY function,the value unexpectedly become null Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

polardb/polardbx-sql#260 · 1 comment · Opened Jan 18, 2026
floating-precision loss happen after changing AVG(x) to -AVG(-x) Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

polardb/polardbx-sql#259 · Opened Jan 18, 2026
after changing YEAR function ,col_2's value unexpectedly become NULL Open

Difficulty 4/5 3-5 days Newbie friendliness 32/100

polardb/polardbx-sql#258 · 1 comment · Opened Jan 18, 2026
after changing AVG(s974.c4) to -AVG(-s974.c4),rows unexpectedly become less Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

polardb/polardbx-sql#257 · 1 comment · Opened Jan 18, 2026
after adding UNION clause ,value unexpectedly change Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

polardb/polardbx-sql#256 · 2 comments · Opened Nov 25, 2025
unexpected value change caused by changing count(x) to count(x)+3 Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

polardb/polardbx-sql#255 · 1 comment · Opened Nov 25, 2025
an error unexpectedly appear after changing avg(x) to avg(x)+5 Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

polardb/polardbx-sql#254 · 1 comment · Opened Nov 25, 2025
string value change after removing except clause Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

polardb/polardbx-sql#253 · Opened Nov 20, 2025
blob value change after removing Except clause Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

polardb/polardbx-sql#252 · Opened Nov 19, 2025
an convertor error disappear because of an empty set Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

polardb/polardbx-sql#251 · Opened Nov 19, 2025
column value unexpectedly change after removing except Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

polardb/polardbx-sql#250 · Opened Nov 19, 2025
an error appear after removing except clause Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

polardb/polardbx-sql#249 · Opened Nov 19, 2025
column type change caused by distinct Open

bug

Difficulty 4/5 3-5 days Newbie friendliness 42/100

polardb/polardbx-sql#248 · Opened Nov 14, 2025

polardb/polardbx-sql

Get new issues in your inbox