SELECT
CASE
WHEN version = '1.6.8.1' THEN 'OMI is Updated'
ELSE 'Update OMI to 1.6.8.1'
END AS OMIGODVersionCheck,
name,
version,
release,
source,
sha1,
arch
FROM rpm_packages WHERE name = 'omi'
UNION ALL
SELECT
CASE
WHEN version = '1.6.8.1' THEN 'OMI is Updated'
ELSE 'Update OMI to 1.6.8.1'
END AS OMIGODVersionCheck,
name,
version,
revision AS release,
source,
'' AS sha1,
arch
FROM deb_packages WHERE name = 'omi'
Output should look like -
