Date: 2015-11-10 18:12:13 +0100
From: Kevin Boulain <<kevin.boulain>>
To: SQL devs <>
Version: 11.21.5 (Jul2015)
CC: @njnes

Last updated: 2016-01-15 11:37:52 +0100

Comment 21499

Date: 2015-11-10 18:12:13 +0100
From: Kevin Boulain <<kevin.boulain>>

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:39.0) Gecko/20100101 Firefox/39.0
Build Identifier:

Using an unusual large LIMIT on a SELECT may abort the query.

Reproducible: Always

Steps to Reproduce:

On the mclient:

1. sql>create table test (x int);
2. sql>select * from test limit 1000000000000000000000000000000000000000;

Actual Results:

GDK reported error.
CMDslice: argument out of range

Expected Results:

+---+
| x |
+===+
+---+
0 tuples (1.693ms)

Note that the select should be done on a table (even empty as shown above), this simpler query won't trigger the problem since the LIMIT seems to be optimised out:
sql>select 1 limit 1000000000000000000000000000000000000000;
+--------------+
| single_value |
+==============+
| 1 |
+--------------+
1 tuple (0.329ms)

Comment 21513

Date: 2015-11-11 11:08:25 +0100
From: @njnes

integer value parsing should have failed, ie the query should fail with a clear sql error not an mal level one.