Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: N/A
-
Fix Version/s: 10.7.1
-
Component/s: Data Manipulation - Insert, Server
-
Labels:None
Description
create or replace table t (a int, check(a>0)); |
insert ignore into t values (1),(0),(2),(0); |
get diagnostics condition 1 @n= row_number;
|
select @n; |
get diagnostics condition 2 @n= row_number;
|
select @n; |
|
# Cleanup
|
drop table t; |
bb-10.7-row_number cb9002bee |
MariaDB [test]> get diagnostics condition 1 @n= row_number;
|
Query OK, 0 rows affected (0.000 sec) |
|
MariaDB [test]> select @n; |
+------+ |
| @n |
|
+------+ |
| 2 |
|
+------+ |
1 row in set (0.000 sec) |
|
MariaDB [test]> get diagnostics condition 2 @n= row_number;
|
Query OK, 0 rows affected (0.000 sec) |
|
MariaDB [test]> select @n; |
+------+ |
| @n |
|
+------+ |
| 3 |
|
+------+ |
1 row in set (0.000 sec) |
The second one is wrong, the expected result is 4.
Attachments
Issue Links
- is caused by
-
MDEV-10075 Provide index of error causing error in array INSERT
-
- Closed
-