Skip to content

Document allowed index type for SQL #1377

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
TarantoolBot opened this issue Jun 19, 2020 · 3 comments
Closed

Document allowed index type for SQL #1377

TarantoolBot opened this issue Jun 19, 2020 · 3 comments
Assignees
Labels
need feedback [special status] On hold, awaiting feedback sql [location] SQL manual

Comments

@TarantoolBot
Copy link
Collaborator

Before the change, Tarantool query planner segfaulted on
try of using non-tree index. It is blocked now w/ appropriate
error message. Need to document the behaviour.
It should be noted, that this restriction might be relaxed in future.

Closes #4659
Requested by @kyukhin in tarantool/tarantool@e7a70be.

@pgulutzan
Copy link
Contributor

pgulutzan commented Jun 19, 2020

@kyukhin: In February I removed the hash-index example after it became clear from issue tarantool/tarantool#4659 comments that their non-support was intentional. The SQL section of the manual currently says: "Fields in NoSQL spaces can be accessed with SQL if and only if they are scalar and are defined in format clauses. Indexes of NoSQL spaces will be used with SQL if and only if they are TREE indexes." Seeing this, would you agree that no change is needed?

@lenkis lenkis added sql [location] SQL manual need feedback [special status] On hold, awaiting feedback labels Jul 7, 2020
@NickVolynkin NickVolynkin changed the title Doceument allowed index type for SQL Document allowed index type for SQL Apr 21, 2021
@NickVolynkin
Copy link
Contributor

@kyukhin please reply to the previous message.

@kyukhin
Copy link
Contributor

kyukhin commented Feb 1, 2022

@kyukhin: In February I removed the hash-index example after it became clear from issue tarantool/tarantool#4659 comments that their non-support was intentional. The SQL section of the manual currently says: "Fields in NoSQL spaces can be accessed with SQL if and only if they are scalar and are defined in format clauses. Indexes of NoSQL spaces will be used with SQL if and only if they are TREE indexes." Seeing this, would you agree that no change is needed?

I guess so.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
need feedback [special status] On hold, awaiting feedback sql [location] SQL manual
Projects
None yet
Development

No branches or pull requests

6 participants