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;