--- policy: /ce/ca/aws/rds/instance-engine-support logic: /ce/ca/aws/rds/instance-engine-support/prod.logic.yaml executionTime: 2026-10-30T18:09:57.256523696Z generationMs: 96 executionMs: 1029 rows: - id: standard-support match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) runtimeError: {} - id: standard-start-exact match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) runtimeError: {} - id: standard-end-exact match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) runtimeError: {} - id: extended-start-exact match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: extended-support match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: extended-end-exact match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: final-support-expired match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1399 actual: 1399 conditionText: expected: extract('caDateTimeFrom__instanceEngineExtendedEnd').beforeToday() actual: extract('caDateTimeFrom__instanceEngineExtendedEnd').beforeToday() runtimeError: {} - id: before-support-start match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 899 actual: 899 conditionText: expected: extract('caDateTimeFrom__instanceEngineStandardStart').afterToday() actual: extract('caDateTimeFrom__instanceEngineStandardStart').afterToday() runtimeError: {} - id: reversed-phases match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: standard-only-mariadb match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) runtimeError: {} - id: standard-only-expired match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1299 actual: 1299 conditionText: expected: extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') == number(0.0) actual: extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') == number(0.0) runtimeError: {} - id: empty-calendar match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) runtimeError: {} - id: missing-calendar match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 499 actual: 499 conditionText: expected: extract('CA10__engineVersion__c').isNotEmpty() && extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() actual: extract('CA10__engineVersion__c').isNotEmpty() && extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() runtimeError: {} - id: invalid-json match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 502 actual: 502 conditionText: expected: extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid() actual: extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid() runtimeError: expected: "Expected property name or '}' in JSON at position 1 (line 1 column\ \ 2)" actual: "Expected property name or '}' in JSON at position 1 (line 1 column\ \ 2)" - id: wrong-root match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) runtimeError: {} - id: missing-standard match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) runtimeError: {} - id: duplicate-standard match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) runtimeError: {} - id: duplicate-extended match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) runtimeError: {} - id: unknown-phase match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) runtimeError: {} - id: invalid-standard-date match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) runtimeError: {} - id: invalid-future-extended-date match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) runtimeError: {} - id: inverted-standard match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) runtimeError: {} - id: inverted-extended match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) runtimeError: {} - id: overlapping-phases match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 599 actual: 599 conditionText: expected: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__instanceEngineCalendarValid')) runtimeError: {} - id: intraday-date match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays')) actual: extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays')) runtimeError: {} - id: missing-version match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 401 actual: 401 conditionText: expected: CA10__engineVersion__c.isEmpty() actual: CA10__engineVersion__c.isEmpty() runtimeError: {} - id: missing-engine match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 301 actual: 301 conditionText: expected: CA10__engine__c.isEmpty() actual: CA10__engine__c.isEmpty() runtimeError: {} - id: missing-status match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 201 actual: 201 conditionText: expected: CA10__status__c.isEmpty() actual: CA10__status__c.isEmpty() runtimeError: {} - id: commercial-no-calendar match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" actual: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" runtimeError: {} - id: unknown-engine match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" actual: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" runtimeError: {} - id: enrollment-disabled-standard match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) runtimeError: {} - id: enrollment-disabled-extended match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: cluster-member match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 199 actual: 199 conditionText: expected: extract('CA10__cluster__c').isNotEmpty() || extract('CA10__clusterArn__c').isNotEmpty() actual: extract('CA10__cluster__c').isNotEmpty() || extract('CA10__clusterArn__c').isNotEmpty() runtimeError: {} - id: cluster-arn-only match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 199 actual: 199 conditionText: expected: extract('CA10__cluster__c').isNotEmpty() || extract('CA10__clusterArn__c').isNotEmpty() actual: extract('CA10__cluster__c').isNotEmpty() || extract('CA10__clusterArn__c').isNotEmpty() runtimeError: {} - id: deleting match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 299 actual: 299 conditionText: expected: extract('CA10__status__c') == 'deleting' actual: extract('CA10__status__c') == 'deleting' runtimeError: {} - id: stopped-extended match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: disappeared match: true status: expected: DISAPPEARED actual: DISAPPEARED conditionIndex: expected: 99 actual: 99 conditionText: expected: isDisappeared(CA10__disappearanceTime__c) actual: isDisappeared(CA10__disappearanceTime__c) runtimeError: {} - id: between-support-phases match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1499 actual: 1499 conditionText: expected: extract('caDateTimeFrom__instanceEngineExtendedStart').afterToday() actual: extract('caDateTimeFrom__instanceEngineExtendedStart').afterToday() runtimeError: {} - id: unparseable-standard-month match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 705 actual: 705 conditionText: expected: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName\ \ == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportStartDate').checkIso8601()" actual: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName\ \ == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportStartDate').checkIso8601()" runtimeError: {} - id: unparseable-future-extended-month match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 713 actual: 713 conditionText: expected: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName\ \ == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportStartDate').checkIso8601()" actual: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName\ \ == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportStartDate').checkIso8601()" runtimeError: {} - id: valid-leap-day-end match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) runtimeError: {} - id: intraday-extended-end-retains-standard-eos match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays')) actual: extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays')) runtimeError: {} - id: aurora-without-membership match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" actual: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" runtimeError: {} - id: mysql80-eos match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: mysql80-standard-last-day match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) runtimeError: {} - id: mysql80-extended-first-day match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: mysql84-standard-support match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) runtimeError: {} - id: mysql57-extended-support-longer-than-three-years match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: mysql57-extended-last-day match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: mysql57-final-support-expired match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1399 actual: 1399 conditionText: expected: extract('caDateTimeFrom__instanceEngineExtendedEnd').beforeToday() actual: extract('caDateTimeFrom__instanceEngineExtendedEnd').beforeToday() runtimeError: {} - id: postgres-rds-patch-suffix match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: mariadb106-current-standard-support match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) runtimeError: {} - id: mariadb106-standard-last-day match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday()) runtimeError: {} - id: mariadb106-first-unsupported-day match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1299 actual: 1299 conditionText: expected: extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') == number(0.0) actual: extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') == number(0.0) runtimeError: {} - id: mariadb-invalid-extended-support match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 699 actual: 699 conditionText: expected: extract('CA10__engine__c') == 'mariadb' && extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') != number(0.0) actual: extract('CA10__engine__c') == 'mariadb' && extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') != number(0.0) runtimeError: {} - id: db2-ce-without-cluster-enrichment match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" actual: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" runtimeError: {} - id: docdb-without-cluster-enrichment match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" actual: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" runtimeError: {} - id: neptune-without-cluster-enrichment match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" actual: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" runtimeError: {} - id: creating-retains-current-engine-eos match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: modifying-retains-current-engine-eos match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: upgrading-retains-current-engine-eos match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: storage-full-retains-current-engine-eos match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1500 actual: 1500 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: missing-version-and-calendar match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 401 actual: 401 conditionText: expected: CA10__engineVersion__c.isEmpty() actual: CA10__engineVersion__c.isEmpty() runtimeError: {} - id: whitespace-version match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 401 actual: 401 conditionText: expected: CA10__engineVersion__c.isEmpty() actual: CA10__engineVersion__c.isEmpty() runtimeError: {} - id: intraday-before-eos-excluded match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 1099 actual: 1099 conditionText: expected: not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays')) actual: not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays')) runtimeError: {} usedFiles: - path: /ce/ca/aws/rds/instance-engine-support/policy.yaml md5Hash: 4CAF6C5DEE0FD242391C54266B2FC134 content: "---\nnames:\n full: AWS RDS Instance engine is outside standard support\n\ \ contextual: Instance engine is outside standard support\ndescription: >-\n\ \ Ensure that standalone Amazon RDS for MySQL, PostgreSQL, and MariaDB instances\ \ \n use an engine major version within AWS standard support to reduce lifecycle\ \ risk \n and reliance on paid Extended Support.\ntype: COMPLIANCE_POLICY\n\ categories:\n - RELIABILITY\nframeworkMappings:\n - /frameworks/cloudaware/resource-reliability/infrastructure-modernization\n" - path: /ce/ca/aws/rds/instance-engine-support/prod.logic.yaml md5Hash: 474C52DFA64FDB8B804657AFBE57B75A content: | --- inputType: CA10__CaAwsDbInstance__c testData: - file: test-data.json importExtracts: - file: /types/CA10__CaAwsDbInstance__c/object.extracts.yaml - file: /types/CA10__CaAwsDbInstance__c/instance-engine-support.extracts.yaml conditions: - status: INAPPLICABLE currentStateMessage: This instance belongs to a DB cluster; assess engine support once on the cluster. check: OR: args: - NOT_EMPTY: arg: EXTRACT: CA10__cluster__c - NOT_EMPTY: arg: EXTRACT: CA10__clusterArn__c - status: INAPPLICABLE currentStateMessage: The DB instance is being deleted. check: IS_EQUAL: left: EXTRACT: CA10__status__c right: TEXT: deleting - status: INAPPLICABLE currentStateMessage: This policy only assesses MySQL, PostgreSQL, and MariaDB engines. check: NOT: arg: CONTAINS: arg: SET: itemType: TEXT items: - mysql - postgres - mariadb search: EXTRACT: CA10__engine__c - status: INAPPLICABLE currentStateMessage: The optional native engine lifecycle calendar is not populated; this policy excludes engines without collected calendar enrichment. check: AND: args: - NOT_EMPTY: arg: EXTRACT: CA10__engineVersion__c - IS_EMPTY: arg: EXTRACT: CA10A2__engineLifecycleSupportInfo__c - status: UNDETERMINED currentStateMessage: The engine support calendar is missing named phases, has duplicate or unknown phases, or has invalid UTC date ranges. check: NOT: arg: EXTRACT: caJsonQueryBoolean__instanceEngineCalendarValid - status: UNDETERMINED currentStateMessage: The MariaDB support calendar contains an Extended Support phase, which AWS does not offer for this engine. check: AND: args: - IS_EQUAL: left: EXTRACT: CA10__engine__c right: TEXT: mariadb - NOT_EQUAL: left: EXTRACT: caJsonQueryNumber__instanceEngineExtendedPhaseCount right: NUMBER: 0 # Parse every published date before making a support claim, including future Extended Support dates. - status: UNDETERMINED currentStateMessage: The engine support calendar contains an invalid date. check: NOT: arg: AND: args: - NOT_EMPTY: arg: EXTRACT: caDateTimeFrom__instanceEngineStandardStart - NOT_EMPTY: arg: EXTRACT: caDateTimeFrom__instanceEngineStandardEnd - OR: args: - IS_EQUAL: left: EXTRACT: caJsonQueryNumber__instanceEngineExtendedPhaseCount right: NUMBER: 0 - AND: args: - NOT_EMPTY: arg: EXTRACT: caDateTimeFrom__instanceEngineExtendedStart - NOT_EMPTY: arg: EXTRACT: caDateTimeFrom__instanceEngineExtendedEnd - status: UNDETERMINED currentStateMessage: The engine standard support period has not started; verify the collected engine version and calendar. check: IS_AFTER_TODAY: arg: EXTRACT: caDateTimeFrom__instanceEngineStandardStart - status: INCOMPLIANT currentStateMessage: AWS standard support has ended; the calendar timestamp precision does not establish the later Extended Support phase on this evaluation day. remediationMessage: Upgrade to an engine version within AWS standard support and verify any temporary Extended Support arrangement with AWS. check: AND: args: - IS_BEFORE_TODAY: arg: EXTRACT: caDateTimeFrom__instanceEngineStandardEnd - NOT: arg: EXTRACT: caJsonQueryBoolean__instanceEngineCalendarWholeDays - status: INAPPLICABLE currentStateMessage: This calendar uses timestamps outside the verified UTC whole-day encoding; the evaluation day is excluded because no standard-support expiry is established. check: NOT: arg: EXTRACT: caJsonQueryBoolean__instanceEngineCalendarWholeDays - status: COMPLIANT currentStateMessage: The instance engine major version is within AWS standard support according to its published support calendar. check: NOT: arg: IS_BEFORE_TODAY: arg: EXTRACT: caDateTimeFrom__instanceEngineStandardEnd - status: INCOMPLIANT currentStateMessage: AWS standard support has ended and the calendar publishes no Extended Support period for this engine major version. remediationMessage: Upgrade the instance to an engine version within AWS standard support after compatibility testing. check: IS_EQUAL: left: EXTRACT: caJsonQueryNumber__instanceEngineExtendedPhaseCount right: NUMBER: 0 - status: INCOMPLIANT currentStateMessage: The instance engine major version is past the final published AWS support end date, including Extended Support. remediationMessage: Prioritize a tested upgrade to a version within AWS standard support and verify the current instance state with AWS. check: IS_BEFORE_TODAY: arg: EXTRACT: caDateTimeFrom__instanceEngineExtendedEnd - status: INCOMPLIANT currentStateMessage: AWS standard support has ended and the published Extended Support period has not started. remediationMessage: Upgrade the instance to a version within AWS standard support and verify support coverage with AWS. check: IS_AFTER_TODAY: arg: EXTRACT: caDateTimeFrom__instanceEngineExtendedStart otherwise: status: INCOMPLIANT currentStateMessage: The instance engine major version is outside AWS standard support and within the published RDS Extended Support period; this calendar does not establish enrollment or entitlement. remediationMessage: Plan a tested instance engine upgrade; if temporarily retaining this version, verify Extended Support enrollment and charges and record a time-limited exception. - path: /ce/ca/aws/rds/instance-engine-support/test-data.json md5Hash: 81425319CB0BC544CF4C1E4C7969EE25 content: | [ { "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null }, "context" : { "snapshotTime" : "2025-10-23T00:00:00Z" }, "Id" : "standard-support", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null }, "context" : { "snapshotTime" : "2021-02-24T00:00:00Z" }, "Id" : "standard-start-exact", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-02-28T23:59:59.999Z" }, "Id" : "standard-end-exact", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-03-01T00:00:00Z" }, "Id" : "extended-start-exact", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "extended-support", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2029-02-28T23:59:59.999Z" }, "Id" : "extended-end-exact", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1399, "conditionText" : "extract('caDateTimeFrom__instanceEngineExtendedEnd').beforeToday()", "runtimeError" : null }, "context" : { "snapshotTime" : "2029-03-01T00:00:00Z" }, "Id" : "final-support-expired", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 899, "conditionText" : "extract('caDateTimeFrom__instanceEngineStandardStart').afterToday()", "runtimeError" : null }, "context" : { "snapshotTime" : "2021-02-23T23:59:59.999Z" }, "Id" : "before-support-start", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "reversed-phases", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null }, "context" : { "snapshotTime" : "2025-10-23T00:00:00Z" }, "Id" : "standard-only-mariadb", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.6.25", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2022-02-03T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-12-31T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1299, "conditionText" : "extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') == number(0.0)", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "standard-only-expired", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.5.29", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-01-21T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-08-31T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "empty-calendar", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[]" }, { "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 499, "conditionText" : "extract('CA10__engineVersion__c').isNotEmpty() && extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty()", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "missing-calendar", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : null }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 502, "conditionText" : "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", "runtimeError" : "Expected property name or '}' in JSON at position 1 (line 1 column 2)" }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "invalid-json", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "{broken" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "wrong-root", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "{}" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "missing-standard", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "duplicate-standard", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "duplicate-extended", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "unknown-phase", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"unknown-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2025-10-23T00:00:00Z" }, "Id" : "invalid-standard-date", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"not-a-date\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2025-10-23T00:00:00Z" }, "Id" : "invalid-future-extended-date", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"not-a-date\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2025-10-23T00:00:00Z" }, "Id" : "inverted-standard", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2028-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2025-10-23T00:00:00Z" }, "Id" : "inverted-extended", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2025-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2025-10-23T00:00:00Z" }, "Id" : "overlapping-phases", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-02-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 999, "conditionText" : "extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "intraday-date", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T12:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T12:00:00.000Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 401, "conditionText" : "CA10__engineVersion__c.isEmpty()", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "missing-version", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "301", "conditionText" : "CA10__engine__c.isEmpty()", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "missing-engine", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "201", "conditionText" : "CA10__status__c.isEmpty()", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "missing-status", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 399, "conditionText" : "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "commercial-no-calendar", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "oracle-ee", "CA10__engineVersion__c" : "19.0.0.0.ru-2026-07.r1", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[]" }, { "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 399, "conditionText" : "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "unknown-engine", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "future-db", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null }, "context" : { "snapshotTime" : "2025-10-23T00:00:00Z" }, "Id" : "enrollment-disabled-standard", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support-disabled", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "enrollment-disabled-extended", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support-disabled", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : "199", "conditionText" : "extract('CA10__cluster__c').isNotEmpty() || extract('CA10__clusterArn__c').isNotEmpty()", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "cluster-member", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "synthetic-cluster", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : null }, { "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : "199", "conditionText" : "extract('CA10__cluster__c').isNotEmpty() || extract('CA10__clusterArn__c').isNotEmpty()", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "cluster-arn-only", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "arn:aws:rds:us-east-1:000000000000:cluster:synthetic", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : null }, { "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : "299", "conditionText" : "extract('CA10__status__c') == 'deleting'", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "deleting", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "deleting", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : null }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "stopped-extended", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "stopped", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "DISAPPEARED", "conditionIndex" : "99", "conditionText" : "isDisappeared(CA10__disappearanceTime__c)", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "disappeared", "CA10__disappearanceTime__c" : "2026-10-22T12:00:00Z", "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : null }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1499, "conditionText" : "extract('caDateTimeFrom__instanceEngineExtendedStart').afterToday()", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-23T00:00:00Z" }, "Id" : "between-support-phases", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2027-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 705, "conditionText" : "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportStartDate').checkIso8601()", "runtimeError" : null }, "context" : { "snapshotTime" : "2025-10-23T00:00:00Z" }, "Id" : "unparseable-standard-month", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-13-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 713, "conditionText" : "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportStartDate').checkIso8601()", "runtimeError" : null }, "context" : { "snapshotTime" : "2025-10-23T00:00:00Z" }, "Id" : "unparseable-future-extended-month", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-13-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null }, "context" : { "snapshotTime" : "2028-02-29T23:59:59.999Z" }, "Id" : "valid-leap-day-end", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.11.16", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2023-08-21T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2028-02-29T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 999, "runtimeError" : null, "conditionText" : "extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays'))" }, "context" : { "snapshotTime" : "2029-02-28T12:00:00Z" }, "Id" : "intraday-extended-end-retains-standard-eos", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T12:00:00.000Z\"}]" }, { "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 399, "runtimeError" : null, "conditionText" : "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" }, "context" : { "snapshotTime" : "2025-10-23T00:00:00Z" }, "Id" : "aurora-without-membership", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "mysql80-eos", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "8.0.40", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2018-10-23T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-07-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-08-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-07-31T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-07-31T23:59:59.999Z" }, "Id" : "mysql80-standard-last-day", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "8.0.46", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2018-10-23T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-07-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-08-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-07-31T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-08-01T00:00:00Z" }, "Id" : "mysql80-extended-first-day", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "8.0.46", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2018-10-23T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-07-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-08-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-07-31T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "mysql84-standard-support", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "8.4.8", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2024-11-21T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-07-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2029-08-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-07-31T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2028-10-27T12:00:00Z" }, "Id" : "mysql57-extended-support-longer-than-three-years", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "5.7.44-rds.20260902", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2016-02-22T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2024-02-29T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2024-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-06-30T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2029-06-30T23:59:59.999Z" }, "Id" : "mysql57-extended-last-day", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "5.7.44-rds.20260902", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2016-02-22T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2024-02-29T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2024-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-06-30T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1399, "conditionText" : "extract('caDateTimeFrom__instanceEngineExtendedEnd').beforeToday()", "runtimeError" : null }, "context" : { "snapshotTime" : "2029-07-01T00:00:00Z" }, "Id" : "mysql57-final-support-expired", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "5.7.44-rds.20260902", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2016-02-22T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2024-02-29T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2024-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-06-30T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "postgres-rds-patch-suffix", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23-rds.20260224", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "mariadb106-current-standard-support", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.6.25", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2022-02-03T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-12-31T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-12-31T23:59:59.999Z" }, "Id" : "mariadb106-standard-last-day", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.6.25", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2022-02-03T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-12-31T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1299, "conditionText" : "extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') == number(0.0)", "runtimeError" : null }, "context" : { "snapshotTime" : "2027-01-01T00:00:00Z" }, "Id" : "mariadb106-first-unsupported-day", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.6.25", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2022-02-03T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-12-31T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 699, "conditionText" : "extract('CA10__engine__c') == 'mariadb' && extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') != number(0.0)", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "mariadb-invalid-extended-support", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.6.25", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 399, "conditionText" : "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "db2-ce-without-cluster-enrichment", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "db2-ce", "CA10__engineVersion__c" : "12.1", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[]" }, { "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 399, "conditionText" : "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "docdb-without-cluster-enrichment", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "docdb", "CA10__engineVersion__c" : "5.0.0", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[]" }, { "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 399, "conditionText" : "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "neptune-without-cluster-enrichment", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "neptune", "CA10__engineVersion__c" : "1.4.8.0", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "creating-retains-current-engine-eos", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "creating", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "modifying-retains-current-engine-eos", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "modifying", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "upgrading-retains-current-engine-eos", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "upgrading", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "storage-full-retains-current-engine-eos", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "storage-full", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 401, "conditionText" : "CA10__engineVersion__c.isEmpty()", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "missing-version-and-calendar", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : null }, { "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 401, "conditionText" : "CA10__engineVersion__c.isEmpty()", "runtimeError" : null }, "context" : { "snapshotTime" : "2026-10-27T12:00:00Z" }, "Id" : "whitespace-version", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : " ", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" }, { "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 1099, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays'))", "runtimeError" : null }, "context" : { "snapshotTime" : "2025-10-27T12:00:00Z" }, "Id" : "intraday-before-eos-excluded", "CA10__disappearanceTime__c" : null, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10__engineLifecycleSupport__c" : "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T12:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]" } ] - path: /types/CA10__CaAwsDbInstance__c/object.extracts.yaml md5Hash: E412E6B71C5DC2C28B5C8B6770634E86 content: "---\nextracts:\n - name: CA10A2__engineLifecycleSupportInfo__c\n \ \ value:\n FIELD:\n path: CA10A2__engineLifecycleSupportInfo__c\n\ \ returnType: BYTES\n - name: CA10__engineVersion__c\n value:\n \ \ FIELD:\n path: CA10__engineVersion__c\n undeterminedIf:\n\ \ isEmpty: The instance engine version is missing.\n - name: CA10__cluster__c\n\ \ value:\n FIELD:\n path: CA10__cluster__c\n# Not Nullable. Can't\ \ have no access, retrieved via rds:DescribeDBInstances\n - name: CA10__engine__c\n\ \ value:\n FIELD:\n path: CA10__engine__c\n undeterminedIf:\n\ \ isEmpty: \"Corrupted data. DB Instance Engine cannot be empty.\"\n\ # Not Nullable. Can't have no access, retrieved via rds:DescribeDBInstances\n\ \ - name: CA10__endpointPort__c\n value:\n FIELD:\n path: CA10__endpointPort__c\n\ \ undeterminedIf:\n isEmpty: \"Corrupted data. DB Endpoint Port\ \ cannot be empty.\"\n# Checkbox. Can't have no access, retrieved via rds:DescribeDBInstances\n\ \ - name: CA10__publiclyAccessible__c\n value:\n FIELD:\n path:\ \ CA10__publiclyAccessible__c\n# Checkbox. Can't have no access, retrieved via\ \ rds:DescribeDBInstances\n - name: CA10__storageEncrypted__c\n value: \n\ \ FIELD:\n path: CA10__storageEncrypted__c\n# Checkbox. Can't have\ \ no access, retrieved via rds:DescribeDBInstances\n - name: CA10__autoMinorVersionUpgrade__c\n\ \ value: \n FIELD:\n path: CA10__autoMinorVersionUpgrade__c\n\ # Checkbox. Can't have no access, retrieved via rds:DescribeDBInstances\n -\ \ name: CA10__multiAz__c\n value: \n FIELD:\n path: CA10__multiAz__c\n\ # Nullable. Values: available, backing-up, creating ...\n - name: \"CA10__status__c\"\ \n value:\n FIELD:\n path: \"CA10__status__c\"\n undeterminedIf:\n\ \ isEmpty: \"The instance status is empty, so the policy cannot determine\ \ whether the instance is available.\"\n# Nullable.\n - name: \"CA10__createTime__c\"\ \n value:\n FIELD:\n path: \"CA10__createTime__c\"\n undeterminedIf:\n\ \ isEmpty: \"The instance creation time is empty, so the policy cannot\ \ confirm a full evaluation period.\"\n# Nullable.\n - name: \"CA10__averageCpuOneMonth__c\"\ \n value:\n FIELD:\n path: \"CA10__averageCpuOneMonth__c\"\n\ # Nullable.\n - name: \"CA10__regionName__c\"\n value:\n FIELD:\n \ \ path: \"CA10__regionName__c\"\n# Nullable.\n - name: \"CA10__diskReadIopsAvg30d__c\"\ \n value:\n FIELD:\n path: \"CA10__diskReadIopsAvg30d__c\"\n\ # Nullable.\n - name: \"CA10__diskWriteIopsAvg30d__c\"\n value:\n FIELD:\n\ \ path: \"CA10__diskWriteIopsAvg30d__c\"\n# Nullable.\n - name: \"CA10__databaseConnectionsAvg30d__c\"\ \n value:\n FIELD:\n path: \"CA10__databaseConnectionsAvg30d__c\"\ \n# Nullable.\n - name: \"CA10__databaseConnectionsMax30d__c\"\n value:\n\ \ FIELD:\n path: \"CA10__databaseConnectionsMax30d__c\"\n# Not nullable.\ \ Can't have no access, retrieved via rds:DescribeDBInstances\n - name: \"\ CA10__backupRetentionPeriod__c\"\n value:\n FIELD:\n path: \"\ CA10__backupRetentionPeriod__c\"\n# Text.\n - name: CA10__masterUsername__c\n\ \ value:\n FIELD:\n path: CA10__masterUsername__c\n# Checkbox.\n\ \ - name: CA10__iamDatabaseAuthenticationEnabled__c\n value:\n FIELD:\n\ \ path: CA10__iamDatabaseAuthenticationEnabled__c\n# Text.\n - name:\ \ CA10__enabledCloudWatchLogsExports__c\n value:\n FIELD:\n path:\ \ CA10__enabledCloudWatchLogsExports__c\n# Checkbox.\n - name: CA10__deletionProtection__c\n\ \ value:\n FIELD:\n path: CA10__deletionProtection__c\n# Nullable.\ \ Can't have no access, retrieved via rds:DescribeDBInstances\n - name: CA10__clusterArn__c\n\ \ value:\n FIELD:\n path: CA10__clusterArn__c\n# Not nullable.\ \ Can't have no access, retrieved via rds:DescribeDBInstances\n - name: \"\ CA10__monitoringInterval__c\"\n value:\n FIELD:\n path: \"CA10__monitoringInterval__c\"\ \n# Checkbox.\n - name: CA10__copyTagsToSnapshot__c\n value:\n FIELD:\n\ \ path: CA10__copyTagsToSnapshot__c\n" - path: /types/CA10__CaAwsDbInstance__c/instance-engine-support.extracts.yaml md5Hash: 4A104A9A6CD44B472ECDBA0065FE86D5 content: | --- extracts: # Parse the collected JSON once, preserving phase names and timestamp strings. - name: caJsonFrom__instanceEngineLifecycle value: JSON_FROM: arg: EXTRACT: CA10A2__engineLifecycleSupportInfo__c undeterminedIf: isEmpty: The instance engine support calendar is missing. isInvalid: The instance engine support calendar is invalid JSON. # Require one standard phase and at most one Extended Support phase, regardless of array order. # sort compares strings; chronological ordering assumes the native, consistently formatted UTC timestamps. - name: caJsonQueryBoolean__instanceEngineCalendarValid value: JSON_QUERY_BOOLEAN: arg: EXTRACT: caJsonFrom__instanceEngineLifecycle expression: >- type(@) == 'array' && length([?LifecycleSupportName == 'open-source-rds-standard-support']) == `1` && length([?LifecycleSupportName == 'open-source-rds-extended-support']) <= `1` && length([?LifecycleSupportName != 'open-source-rds-standard-support' && LifecycleSupportName != 'open-source-rds-extended-support']) == `0` && length([?type(LifecycleSupportStartDate) != 'string' || type(LifecycleSupportEndDate) != 'string']) == `0` && length([?sort([LifecycleSupportStartDate, LifecycleSupportEndDate])[0] != LifecycleSupportStartDate]) == `0` && (length([?LifecycleSupportName == 'open-source-rds-extended-support']) == `0` || sort([([?LifecycleSupportName == 'open-source-rds-standard-support'] | [0].LifecycleSupportEndDate), ([?LifecycleSupportName == 'open-source-rds-extended-support'] | [0].LifecycleSupportStartDate)])[0] == ([?LifecycleSupportName == 'open-source-rds-standard-support'] | [0].LifecycleSupportEndDate)) undeterminedIf: evaluationError: The instance engine support calendar cannot be interpreted. resultTypeMismatch: The instance engine support calendar has an unexpected structure. # Midnight starts and inclusive end-of-day timestamps preserve AWS day boundaries in TODAY checks. - name: caJsonQueryBoolean__instanceEngineCalendarWholeDays value: JSON_QUERY_BOOLEAN: arg: EXTRACT: caJsonFrom__instanceEngineLifecycle expression: >- length([?length(LifecycleSupportStartDate) != `24` || length(LifecycleSupportEndDate) != `24` || !ends_with(LifecycleSupportStartDate, 'T00:00:00.000Z') || !ends_with(LifecycleSupportEndDate, 'T23:59:59.999Z')]) == `0` undeterminedIf: evaluationError: The calendar timestamp precision cannot be interpreted. resultTypeMismatch: The calendar timestamp precision has an unexpected structure. # Zero means no Extended Support phase was published; this does not establish enrollment. - name: caJsonQueryNumber__instanceEngineExtendedPhaseCount value: JSON_QUERY_NUMBER: arg: EXTRACT: caJsonFrom__instanceEngineLifecycle expression: "length([?LifecycleSupportName == 'open-source-rds-extended-support'])" undeterminedIf: evaluationError: The Extended Support phase cannot be interpreted. resultTypeMismatch: The Extended Support phase has an unexpected structure. # Select dates by phase name, then parse ISO 8601 for date operations; validate the calendar first. # shortcut: DATE_TIME_FROM normalizes impossible month-days; add strict validation if calendars stop coming directly from AWS. - name: caDateTimeFrom__instanceEngineStandardStart value: DATE_TIME_FROM: arg: JSON_QUERY_TEXT: arg: EXTRACT: caJsonFrom__instanceEngineLifecycle expression: "[?LifecycleSupportName == 'open-source-rds-standard-support'] | [0].LifecycleSupportStartDate" undeterminedIf: evaluationError: The standard support start date cannot be read. resultTypeMismatch: The standard support start date is missing or invalid. format: ISO_8601 undeterminedIf: invalidFormat: The standard support start date is invalid. - name: caDateTimeFrom__instanceEngineStandardEnd value: DATE_TIME_FROM: arg: JSON_QUERY_TEXT: arg: EXTRACT: caJsonFrom__instanceEngineLifecycle expression: "[?LifecycleSupportName == 'open-source-rds-standard-support'] | [0].LifecycleSupportEndDate" undeterminedIf: evaluationError: The standard support end date cannot be read. resultTypeMismatch: The standard support end date is missing or invalid. format: ISO_8601 undeterminedIf: invalidFormat: The standard support end date is invalid. # Read Extended Support dates only after confirming that the optional phase exists. - name: caDateTimeFrom__instanceEngineExtendedStart value: DATE_TIME_FROM: arg: JSON_QUERY_TEXT: arg: EXTRACT: caJsonFrom__instanceEngineLifecycle expression: "[?LifecycleSupportName == 'open-source-rds-extended-support'] | [0].LifecycleSupportStartDate" undeterminedIf: evaluationError: The Extended Support start date cannot be read. resultTypeMismatch: The Extended Support start date is missing or invalid. format: ISO_8601 undeterminedIf: invalidFormat: The Extended Support start date is invalid. - name: caDateTimeFrom__instanceEngineExtendedEnd value: DATE_TIME_FROM: arg: JSON_QUERY_TEXT: arg: EXTRACT: caJsonFrom__instanceEngineLifecycle expression: "[?LifecycleSupportName == 'open-source-rds-extended-support'] | [0].LifecycleSupportEndDate" undeterminedIf: evaluationError: The Extended Support end date cannot be read. resultTypeMismatch: The Extended Support end date is missing or invalid. format: ISO_8601 undeterminedIf: invalidFormat: The Extended Support end date is invalid. script: |- CREATE TEMP FUNCTION mock_ExpectedResult() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "Id" : "standard-support", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "standard-start-exact", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "standard-end-exact", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "extended-start-exact", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "extended-support", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "extended-end-exact", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "final-support-expired", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1399, "conditionText" : "extract('caDateTimeFrom__instanceEngineExtendedEnd').beforeToday()", "runtimeError" : null } }, { "Id" : "before-support-start", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 899, "conditionText" : "extract('caDateTimeFrom__instanceEngineStandardStart').afterToday()", "runtimeError" : null } }, { "Id" : "reversed-phases", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "standard-only-mariadb", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "standard-only-expired", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1299, "conditionText" : "extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') == number(0.0)", "runtimeError" : null } }, { "Id" : "empty-calendar", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null } }, { "Id" : "missing-calendar", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 499, "conditionText" : "extract('CA10__engineVersion__c').isNotEmpty() && extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty()", "runtimeError" : null } }, { "Id" : "invalid-json", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 502, "conditionText" : "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", "runtimeError" : "Expected property name or '}' in JSON at position 1 (line 1 column 2)" } }, { "Id" : "wrong-root", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null } }, { "Id" : "missing-standard", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null } }, { "Id" : "duplicate-standard", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null } }, { "Id" : "duplicate-extended", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null } }, { "Id" : "unknown-phase", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null } }, { "Id" : "invalid-standard-date", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null } }, { "Id" : "invalid-future-extended-date", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null } }, { "Id" : "inverted-standard", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null } }, { "Id" : "inverted-extended", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null } }, { "Id" : "overlapping-phases", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 599, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", "runtimeError" : null } }, { "Id" : "intraday-date", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 999, "conditionText" : "extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays'))", "runtimeError" : null } }, { "Id" : "missing-version", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 401, "conditionText" : "CA10__engineVersion__c.isEmpty()", "runtimeError" : null } }, { "Id" : "missing-engine", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "301", "conditionText" : "CA10__engine__c.isEmpty()", "runtimeError" : null } }, { "Id" : "missing-status", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : "201", "conditionText" : "CA10__status__c.isEmpty()", "runtimeError" : null } }, { "Id" : "commercial-no-calendar", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 399, "conditionText" : "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))", "runtimeError" : null } }, { "Id" : "unknown-engine", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 399, "conditionText" : "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))", "runtimeError" : null } }, { "Id" : "enrollment-disabled-standard", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "enrollment-disabled-extended", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "cluster-member", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : "199", "conditionText" : "extract('CA10__cluster__c').isNotEmpty() || extract('CA10__clusterArn__c').isNotEmpty()", "runtimeError" : null } }, { "Id" : "cluster-arn-only", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : "199", "conditionText" : "extract('CA10__cluster__c').isNotEmpty() || extract('CA10__clusterArn__c').isNotEmpty()", "runtimeError" : null } }, { "Id" : "deleting", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : "299", "conditionText" : "extract('CA10__status__c') == 'deleting'", "runtimeError" : null } }, { "Id" : "stopped-extended", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "disappeared", "expectedResult" : { "status" : "DISAPPEARED", "conditionIndex" : "99", "conditionText" : "isDisappeared(CA10__disappearanceTime__c)", "runtimeError" : null } }, { "Id" : "between-support-phases", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1499, "conditionText" : "extract('caDateTimeFrom__instanceEngineExtendedStart').afterToday()", "runtimeError" : null } }, { "Id" : "unparseable-standard-month", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 705, "conditionText" : "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportStartDate').checkIso8601()", "runtimeError" : null } }, { "Id" : "unparseable-future-extended-month", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 713, "conditionText" : "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportStartDate').checkIso8601()", "runtimeError" : null } }, { "Id" : "valid-leap-day-end", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "intraday-extended-end-retains-standard-eos", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 999, "runtimeError" : null, "conditionText" : "extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays'))" } }, { "Id" : "aurora-without-membership", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 399, "runtimeError" : null, "conditionText" : "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))" } }, { "Id" : "mysql80-eos", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "mysql80-standard-last-day", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "mysql80-extended-first-day", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "mysql84-standard-support", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "mysql57-extended-support-longer-than-three-years", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "mysql57-extended-last-day", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "mysql57-final-support-expired", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1399, "conditionText" : "extract('caDateTimeFrom__instanceEngineExtendedEnd').beforeToday()", "runtimeError" : null } }, { "Id" : "postgres-rds-patch-suffix", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "mariadb106-current-standard-support", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "mariadb106-standard-last-day", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 1199, "conditionText" : "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "mariadb106-first-unsupported-day", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1299, "conditionText" : "extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') == number(0.0)", "runtimeError" : null } }, { "Id" : "mariadb-invalid-extended-support", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 699, "conditionText" : "extract('CA10__engine__c') == 'mariadb' && extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') != number(0.0)", "runtimeError" : null } }, { "Id" : "db2-ce-without-cluster-enrichment", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 399, "conditionText" : "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))", "runtimeError" : null } }, { "Id" : "docdb-without-cluster-enrichment", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 399, "conditionText" : "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))", "runtimeError" : null } }, { "Id" : "neptune-without-cluster-enrichment", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 399, "conditionText" : "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))", "runtimeError" : null } }, { "Id" : "creating-retains-current-engine-eos", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "modifying-retains-current-engine-eos", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "upgrading-retains-current-engine-eos", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "storage-full-retains-current-engine-eos", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1500, "conditionText" : "otherwise", "runtimeError" : null } }, { "Id" : "missing-version-and-calendar", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 401, "conditionText" : "CA10__engineVersion__c.isEmpty()", "runtimeError" : null } }, { "Id" : "whitespace-version", "expectedResult" : { "status" : "UNDETERMINED", "conditionIndex" : 401, "conditionText" : "CA10__engineVersion__c.isEmpty()", "runtimeError" : null } }, { "Id" : "intraday-before-eos-excluded", "expectedResult" : { "status" : "INAPPLICABLE", "conditionIndex" : 1099, "conditionText" : "not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays'))", "runtimeError" : null } } ]; """; CREATE TEMP FUNCTION mock_CA10__CaAwsDbInstance__c() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "context" : { "snapshotTime" : new Date("2025-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "standard-support" }, { "context" : { "snapshotTime" : new Date("2021-02-24T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "standard-start-exact" }, { "context" : { "snapshotTime" : new Date("2026-02-28T23:59:59.999Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "standard-end-exact" }, { "context" : { "snapshotTime" : new Date("2026-03-01T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "extended-start-exact" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "extended-support" }, { "context" : { "snapshotTime" : new Date("2029-02-28T23:59:59.999Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "extended-end-exact" }, { "context" : { "snapshotTime" : new Date("2029-03-01T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "final-support-expired" }, { "context" : { "snapshotTime" : new Date("2021-02-23T23:59:59.999Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "before-support-start" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"}]", "Id" : "reversed-phases" }, { "context" : { "snapshotTime" : new Date("2025-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.6.25", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2022-02-03T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-12-31T23:59:59.999Z\"}]", "Id" : "standard-only-mariadb" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.5.29", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-01-21T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-08-31T23:59:59.999Z\"}]", "Id" : "standard-only-expired" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[]", "Id" : "empty-calendar" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : null, "Id" : "missing-calendar" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "{broken", "Id" : "invalid-json" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "{}", "Id" : "wrong-root" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "missing-standard" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "duplicate-standard" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "duplicate-extended" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"unknown-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "unknown-phase" }, { "context" : { "snapshotTime" : new Date("2025-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"not-a-date\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "invalid-standard-date" }, { "context" : { "snapshotTime" : new Date("2025-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"not-a-date\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "invalid-future-extended-date" }, { "context" : { "snapshotTime" : new Date("2025-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2028-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "inverted-standard" }, { "context" : { "snapshotTime" : new Date("2025-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2025-02-28T23:59:59.999Z\"}]", "Id" : "inverted-extended" }, { "context" : { "snapshotTime" : new Date("2025-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-02-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "overlapping-phases" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T12:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T12:00:00.000Z\"}]", "Id" : "intraday-date" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "missing-version" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "missing-engine" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "missing-status" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "oracle-ee", "CA10__engineVersion__c" : "19.0.0.0.ru-2026-07.r1", "CA10A2__engineLifecycleSupportInfo__c" : "[]", "Id" : "commercial-no-calendar" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "future-db", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "unknown-engine" }, { "context" : { "snapshotTime" : new Date("2025-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "enrollment-disabled-standard" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "enrollment-disabled-extended" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "synthetic-cluster", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : null, "Id" : "cluster-member" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "arn:aws:rds:us-east-1:000000000000:cluster:synthetic", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : null, "Id" : "cluster-arn-only" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "deleting", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : null, "Id" : "deleting" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "stopped", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "stopped-extended" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__disappearanceTime__c" : new Date("2026-10-22T12:00:00Z"), "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : null, "Id" : "disappeared" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2027-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "between-support-phases" }, { "context" : { "snapshotTime" : new Date("2025-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-13-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "unparseable-standard-month" }, { "context" : { "snapshotTime" : new Date("2025-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-13-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "unparseable-future-extended-month" }, { "context" : { "snapshotTime" : new Date("2028-02-29T23:59:59.999Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.11.16", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2023-08-21T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2028-02-29T23:59:59.999Z\"}]", "Id" : "valid-leap-day-end" }, { "context" : { "snapshotTime" : new Date("2029-02-28T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T12:00:00.000Z\"}]", "Id" : "intraday-extended-end-retains-standard-eos" }, { "context" : { "snapshotTime" : new Date("2025-10-23T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "aurora-without-membership" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "8.0.40", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2018-10-23T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-07-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-08-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-07-31T23:59:59.999Z\"}]", "Id" : "mysql80-eos" }, { "context" : { "snapshotTime" : new Date("2026-07-31T23:59:59.999Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "8.0.46", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2018-10-23T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-07-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-08-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-07-31T23:59:59.999Z\"}]", "Id" : "mysql80-standard-last-day" }, { "context" : { "snapshotTime" : new Date("2026-08-01T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "8.0.46", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2018-10-23T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-07-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-08-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-07-31T23:59:59.999Z\"}]", "Id" : "mysql80-extended-first-day" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "8.4.8", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2024-11-21T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-07-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2029-08-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-07-31T23:59:59.999Z\"}]", "Id" : "mysql84-standard-support" }, { "context" : { "snapshotTime" : new Date("2028-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "5.7.44-rds.20260902", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2016-02-22T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2024-02-29T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2024-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-06-30T23:59:59.999Z\"}]", "Id" : "mysql57-extended-support-longer-than-three-years" }, { "context" : { "snapshotTime" : new Date("2029-06-30T23:59:59.999Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "5.7.44-rds.20260902", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2016-02-22T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2024-02-29T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2024-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-06-30T23:59:59.999Z\"}]", "Id" : "mysql57-extended-last-day" }, { "context" : { "snapshotTime" : new Date("2029-07-01T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "5.7.44-rds.20260902", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2016-02-22T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2024-02-29T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2024-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-06-30T23:59:59.999Z\"}]", "Id" : "mysql57-final-support-expired" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23-rds.20260224", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "postgres-rds-patch-suffix" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.6.25", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2022-02-03T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-12-31T23:59:59.999Z\"}]", "Id" : "mariadb106-current-standard-support" }, { "context" : { "snapshotTime" : new Date("2026-12-31T23:59:59.999Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.6.25", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2022-02-03T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-12-31T23:59:59.999Z\"}]", "Id" : "mariadb106-standard-last-day" }, { "context" : { "snapshotTime" : new Date("2027-01-01T00:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.6.25", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2022-02-03T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-12-31T23:59:59.999Z\"}]", "Id" : "mariadb106-first-unsupported-day" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.6.25", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "mariadb-invalid-extended-support" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "db2-ce", "CA10__engineVersion__c" : "12.1", "CA10A2__engineLifecycleSupportInfo__c" : "[]", "Id" : "db2-ce-without-cluster-enrichment" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "docdb", "CA10__engineVersion__c" : "5.0.0", "CA10A2__engineLifecycleSupportInfo__c" : "[]", "Id" : "docdb-without-cluster-enrichment" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "neptune", "CA10__engineVersion__c" : "1.4.8.0", "CA10A2__engineLifecycleSupportInfo__c" : "[]", "Id" : "neptune-without-cluster-enrichment" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "creating", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "creating-retains-current-engine-eos" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "modifying", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "modifying-retains-current-engine-eos" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "upgrading", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "upgrading-retains-current-engine-eos" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "storage-full", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "storage-full-retains-current-engine-eos" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "", "CA10A2__engineLifecycleSupportInfo__c" : null, "Id" : "missing-version-and-calendar" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : " ", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "whitespace-version" }, { "context" : { "snapshotTime" : new Date("2025-10-27T12:00:00Z") }, "CA10__cluster__c" : "", "CA10__clusterArn__c" : "", "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2021-02-24T12:00:00.000Z\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"}]", "Id" : "intraday-before-eos-excluded" } ]; """; CREATE TEMP FUNCTION process_CA10__CaAwsDbInstance__c( obj STRUCT< CA10__disappearanceTime__c TIMESTAMP, CA10__cluster__c STRING, CA10__clusterArn__c STRING, CA10__status__c STRING, CA10__engine__c STRING, CA10__engineVersion__c STRING, CA10A2__engineLifecycleSupportInfo__c STRING, Id STRING >, snapshotTime TIMESTAMP ) RETURNS STRUCT DETERMINISTIC LANGUAGE js OPTIONS (library=['gs://compliance-platform-public/jmespath.min.js']) AS r""" var TextLib = new function () { this.normalize = function(arg) { return arg == null ? '' : arg.replace(/\s+/g, ' ').trim().toLowerCase(); }; this.isEmpty = function(arg) { return this.normalize(arg) == ''; }; this.isNotEmpty = function(arg) { return this.normalize(arg) != ''; }; this.equal = function(left, right) { return this.normalize(left) == this.normalize(right); }; this.notEqual = function(left, right) { return this.normalize(left) != this.normalize(right); }; this.startsWith = function(arg, substring) { return this.normalize(arg).startsWith(this.normalize(substring)); }; this.endsWith = function(arg, substring) { return this.normalize(arg).endsWith(this.normalize(substring)); }; this.contains = function(arg, substring) { return this.normalize(arg).includes(this.normalize(substring)); }; this.containsAll = function(arg, substrings) { if (substrings == null || substrings.length === 0) return false; let normalizedArg = this.normalize(arg); return substrings.every(sub => normalizedArg.includes(this.normalize(sub))); }; this.containsAny = function(arg, substrings) { if (substrings == null || substrings.length === 0) return false; let normalizedArg = this.normalize(arg); return substrings.some(sub => normalizedArg.includes(this.normalize(sub))); }; }(); var BytesLib = new function () { this.normalize = function(arg) { return arg == null ? '' : arg; }; this.isEmpty = function(arg) { return this.normalize(arg) == ''; }; this.isNotEmpty = function(arg) { return this.normalize(arg) != ''; }; this.equal = function(left, right) { return this.normalize(left) == this.normalize(right); }; this.notEqual = function(left, right) { return this.normalize(left) != this.normalize(right); }; this.startsWith = function(arg, substring) { return this.normalize(arg).startsWith(this.normalize(substring)); }; this.endsWith = function(arg, substring) { return this.normalize(arg).endsWith(this.normalize(substring)); }; this.contains = function(arg, substring) { return this.normalize(arg).includes(this.normalize(substring)); }; this.containsAll = function(arg, substrings) { if (substrings == null || substrings.length === 0) return false; let normalizedArg = this.normalize(arg); return substrings.every(sub => normalizedArg.includes(this.normalize(sub))); }; this.containsAny = function(arg, substrings) { if (substrings == null || substrings.length === 0) return false; let normalizedArg = this.normalize(arg); return substrings.some(sub => normalizedArg.includes(this.normalize(sub))); }; }(); var TemporalLib = new function () { var iso8601regex = /^([\+-]?\d{4}(?!\d{2}\b))((-?)((0[1-9]|1[0-2])(\3([12]\d|0[1-9]|3[01]))?|W([0-4]\d|5[0-2])(-?[1-7])?|(00[1-9]|0[1-9]\d|[12]\d{2}|3([0-5]\d|6[1-6])))([T\s]((([01]\d|2[0-3])((:?)[0-5]\d)?|24\:?00)([\.,]\d+(?!:))?)?(\17[0-5]\d([\.,]\d+)?)?([zZ]|([\+-])([01]\d|2[0-3]):?([0-5]\d)?)?)?)?$/ this.checkIso8601 = function(arg) { return arg == null || iso8601regex.test(arg); }; this.parseIso8601 = function(arg) { return arg == null ? null: new Date(arg); }; this.replaceNullValues = function(arg, nullValues) { for (var i = 0; i < nullValues.length; i++) { if (TextLib.equal(arg, nullValues[i])) { return null; } } return arg; }; }(); var IsEmptyLib = new function () { this.simpleIsEmpty = function(arg) { return arg == null; }; this.simpleIsNotEmpty = function(arg) { return arg != null; }; }(); var CollectionLib = new function () { this.parse = function(arg, separator, skipEmpty, skipDuplicates, sort, normalize) { if (arg == null) return []; let parts = arg.split(separator); return this.fromArray(parts, skipEmpty, skipDuplicates, sort, normalize); }; this.fromArray = function(arr, skipEmpty, skipDuplicates, sort, normalize) { if (arr == null) return []; let result = []; let seen = new Set(); arr.forEach(el => { let normalized = normalize ? TextLib.normalize(el) : BytesLib.normalize(el); if (!skipEmpty || (normalize ? TextLib.isNotEmpty(el) : BytesLib.isNotEmpty(el))) { if (!skipDuplicates || !seen.has(normalized)) { if (skipDuplicates) seen.add(normalized); result.push(normalized); } } }); if (sort) result.sort(); return result; }; this.equal = function(left, right) { left = left == null ? [] : left; right = right == null ? [] : right; if (left.length !== right.length) return false; for (let i = 0; i < left.length; i++) { if (left[i] !== right[i]) return false; } return true; }; this.notEqual = function(left, right) { return !this.equal(left, right); }; this.size = function(collection) { return collection == null ? 0 : collection.length; }; this.startsWith = function(collection, search, normalize) { if (collection == null || collection.length === 0) return false; let normalizedSearch = normalize ? TextLib.normalize(search) : BytesLib.normalize(search); return collection[0] === normalizedSearch; }; this.endsWith = function(collection, search, normalize) { if (collection == null || collection.length === 0) return false; let normalizedSearch = normalize ? TextLib.normalize(search) : BytesLib.normalize(search); return collection[collection.length - 1] === normalizedSearch; }; this.contains = function(collection, search, normalize) { if (collection == null || collection.length === 0) return false; return collection.includes(normalize ? TextLib.normalize(search) : BytesLib.normalize(search)); }; this.containsAll = function(collection, searchArray, normalize) { if (collection == null || collection.length === 0 || searchArray == null || searchArray.length === 0) return false; return searchArray.every(search => collection.includes(normalize ? TextLib.normalize(search) : BytesLib.normalize(search))); }; this.containsAny = function(collection, searchArray, normalize) { if (collection == null || collection.length === 0 || searchArray == null || searchArray.length === 0) return false; return searchArray.some(search => collection.includes(normalize ? TextLib.normalize(search) : BytesLib.normalize(search))); }; }(); var todayPlus1Day = new Date(snapshotTime.toISOString().substr(0,10)+'T00:00:00.000Z').getTime() + (1 * 86400000); var today = new Date(snapshotTime.toISOString().substr(0,10)+'T00:00:00.000Z').getTime(); var references1 = []; // condition[0], conditionIndex:[0..99] references1.push('Deleted From AWS [CA10__disappearanceTime__c]: ' + obj.CA10__disappearanceTime__c); if (obj.CA10__disappearanceTime__c != null) { return {status: 'DISAPPEARED', conditionIndex: 99, conditionText: "isDisappeared(CA10__disappearanceTime__c)", currentStateMessage: "Object is deleted in the source", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } // condition[1], conditionIndex:[100..199] function extract3() { if (!this.out) { this.out = obj.CA10__cluster__c; } return this.out; }; function extract6() { if (!this.out) { this.out = obj.CA10__clusterArn__c; } return this.out; }; references1.push('Cluster [obj.CA10__cluster__c]: ' + obj.CA10__cluster__c); references1.push('Cluster ARN [obj.CA10__clusterArn__c]: ' + obj.CA10__clusterArn__c); if (TextLib.isNotEmpty(extract3.call(extract3)) || TextLib.isNotEmpty(extract6.call(extract6))) { return {status: 'INAPPLICABLE', conditionIndex: 199, conditionText: "extract('CA10__cluster__c').isNotEmpty() || extract('CA10__clusterArn__c').isNotEmpty()", currentStateMessage: "This instance belongs to a DB cluster; assess engine support once on the cluster.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } // condition[2], conditionIndex:[200..299] function fieldChecked10() { if (TextLib.isEmpty(obj.CA10__status__c)) { throw new Error("UNDETERMINED condition:201", {cause: {status: 'UNDETERMINED', conditionIndex: 201, conditionText: "CA10__status__c.isEmpty()", currentStateMessage: "The instance status is empty, so the policy cannot determine whether the instance is available.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__status__c; } function extract9() { if (!this.out) { this.out = fieldChecked10(); } return this.out; }; references1.push('Status [obj.CA10__status__c]: ' + obj.CA10__status__c); try { if (TextLib.equal(extract9.call(extract9), 'deleting')) { return {status: 'INAPPLICABLE', conditionIndex: 299, conditionText: "extract('CA10__status__c') == 'deleting'", currentStateMessage: "The DB instance is being deleted.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[3], conditionIndex:[300..399] function fieldChecked13() { if (TextLib.isEmpty(obj.CA10__engine__c)) { throw new Error("UNDETERMINED condition:301", {cause: {status: 'UNDETERMINED', conditionIndex: 301, conditionText: "CA10__engine__c.isEmpty()", currentStateMessage: "Corrupted data. DB Instance Engine cannot be empty.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__engine__c; } function extract12() { if (!this.out) { this.out = fieldChecked13(); } return this.out; }; references1.push('Engine [obj.CA10__engine__c]: ' + obj.CA10__engine__c); try { if (!CollectionLib.contains(CollectionLib.fromArray(['mysql', 'postgres', 'mariadb'], true, true, true, true), extract12.call(extract12), true)) { return {status: 'INAPPLICABLE', conditionIndex: 399, conditionText: "not(setOfText(['mysql', 'postgres', 'mariadb']).contains(extract('CA10__engine__c')))", currentStateMessage: "This policy only assesses MySQL, PostgreSQL, and MariaDB engines.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[4], conditionIndex:[400..499] function fieldChecked16() { if (TextLib.isEmpty(obj.CA10__engineVersion__c)) { throw new Error("UNDETERMINED condition:401", {cause: {status: 'UNDETERMINED', conditionIndex: 401, conditionText: "CA10__engineVersion__c.isEmpty()", currentStateMessage: "The instance engine version is missing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__engineVersion__c; } function extract15() { if (!this.out) { this.out = fieldChecked16(); } return this.out; }; function extract18() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; references1.push('Engine Version Name [obj.CA10__engineVersion__c]: ' + obj.CA10__engineVersion__c); references1.push('Engine Lifecycle Support Info [obj.CA10A2__engineLifecycleSupportInfo__c]: ' + obj.CA10A2__engineLifecycleSupportInfo__c); try { if (TextLib.isNotEmpty(extract15.call(extract15)) && BytesLib.isEmpty(extract18.call(extract18))) { return {status: 'INAPPLICABLE', conditionIndex: 499, conditionText: "extract('CA10__engineVersion__c').isNotEmpty() && extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty()", currentStateMessage: "The optional native engine lifecycle calendar is not populated; this policy excludes engines without collected calendar enrichment.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[5], conditionIndex:[500..599] function jsonQueryChecked22() { var input = extract24.call(extract24); var out; try { out = jmespath.search(input, 'type(@) == \'array\' && length([?LifecycleSupportName == \'open-source-rds-standard-support\']) == `1` && length([?LifecycleSupportName == \'open-source-rds-extended-support\']) <= `1` && length([?LifecycleSupportName != \'open-source-rds-standard-support\' && LifecycleSupportName != \'open-source-rds-extended-support\']) == `0` && length([?type(LifecycleSupportStartDate) != \'string\' || type(LifecycleSupportEndDate) != \'string\']) == `0` && length([?sort([LifecycleSupportStartDate, LifecycleSupportEndDate])[0] != LifecycleSupportStartDate]) == `0` && (length([?LifecycleSupportName == \'open-source-rds-extended-support\']) == `0` || sort([([?LifecycleSupportName == \'open-source-rds-standard-support\'] | [0].LifecycleSupportEndDate), ([?LifecycleSupportName == \'open-source-rds-extended-support\'] | [0].LifecycleSupportStartDate)])[0] == ([?LifecycleSupportName == \'open-source-rds-standard-support\'] | [0].LifecycleSupportEndDate))'); if (out != null && typeof out != 'boolean') { throw new Error("UNDETERMINED condition:503", {cause: {status: 'UNDETERMINED', conditionIndex: 503, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('type(@) == \\'array\\' && length([?LifecycleSupportName == \\'open-source-rds-standard-support\\']) == `1` && length([?LifecycleSupportName == \\'open-source-rds-extended-support\\']) <= `1` && length([?LifecycleSupportName != \\'open-source-rds-standard-support\\' && LifecycleSupportName != \\'open-source-rds-extended-support\\']) == `0` && length([?type(LifecycleSupportStartDate) != \\'string\\' || type(LifecycleSupportEndDate) != \\'string\\']) == `0` && length([?sort([LifecycleSupportStartDate, LifecycleSupportEndDate])[0] != LifecycleSupportStartDate]) == `0` && (length([?LifecycleSupportName == \\'open-source-rds-extended-support\\']) == `0` || sort([([?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate), ([?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportStartDate)])[0] == ([?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate))').isResultTypeMismatch()", currentStateMessage: "The instance engine support calendar has an unexpected structure.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:504", {cause: {status: 'UNDETERMINED', conditionIndex: 504, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('type(@) == \\'array\\' && length([?LifecycleSupportName == \\'open-source-rds-standard-support\\']) == `1` && length([?LifecycleSupportName == \\'open-source-rds-extended-support\\']) <= `1` && length([?LifecycleSupportName != \\'open-source-rds-standard-support\\' && LifecycleSupportName != \\'open-source-rds-extended-support\\']) == `0` && length([?type(LifecycleSupportStartDate) != \\'string\\' || type(LifecycleSupportEndDate) != \\'string\\']) == `0` && length([?sort([LifecycleSupportStartDate, LifecycleSupportEndDate])[0] != LifecycleSupportStartDate]) == `0` && (length([?LifecycleSupportName == \\'open-source-rds-extended-support\\']) == `0` || sort([([?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate), ([?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportStartDate)])[0] == ([?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate))').isEvaluationFailed()", currentStateMessage: "The instance engine support calendar cannot be interpreted.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function jsonChecked25() { var input = extract27.call(extract27); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:501", {cause: {status: 'UNDETERMINED', conditionIndex: 501, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The instance engine support calendar is missing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } var out; try { out = JSON.parse(input); } catch (e) { throw new Error("UNDETERMINED condition:502", {cause: {status: 'UNDETERMINED', conditionIndex: 502, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The instance engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract27() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract24() { if (!this.out) { this.out = jsonChecked25(); } return this.out; }; function extract21() { if (!this.out) { this.out = jsonQueryChecked22(); } return this.out; }; try { if (!extract21.call(extract21)) { return {status: 'UNDETERMINED', conditionIndex: 599, conditionText: "not(extract('caJsonQueryBoolean__instanceEngineCalendarValid'))", currentStateMessage: "The engine support calendar is missing named phases, has duplicate or unknown phases, or has invalid UTC date ranges.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[6], conditionIndex:[600..699] function fieldChecked31() { if (TextLib.isEmpty(obj.CA10__engine__c)) { throw new Error("UNDETERMINED condition:601", {cause: {status: 'UNDETERMINED', conditionIndex: 601, conditionText: "CA10__engine__c.isEmpty()", currentStateMessage: "Corrupted data. DB Instance Engine cannot be empty.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__engine__c; } function extract30() { if (!this.out) { this.out = fieldChecked31(); } return this.out; }; function jsonQueryChecked34() { var input = extract36.call(extract36); var out; try { out = jmespath.search(input, 'length([?LifecycleSupportName == \'open-source-rds-extended-support\'])'); if (out != null && typeof out != 'number') { throw new Error("UNDETERMINED condition:604", {cause: {status: 'UNDETERMINED', conditionIndex: 604, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('length([?LifecycleSupportName == \\'open-source-rds-extended-support\\'])').isResultTypeMismatch()", currentStateMessage: "The Extended Support phase has an unexpected structure.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:605", {cause: {status: 'UNDETERMINED', conditionIndex: 605, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('length([?LifecycleSupportName == \\'open-source-rds-extended-support\\'])').isEvaluationFailed()", currentStateMessage: "The Extended Support phase cannot be interpreted.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function jsonChecked37() { var input = extract39.call(extract39); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:602", {cause: {status: 'UNDETERMINED', conditionIndex: 602, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The instance engine support calendar is missing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } var out; try { out = JSON.parse(input); } catch (e) { throw new Error("UNDETERMINED condition:603", {cause: {status: 'UNDETERMINED', conditionIndex: 603, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The instance engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract39() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract36() { if (!this.out) { this.out = jsonChecked37(); } return this.out; }; function extract33() { if (!this.out) { this.out = jsonQueryChecked34(); } return this.out; }; try { if (TextLib.equal(extract30.call(extract30), 'mariadb') && extract33.call(extract33) != 0.0) { return {status: 'UNDETERMINED', conditionIndex: 699, conditionText: "extract('CA10__engine__c') == 'mariadb' && extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') != number(0.0)", currentStateMessage: "The MariaDB support calendar contains an Extended Support phase, which AWS does not offer for this engine.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[7], conditionIndex:[700..799] function dateChecked43() { var dateTimeFrom44 = jsonQueryChecked45(); if (!TemporalLib.checkIso8601(dateTimeFrom44)) { throw new Error("UNDETERMINED condition:705", {cause: {status: 'UNDETERMINED', conditionIndex: 705, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportStartDate').checkIso8601()", currentStateMessage: "The standard support start date is invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return TemporalLib.parseIso8601(dateTimeFrom44); } function jsonQueryChecked45() { var input = extract47.call(extract47); var out; try { out = jmespath.search(input, '[?LifecycleSupportName == \'open-source-rds-standard-support\'] | [0].LifecycleSupportStartDate'); if (out != null && typeof out != 'string') { throw new Error("UNDETERMINED condition:703", {cause: {status: 'UNDETERMINED', conditionIndex: 703, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportStartDate').isResultTypeMismatch()", currentStateMessage: "The standard support start date is missing or invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:704", {cause: {status: 'UNDETERMINED', conditionIndex: 704, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportStartDate').isEvaluationFailed()", currentStateMessage: "The standard support start date cannot be read.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function jsonChecked48() { var input = extract50.call(extract50); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:701", {cause: {status: 'UNDETERMINED', conditionIndex: 701, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The instance engine support calendar is missing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } var out; try { out = JSON.parse(input); } catch (e) { throw new Error("UNDETERMINED condition:702", {cause: {status: 'UNDETERMINED', conditionIndex: 702, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The instance engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract50() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract47() { if (!this.out) { this.out = jsonChecked48(); } return this.out; }; function extract42() { if (!this.out) { this.out = dateChecked43(); } return this.out; }; function dateChecked54() { var dateTimeFrom55 = jsonQueryChecked56(); if (!TemporalLib.checkIso8601(dateTimeFrom55)) { throw new Error("UNDETERMINED condition:708", {cause: {status: 'UNDETERMINED', conditionIndex: 708, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate').checkIso8601()", currentStateMessage: "The standard support end date is invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return TemporalLib.parseIso8601(dateTimeFrom55); } function jsonQueryChecked56() { var input = extract47.call(extract47); var out; try { out = jmespath.search(input, '[?LifecycleSupportName == \'open-source-rds-standard-support\'] | [0].LifecycleSupportEndDate'); if (out != null && typeof out != 'string') { throw new Error("UNDETERMINED condition:706", {cause: {status: 'UNDETERMINED', conditionIndex: 706, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate').isResultTypeMismatch()", currentStateMessage: "The standard support end date is missing or invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:707", {cause: {status: 'UNDETERMINED', conditionIndex: 707, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate').isEvaluationFailed()", currentStateMessage: "The standard support end date cannot be read.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract53() { if (!this.out) { this.out = dateChecked54(); } return this.out; }; function jsonQueryChecked60() { var input = extract47.call(extract47); var out; try { out = jmespath.search(input, 'length([?LifecycleSupportName == \'open-source-rds-extended-support\'])'); if (out != null && typeof out != 'number') { throw new Error("UNDETERMINED condition:709", {cause: {status: 'UNDETERMINED', conditionIndex: 709, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('length([?LifecycleSupportName == \\'open-source-rds-extended-support\\'])').isResultTypeMismatch()", currentStateMessage: "The Extended Support phase has an unexpected structure.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:710", {cause: {status: 'UNDETERMINED', conditionIndex: 710, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('length([?LifecycleSupportName == \\'open-source-rds-extended-support\\'])').isEvaluationFailed()", currentStateMessage: "The Extended Support phase cannot be interpreted.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract59() { if (!this.out) { this.out = jsonQueryChecked60(); } return this.out; }; function dateChecked64() { var dateTimeFrom65 = jsonQueryChecked66(); if (!TemporalLib.checkIso8601(dateTimeFrom65)) { throw new Error("UNDETERMINED condition:713", {cause: {status: 'UNDETERMINED', conditionIndex: 713, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportStartDate').checkIso8601()", currentStateMessage: "The Extended Support start date is invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return TemporalLib.parseIso8601(dateTimeFrom65); } function jsonQueryChecked66() { var input = extract47.call(extract47); var out; try { out = jmespath.search(input, '[?LifecycleSupportName == \'open-source-rds-extended-support\'] | [0].LifecycleSupportStartDate'); if (out != null && typeof out != 'string') { throw new Error("UNDETERMINED condition:711", {cause: {status: 'UNDETERMINED', conditionIndex: 711, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportStartDate').isResultTypeMismatch()", currentStateMessage: "The Extended Support start date is missing or invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:712", {cause: {status: 'UNDETERMINED', conditionIndex: 712, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportStartDate').isEvaluationFailed()", currentStateMessage: "The Extended Support start date cannot be read.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract63() { if (!this.out) { this.out = dateChecked64(); } return this.out; }; function dateChecked70() { var dateTimeFrom71 = jsonQueryChecked72(); if (!TemporalLib.checkIso8601(dateTimeFrom71)) { throw new Error("UNDETERMINED condition:716", {cause: {status: 'UNDETERMINED', conditionIndex: 716, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportEndDate').checkIso8601()", currentStateMessage: "The Extended Support end date is invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return TemporalLib.parseIso8601(dateTimeFrom71); } function jsonQueryChecked72() { var input = extract47.call(extract47); var out; try { out = jmespath.search(input, '[?LifecycleSupportName == \'open-source-rds-extended-support\'] | [0].LifecycleSupportEndDate'); if (out != null && typeof out != 'string') { throw new Error("UNDETERMINED condition:714", {cause: {status: 'UNDETERMINED', conditionIndex: 714, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportEndDate').isResultTypeMismatch()", currentStateMessage: "The Extended Support end date is missing or invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:715", {cause: {status: 'UNDETERMINED', conditionIndex: 715, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportEndDate').isEvaluationFailed()", currentStateMessage: "The Extended Support end date cannot be read.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract69() { if (!this.out) { this.out = dateChecked70(); } return this.out; }; try { if (!(IsEmptyLib.simpleIsNotEmpty(extract42.call(extract42)) && IsEmptyLib.simpleIsNotEmpty(extract53.call(extract53)) && (extract59.call(extract59) == 0.0 || (IsEmptyLib.simpleIsNotEmpty(extract63.call(extract63)) && IsEmptyLib.simpleIsNotEmpty(extract69.call(extract69)))))) { return {status: 'UNDETERMINED', conditionIndex: 799, conditionText: "not(extract('caDateTimeFrom__instanceEngineStandardStart').isNotEmpty() && extract('caDateTimeFrom__instanceEngineStandardEnd').isNotEmpty() && (extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') == number(0.0) || (extract('caDateTimeFrom__instanceEngineExtendedStart').isNotEmpty() && extract('caDateTimeFrom__instanceEngineExtendedEnd').isNotEmpty())))", currentStateMessage: "The engine support calendar contains an invalid date.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[8], conditionIndex:[800..899] function dateChecked76() { var dateTimeFrom77 = jsonQueryChecked78(); if (!TemporalLib.checkIso8601(dateTimeFrom77)) { throw new Error("UNDETERMINED condition:805", {cause: {status: 'UNDETERMINED', conditionIndex: 805, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportStartDate').checkIso8601()", currentStateMessage: "The standard support start date is invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return TemporalLib.parseIso8601(dateTimeFrom77); } function jsonQueryChecked78() { var input = extract80.call(extract80); var out; try { out = jmespath.search(input, '[?LifecycleSupportName == \'open-source-rds-standard-support\'] | [0].LifecycleSupportStartDate'); if (out != null && typeof out != 'string') { throw new Error("UNDETERMINED condition:803", {cause: {status: 'UNDETERMINED', conditionIndex: 803, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportStartDate').isResultTypeMismatch()", currentStateMessage: "The standard support start date is missing or invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:804", {cause: {status: 'UNDETERMINED', conditionIndex: 804, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportStartDate').isEvaluationFailed()", currentStateMessage: "The standard support start date cannot be read.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function jsonChecked81() { var input = extract83.call(extract83); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:801", {cause: {status: 'UNDETERMINED', conditionIndex: 801, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The instance engine support calendar is missing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } var out; try { out = JSON.parse(input); } catch (e) { throw new Error("UNDETERMINED condition:802", {cause: {status: 'UNDETERMINED', conditionIndex: 802, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The instance engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract83() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract80() { if (!this.out) { this.out = jsonChecked81(); } return this.out; }; function extract75() { if (!this.out) { this.out = dateChecked76(); } return this.out; }; try { if (extract75.call(extract75) != null && extract75.call(extract75).getTime() >= todayPlus1Day) { return {status: 'UNDETERMINED', conditionIndex: 899, conditionText: "extract('caDateTimeFrom__instanceEngineStandardStart').afterToday()", currentStateMessage: "The engine standard support period has not started; verify the collected engine version and calendar.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[9], conditionIndex:[900..999] function dateChecked88() { var dateTimeFrom89 = jsonQueryChecked90(); if (!TemporalLib.checkIso8601(dateTimeFrom89)) { throw new Error("UNDETERMINED condition:905", {cause: {status: 'UNDETERMINED', conditionIndex: 905, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate').checkIso8601()", currentStateMessage: "The standard support end date is invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return TemporalLib.parseIso8601(dateTimeFrom89); } function jsonQueryChecked90() { var input = extract92.call(extract92); var out; try { out = jmespath.search(input, '[?LifecycleSupportName == \'open-source-rds-standard-support\'] | [0].LifecycleSupportEndDate'); if (out != null && typeof out != 'string') { throw new Error("UNDETERMINED condition:903", {cause: {status: 'UNDETERMINED', conditionIndex: 903, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate').isResultTypeMismatch()", currentStateMessage: "The standard support end date is missing or invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:904", {cause: {status: 'UNDETERMINED', conditionIndex: 904, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate').isEvaluationFailed()", currentStateMessage: "The standard support end date cannot be read.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function jsonChecked93() { var input = extract95.call(extract95); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:901", {cause: {status: 'UNDETERMINED', conditionIndex: 901, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The instance engine support calendar is missing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } var out; try { out = JSON.parse(input); } catch (e) { throw new Error("UNDETERMINED condition:902", {cause: {status: 'UNDETERMINED', conditionIndex: 902, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The instance engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract95() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract92() { if (!this.out) { this.out = jsonChecked93(); } return this.out; }; function extract87() { if (!this.out) { this.out = dateChecked88(); } return this.out; }; function jsonQueryChecked100() { var input = extract92.call(extract92); var out; try { out = jmespath.search(input, 'length([?length(LifecycleSupportStartDate) != `24` || length(LifecycleSupportEndDate) != `24` || !ends_with(LifecycleSupportStartDate, \'T00:00:00.000Z\') || !ends_with(LifecycleSupportEndDate, \'T23:59:59.999Z\')]) == `0`'); if (out != null && typeof out != 'boolean') { throw new Error("UNDETERMINED condition:906", {cause: {status: 'UNDETERMINED', conditionIndex: 906, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('length([?length(LifecycleSupportStartDate) != `24` || length(LifecycleSupportEndDate) != `24` || !ends_with(LifecycleSupportStartDate, \\'T00:00:00.000Z\\') || !ends_with(LifecycleSupportEndDate, \\'T23:59:59.999Z\\')]) == `0`').isResultTypeMismatch()", currentStateMessage: "The calendar timestamp precision has an unexpected structure.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:907", {cause: {status: 'UNDETERMINED', conditionIndex: 907, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('length([?length(LifecycleSupportStartDate) != `24` || length(LifecycleSupportEndDate) != `24` || !ends_with(LifecycleSupportStartDate, \\'T00:00:00.000Z\\') || !ends_with(LifecycleSupportEndDate, \\'T23:59:59.999Z\\')]) == `0`').isEvaluationFailed()", currentStateMessage: "The calendar timestamp precision cannot be interpreted.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract99() { if (!this.out) { this.out = jsonQueryChecked100(); } return this.out; }; try { if ((extract87.call(extract87) != null && extract87.call(extract87).getTime() < today) && !extract99.call(extract99)) { return {status: 'INCOMPLIANT', conditionIndex: 999, conditionText: "extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays'))", currentStateMessage: "AWS standard support has ended; the calendar timestamp precision does not establish the later Extended Support phase on this evaluation day.", currentStateReferences: references1.join('\n'), remediation: "Upgrade to an engine version within AWS standard support and verify any temporary Extended Support arrangement with AWS.", runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[10], conditionIndex:[1000..1099] function jsonQueryChecked104() { var input = extract106.call(extract106); var out; try { out = jmespath.search(input, 'length([?length(LifecycleSupportStartDate) != `24` || length(LifecycleSupportEndDate) != `24` || !ends_with(LifecycleSupportStartDate, \'T00:00:00.000Z\') || !ends_with(LifecycleSupportEndDate, \'T23:59:59.999Z\')]) == `0`'); if (out != null && typeof out != 'boolean') { throw new Error("UNDETERMINED condition:1003", {cause: {status: 'UNDETERMINED', conditionIndex: 1003, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('length([?length(LifecycleSupportStartDate) != `24` || length(LifecycleSupportEndDate) != `24` || !ends_with(LifecycleSupportStartDate, \\'T00:00:00.000Z\\') || !ends_with(LifecycleSupportEndDate, \\'T23:59:59.999Z\\')]) == `0`').isResultTypeMismatch()", currentStateMessage: "The calendar timestamp precision has an unexpected structure.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:1004", {cause: {status: 'UNDETERMINED', conditionIndex: 1004, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('length([?length(LifecycleSupportStartDate) != `24` || length(LifecycleSupportEndDate) != `24` || !ends_with(LifecycleSupportStartDate, \\'T00:00:00.000Z\\') || !ends_with(LifecycleSupportEndDate, \\'T23:59:59.999Z\\')]) == `0`').isEvaluationFailed()", currentStateMessage: "The calendar timestamp precision cannot be interpreted.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function jsonChecked107() { var input = extract109.call(extract109); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:1001", {cause: {status: 'UNDETERMINED', conditionIndex: 1001, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The instance engine support calendar is missing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } var out; try { out = JSON.parse(input); } catch (e) { throw new Error("UNDETERMINED condition:1002", {cause: {status: 'UNDETERMINED', conditionIndex: 1002, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The instance engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract109() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract106() { if (!this.out) { this.out = jsonChecked107(); } return this.out; }; function extract103() { if (!this.out) { this.out = jsonQueryChecked104(); } return this.out; }; try { if (!extract103.call(extract103)) { return {status: 'INAPPLICABLE', conditionIndex: 1099, conditionText: "not(extract('caJsonQueryBoolean__instanceEngineCalendarWholeDays'))", currentStateMessage: "This calendar uses timestamps outside the verified UTC whole-day encoding; the evaluation day is excluded because no standard-support expiry is established.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[11], conditionIndex:[1100..1199] function dateChecked113() { var dateTimeFrom114 = jsonQueryChecked115(); if (!TemporalLib.checkIso8601(dateTimeFrom114)) { throw new Error("UNDETERMINED condition:1105", {cause: {status: 'UNDETERMINED', conditionIndex: 1105, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate').checkIso8601()", currentStateMessage: "The standard support end date is invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return TemporalLib.parseIso8601(dateTimeFrom114); } function jsonQueryChecked115() { var input = extract117.call(extract117); var out; try { out = jmespath.search(input, '[?LifecycleSupportName == \'open-source-rds-standard-support\'] | [0].LifecycleSupportEndDate'); if (out != null && typeof out != 'string') { throw new Error("UNDETERMINED condition:1103", {cause: {status: 'UNDETERMINED', conditionIndex: 1103, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate').isResultTypeMismatch()", currentStateMessage: "The standard support end date is missing or invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:1104", {cause: {status: 'UNDETERMINED', conditionIndex: 1104, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-standard-support\\'] | [0].LifecycleSupportEndDate').isEvaluationFailed()", currentStateMessage: "The standard support end date cannot be read.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function jsonChecked118() { var input = extract120.call(extract120); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:1101", {cause: {status: 'UNDETERMINED', conditionIndex: 1101, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The instance engine support calendar is missing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } var out; try { out = JSON.parse(input); } catch (e) { throw new Error("UNDETERMINED condition:1102", {cause: {status: 'UNDETERMINED', conditionIndex: 1102, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The instance engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract120() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract117() { if (!this.out) { this.out = jsonChecked118(); } return this.out; }; function extract112() { if (!this.out) { this.out = dateChecked113(); } return this.out; }; try { if (!(extract112.call(extract112) != null && extract112.call(extract112).getTime() < today)) { return {status: 'COMPLIANT', conditionIndex: 1199, conditionText: "not(extract('caDateTimeFrom__instanceEngineStandardEnd').beforeToday())", currentStateMessage: "The instance engine major version is within AWS standard support according to its published support calendar.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[12], conditionIndex:[1200..1299] function jsonQueryChecked125() { var input = extract127.call(extract127); var out; try { out = jmespath.search(input, 'length([?LifecycleSupportName == \'open-source-rds-extended-support\'])'); if (out != null && typeof out != 'number') { throw new Error("UNDETERMINED condition:1203", {cause: {status: 'UNDETERMINED', conditionIndex: 1203, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('length([?LifecycleSupportName == \\'open-source-rds-extended-support\\'])').isResultTypeMismatch()", currentStateMessage: "The Extended Support phase has an unexpected structure.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:1204", {cause: {status: 'UNDETERMINED', conditionIndex: 1204, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('length([?LifecycleSupportName == \\'open-source-rds-extended-support\\'])').isEvaluationFailed()", currentStateMessage: "The Extended Support phase cannot be interpreted.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function jsonChecked128() { var input = extract130.call(extract130); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:1201", {cause: {status: 'UNDETERMINED', conditionIndex: 1201, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The instance engine support calendar is missing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } var out; try { out = JSON.parse(input); } catch (e) { throw new Error("UNDETERMINED condition:1202", {cause: {status: 'UNDETERMINED', conditionIndex: 1202, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The instance engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract130() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract127() { if (!this.out) { this.out = jsonChecked128(); } return this.out; }; function extract124() { if (!this.out) { this.out = jsonQueryChecked125(); } return this.out; }; try { if (extract124.call(extract124) == 0.0) { return {status: 'INCOMPLIANT', conditionIndex: 1299, conditionText: "extract('caJsonQueryNumber__instanceEngineExtendedPhaseCount') == number(0.0)", currentStateMessage: "AWS standard support has ended and the calendar publishes no Extended Support period for this engine major version.", currentStateReferences: references1.join('\n'), remediation: "Upgrade the instance to an engine version within AWS standard support after compatibility testing.", runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[13], conditionIndex:[1300..1399] function dateChecked134() { var dateTimeFrom135 = jsonQueryChecked136(); if (!TemporalLib.checkIso8601(dateTimeFrom135)) { throw new Error("UNDETERMINED condition:1305", {cause: {status: 'UNDETERMINED', conditionIndex: 1305, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportEndDate').checkIso8601()", currentStateMessage: "The Extended Support end date is invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return TemporalLib.parseIso8601(dateTimeFrom135); } function jsonQueryChecked136() { var input = extract138.call(extract138); var out; try { out = jmespath.search(input, '[?LifecycleSupportName == \'open-source-rds-extended-support\'] | [0].LifecycleSupportEndDate'); if (out != null && typeof out != 'string') { throw new Error("UNDETERMINED condition:1303", {cause: {status: 'UNDETERMINED', conditionIndex: 1303, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportEndDate').isResultTypeMismatch()", currentStateMessage: "The Extended Support end date is missing or invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:1304", {cause: {status: 'UNDETERMINED', conditionIndex: 1304, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportEndDate').isEvaluationFailed()", currentStateMessage: "The Extended Support end date cannot be read.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function jsonChecked139() { var input = extract141.call(extract141); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:1301", {cause: {status: 'UNDETERMINED', conditionIndex: 1301, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The instance engine support calendar is missing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } var out; try { out = JSON.parse(input); } catch (e) { throw new Error("UNDETERMINED condition:1302", {cause: {status: 'UNDETERMINED', conditionIndex: 1302, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The instance engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract141() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract138() { if (!this.out) { this.out = jsonChecked139(); } return this.out; }; function extract133() { if (!this.out) { this.out = dateChecked134(); } return this.out; }; try { if (extract133.call(extract133) != null && extract133.call(extract133).getTime() < today) { return {status: 'INCOMPLIANT', conditionIndex: 1399, conditionText: "extract('caDateTimeFrom__instanceEngineExtendedEnd').beforeToday()", currentStateMessage: "The instance engine major version is past the final published AWS support end date, including Extended Support.", currentStateReferences: references1.join('\n'), remediation: "Prioritize a tested upgrade to a version within AWS standard support and verify the current instance state with AWS.", runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[14], conditionIndex:[1400..1499] function dateChecked146() { var dateTimeFrom147 = jsonQueryChecked148(); if (!TemporalLib.checkIso8601(dateTimeFrom147)) { throw new Error("UNDETERMINED condition:1405", {cause: {status: 'UNDETERMINED', conditionIndex: 1405, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportStartDate').checkIso8601()", currentStateMessage: "The Extended Support start date is invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return TemporalLib.parseIso8601(dateTimeFrom147); } function jsonQueryChecked148() { var input = extract150.call(extract150); var out; try { out = jmespath.search(input, '[?LifecycleSupportName == \'open-source-rds-extended-support\'] | [0].LifecycleSupportStartDate'); if (out != null && typeof out != 'string') { throw new Error("UNDETERMINED condition:1403", {cause: {status: 'UNDETERMINED', conditionIndex: 1403, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportStartDate').isResultTypeMismatch()", currentStateMessage: "The Extended Support start date is missing or invalid.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:1404", {cause: {status: 'UNDETERMINED', conditionIndex: 1404, conditionText: "extract('caJsonFrom__instanceEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportStartDate').isEvaluationFailed()", currentStateMessage: "The Extended Support start date cannot be read.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function jsonChecked151() { var input = extract153.call(extract153); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:1401", {cause: {status: 'UNDETERMINED', conditionIndex: 1401, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The instance engine support calendar is missing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } var out; try { out = JSON.parse(input); } catch (e) { throw new Error("UNDETERMINED condition:1402", {cause: {status: 'UNDETERMINED', conditionIndex: 1402, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The instance engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract153() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract150() { if (!this.out) { this.out = jsonChecked151(); } return this.out; }; function extract145() { if (!this.out) { this.out = dateChecked146(); } return this.out; }; try { if (extract145.call(extract145) != null && extract145.call(extract145).getTime() >= todayPlus1Day) { return {status: 'INCOMPLIANT', conditionIndex: 1499, conditionText: "extract('caDateTimeFrom__instanceEngineExtendedStart').afterToday()", currentStateMessage: "AWS standard support has ended and the published Extended Support period has not started.", currentStateReferences: references1.join('\n'), remediation: "Upgrade the instance to a version within AWS standard support and verify support coverage with AWS.", runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } return {status: 'INCOMPLIANT', conditionIndex: 1500, conditionText: "otherwise", currentStateMessage: "The instance engine major version is outside AWS standard support and within the published RDS Extended Support period; this calendar does not establish enrollment or entitlement.", currentStateReferences: references1.join('\n'), remediation: "Plan a tested instance engine upgrade; if temporarily retaining this version, verify Extended Support enrollment and charges and record a time-limited exception.", runtimeError: null}; """; SELECT expectedResult.Id as Id, IF ( IFNULL(expectedResult.expectedResult.status, '') = IFNULL(sObject.result.status, '') AND IFNULL(expectedResult.expectedResult.conditionIndex, -1) = IFNULL(sObject.result.conditionIndex, -1) AND IFNULL(expectedResult.expectedResult.conditionText, '') = IFNULL(sObject.result.conditionText, '') AND IFNULL(expectedResult.expectedResult.runtimeError, '') = IFNULL(sObject.result.runtimeError, ''), "MATCH", "FAIL" ) as match, expectedResult.expectedResult.status as expectedStatus, sObject.result.status as actualStatus, expectedResult.expectedResult.conditionIndex as expectedConditionIndex, sObject.result.conditionIndex as actualConditionIndex, expectedResult.expectedResult.conditionText as expectedConditionText, sObject.result.conditionText as actualConditionText, expectedResult.expectedResult.runtimeError as expectedRuntimeError, sObject.result.runtimeError as actualRuntimeError FROM UNNEST(mock_ExpectedResult()) expectedResult LEFT JOIN ( SELECT sObject.CA10__disappearanceTime__c AS CA10__disappearanceTime__c, sObject.CA10__cluster__c AS CA10__cluster__c, sObject.CA10__clusterArn__c AS CA10__clusterArn__c, sObject.CA10__status__c AS CA10__status__c, sObject.CA10__engine__c AS CA10__engine__c, sObject.CA10__engineVersion__c AS CA10__engineVersion__c, sObject.CA10A2__engineLifecycleSupportInfo__c AS CA10A2__engineLifecycleSupportInfo__c, sObject.Id AS Id, process_CA10__CaAwsDbInstance__c( STRUCT( sObject.CA10__disappearanceTime__c AS CA10__disappearanceTime__c, sObject.CA10__cluster__c AS CA10__cluster__c, sObject.CA10__clusterArn__c AS CA10__clusterArn__c, sObject.CA10__status__c AS CA10__status__c, sObject.CA10__engine__c AS CA10__engine__c, sObject.CA10__engineVersion__c AS CA10__engineVersion__c, sObject.CA10A2__engineLifecycleSupportInfo__c AS CA10A2__engineLifecycleSupportInfo__c, sObject.Id AS Id ), sObject.context.snapshotTime ) as result FROM UNNEST(mock_CA10__CaAwsDbInstance__c()) AS sObject ) sObject ON sObject.Id = expectedResult.Id;