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 minus/except and intersect set operations for TiDB. #18313

Closed
lzmhhh123 opened this issue Jul 1, 2020 · 3 comments
Closed

Support minus/except and intersect set operations for TiDB. #18313

lzmhhh123 opened this issue Jul 1, 2020 · 3 comments
Labels
feature/accepted This feature request is accepted by product managers help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. sig/execution SIG execution type/feature-request Categorizes issue or PR as related to a new feature.

Comments

@lzmhhh123
Copy link
Contributor

Feature Request

TiDB supports union and union all set operations in v4.0.

It's better also to support minus/except and intersect.

oracle reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries004.htm
@lzmhhh123 lzmhhh123 added sig/execution SIG execution type/feature-request Categorizes issue or PR as related to a new feature. labels Jul 1, 2020
@lzmhhh123 lzmhhh123 changed the title Support minus/except and intersect operators for TiDB. Support minus/except and intersect set operations for TiDB. Jul 1, 2020
@SunRunAway SunRunAway added the help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. label Jul 2, 2020
@SunRunAway
Copy link
Contributor

Duplicate of #18031

@SunRunAway SunRunAway marked this as a duplicate of #18031 Jul 2, 2020
@zz-jason
Copy link
Member

zz-jason commented Jul 2, 2020

Do we need to support minus and except at the same time? Although the name is different in different databases, but the functionality is the same.

@lzmhhh123
Copy link
Contributor Author

Do we need to support minus and except at the same time? Although the name is different in different databases, but the functionality is the same.

There are just different in grammar and parser layer. I think we can support them both.

@zz-jason zz-jason added the feature/accepted This feature request is accepted by product managers label Jul 29, 2020
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 help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. sig/execution SIG execution type/feature-request Categorizes issue or PR as related to a new feature.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@SunRunAway @zz-jason @lzmhhh123