maria-developers team mailing list archive

[Pantelis Theodosiou <ypercube@xxxxxxxxx>]

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@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp
>