[Query Fuzz] LIMIT / OFFSET in query hangs

[e-dard]

This issue was found by fuzzing the database with a query generator tool. It may be possible to simplify the query to help identify the root cause.

Dataset

$ curl https://s3.amazonaws.com/noaa.water-database/NOAA_data.txt -o NOAA_data.txt
$ influx -import -path=NOAA_data.txt

Query

USE NOAA_water_database

SELECT  "degrees",   SAMPLE("degrees", 2) FROM  "average_temperature" LIMIT 42747 OFFSET 323971

Result

The query hangs. Heap remains very low, no CPU activity.

See attached SIGQUIT on the server.

I have managed to simplify a query that triggers this issue to:

SELECT  "degrees",   SAMPLE("degrees", 2) FROM  "average_temperature" LIMIT 1 OFFSET 1

Note that all the following queries return results, or at least return an empty result immediately:

SELECT  "degrees",   SAMPLE("degrees", 2) FROM  "average_temperature"
SELECT  "degrees",   SAMPLE("degrees", 2) FROM  "average_temperature" LIMIT 1

However, SELECT "degrees", SAMPLE("degrees", 2) FROM "average_temperature" OFFSET 1 also hangs the server. I note in this case the docs say that OFFSET should not be used without LIMIT, but as you can see above, using it with LIMIT still hangs the server.

1488220454176671673-freeze.txt