Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.4.1
-
None
-
2020-3, 2020-4, 2020-5
Description
Build tested: 1.4.1-1
[dlee@cs-tst-01 centos7]$ cat gitversionInfo.txt
engine commit:
3e7a964
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;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OVER (PARTITION BY 55 ORDER BY o_custkey ,o_orderkey ROWS BETWEEN CURRENT ROW AN' at line 1
All returned errors complain about "near the OVER keyword"
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Rank | Ranked higher |
Assignee | David Hall [ david.hall ] |
Assignee | David Hall [ david.hall ] | Daniel Lee [ dleeyh ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Status | In Progress [ 3 ] | In Testing [ 10301 ] |
Sprint | 2020-3 [ 383 ] |
Fix Version/s | 1.4.4 [ 24039 ] |
Sprint | 2020-3 [ 383 ] | 2020-3, 2020-4 [ 383, 392 ] |
Team | ColumnStore Team |
Sprint | 2020-3, 2020-4 [ 383, 392 ] | 2020-3, 2020-4, 2020-5 [ 383, 392, 396 ] |
Sprint | 2020-3, 2020-4, 2020-5 [ 383, 392, 396 ] | 2020-3, 2020-4 [ 383, 392 ] |
Sprint | 2020-3, 2020-4 [ 383, 392 ] | 2020-3, 2020-4, 2020-5 [ 383, 392, 396 ] |
issue.field.resolutiondate | 2020-03-27 14:53:28.0 | 2020-03-27 14:53:28.185 |
Resolution | Fixed [ 1 ] | |
Status | In Testing [ 10301 ] | Closed [ 6 ] |