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

Oracle Compatibility: A specific stored procedure caused mysqld to crash

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.0
    • Fix Version/s: Icebox
    • Component/s: MariaDB Server
    • Labels:
      None

      Description

      Build tested: Github source
      /root/columnstore/mariadb-columnstore-server
      commit 7db44a78066cb55b7e2ffded80e2673d16940cee
      Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
      Date: Mon Sep 10 13:39:42 2018 +0100
      Revert "MDEV-11036 Add link wsrep_sst_rsync_wan -> wsrep_sst_rsync"
      This reverts commit e8a2a751212a04e835b2b03408132ecbbab52410.
      /root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
      commit 3326be00de5f53ec365910f07a7fd882ba193d4d
      Merge: ebbeb30 5cab6c4
      Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
      Date: Tue Sep 18 13:57:17 2018 +0100
      Merge pull request #565 from drrtuy/MCOL-1601
      MCOL-1601 GROUP BY now supports subqueries in HAVING.

      Testing Oracle compatibility feature, using MariaDB 10.3.9 as the reference. SQLMODE has to set as the following:

      SET SQL_MODE=ORACLE;

      The following stored procedures created fine, but mysqld crash when executing the CALL command. The same test works fine for the reference server.

      1. -----------------------------------------------------------------------
      2. Create procedure test with IN and OUT parameters
      3. -----------------------------------------------------------------------
        SET @stateName = 'Hawaii';
        SELECT @capitalName;
        SET SQL_MODE=ORACLE;
        #
        DELIMITER //
        CREATE OR REPLACE PROCEDURE getCapitalName (sp_stateName IN varchar(30), sp_capitalName OUT varchar(30))
        AS
        BEGIN
        SELECT capital INTO sp_capitalName FROM states where state=sp_stateName;
        END;
        //
        #
        DELIMITER ;
        CALL getCapitalName(@stateName, @capitalName);
        SELECT @capitalName;
        SELECT 'Procedure.2.testResult: Procedure with IN and OUT parameters' AS test, IF (@capitalName='Honolulu', 'Passed', 'Failed') AS result;

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            dleeyh Daniel Lee
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration