[MCOL-3580] Many window function queries returned syntax errors Created: 2019-10-31 Updated: 2020-03-27 Resolved: 2020-03-27 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MariaDB Server |
| Affects Version/s: | 1.4.1 |
| Fix Version/s: | 1.4.4 |
| Type: | Bug | Priority: | Major |
| Reporter: | Daniel Lee (Inactive) | Assignee: | Daniel Lee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Sprint: | 2020-3, 2020-4, 2020-5 |
| Description |
|
Build tested: 1.4.1-1 [dlee@cs-tst-01 centos7]$ cat gitversionInfo.txt Test suite: autopilot.windowFunctions There are a total of 6576 queries in the test suite. 2976 of them failed with a syntax error. All these queries got executed successfully in 1.2.5-1 and 1.4.0-1. select o_custkey, regr_syy(o_custkey,o_orderkey) OVER (PARTITION BY 55 ORDER BY o_custkey ,o_orderkey ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) from orders order by 1, 2; All returned errors complain about "near the OVER keyword" |
| Comments |
| Comment by David Hall (Inactive) [ 2020-02-11 ] |
|
This appears fixed by other things. |
| Comment by Daniel Lee (Inactive) [ 2020-03-27 ] |
|
Build verified: 1.4.4-1 source /root/ColumnStore/buildColumnstoreFromGithubSource/server /root/ColumnStore/buildColumnstoreFromGithubSource/server/engine Merge pull request #1117 from drrtuy/ Executed window function tests suite. Verified that reported issue has been fixed. |