[MCOL-1574] test oracle compatiblity in columnstore Created: 2018-07-20  Updated: 2018-10-04  Resolved: 2018-10-04

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.2
Fix Version/s: 1.2.0

Type: Task Priority: Major
Reporter: David Thompson (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MCOL-1385 Merge MariaDB 10.3 Closed
Sprint: 2018-17, 2018-18

 Description   

Once 10.3 is merged, test the major oracle compatibility features and validate what works / does not work and file tickets for what does not work - we will prioritze and fix low hanging fruit. Most stored procedure logic is likely problematic.

A good starting point for changes is this article:
https://mariadb.com/kb/en/library/sql_modeoracle-from-mariadb-103/

 Comments   
Comment by Daniel Lee (Inactive) [ 2018-10-01 ]

Created the features/oracleCompatibility test suite, which consists of 76 test cases at the moment. I execute the test suite on the latest build ColumnStore 1.2.0-1. Two bugs have been identified and tickets have been created.

MCOL-1751 Oracle Compatibility: SELECT IF (...) INTO variable FROM DUAL result in syntax error
MCOL-1752 Oracle Compatibility: A specific stored procedure caused mysqld to crash

Comment by Daniel Lee (Inactive) [ 2018-10-04 ]

Test suite has been created in Autopilot. Tests have been executed. tickets have been open for issues found in both MariaDB 10.3.9 and ColumnStore 1.2 build.

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