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) Email Updates:
Status: Closed Impact on me:
None 
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 konstantin@mysql.com +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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.057 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.