tarantool / tarantool / 11938

81%

master: 87%

Build Type

push

travis-ci

Committed by Ivan Koptelov

Commit Message

sql: fixes op-codes' generation for skip-scan

Currently we have skip-scan optimization working
the way described here:
(https://sqlite.org/optoverview.html#skipscan)

To understand the problem solved consider the example
with some skip-scan query and a table created like
CREATE TABLE t(a, b, c, PRIMARY KEY(c, b, a));

Before the patch: op-codes realization of skip-scan
relied on the following work of 'Column' op-code:
If P1 is a number of cursor pointing to the table
then P2 is number of column in 'native' order
(0 for a, 1 for b, etc)
If P1 is a number of cursor pointing to the index
then P2 in number of column in 'index' order
(0 for c, 1 for b, etc)
But currently our 'Column' op-code always consider
P2 to be column number in 'native order'.

With the patch:
P2 is always set in 'Column' as a column number
in 'native' order.

Closes #3350, #2859

Run Details

1 of 1 new or added line in 1 file covered. (100.0%)

60510 of 74990 relevant lines covered (80.69%)

101166951445353.69 hits per line