[MCOL-1680] MariaDB 10.3 median() WF overlaps with the test UDAF function. Created: 2018-08-29  Updated: 2018-08-29  Resolved: 2018-08-29

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 1.2
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Roman Assignee: David Hall (Inactive)
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

There is a number of tests against median() UDAF. After 10.3 merging the tests complain in this way and queries use the median() UDAF fails afterwards with a syntax error:

MariaDB [tpch1]> CREATE OR REPLACE AGGREGATE FUNCTION median returns REAL soname 'libudf_mysql.so';
ERROR 1585 (HY000): This function 'median' has the same name as a native function
MariaDB [tpch1]> select l_shipmode,avg_mode(l_extendedprice),l_shipmode,median(l_extendedprice) from lineitem group by l_shipmode order by l_shipmode;
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 'from lineitem group by l_shipmode order by l_shipmode' at line 1
MariaDB [tpch1]>



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-08-29 ]

the tests in develop have already been updated to reflect this. Please update your local copy of the regression suite.

Generated at Thu Feb 08 02:30:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.