Issues

• [Bug]: CAST of DATE/TIME/DATETIME/TIMESTAMP/YEAR/JSON to DECIMAL(p>38) fails (works for p<=38)

  kind/bug
  matrixorigin/matrixone#31577 · Filter by author MatrixAdventurer opened on Oct 28, 2026

• [Bug]: CAST(json AS DATE/TIME/DATETIME/TIMESTAMP) is rejected

  kind/bug
  matrixorigin/matrixone#31576 · Filter by author MatrixAdventurer opened on Oct 28, 2026

• [Bug]: expr +/- INTERVAL fails for CHAR/TEXT/BLOB operands and prepared parameters (DATE_ADD/DATE_SUB accept them)

  kind/bug
  matrixorigin/matrixone#31575 · Filter by author MatrixAdventurer opened on Oct 28, 2026

• [Bug]: Sinker pipelineSubmit never cancels its derived context on success, leaking one cancelCtx per flush

  kind/bugseverity/s2
  matrixorigin/matrixone#31570 · Filter by author iamlinjunhong opened on Oct 28, 2026
  

• [Bug]: a rejected mpool allocation permanently raises HighWaterMark above the pool cap

  kind/bugseverity/s2
  matrixorigin/matrixone#31569 · Filter by author iamlinjunhong opened on Oct 28, 2026
  

• [Bug]: correlated EXISTS and NOT EXISTS on ENUM/SET keys fail column remapping

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31568 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  

• [Bug]: SET columns with different member orders compare raw bitmaps and persist wrong JOIN results

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31567 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  

• [Compatibility]: Named WINDOW clause is unsupported — SELECT ... WINDOW w AS (...) fails with syntax error 1064

  area/compatibilitykind/bug
  matrixorigin/matrixone#31565 · Filter by author Ariznawlll opened on Oct 28, 2026
  

• [Compatibility]: HOUR/MINUTE/SECOND reject bare TIME strings ('parse timestamp' error) while sibling MICROSECOND accepts them

  area/compatibilitykind/bug
  matrixorigin/matrixone#31564 · Filter by author Ariznawlll opened on Oct 28, 2026
  

• [Compatibility]: BINARY prefix operator rejects general expressions (BINARY CAST(...) / BINARY (expr) -> syntax error 1064)

  area/compatibilitykind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31563 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  

• [Compatibility]: Unaliased GROUP_CONCAT column header always shows "separator ," — MySQL returns plain GROUP_CONCAT(col)

  area/compatibilitykind/bug
  matrixorigin/matrixone#31562 · Filter by author Ariznawlll opened on Oct 28, 2026
  

• [Bug]: three-level correlated NOT EXISTS takes 13–24 seconds on 705 rows

  kind/bugkind/performanceneeds-triage
  Bug

  matrixorigin/matrixone#31561 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  

• [Bug]: SET PERSIST/PERSIST_ONLY and RESET PERSIST are parser-rejected

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31558 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  

• [Bug]: BIGINT / 3 loses precision while DIV returns correct quotient

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31556 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  

• [Bug]: MAKE_SET accepts a negative bits argument instead of NULL

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31555 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  

• [Bug]: saved DATA BRANCH DIFF corrupts TIMESTAMP precision and timezone

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31550 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  

• [Bug]: Recursive CTE freezes VARCHAR computed column at anchor value

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31549 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  2

  

• [Compatibility]: Window functions are accepted in non-standard positions (HAVING, DELETE..IN subquery) where MySQL rejects the statement

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31548 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  

• [Bug]: saving DATA BRANCH DIFF with DATETIME crashes the service

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31547 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  1

  

• [Bug]: race CI TestShowTableStatusWithIndexes cleanup DROP DATABASE times out

  kind/bugneeds-triage
  matrixorigin/matrixone#31545 · Filter by author iamlinjunhong opened on Oct 28, 2026
  

• [Bug]: IFNULL() and IF() error out (20203) whenever an argument is json_extract(), even when the result is not NULL

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31544 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  

• [Bug]: ddl_atomicity DROP DATABASE fails with rolling-restart error during injected logtail reconnect on 4.2-dev

  kind/bugneeds-triage
  matrixorigin/matrixone#31542 · Filter by author ck89119 opened on Oct 28, 2026
  

• [Bug]: ALTER USER u'@'%' silently rewrites u@localhost's password

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31541 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  

• [Bug]: INSERT/UPDATE/DELETE RETURNING fails with admission error

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31540 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610
  1

  

• [Bug]: TIME/DATE compares with bare literals drop coercion

  kind/bugneeds-triage
  Bug

  matrixorigin/matrixone#31539 · Filter by author Ariznawlll opened on Oct 28, 2026 · MO-202610