[MDEV-10140] Add support for EXCEPT Created: 2016-05-27 Updated: 2018-08-31 Resolved: 2017-03-13 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Optimizer, Parser |
| Fix Version/s: | 10.3.0 |
| Type: | Task | Priority: | Major |
| Reporter: | Michael Widenius | Assignee: | Oleksandr Byelkin |
| Resolution: | Fixed | Votes: | 2 |
| Labels: | 10.3-beta, Compatibility | ||
| Issue Links: |
|
||||||||||||||||||||
| Epic Link: | Oracle Compatibility | ||||||||||||||||||||
| Description |
|
Add support for EXCEPT clause The EXCEPT clause has this general form: select_statement EXCEPT select_statement select_statement is any SELECT statement without an ORDER BY, LIMIT, or FOR UPDATE clause. The EXCEPT operator computes the set of rows that are in the result of the left SELECT statement but not in the result of the right one. The result of EXCEPT does not contain any duplicate rows unless the ALL option is specified. With ALL, a row that has m duplicates in the left table and n duplicates in the right table will appear max(m-n,0) times in the result set. |
| Comments |
| Comment by Oleksandr Byelkin [ 2016-11-24 ] |
|
All common code and preparations will be done under |
| Comment by Oleksandr Byelkin [ 2017-07-02 ] |
|
ALL is not standard option |