Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
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