Details
-
Bug
-
Status: Open (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.4, 11.5(EOL)
-
None
Description
set @userstat.save= @@userstat; |
set global userstat= 1; |
|
create temporary table t (a int primary key); |
|
flush user_statistics, table_statistics;
|
insert into t values (1),(2); |
update t set a = 10 where a = 1; |
select rows_inserted, rows_updated from information_schema.user_statistics where user = 'root'; |
select table_name, rows_changed from information_schema.table_statistics where table_schema = 'test'; |
|
# Cleanup
|
set global userstat= @userstat.save; |
10.4 ee59ca7ff1620dd74b9bc1449878c5d1acee0f53 |
insert into t values (1),(2); |
update t set a = 10 where a = 1; |
select rows_inserted, rows_updated from information_schema.user_statistics where user = 'root'; |
rows_inserted rows_updated
|
2 1
|
select table_name, rows_changed from information_schema.table_statistics where table_schema = 'test'; |
table_name rows_changed
|
set global userstat= @userstat.save; |