Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1338

The storage engine executes stored function within IF() function

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Do
    • 1.1.3
    • Icebox
    • MariaDB Server
    • None
    • CentOS 7.4
      SoftwareVersion = 1.1.3
      SoftwareRelease = 1

    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.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MCOL-4256 Signal 11 crash from UDF

          • Major - Major loss of function.
          • Closed

          Activity

            People

              toddstoffel Todd Stoffel (Inactive)
              misi Mihaly Hazag
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.