Details
-
Bug
-
Status: In Review (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 13.0, 13.1
Description
Use the CLI to see the full oput:
CREATE TABLE t (c DECIMAL(8,3)) ENGINE=InnoDB; # Or ENGINE=Aria |
INSERT INTO t VALUES(NULL); |
UPDATE t SET c=DEFAULT; |
The last statement succeeds for both engines. However, with InnoDB we see "affected=0" whereas with Aria we see "affected=1" and a longer processing time (it is possible that with other testcases a data difference could be introduced):
Leads to (using InnoDB):
|
CS 13.1.0 da18481158c81ca94689702073c3e04aad85a6a3 (Optimized, Clang 22.1.8-20260622) Build 18/08/2026 [InnoDB] |
13.1.0-dbg>UPDATE t SET c=DEFAULT;
|
Query OK, 0 rows affected (0.001 sec)
|
Rows matched: 1 Changed: 0 Warnings: 0
|
Leads to (using Aria):
|
CS 13.1.0 da18481158c81ca94689702073c3e04aad85a6a3 (Optimized, Clang 22.1.8-20260622) Build 18/08/2026 [Aria] |
13.1.0-dbg>UPDATE t SET c=DEFAULT;
|
Query OK, 1 row affected (0.020 sec)
|
Rows matched: 1 Changed: 1 Warnings: 0
|
|
Bug Detection Matrix |
Rel o/d Build Commit Diff observed
|
ES 10.6 dbg 180826 fcecb2620f25965723d640decede7c018bcb1dcc DIFF: AFFECTED ROWS
|
ES 10.6 opt 180826 fcecb2620f25965723d640decede7c018bcb1dcc DIFF: AFFECTED ROWS
|
ES 11.4 dbg 180826 3b34189bfe675c18c4ced3ef531d016ea74c76f4 DIFF: AFFECTED ROWS
|
ES 11.4 opt 180826 3b34189bfe675c18c4ced3ef531d016ea74c76f4 DIFF: AFFECTED ROWS
|
ES 11.8 dbg 180826 4694e931d10fecf733c34f83ea2146d31b708eb3 DIFF: AFFECTED ROWS
|
ES 11.8 opt 180826 4694e931d10fecf733c34f83ea2146d31b708eb3 DIFF: AFFECTED ROWS
|
ES 12.3 dbg 180826 f513f503feacabfb219d4a6f965b5f72b86d4db0 DIFF: AFFECTED ROWS
|
ES 12.3 opt 180826 f513f503feacabfb219d4a6f965b5f72b86d4db0 DIFF: AFFECTED ROWS
|
CS 10.11 dbg 180826 8f00e6caca633c783140db86d3a48a96de67cf38 DIFF: AFFECTED ROWS
|
CS 10.11 opt 180826 8f00e6caca633c783140db86d3a48a96de67cf38 DIFF: AFFECTED ROWS
|
CS 11.4 dbg 180826 1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc DIFF: AFFECTED ROWS
|
CS 11.4 opt 180826 1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc DIFF: AFFECTED ROWS
|
CS 11.8 dbg 180826 d26f9ab217a7fcf9d4eccc62c01020ff275ff42e DIFF: AFFECTED ROWS
|
CS 11.8 opt 180826 d26f9ab217a7fcf9d4eccc62c01020ff275ff42e DIFF: AFFECTED ROWS
|
CS 12.3 dbg 180826 add63991988734383c5e942de2a19c6c45f511f7 DIFF: AFFECTED ROWS
|
CS 12.3 opt 180826 add63991988734383c5e942de2a19c6c45f511f7 DIFF: AFFECTED ROWS
|
CS 13.0 dbg 180826 a848493c6fe031f23606144420c1ca1e467cbd81 DIFF: AFFECTED ROWS
|
CS 13.0 opt 180826 a848493c6fe031f23606144420c1ca1e467cbd81 DIFF: AFFECTED ROWS
|
CS 13.1 dbg 180826 da18481158c81ca94689702073c3e04aad85a6a3 DIFF: AFFECTED ROWS
|
CS 13.1 opt 180826 da18481158c81ca94689702073c3e04aad85a6a3 DIFF: AFFECTED ROWS
|
