[#MDEV-2730] LP:802845 - Derived tables with LIMIT 0 return rows with mwl#106

[MDEV-2730] LP:802845 - Derived tables with LIMIT 0 return rows with mwl#106 Created: 2011-06-28 Updated: 2015-02-02 Resolved: 2012-10-04
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	None
Fix Version/s:	None

Type:

Bug

Priority:

Minor

Reporter:

Philip Stoev (Inactive)

Assignee:

Igor Babaev

Resolution:

Fixed

Votes:

Labels:

Launchpad

Attachments:

LPexportBug802845.xml

Description

Not repeatable with maria-5.3 before MWL#106. The following query:

SELECT * FROM (SELECT 0 LIMIT 0) AS alias1;

returns 1 row even though there is a LIMIT 0 clause.

Comments

Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 802845

Generated at Thu Feb 08 06:43:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.