SELECT fails with a disjunct and small LIMIT

Bug #729758 reported by Kostja Osipov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
tarantool
Fix Released
High
Kostja Osipov

Bug Description

When SELECT limit is small (below 7), SELECT fails with ERR_CODE_ILLEGAL_PARAMETERS
Select(key1, key2, { use_index => 1, limit=$N })

Test suite test case (box_big configuration, namespace 0):

exec sql "insert into t0 values ('Doe', 'Richard')"
exec sql "insert into t0 values ('Roe', 'Richard')"
exec sql "insert into t0 values ('Woe', 'Richard')"
exec sql "insert into t0 values ('Major', 'Tomas')"
exec sql "insert into t0 values ('Kytes', 'Tomas')"
exec sql "insert into t0 values ('Stiles', 'Tomas')"
exec sql "insert into t0 values ('Wales', 'Tomas')"
exec sql "insert into t0 values ('Callaghan', 'Tomas')"
# xxx: bug
exec sql "select * from t0 where k1='Richard' or k1='Tomas' or k1='Tomas' limit 5"

Kostja Osipov (kostja)
summary: - SELECT fails with a small LIMIT
+ SELECT fails with a disjunct and small LIMIT
Kostja Osipov (kostja)
Changed in tarantool:
status: New → Confirmed
importance: Undecided → High
milestone: none → 1.3.5
Kostja Osipov (kostja)
description: updated
Kostja Osipov (kostja)
Changed in tarantool:
assignee: nobody → Kostja Osipov (kostja)
Kostja Osipov (kostja)
Changed in tarantool:
status: Confirmed → Fix Committed
Kostja Osipov (kostja)
Changed in tarantool:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.