[MCOL-4113] XOR function cannot be used in the order by clause Created: 2020-06-25 Updated: 2023-10-25 Resolved: 2023-10-25 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | ExeMgr |
| Affects Version/s: | 1.4.4, 1.5.2 |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Minor |
| Reporter: | Daniel Lee (Inactive) | Assignee: | Unassigned |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Build tested: 1.4.401, 1.5.2-1 (community edition b33685) MariaDB [mytest]> create table t2 (c1 int, c2 char(30)) engine=columnstore; MariaDB [mytest]> insert into t2 values (1,'hello'); MariaDB [mytest]> insert into t2 values (2,'world'); MariaDB [mytest]> select * from t2 order by c1 xor 1; The same query works on InnoDB and release 1.2.5-1 |