I wonder why this non-standard SQL syntax needs to be added. The example provided:

SELECT COUNT(*) FROM test LIMIT ROWS MATCHED 3;

can easily be produced with existing syntax:

SELECT COUNT(*) FROM (SELECT 1 FROM test LIMIT 3) AS t;

I can't imagine any query that this syntax will solve better that the existing ones.

Pantelis Theodosiou

On Fri, May 16, 2014 at 12:11 PM, Colin Charles <colin@mariadb.org> wrote:

Hi!

http://seonguck.blogspot.kr/2014/05/limit-rows-matched.html

We have a potential contribution here for a LIMIT ROWS MATCHED feature - might be interesting for us to consider this for 10.1 ?

cheers,
-colin

--
Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company
blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp