Skip to content
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.

Sign up for GitHub

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

Jump to bottom

Support ascending or descending index #2519

Open
ngaut opened this issue Jan 20, 2017 · 1 comment
Open

Support ascending or descending index #2519

ngaut opened this issue Jan 20, 2017 · 1 comment
Labels
feature/accepted This feature request is accepted by product managers priority/P2 The issue has P2 priority. proposal sig/sql-infra SIG: SQL Infra type/enhancement The issue or PR belongs to an enhancement.
Milestone
Requirement pool

Comments

@ngaut
Copy link
Member

ngaut commented Jan 20, 2017

According to MySQL reference we should support ascending or descending index, it's helpful for RocksDB engine to do ascend scanning.
@ngaut ngaut added type/enhancement The issue or PR belongs to an enhancement. proposal labels Jan 20, 2017
@morgo morgo mentioned this issue Nov 24, 2018
Open
69 tasks
@morgo
Copy link
Contributor

morgo commented Nov 24, 2018

For MySQL 5.7 compatibility, only ascending indexes are required (the DESC keyword is parsed but ignored). MySQL 8.0 adds support for descending indexes.

@zimulala zimulala mentioned this issue Feb 14, 2020
Closed
27 tasks
@zimulala zimulala added sig/sql-infra SIG: SQL Infra and removed component/DDL1 labels Mar 4, 2020
@zz-jason zz-jason added feature/reviewing This feature request is reviewing by product managers feature/discussing This feature request is discussing among product managers and removed feature/reviewing This feature request is reviewing by product managers labels Aug 6, 2020
@scsldb scsldb added the priority/P1 The issue has P1 priority. label Aug 28, 2020
@scsldb scsldb added priority/P2 The issue has P2 priority. and removed priority/P1 The issue has P1 priority. labels Aug 28, 2020
@zz-jason zz-jason added feature/accepted This feature request is accepted by product managers and removed feature/discussing This feature request is discussing among product managers labels Aug 28, 2020
@scsldb scsldb added this to the Requirement pool milestone Aug 28, 2020
This was referenced Aug 30, 2021
Closed
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
feature/accepted This feature request is accepted by product managers priority/P2 The issue has P2 priority. proposal sig/sql-infra SIG: SQL Infra type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
Requirement pool
Development

No branches or pull requests
5 participants
@morgo @ngaut @zimulala @zz-jason @scsldb