Bug #11095 show warnings limit 0 returns all rows instead of zero rows

• Submitted: 4 Jun 2005 10:55
• Modified: 8 Jun 2005 20:44
• Reporter: Konstantin Osipov (OCA)
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1
• OS: Linux (SuSE 9.1)
• Assigned to: Konstantin Osipov
• CPU Architecture: Any

[4 Jun 2005 10:55] Konstantin Osipov

Description:
show warnings limit 0 returns all rows instead of zero rows
See how to repeat.

How to repeat:
create table t1 (a int);
insert into t1 (a) values (1), (2);
update t1 set a='abc'; -- to generate warnings
show warnings limit 0;

[4 Jun 2005 10:56] Konstantin Osipov

Subject: bk commit - 4.1 tree (konstantin:1.2312)
ChangeSet
  1.2312 05/06/04 14:18:08 [e-mail] +3 -0
  Fix show warnings limit 0 and show warnings limit 0, 0.
  Add test coverage for SHOW WARNINGS LIMIT a, b;

Fidex in 4.1 tree currently marked 4.1.13

[8 Jun 2005 20:44] Paul DuBois

Noted in 4.1.13 changelog.