[MDEV-31721] Cursor protocol increases the counter of "Empty_queries" for select - Jira

XML

Word

Printable

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 11.0(EOL), 11.1(EOL), 11.2(EOL)
Fix Version/s: 10.5, 10.6
Component/s: None
Labels:
None

Testcase (run MTR test with --cursor-protocol):

create table t1 (a int);

insert into t1 values (1);

select count(*) from t1;

select * from t1;

select * from t1 limit 0;

show status like "Empty_queries";

drop table t1;

Expected result:

show status like "Empty_queries";

Variable_name	Value

Empty_queries	1

Actual result:

show status like "Empty_queries";

Variable_name	Value

Empty_queries	3

relates to

MDEV-31005 Make working ./mtr --cursor-protocol

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.