Documentation

Table of Contents:


    MariaDB support

    2018-05-09 2018-06-16
    Applies to: 7.1 (current), Article available also for: 6.3, 5.2

    Supported versions

    MariaDB Server 5.1, 5.2, 5.3, 5.5, 10.0, 10.1, 10.2

    MariaDB Columnstore

    Some versions of MariaDB Columnstore may cause issues - we have tested and version 1.1.2-1 works properly.

    If you do run into any issues please post here.

    Supported schema elements and metadata

    Dataedo reads following metadata from MariaDB databases.

    • Tables
      • Columns
        • Data type with length
        • Nullable
        • Default value
      • Primary keys
        • Columns
      • Unique indexes
        • Column
      • Foreign keys
        • Columns
      • Triggers
        • When triggered
        • Script
    • Views
      • Columns (see tables)
      • Script
    • Procedures
      • Script
      • Parameters (may not work on older versions of MariaDB)
    • Functions
      • Script
      • Parameters (may not work on MariaDB 5.1)
      • Returned value (may not work on MariaDB 5.1)

    Comments

    Dataedo reads MariaDB comments from following objects:

    • Tables
      • Columns
      • Primary keys
      • Unique indexes
    • Views
      • Columns
    • Procedures
    • Functions

    Dataedo does not write comments back to MariaDB.

    Limitations

    Following schema/metadata elements currently are not supported:

    • Check constraints (vote)
    • Non unique indexes (vote)
    • Dependencies - are not presented by MariaDB

    Connection:

    • SSL connection is not currently supported
    Found issue with this article? Comment below
    Comments (0)