[MCOL-1338] The storage engine executes stored function within IF() function Created: 2018-04-13  Updated: 2023-11-21  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.1.3
Fix Version/s: Icebox

Type: New Feature Priority: Minor
Reporter: Mihaly Hazag Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 1
Labels: None
Environment:

CentOS 7.4
SoftwareVersion = 1.1.3
SoftwareRelease = 1

Attachments: File ax_bug_function_work_when_IF_used.sql    
Issue Links:
Problem/Incident
causes MCOL-4256 Signal 11 crash from UDF Closed

 Description   

By default the SQL stored function is not supported by Columnstore: 

Error Code: 1178. The storage engine for the table doesn't support IDB-1017: Stored function is currently not supported in Columnstore.

BUT Function is executed when it used within IF() function:

SELECT 
    IF(TRUE,
 
        TEST_FUNCTION(some_string),
 
        NULL)
 
FROM
 
    bug_test;

Please find ax_bug_function_work_when_IF_used.sql attached to reproduce.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-06-01 ]

Updated to feature request as we cannot support stored functions properly at the moment.

Comment by Rupert Harwood (Inactive) [ 2020-08-19 ]

In MCOL-4256 we crashed because we do not support user defined functions.

Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

This item is being closed because it was well passed the expiration date with no activity. If you suspect this was done in error please create a new ticket.

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