|
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.
|