[MCOL-4258] Add support for user defined functions/stored functions (UDFs) Created: 2020-08-20  Updated: 2024-01-04  Resolved: 2023-10-25

Status: Closed
Project: MariaDB ColumnStore
Component/s: Columnstore Select Handler
Affects Version/s: None
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: susil.behera Assignee: Todd Stoffel (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

Server version: 10.5.6
MCS version: 1.5.4-1


 Description   

Like InnoDB engine, Columnstore should also support user defined functions.

CREATE TABLE t1(number INT) Engine=Columnstore;
INSERT INTO t1 VALUEs(1),(2),(3),(4),(5),(6);
CREATE FUNCTION square(num INT) RETURNS INT RETURN(num * num);
SELECT number, square(number) FROM t1;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1017: Stored function is currently not supported in Columnstore.
Generated at Thu Feb 08 02:49:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.