Complete Compatibility Matrix (view)

Data license: MIT · Data source: Generated from Canonical documentation · About: version-query

12 rows where base_version = "22.04" sorted by base_version

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: juju_version, charmcraft_version, ops_version, pebble_version, ops_min_python, juju_eol, ops_eol, juju_eol (date), ops_eol (date)

CREATE VIEW base_compatibility AS
        SELECT 
            bp.Base as base_version,
            bp.python_version as default_python,
            jb.juju_version,
            cb.charmcraft_version,
            ob.ops_version,
            jp.pebble_version,
            op.min_python_version as ops_min_python,
            je.eol_date as juju_eol,
            oe.eol_date as ops_eol
        FROM base_python bp
        LEFT JOIN juju_base jb ON bp.Base = jb.supported_base
        LEFT JOIN charmcraft_base cb ON bp.Base = cb.supported_base
        LEFT JOIN ops_base ob ON (
            (ob.min_base = '20.04' AND bp.Base IN ('20.04', '22.04', '24.04')) OR
            (ob.min_base = '22.04' AND bp.Base IN ('22.04', '24.04'))
        )
        LEFT JOIN juju_pebble jp ON jb.juju_version = jp.juju_version
        LEFT JOIN ops_python op ON ob.ops_version = op.ops_version
        LEFT JOIN juju_eol je ON jb.juju_version = je.juju_version
        LEFT JOIN ops_eol oe ON ob.ops_version = oe.ops_version
        ORDER BY bp.Base, jb.juju_version, cb.charmcraft_version, ob.ops_version;