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"