--- policy: /ce/ca/aws/rds/cluster-engine-support logic: /ce/ca/aws/rds/cluster-engine-support/prod.logic.yaml executionTime: 2026-10-30T18:09:55.007913286Z generationMs: 122 executionMs: 1395 rows: - id: standard-enrolled match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: standard-start-boundary match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: standard-end-boundary match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: extended-start-boundary match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: extended-current match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: extended-end-boundary match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: final-support-expired match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday() actual: extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday() runtimeError: {} - id: reordered-phases match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: standard-enrollment-disabled match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: extended-enrollment-disabled match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: standard-only-supported match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: standard-only-expired match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1099 actual: 1099 conditionText: expected: extract('caJsonQueryNumber__clusterEngineExtendedPhaseCount') == number(0.0) actual: extract('caJsonQueryNumber__clusterEngineExtendedPhaseCount') == number(0.0) runtimeError: {} - id: future-standard-start match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 699 actual: 699 conditionText: expected: extract('caDateTimeFrom__clusterEngineStandardStart').afterToday() actual: extract('caDateTimeFrom__clusterEngineStandardStart').afterToday() runtimeError: {} - id: missing-calendar match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty')) actual: extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty')) runtimeError: {} - id: empty-calendar match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty')) actual: extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty')) runtimeError: {} - id: malformed-json match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 303 actual: 303 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-type match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) runtimeError: {} - id: duplicate-standard match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) runtimeError: {} - id: duplicate-extended match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) runtimeError: {} - id: unknown-phase match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) runtimeError: {} - id: missing-date match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) runtimeError: {} - id: invalid-date match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) runtimeError: {} - id: invalid-extended-date-during-standard match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 516 actual: 516 conditionText: expected: "extract('caJsonFrom__clusterEngineLifecycle').jsonQueryText('[?LifecycleSupportName\ \ == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportEndDate').checkIso8601()" actual: "extract('caJsonFrom__clusterEngineLifecycle').jsonQueryText('[?LifecycleSupportName\ \ == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportEndDate').checkIso8601()" runtimeError: {} - id: inverted-standard-range match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) runtimeError: {} - id: overlapping-extended-range match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) runtimeError: {} - id: unexpected-intraday-end match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 899 actual: 899 conditionText: expected: not(extract('caJsonQueryBoolean__clusterEngineCalendarWholeDays')) actual: not(extract('caJsonQueryBoolean__clusterEngineCalendarWholeDays')) runtimeError: {} - id: missing-engine match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 201 actual: 201 conditionText: expected: CA10__engine__c.isEmpty() actual: CA10__engine__c.isEmpty() runtimeError: {} - id: missing-version match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 301 actual: 301 conditionText: expected: CA10__engineVersion__c.isEmpty() actual: CA10__engineVersion__c.isEmpty() runtimeError: {} - id: missing-status match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 101 actual: 101 conditionText: expected: CA10__status__c.isEmpty() actual: CA10__status__c.isEmpty() runtimeError: {} - id: deleting match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 199 actual: 199 conditionText: expected: extract('CA10__status__c') == 'deleting' actual: extract('CA10__status__c') == 'deleting' runtimeError: {} - id: stopped-still-assessed match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: neptune-excluded match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 299 actual: 299 conditionText: expected: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" actual: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" runtimeError: {} - id: documentdb-excluded match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 299 actual: 299 conditionText: expected: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" actual: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" 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: valid-leap-day-standard-end match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: gap-before-extended-support match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1299 actual: 1299 conditionText: expected: extract('caDateTimeFrom__clusterEngineExtendedStart').afterToday() actual: extract('caDateTimeFrom__clusterEngineExtendedStart').afterToday() runtimeError: {} - id: aurora-mysql-standard match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: intraday-extended-end-retains-standard-eos match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 799 actual: 799 conditionText: expected: extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__clusterEngineCalendarWholeDays')) actual: extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__clusterEngineCalendarWholeDays')) runtimeError: {} - id: unexpected-engine-enum match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 299 actual: 299 conditionText: expected: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" actual: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" runtimeError: {} - id: new-aurora-postgresql-18-calendar-unavailable match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty')) actual: extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty')) runtimeError: {} - id: empty-array-with-whitespace match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 399 actual: 399 conditionText: expected: extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty')) actual: extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty')) runtimeError: {} - id: missing-version-and-empty-array match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 301 actual: 301 conditionText: expected: CA10__engineVersion__c.isEmpty() actual: CA10__engineVersion__c.isEmpty() runtimeError: {} - id: missing-version-and-missing-calendar match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 301 actual: 301 conditionText: expected: CA10__engineVersion__c.isEmpty() actual: CA10__engineVersion__c.isEmpty() runtimeError: {} - id: unexpected-status match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: upgrading-current-version-still-expired match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: backing-up-current-version-still-expired match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: creating-missing-version match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 301 actual: 301 conditionText: expected: CA10__engineVersion__c.isEmpty() actual: CA10__engineVersion__c.isEmpty() runtimeError: {} - id: mariadb-is-not-a-cluster-engine match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 299 actual: 299 conditionText: expected: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" actual: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" runtimeError: {} - id: commercial-instance-engine-on-cluster match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 299 actual: 299 conditionText: expected: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" actual: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" runtimeError: {} - id: legacy-aurora-excluded match: true status: expected: INAPPLICABLE actual: INAPPLICABLE conditionIndex: expected: 299 actual: 299 conditionText: expected: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" actual: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" runtimeError: {} - id: multi-az-mysql-standard-final-day match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: multi-az-mysql-extended-first-day match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: multi-az-mysql-final-support-expired match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday() actual: extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday() runtimeError: {} - id: aurora-postgresql-16.8-standard match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: aurora-postgresql-16.11-standard match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: multi-az-postgresql-standard match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: recoverable-cluster-still-assessed match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: serverless-cluster-still-assessed match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: auto-minor-upgrade-does-not-resolve-major-eos match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: aurora-mysql-2-extended-before-charging-starts match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: aurora-mysql-2-extended-last-day match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: aurora-mysql-2-final-support-expired match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1199 actual: 1199 conditionText: expected: extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday() actual: extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday() runtimeError: {} - id: calendar-json-null-is-invalid-enrichment match: true status: expected: UNDETERMINED actual: UNDETERMINED conditionIndex: expected: 499 actual: 499 conditionText: expected: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) actual: not(extract('caJsonQueryBoolean__clusterEngineCalendarValid')) runtimeError: {} - id: rebooting-multi-az-cluster-still-assessed match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1300 actual: 1300 conditionText: expected: otherwise actual: otherwise runtimeError: {} - id: future-aurora-postgresql-version-standard match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: future-postgres-version-standard match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: future-aurora-mysql-version-standard match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: future-mysql-version-standard match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} - id: future-version-still-fails-after-standard-support-ends match: true status: expected: INCOMPLIANT actual: INCOMPLIANT conditionIndex: expected: 1099 actual: 1099 conditionText: expected: extract('caJsonQueryNumber__clusterEngineExtendedPhaseCount') == number(0.0) actual: extract('caJsonQueryNumber__clusterEngineExtendedPhaseCount') == number(0.0) runtimeError: {} - id: unlisted-status-with-standard-support match: true status: expected: COMPLIANT actual: COMPLIANT conditionIndex: expected: 999 actual: 999 conditionText: expected: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) actual: not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday()) runtimeError: {} usedFiles: - path: /ce/ca/aws/rds/cluster-engine-support/policy.yaml md5Hash: 6545D348131173DADA9164FCAD7E58B1 content: "---\nnames:\n full: AWS RDS Cluster engine is outside standard support\n\ \ contextual: Cluster engine is outside standard support\ndescription: >\n\ \ Ensure that Aurora and RDS for MySQL or PostgreSQL Multi-AZ DB clusters use\ \ \n an engine major version within AWS standard support. Identify expired\ \ standard \n support without confusing Extended Support availability with\ \ enrollment or charges.\ntype: COMPLIANCE_POLICY\ncategories:\n - RELIABILITY\n\ frameworkMappings:\n - /frameworks/cloudaware/resource-reliability/infrastructure-modernization\n" - path: /ce/ca/aws/rds/cluster-engine-support/prod.logic.yaml md5Hash: 66635B9727C934C6A950A2D8BE3C4024 content: | --- inputType: CA10__CaAwsDbCluster__c testData: - file: test-data.json importExtracts: - file: /types/CA10__CaAwsDbCluster__c/object.extracts.yaml - file: /types/CA10__CaAwsDbCluster__c/cluster-engine-support.extracts.yaml conditions: - status: INAPPLICABLE currentStateMessage: The DB cluster is being deleted. check: IS_EQUAL: left: EXTRACT: CA10__status__c right: TEXT: deleting - status: INAPPLICABLE currentStateMessage: This policy does not assess support for this cluster's database engine. check: NOT: arg: CONTAINS: arg: SET: itemType: TEXT items: - aurora-mysql - aurora-postgresql - mysql - postgres search: EXTRACT: CA10__engine__c - status: INAPPLICABLE currentStateMessage: Support dates are unavailable for this cluster's engine major version. check: AND: args: - NOT_EMPTY: arg: EXTRACT: CA10__engineVersion__c - OR: args: - IS_EMPTY: arg: EXTRACT: CA10A2__engineLifecycleSupportInfo__c - EXTRACT: caJsonQueryBoolean__clusterEngineCalendarEmpty - status: UNDETERMINED currentStateMessage: The engine support information is incomplete or inconsistent, so support status cannot be assessed. check: NOT: arg: EXTRACT: caJsonQueryBoolean__clusterEngineCalendarValid # Parse every published date before making a support claim, including future Extended Support dates. - status: UNDETERMINED currentStateMessage: A required engine support date is missing or invalid. check: NOT: arg: AND: args: - NOT_EMPTY: arg: EXTRACT: caDateTimeFrom__clusterEngineStandardStart - NOT_EMPTY: arg: EXTRACT: caDateTimeFrom__clusterEngineStandardEnd - OR: args: - IS_EQUAL: left: EXTRACT: caJsonQueryNumber__clusterEngineExtendedPhaseCount right: NUMBER: 0 - AND: args: - NOT_EMPTY: arg: EXTRACT: caDateTimeFrom__clusterEngineExtendedStart - NOT_EMPTY: arg: EXTRACT: caDateTimeFrom__clusterEngineExtendedEnd - status: UNDETERMINED currentStateMessage: The reported standard support period for this engine version has not started. check: IS_AFTER_TODAY: arg: EXTRACT: caDateTimeFrom__clusterEngineStandardStart - status: INCOMPLIANT currentStateMessage: AWS standard support has ended for this engine version, but its Extended Support status could not be confirmed. remediationMessage: Plan a tested engine upgrade and verify any temporary Extended Support coverage with AWS. check: AND: args: - IS_BEFORE_TODAY: arg: EXTRACT: caDateTimeFrom__clusterEngineStandardEnd - NOT: arg: EXTRACT: caJsonQueryBoolean__clusterEngineCalendarWholeDays - status: UNDETERMINED currentStateMessage: Standard support for this engine version cannot be confirmed from the reported dates. check: NOT: arg: EXTRACT: caJsonQueryBoolean__clusterEngineCalendarWholeDays - status: COMPLIANT currentStateMessage: The cluster's engine major version is within AWS standard support. check: NOT: arg: IS_BEFORE_TODAY: arg: EXTRACT: caDateTimeFrom__clusterEngineStandardEnd - status: INCOMPLIANT currentStateMessage: AWS standard support has ended for this engine version, and no Extended Support period is listed. remediationMessage: Test and upgrade the cluster to an engine major version within AWS standard support. check: IS_EQUAL: left: EXTRACT: caJsonQueryNumber__clusterEngineExtendedPhaseCount right: NUMBER: 0 - status: INCOMPLIANT currentStateMessage: The cluster's engine major version is past the end of AWS support, including Extended Support. remediationMessage: Prioritize a tested engine upgrade and confirm the cluster's current version and support status with AWS. check: IS_BEFORE_TODAY: arg: EXTRACT: caDateTimeFrom__clusterEngineExtendedEnd - status: INCOMPLIANT currentStateMessage: AWS standard support has ended for this engine version, and its listed Extended Support period has not started. remediationMessage: Test and upgrade to an engine major version within AWS standard support, and confirm support coverage with AWS. check: IS_AFTER_TODAY: arg: EXTRACT: caDateTimeFrom__clusterEngineExtendedStart otherwise: status: INCOMPLIANT currentStateMessage: The cluster's engine major version is outside AWS standard support but within the published RDS Extended Support period. remediationMessage: Plan a tested engine upgrade or approve a temporary exception after verifying Extended Support enrollment and costs. - path: /ce/ca/aws/rds/cluster-engine-support/test-data.json md5Hash: 84CB8F78404B5B2D27C7933E88B87756 content: | [ { "Id": "standard-enrolled", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2026-02-01T12:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "standard-start-boundary", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2021-08-26T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "standard-end-boundary", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2026-02-28T23:59:59.999Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "extended-start-boundary", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-03-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "extended-current", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "extended-end-boundary", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2029-02-28T23:59:59.999Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "final-support-expired", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1199, "conditionText": "extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday()" }, "context": { "snapshotTime": "2029-03-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "reordered-phases", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"}]" }, { "Id": "standard-enrollment-disabled", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2026-02-01T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": "13.23", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support-disabled", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "extended-enrollment-disabled", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": "13.23", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support-disabled", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "standard-only-supported", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-mysql", "CA10__engineVersion__c": "8.4.7", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2026-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-04-30T23:59:59.999Z\"}]" }, { "Id": "standard-only-expired", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1099, "conditionText": "extract('caJsonQueryNumber__clusterEngineExtendedPhaseCount') == number(0.0)" }, "context": { "snapshotTime": "2032-05-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-mysql", "CA10__engineVersion__c": "8.4.7", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2026-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-04-30T23:59:59.999Z\"}]" }, { "Id": "future-standard-start", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 699, "conditionText": "extract('caDateTimeFrom__clusterEngineStandardStart').afterToday()" }, "context": { "snapshotTime": "2021-08-25T12:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "missing-calendar", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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": null }, { "Id": "empty-calendar", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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": "[]" }, { "Id": "malformed-json", "expectedResult": { "status": "UNDETERMINED", "runtimeError": "Expected property name or '}' in JSON at position 1 (line 1 column 2)", "conditionIndex": 303, "conditionText": "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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": "{" }, { "Id": "wrong-root-type", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 499, "conditionText": "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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": "{}" }, { "Id": "duplicate-standard", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 499, "conditionText": "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "duplicate-extended", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 499, "conditionText": "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "unknown-phase", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 499, "conditionText": "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\":\"unknown\"}]" }, { "Id": "missing-date", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 499, "conditionText": "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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-08-26T00:00:00.000Z\"}]" }, { "Id": "invalid-date", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 499, "conditionText": "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" }, "context": { "snapshotTime": "2026-02-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-13-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "invalid-extended-date-during-standard", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 516, "conditionText": "extract('caJsonFrom__clusterEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportEndDate').checkIso8601()" }, "context": { "snapshotTime": "2026-02-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-13-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "inverted-standard-range", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 499, "conditionText": "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" }, "context": { "snapshotTime": "2026-02-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2027-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "overlapping-extended-range", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 499, "conditionText": "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" }, "context": { "snapshotTime": "2026-02-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-02-01T00:00:00.000Z\"}]" }, { "Id": "unexpected-intraday-end", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 899, "conditionText": "not(extract('caJsonQueryBoolean__clusterEngineCalendarWholeDays'))" }, "context": { "snapshotTime": "2026-02-28T12:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T12:00:00.000Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "missing-engine", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 201, "conditionText": "CA10__engine__c.isEmpty()" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": null, "CA10__engineVersion__c": "13.23", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "missing-version", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 301, "conditionText": "CA10__engineVersion__c.isEmpty()" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": null, "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "missing-status", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 101, "conditionText": "CA10__status__c.isEmpty()" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "deleting", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 199, "conditionText": "extract('CA10__status__c') == 'deleting'" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "deleting", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": "13.23", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": null }, { "Id": "stopped-still-assessed", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "stopped", "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "neptune-excluded", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 299, "conditionText": "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "neptune", "CA10__engineVersion__c": "13.23", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": null }, { "Id": "documentdb-excluded", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 299, "conditionText": "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "docdb", "CA10__engineVersion__c": "13.23", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": null }, { "Id": "disappeared", "expectedResult": { "status": "DISAPPEARED", "runtimeError": null, "conditionIndex": 99, "conditionText": "isDisappeared(CA10__disappearanceTime__c)" }, "context": { "snapshotTime": "2026-10-23T00:00:00Z" }, "CA10__disappearanceTime__c": "2026-10-22T00:00:00Z", "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": null }, { "Id": "valid-leap-day-standard-end", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2028-02-29T23:59:59.999Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2028-02-29T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2028-03-01T00:00:00.000Z\"}]" }, { "Id": "gap-before-extended-support", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1299, "conditionText": "extract('caDateTimeFrom__clusterEngineExtendedStart').afterToday()" }, "context": { "snapshotTime": "2026-03-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-04-01T00:00:00.000Z\"}]" }, { "Id": "aurora-mysql-standard", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2026-02-01T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-mysql", "CA10__engineVersion__c": "8.0.mysql_aurora.3.10.3", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "intraday-extended-end-retains-standard-eos", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 799, "conditionText": "extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__clusterEngineCalendarWholeDays'))" }, "context": { "snapshotTime": "2029-02-28T12:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T12:00:00.000Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "unexpected-engine-enum", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 299, "conditionText": "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" }, "context": { "snapshotTime": "2026-02-01T12:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "new-aurora-postgresql-18-calendar-unavailable", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": "18.6", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[]" }, { "Id": "empty-array-with-whitespace", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 399, "conditionText": "extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "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": " [ \n ] " }, { "Id": "missing-version-and-empty-array", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 301, "conditionText": "CA10__engineVersion__c.isEmpty()" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": null, "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[]" }, { "Id": "missing-version-and-missing-calendar", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 301, "conditionText": "CA10__engineVersion__c.isEmpty()" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": "", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "" }, { "Id": "unexpected-status", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "unexpected-status", "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "upgrading-current-version-still-expired", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "upgrading", "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "backing-up-current-version-still-expired", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "backing-up", "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "creating-missing-version", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 301, "conditionText": "CA10__engineVersion__c.isEmpty()" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "creating", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": null, "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "mariadb-is-not-a-cluster-engine", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 299, "conditionText": "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "mariadb", "CA10__engineVersion__c": "10.6.24", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "commercial-instance-engine-on-cluster", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 299, "conditionText": "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "oracle-ee", "CA10__engineVersion__c": "13.23", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]" }, { "Id": "legacy-aurora-excluded", "expectedResult": { "status": "INAPPLICABLE", "runtimeError": null, "conditionIndex": 299, "conditionText": "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora", "CA10__engineVersion__c": "13.23", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "" }, { "Id": "multi-az-mysql-standard-final-day", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2026-07-31T23:59:59.999Z" }, "CA10__disappearanceTime__c": null, "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\"}]" }, { "Id": "multi-az-mysql-extended-first-day", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-08-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\"}]" }, { "Id": "multi-az-mysql-final-support-expired", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1199, "conditionText": "extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday()" }, "context": { "snapshotTime": "2029-08-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "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\"}]" }, { "Id": "aurora-postgresql-16.8-standard", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": "16.8", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2024-01-31T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2029-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-02-29T23:59:59.999Z\"}]" }, { "Id": "aurora-postgresql-16.11-standard", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": "16.11", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2024-01-31T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2029-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-02-29T23:59:59.999Z\"}]" }, { "Id": "multi-az-postgresql-standard", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "postgres", "CA10__engineVersion__c": "16.11", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2023-11-09T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2029-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-02-29T23:59:59.999Z\"}]" }, { "Id": "recoverable-cluster-still-assessed", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "inaccessible-encryption-credentials-recoverable", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": "16.11", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2024-01-31T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2029-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-02-29T23:59:59.999Z\"}]" }, { "Id": "serverless-cluster-still-assessed", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "CA10__engineMode__c": "serverless" }, { "Id": "auto-minor-upgrade-does-not-resolve-major-eos", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "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\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "CA10__autoMinorVersionUpgrade__c": "Yes" }, { "Id": "aurora-mysql-2-extended-before-charging-starts", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2024-11-15T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-mysql", "CA10__engineVersion__c": "5.7.mysql_aurora.2.11.5", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2018-02-06T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2024-10-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2024-11-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-06-30T23:59:59.999Z\"}]" }, { "Id": "aurora-mysql-2-extended-last-day", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2029-06-30T23:59:59.999Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-mysql", "CA10__engineVersion__c": "5.7.mysql_aurora.2.11.5", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2018-02-06T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2024-10-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2024-11-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-06-30T23:59:59.999Z\"}]" }, { "Id": "aurora-mysql-2-final-support-expired", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1199, "conditionText": "extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday()" }, "context": { "snapshotTime": "2029-07-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-mysql", "CA10__engineVersion__c": "5.7.mysql_aurora.2.11.5", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2018-02-06T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2024-10-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2024-11-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-06-30T23:59:59.999Z\"}]" }, { "Id": "calendar-json-null-is-invalid-enrichment", "expectedResult": { "status": "UNDETERMINED", "runtimeError": null, "conditionIndex": 499, "conditionText": "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "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": "null" }, { "Id": "rebooting-multi-az-cluster-still-assessed", "expectedResult": { "status": "INCOMPLIANT", "runtimeError": null, "conditionIndex": 1300, "conditionText": "otherwise" }, "context": { "snapshotTime": "2026-08-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "rebooting", "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\"}]" }, { "Id": "future-aurora-postgresql-version-standard", "expectedResult": { "status": "COMPLIANT", "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())", "runtimeError": null }, "context": { "snapshotTime": "2030-02-01T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": "99.1", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2030-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2034-12-31T23:59:59.999Z\"}]" }, { "Id": "future-postgres-version-standard", "expectedResult": { "status": "COMPLIANT", "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())", "runtimeError": null }, "context": { "snapshotTime": "2030-02-01T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "postgres", "CA10__engineVersion__c": "99.1", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2030-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2034-12-31T23:59:59.999Z\"}]" }, { "Id": "future-aurora-mysql-version-standard", "expectedResult": { "status": "COMPLIANT", "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())", "runtimeError": null }, "context": { "snapshotTime": "2030-02-01T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "aurora-mysql", "CA10__engineVersion__c": "99.0.1", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2030-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2034-12-31T23:59:59.999Z\"}]" }, { "Id": "future-mysql-version-standard", "expectedResult": { "status": "COMPLIANT", "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())", "runtimeError": null }, "context": { "snapshotTime": "2030-02-01T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "mysql", "CA10__engineVersion__c": "99.0.1", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2030-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2034-12-31T23:59:59.999Z\"}]" }, { "Id": "future-version-still-fails-after-standard-support-ends", "expectedResult": { "status": "INCOMPLIANT", "conditionIndex": 1099, "conditionText": "extract('caJsonQueryNumber__clusterEngineExtendedPhaseCount') == number(0.0)", "runtimeError": null }, "context": { "snapshotTime": "2035-01-01T00:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "available", "CA10__engine__c": "mysql", "CA10__engineVersion__c": "99.0.1", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2030-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2034-12-31T23:59:59.999Z\"}]" }, { "Id": "unlisted-status-with-standard-support", "expectedResult": { "status": "COMPLIANT", "runtimeError": null, "conditionIndex": 999, "conditionText": "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" }, "context": { "snapshotTime": "2026-10-27T12:00:00Z" }, "CA10__disappearanceTime__c": null, "CA10__status__c": "future-status", "CA10__engine__c": "aurora-postgresql", "CA10__engineVersion__c": "16.8", "CA10__engineLifecycleSupport__c": "open-source-rds-extended-support", "CA10A2__engineLifecycleSupportInfo__c": "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2024-01-31T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2029-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-02-29T23:59:59.999Z\"}]" } ] - path: /types/CA10__CaAwsDbCluster__c/cluster-engine-support.extracts.yaml md5Hash: B375733DD23A2C39CD3713C93EE6AFDC content: | --- extracts: # The source field contains serialized AWS lifecycle records, so parse it before querying phases. - name: caJsonFrom__clusterEngineLifecycle value: JSON_FROM: arg: EXTRACT: CA10A2__engineLifecycleSupportInfo__c undeterminedIf: isEmpty: The cluster engine support calendar is missing. isInvalid: The cluster engine support calendar is invalid JSON. # New major versions can have an empty array until AWS publishes their calendar. - name: caJsonQueryBoolean__clusterEngineCalendarEmpty value: JSON_QUERY_BOOLEAN: arg: EXTRACT: caJsonFrom__clusterEngineLifecycle expression: "type(@) == 'array' && length(@) == `0`" undeterminedIf: evaluationError: The cluster engine support calendar cannot be interpreted. resultTypeMismatch: The cluster engine support calendar has an unexpected structure. # Require one standard phase and at most one Extended Support phase before selecting dates. # Sorting UTC ISO strings checks date order within and between support periods. - name: caJsonQueryBoolean__clusterEngineCalendarValid value: JSON_QUERY_BOOLEAN: arg: EXTRACT: caJsonFrom__clusterEngineLifecycle 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 cluster engine support calendar cannot be interpreted. resultTypeMismatch: The cluster engine support calendar has an unexpected structure. # Midnight starts and end-of-day ends preserve inclusive AWS dates with CE's TODAY comparisons. - name: caJsonQueryBoolean__clusterEngineCalendarWholeDays value: JSON_QUERY_BOOLEAN: arg: EXTRACT: caJsonFrom__clusterEngineLifecycle 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 is published, not that enrollment is disabled. - name: caJsonQueryNumber__clusterEngineExtendedPhaseCount value: JSON_QUERY_NUMBER: arg: EXTRACT: caJsonFrom__clusterEngineLifecycle 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 phases by name, independent of array order, and parse date text for UTC comparisons. - name: caDateTimeFrom__clusterEngineStandardStart # shortcut: ISO parsing can normalize impossible day numbers; use trusted AWS dates until the engine provides strict calendar parsing. value: DATE_TIME_FROM: arg: JSON_QUERY_TEXT: arg: EXTRACT: caJsonFrom__clusterEngineLifecycle 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__clusterEngineStandardEnd value: DATE_TIME_FROM: arg: JSON_QUERY_TEXT: arg: EXTRACT: caJsonFrom__clusterEngineLifecycle 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. # These optional dates require an Extended Support phase; callers must check its count first. - name: caDateTimeFrom__clusterEngineExtendedStart value: DATE_TIME_FROM: arg: JSON_QUERY_TEXT: arg: EXTRACT: caJsonFrom__clusterEngineLifecycle 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__clusterEngineExtendedEnd value: DATE_TIME_FROM: arg: JSON_QUERY_TEXT: arg: EXTRACT: caJsonFrom__clusterEngineLifecycle 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. - path: /types/CA10__CaAwsDbCluster__c/object.extracts.yaml md5Hash: 06106363DB027F40632D1ACB814D99C8 content: | --- extracts: - name: CA10A2__engineLifecycleSupportInfo__c value: FIELD: path: CA10A2__engineLifecycleSupportInfo__c returnType: BYTES - name: CA10__engineVersion__c value: FIELD: path: CA10__engineVersion__c undeterminedIf: isEmpty: The cluster engine version is missing. - name: CA10__engine__c value: FIELD: path: CA10__engine__c undeterminedIf: # https://docs.aws.amazon.com/cli/latest/reference/rds/describe-db-clusters.html # "Engine" attribute represents a non-nullable string. isEmpty: DB Engine value cannot be empty. Potential data corruption. # Values: Yes | No. Not nullable. Cannot have no access, retrieved via rds:DescribeDBClusters - name: CA10__autoMinorVersionUpgrade__c value: FIELD: path: CA10__autoMinorVersionUpgrade__c # Number. Can't have no access, retrieved via rds:DescribeDBClusters - name: CA10__backupRetentionPeriod__c value: FIELD: path: CA10__backupRetentionPeriod__c # Number. Can't have no access, retrieved via rds:DescribeDBClusters - name: CA10__backtrackWindow__c value: FIELD: path: CA10__backtrackWindow__c # Checkbox. - name: CA10__multiAZ__c value: FIELD: path: CA10__multiAZ__c # Checkbox. - name: CA10__storageEncrypted__c value: FIELD: path: CA10__storageEncrypted__c # Text. - name: CA10__masterUsername__c value: FIELD: path: CA10__masterUsername__c # Checkbox. - name: CA10__iamDatabaseAuthenticationEnabled__c value: FIELD: path: CA10__iamDatabaseAuthenticationEnabled__c - name: CA10__status__c value: FIELD: path: CA10__status__c undeterminedIf: # https://docs.aws.amazon.com/cli/latest/reference/rds/describe-db-clusters.html # "Engine" attribute represents a non-nullable string. isEmpty: DB Status value cannot be empty. Potential data corruption. # Nullable. Can't have no access, retrieved via rds:DescribeDBClusters - name: CA10__enabledCloudwatchLogsExports__c value: FIELD: path: CA10__enabledCloudwatchLogsExports__c # Checkbox. - name: CA10__copyTagsToSnapshot__c value: FIELD: path: CA10__copyTagsToSnapshot__c script: |- CREATE TEMP FUNCTION mock_ExpectedResult() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "Id" : "standard-enrolled", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } }, { "Id" : "standard-start-boundary", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } }, { "Id" : "standard-end-boundary", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } }, { "Id" : "extended-start-boundary", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "extended-current", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "extended-end-boundary", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "final-support-expired", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1199, "conditionText" : "extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday()" } }, { "Id" : "reordered-phases", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "standard-enrollment-disabled", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } }, { "Id" : "extended-enrollment-disabled", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "standard-only-supported", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } }, { "Id" : "standard-only-expired", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1099, "conditionText" : "extract('caJsonQueryNumber__clusterEngineExtendedPhaseCount') == number(0.0)" } }, { "Id" : "future-standard-start", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 699, "conditionText" : "extract('caDateTimeFrom__clusterEngineStandardStart').afterToday()" } }, { "Id" : "missing-calendar", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))" } }, { "Id" : "empty-calendar", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))" } }, { "Id" : "malformed-json", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : "Expected property name or '}' in JSON at position 1 (line 1 column 2)", "conditionIndex" : 303, "conditionText" : "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()" } }, { "Id" : "wrong-root-type", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" } }, { "Id" : "duplicate-standard", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" } }, { "Id" : "duplicate-extended", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" } }, { "Id" : "unknown-phase", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" } }, { "Id" : "missing-date", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" } }, { "Id" : "invalid-date", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" } }, { "Id" : "invalid-extended-date-during-standard", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 516, "conditionText" : "extract('caJsonFrom__clusterEngineLifecycle').jsonQueryText('[?LifecycleSupportName == \\'open-source-rds-extended-support\\'] | [0].LifecycleSupportEndDate').checkIso8601()" } }, { "Id" : "inverted-standard-range", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" } }, { "Id" : "overlapping-extended-range", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" } }, { "Id" : "unexpected-intraday-end", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 899, "conditionText" : "not(extract('caJsonQueryBoolean__clusterEngineCalendarWholeDays'))" } }, { "Id" : "missing-engine", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 201, "conditionText" : "CA10__engine__c.isEmpty()" } }, { "Id" : "missing-version", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 301, "conditionText" : "CA10__engineVersion__c.isEmpty()" } }, { "Id" : "missing-status", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 101, "conditionText" : "CA10__status__c.isEmpty()" } }, { "Id" : "deleting", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 199, "conditionText" : "extract('CA10__status__c') == 'deleting'" } }, { "Id" : "stopped-still-assessed", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "neptune-excluded", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 299, "conditionText" : "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" } }, { "Id" : "documentdb-excluded", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 299, "conditionText" : "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" } }, { "Id" : "disappeared", "expectedResult" : { "status" : "DISAPPEARED", "runtimeError" : null, "conditionIndex" : 99, "conditionText" : "isDisappeared(CA10__disappearanceTime__c)" } }, { "Id" : "valid-leap-day-standard-end", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } }, { "Id" : "gap-before-extended-support", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1299, "conditionText" : "extract('caDateTimeFrom__clusterEngineExtendedStart').afterToday()" } }, { "Id" : "aurora-mysql-standard", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } }, { "Id" : "intraday-extended-end-retains-standard-eos", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 799, "conditionText" : "extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__clusterEngineCalendarWholeDays'))" } }, { "Id" : "unexpected-engine-enum", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 299, "conditionText" : "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" } }, { "Id" : "new-aurora-postgresql-18-calendar-unavailable", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))" } }, { "Id" : "empty-array-with-whitespace", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 399, "conditionText" : "extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))" } }, { "Id" : "missing-version-and-empty-array", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 301, "conditionText" : "CA10__engineVersion__c.isEmpty()" } }, { "Id" : "missing-version-and-missing-calendar", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 301, "conditionText" : "CA10__engineVersion__c.isEmpty()" } }, { "Id" : "unexpected-status", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "upgrading-current-version-still-expired", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "backing-up-current-version-still-expired", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "creating-missing-version", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 301, "conditionText" : "CA10__engineVersion__c.isEmpty()" } }, { "Id" : "mariadb-is-not-a-cluster-engine", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 299, "conditionText" : "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" } }, { "Id" : "commercial-instance-engine-on-cluster", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 299, "conditionText" : "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" } }, { "Id" : "legacy-aurora-excluded", "expectedResult" : { "status" : "INAPPLICABLE", "runtimeError" : null, "conditionIndex" : 299, "conditionText" : "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))" } }, { "Id" : "multi-az-mysql-standard-final-day", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } }, { "Id" : "multi-az-mysql-extended-first-day", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "multi-az-mysql-final-support-expired", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1199, "conditionText" : "extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday()" } }, { "Id" : "aurora-postgresql-16.8-standard", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } }, { "Id" : "aurora-postgresql-16.11-standard", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } }, { "Id" : "multi-az-postgresql-standard", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } }, { "Id" : "recoverable-cluster-still-assessed", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } }, { "Id" : "serverless-cluster-still-assessed", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "auto-minor-upgrade-does-not-resolve-major-eos", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "aurora-mysql-2-extended-before-charging-starts", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "aurora-mysql-2-extended-last-day", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "aurora-mysql-2-final-support-expired", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1199, "conditionText" : "extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday()" } }, { "Id" : "calendar-json-null-is-invalid-enrichment", "expectedResult" : { "status" : "UNDETERMINED", "runtimeError" : null, "conditionIndex" : 499, "conditionText" : "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))" } }, { "Id" : "rebooting-multi-az-cluster-still-assessed", "expectedResult" : { "status" : "INCOMPLIANT", "runtimeError" : null, "conditionIndex" : 1300, "conditionText" : "otherwise" } }, { "Id" : "future-aurora-postgresql-version-standard", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "future-postgres-version-standard", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "future-aurora-mysql-version-standard", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "future-mysql-version-standard", "expectedResult" : { "status" : "COMPLIANT", "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())", "runtimeError" : null } }, { "Id" : "future-version-still-fails-after-standard-support-ends", "expectedResult" : { "status" : "INCOMPLIANT", "conditionIndex" : 1099, "conditionText" : "extract('caJsonQueryNumber__clusterEngineExtendedPhaseCount') == number(0.0)", "runtimeError" : null } }, { "Id" : "unlisted-status-with-standard-support", "expectedResult" : { "status" : "COMPLIANT", "runtimeError" : null, "conditionIndex" : 999, "conditionText" : "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())" } } ]; """; CREATE TEMP FUNCTION mock_CA10__CaAwsDbCluster__c() RETURNS ARRAY >> DETERMINISTIC LANGUAGE js AS r""" return [ { "context" : { "snapshotTime" : new Date("2026-02-01T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "standard-enrolled" }, { "context" : { "snapshotTime" : new Date("2021-08-26T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "standard-start-boundary" }, { "context" : { "snapshotTime" : new Date("2026-02-28T23:59:59.999Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "standard-end-boundary" }, { "context" : { "snapshotTime" : new Date("2026-03-01T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "extended-start-boundary" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "extended-current" }, { "context" : { "snapshotTime" : new Date("2029-02-28T23:59:59.999Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "extended-end-boundary" }, { "context" : { "snapshotTime" : new Date("2029-03-01T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "final-support-expired" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"}]", "Id" : "reordered-phases" }, { "context" : { "snapshotTime" : new Date("2026-02-01T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "standard-enrollment-disabled" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "extended-enrollment-disabled" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-mysql", "CA10__engineVersion__c" : "8.4.7", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2026-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-04-30T23:59:59.999Z\"}]", "Id" : "standard-only-supported" }, { "context" : { "snapshotTime" : new Date("2032-05-01T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-mysql", "CA10__engineVersion__c" : "8.4.7", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2026-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-04-30T23:59:59.999Z\"}]", "Id" : "standard-only-expired" }, { "context" : { "snapshotTime" : new Date("2021-08-25T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "future-standard-start" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : null, "Id" : "missing-calendar" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[]", "Id" : "empty-calendar" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "{", "Id" : "malformed-json" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "{}", "Id" : "wrong-root-type" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "duplicate-standard" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "duplicate-extended" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"unknown\"}]", "Id" : "unknown-phase" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "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-08-26T00:00:00.000Z\"}]", "Id" : "missing-date" }, { "context" : { "snapshotTime" : new Date("2026-02-01T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-13-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "invalid-date" }, { "context" : { "snapshotTime" : new Date("2026-02-01T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-13-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "invalid-extended-date-during-standard" }, { "context" : { "snapshotTime" : new Date("2026-02-01T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2027-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "inverted-standard-range" }, { "context" : { "snapshotTime" : new Date("2026-02-01T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-02-01T00:00:00.000Z\"}]", "Id" : "overlapping-extended-range" }, { "context" : { "snapshotTime" : new Date("2026-02-28T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T12:00:00.000Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "unexpected-intraday-end" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : null, "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "missing-engine" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : null, "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "missing-version" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : null, "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "missing-status" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "deleting", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : null, "Id" : "deleting" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "stopped", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "stopped-still-assessed" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "neptune", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : null, "Id" : "neptune-excluded" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "docdb", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : null, "Id" : "documentdb-excluded" }, { "context" : { "snapshotTime" : new Date("2026-10-23T00:00:00Z") }, "CA10__disappearanceTime__c" : new Date("2026-10-22T00:00:00Z"), "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : null, "Id" : "disappeared" }, { "context" : { "snapshotTime" : new Date("2028-02-29T23:59:59.999Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2028-02-29T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2028-03-01T00:00:00.000Z\"}]", "Id" : "valid-leap-day-standard-end" }, { "context" : { "snapshotTime" : new Date("2026-03-01T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-04-01T00:00:00.000Z\"}]", "Id" : "gap-before-extended-support" }, { "context" : { "snapshotTime" : new Date("2026-02-01T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-mysql", "CA10__engineVersion__c" : "8.0.mysql_aurora.3.10.3", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "aurora-mysql-standard" }, { "context" : { "snapshotTime" : new Date("2029-02-28T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T12:00:00.000Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "intraday-extended-end-retains-standard-eos" }, { "context" : { "snapshotTime" : new Date("2026-02-01T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "future-db", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "unexpected-engine-enum" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "18.6", "CA10A2__engineLifecycleSupportInfo__c" : "[]", "Id" : "new-aurora-postgresql-18-calendar-unavailable" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : " [ \n ] ", "Id" : "empty-array-with-whitespace" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : null, "CA10A2__engineLifecycleSupportInfo__c" : "[]", "Id" : "missing-version-and-empty-array" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "", "CA10A2__engineLifecycleSupportInfo__c" : "", "Id" : "missing-version-and-missing-calendar" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "unexpected-status", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "unexpected-status" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "upgrading", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "upgrading-current-version-still-expired" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "backing-up", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "backing-up-current-version-still-expired" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "creating", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : null, "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "creating-missing-version" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "mariadb", "CA10__engineVersion__c" : "10.6.24", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "mariadb-is-not-a-cluster-engine" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "oracle-ee", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "commercial-instance-engine-on-cluster" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "", "Id" : "legacy-aurora-excluded" }, { "context" : { "snapshotTime" : new Date("2026-07-31T23:59:59.999Z") }, "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" : "multi-az-mysql-standard-final-day" }, { "context" : { "snapshotTime" : new Date("2026-08-01T00:00:00Z") }, "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" : "multi-az-mysql-extended-first-day" }, { "context" : { "snapshotTime" : new Date("2029-08-01T00:00:00Z") }, "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" : "multi-az-mysql-final-support-expired" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "16.8", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2024-01-31T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2029-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-02-29T23:59:59.999Z\"}]", "Id" : "aurora-postgresql-16.8-standard" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "16.11", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2024-01-31T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2029-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-02-29T23:59:59.999Z\"}]", "Id" : "aurora-postgresql-16.11-standard" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "16.11", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2023-11-09T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2029-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-02-29T23:59:59.999Z\"}]", "Id" : "multi-az-postgresql-standard" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "inaccessible-encryption-credentials-recoverable", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "16.11", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2024-01-31T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2029-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-02-29T23:59:59.999Z\"}]", "Id" : "recoverable-cluster-still-assessed" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "serverless-cluster-still-assessed" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportEndDate\":\"2026-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2021-08-26T00:00:00.000Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\",\"LifecycleSupportStartDate\":\"2026-03-01T00:00:00.000Z\"}]", "Id" : "auto-minor-upgrade-does-not-resolve-major-eos" }, { "context" : { "snapshotTime" : new Date("2024-11-15T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-mysql", "CA10__engineVersion__c" : "5.7.mysql_aurora.2.11.5", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2018-02-06T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2024-10-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2024-11-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-06-30T23:59:59.999Z\"}]", "Id" : "aurora-mysql-2-extended-before-charging-starts" }, { "context" : { "snapshotTime" : new Date("2029-06-30T23:59:59.999Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-mysql", "CA10__engineVersion__c" : "5.7.mysql_aurora.2.11.5", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2018-02-06T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2024-10-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2024-11-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-06-30T23:59:59.999Z\"}]", "Id" : "aurora-mysql-2-extended-last-day" }, { "context" : { "snapshotTime" : new Date("2029-07-01T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-mysql", "CA10__engineVersion__c" : "5.7.mysql_aurora.2.11.5", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2018-02-06T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2024-10-31T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2024-11-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-06-30T23:59:59.999Z\"}]", "Id" : "aurora-mysql-2-final-support-expired" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "13.23", "CA10A2__engineLifecycleSupportInfo__c" : "null", "Id" : "calendar-json-null-is-invalid-enrichment" }, { "context" : { "snapshotTime" : new Date("2026-08-01T00:00:00Z") }, "CA10__status__c" : "rebooting", "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" : "rebooting-multi-az-cluster-still-assessed" }, { "context" : { "snapshotTime" : new Date("2030-02-01T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "99.1", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2030-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2034-12-31T23:59:59.999Z\"}]", "Id" : "future-aurora-postgresql-version-standard" }, { "context" : { "snapshotTime" : new Date("2030-02-01T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "postgres", "CA10__engineVersion__c" : "99.1", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2030-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2034-12-31T23:59:59.999Z\"}]", "Id" : "future-postgres-version-standard" }, { "context" : { "snapshotTime" : new Date("2030-02-01T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "aurora-mysql", "CA10__engineVersion__c" : "99.0.1", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2030-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2034-12-31T23:59:59.999Z\"}]", "Id" : "future-aurora-mysql-version-standard" }, { "context" : { "snapshotTime" : new Date("2030-02-01T12:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "99.0.1", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2030-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2034-12-31T23:59:59.999Z\"}]", "Id" : "future-mysql-version-standard" }, { "context" : { "snapshotTime" : new Date("2035-01-01T00:00:00Z") }, "CA10__status__c" : "available", "CA10__engine__c" : "mysql", "CA10__engineVersion__c" : "99.0.1", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2030-01-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2034-12-31T23:59:59.999Z\"}]", "Id" : "future-version-still-fails-after-standard-support-ends" }, { "context" : { "snapshotTime" : new Date("2026-10-27T12:00:00Z") }, "CA10__status__c" : "future-status", "CA10__engine__c" : "aurora-postgresql", "CA10__engineVersion__c" : "16.8", "CA10A2__engineLifecycleSupportInfo__c" : "[{\"LifecycleSupportName\":\"open-source-rds-standard-support\",\"LifecycleSupportStartDate\":\"2024-01-31T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2029-02-28T23:59:59.999Z\"},{\"LifecycleSupportName\":\"open-source-rds-extended-support\",\"LifecycleSupportStartDate\":\"2029-03-01T00:00:00.000Z\",\"LifecycleSupportEndDate\":\"2032-02-29T23:59:59.999Z\"}]", "Id" : "unlisted-status-with-standard-support" } ]; """; CREATE TEMP FUNCTION process_CA10__CaAwsDbCluster__c( obj STRUCT< CA10__disappearanceTime__c TIMESTAMP, 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 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 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 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 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 fieldChecked4() { if (TextLib.isEmpty(obj.CA10__status__c)) { throw new Error("UNDETERMINED condition:101", {cause: {status: 'UNDETERMINED', conditionIndex: 101, conditionText: "CA10__status__c.isEmpty()", currentStateMessage: "DB Status value cannot be empty. Potential data corruption.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__status__c; } function extract3() { if (!this.out) { this.out = fieldChecked4(); } return this.out; }; references1.push('Status [obj.CA10__status__c]: ' + obj.CA10__status__c); try { if (TextLib.equal(extract3.call(extract3), 'deleting')) { return {status: 'INAPPLICABLE', conditionIndex: 199, conditionText: "extract('CA10__status__c') == 'deleting'", currentStateMessage: "The DB cluster 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[2], conditionIndex:[200..299] function fieldChecked7() { if (TextLib.isEmpty(obj.CA10__engine__c)) { throw new Error("UNDETERMINED condition:201", {cause: {status: 'UNDETERMINED', conditionIndex: 201, conditionText: "CA10__engine__c.isEmpty()", currentStateMessage: "DB Engine value cannot be empty. Potential data corruption.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__engine__c; } function extract6() { if (!this.out) { this.out = fieldChecked7(); } return this.out; }; references1.push('Engine [obj.CA10__engine__c]: ' + obj.CA10__engine__c); try { if (!CollectionLib.contains(CollectionLib.fromArray(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres'], true, true, true, true), extract6.call(extract6), true)) { return {status: 'INAPPLICABLE', conditionIndex: 299, conditionText: "not(setOfText(['aurora-mysql', 'aurora-postgresql', 'mysql', 'postgres']).contains(extract('CA10__engine__c')))", currentStateMessage: "This policy does not assess support for this cluster's database engine.", 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 fieldChecked10() { if (TextLib.isEmpty(obj.CA10__engineVersion__c)) { throw new Error("UNDETERMINED condition:301", {cause: {status: 'UNDETERMINED', conditionIndex: 301, conditionText: "CA10__engineVersion__c.isEmpty()", currentStateMessage: "The cluster engine version is missing.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } return obj.CA10__engineVersion__c; } function extract9() { if (!this.out) { this.out = fieldChecked10(); } return this.out; }; function extract12() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function jsonQueryChecked16() { var input = extract18.call(extract18); var out; try { out = jmespath.search(input, 'type(@) == \'array\' && length(@) == `0`'); if (out != null && typeof out != 'boolean') { throw new Error("UNDETERMINED condition:304", {cause: {status: 'UNDETERMINED', conditionIndex: 304, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').jsonQueryText('type(@) == \\'array\\' && length(@) == `0`').isResultTypeMismatch()", currentStateMessage: "The cluster engine support calendar has an unexpected structure.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:305", {cause: {status: 'UNDETERMINED', conditionIndex: 305, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').jsonQueryText('type(@) == \\'array\\' && length(@) == `0`').isEvaluationFailed()", currentStateMessage: "The cluster engine support calendar cannot be interpreted.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function jsonChecked19() { var input = extract12.call(extract12); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:302", {cause: {status: 'UNDETERMINED', conditionIndex: 302, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The cluster 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:303", {cause: {status: 'UNDETERMINED', conditionIndex: 303, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The cluster engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract18() { if (!this.out) { this.out = jsonChecked19(); } return this.out; }; function extract15() { if (!this.out) { this.out = jsonQueryChecked16(); } 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(extract9.call(extract9)) && (BytesLib.isEmpty(extract12.call(extract12)) || extract15.call(extract15))) { return {status: 'INAPPLICABLE', conditionIndex: 399, conditionText: "extract('CA10__engineVersion__c').isNotEmpty() && (extract('CA10A2__engineLifecycleSupportInfo__c').isEmpty() || extract('caJsonQueryBoolean__clusterEngineCalendarEmpty'))", currentStateMessage: "Support dates are unavailable for this cluster's engine major version.", 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 jsonQueryChecked23() { var input = extract25.call(extract25); 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:403", {cause: {status: 'UNDETERMINED', conditionIndex: 403, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 cluster engine support calendar has an unexpected structure.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}}); } } catch (e) { throw new Error("UNDETERMINED condition:404", {cause: {status: 'UNDETERMINED', conditionIndex: 404, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 cluster engine support calendar cannot be interpreted.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function jsonChecked26() { var input = extract28.call(extract28); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:401", {cause: {status: 'UNDETERMINED', conditionIndex: 401, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The cluster 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:402", {cause: {status: 'UNDETERMINED', conditionIndex: 402, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The cluster engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract28() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract25() { if (!this.out) { this.out = jsonChecked26(); } return this.out; }; function extract22() { if (!this.out) { this.out = jsonQueryChecked23(); } return this.out; }; try { if (!extract22.call(extract22)) { return {status: 'UNDETERMINED', conditionIndex: 499, conditionText: "not(extract('caJsonQueryBoolean__clusterEngineCalendarValid'))", currentStateMessage: "The engine support information is incomplete or inconsistent, so support status cannot be assessed.", 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 dateChecked32() { var dateTimeFrom33 = jsonQueryChecked34(); if (!TemporalLib.checkIso8601(dateTimeFrom33)) { throw new Error("UNDETERMINED condition:505", {cause: {status: 'UNDETERMINED', conditionIndex: 505, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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(dateTimeFrom33); } function jsonQueryChecked34() { var input = extract36.call(extract36); 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:503", {cause: {status: 'UNDETERMINED', conditionIndex: 503, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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:504", {cause: {status: 'UNDETERMINED', conditionIndex: 504, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 jsonChecked37() { var input = extract39.call(extract39); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:501", {cause: {status: 'UNDETERMINED', conditionIndex: 501, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The cluster 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 cluster 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 extract31() { if (!this.out) { this.out = dateChecked32(); } return this.out; }; function dateChecked43() { var dateTimeFrom44 = jsonQueryChecked45(); if (!TemporalLib.checkIso8601(dateTimeFrom44)) { throw new Error("UNDETERMINED condition:508", {cause: {status: 'UNDETERMINED', conditionIndex: 508, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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(dateTimeFrom44); } function jsonQueryChecked45() { var input = extract36.call(extract36); 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:506", {cause: {status: 'UNDETERMINED', conditionIndex: 506, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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:507", {cause: {status: 'UNDETERMINED', conditionIndex: 507, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 extract42() { if (!this.out) { this.out = dateChecked43(); } return this.out; }; function jsonQueryChecked49() { 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:509", {cause: {status: 'UNDETERMINED', conditionIndex: 509, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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:510", {cause: {status: 'UNDETERMINED', conditionIndex: 510, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 extract48() { if (!this.out) { this.out = jsonQueryChecked49(); } return this.out; }; function dateChecked53() { var dateTimeFrom54 = jsonQueryChecked55(); if (!TemporalLib.checkIso8601(dateTimeFrom54)) { throw new Error("UNDETERMINED condition:513", {cause: {status: 'UNDETERMINED', conditionIndex: 513, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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(dateTimeFrom54); } function jsonQueryChecked55() { var input = extract36.call(extract36); 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:511", {cause: {status: 'UNDETERMINED', conditionIndex: 511, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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:512", {cause: {status: 'UNDETERMINED', conditionIndex: 512, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 extract52() { if (!this.out) { this.out = dateChecked53(); } return this.out; }; function dateChecked59() { var dateTimeFrom60 = jsonQueryChecked61(); if (!TemporalLib.checkIso8601(dateTimeFrom60)) { throw new Error("UNDETERMINED condition:516", {cause: {status: 'UNDETERMINED', conditionIndex: 516, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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(dateTimeFrom60); } function jsonQueryChecked61() { var input = extract36.call(extract36); 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:514", {cause: {status: 'UNDETERMINED', conditionIndex: 514, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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:515", {cause: {status: 'UNDETERMINED', conditionIndex: 515, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 extract58() { if (!this.out) { this.out = dateChecked59(); } return this.out; }; try { if (!(IsEmptyLib.simpleIsNotEmpty(extract31.call(extract31)) && IsEmptyLib.simpleIsNotEmpty(extract42.call(extract42)) && (extract48.call(extract48) == 0.0 || (IsEmptyLib.simpleIsNotEmpty(extract52.call(extract52)) && IsEmptyLib.simpleIsNotEmpty(extract58.call(extract58)))))) { return {status: 'UNDETERMINED', conditionIndex: 599, conditionText: "not(extract('caDateTimeFrom__clusterEngineStandardStart').isNotEmpty() && extract('caDateTimeFrom__clusterEngineStandardEnd').isNotEmpty() && (extract('caJsonQueryNumber__clusterEngineExtendedPhaseCount') == number(0.0) || (extract('caDateTimeFrom__clusterEngineExtendedStart').isNotEmpty() && extract('caDateTimeFrom__clusterEngineExtendedEnd').isNotEmpty())))", currentStateMessage: "A required engine support date is missing or invalid.", 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 dateChecked65() { var dateTimeFrom66 = jsonQueryChecked67(); if (!TemporalLib.checkIso8601(dateTimeFrom66)) { throw new Error("UNDETERMINED condition:605", {cause: {status: 'UNDETERMINED', conditionIndex: 605, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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(dateTimeFrom66); } function jsonQueryChecked67() { var input = extract69.call(extract69); 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:603", {cause: {status: 'UNDETERMINED', conditionIndex: 603, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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:604", {cause: {status: 'UNDETERMINED', conditionIndex: 604, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 jsonChecked70() { var input = extract72.call(extract72); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:601", {cause: {status: 'UNDETERMINED', conditionIndex: 601, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The cluster 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:602", {cause: {status: 'UNDETERMINED', conditionIndex: 602, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isInvalid()", currentStateMessage: "The cluster engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract72() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract69() { if (!this.out) { this.out = jsonChecked70(); } return this.out; }; function extract64() { if (!this.out) { this.out = dateChecked65(); } return this.out; }; try { if (extract64.call(extract64) != null && extract64.call(extract64).getTime() >= todayPlus1Day) { return {status: 'UNDETERMINED', conditionIndex: 699, conditionText: "extract('caDateTimeFrom__clusterEngineStandardStart').afterToday()", currentStateMessage: "The reported standard support period for this engine version has not started.", 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 dateChecked77() { var dateTimeFrom78 = jsonQueryChecked79(); if (!TemporalLib.checkIso8601(dateTimeFrom78)) { throw new Error("UNDETERMINED condition:705", {cause: {status: 'UNDETERMINED', conditionIndex: 705, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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(dateTimeFrom78); } function jsonQueryChecked79() { var input = extract81.call(extract81); 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:703", {cause: {status: 'UNDETERMINED', conditionIndex: 703, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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:704", {cause: {status: 'UNDETERMINED', conditionIndex: 704, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 jsonChecked82() { var input = extract84.call(extract84); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:701", {cause: {status: 'UNDETERMINED', conditionIndex: 701, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The cluster 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 cluster engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract84() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract81() { if (!this.out) { this.out = jsonChecked82(); } return this.out; }; function extract76() { if (!this.out) { this.out = dateChecked77(); } return this.out; }; function jsonQueryChecked89() { var input = extract81.call(extract81); 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:706", {cause: {status: 'UNDETERMINED', conditionIndex: 706, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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:707", {cause: {status: 'UNDETERMINED', conditionIndex: 707, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 extract88() { if (!this.out) { this.out = jsonQueryChecked89(); } return this.out; }; try { if ((extract76.call(extract76) != null && extract76.call(extract76).getTime() < today) && !extract88.call(extract88)) { return {status: 'INCOMPLIANT', conditionIndex: 799, conditionText: "extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday() && not(extract('caJsonQueryBoolean__clusterEngineCalendarWholeDays'))", currentStateMessage: "AWS standard support has ended for this engine version, but its Extended Support status could not be confirmed.", currentStateReferences: references1.join('\n'), remediation: "Plan a tested engine upgrade and verify any temporary Extended Support coverage with AWS.", runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[8], conditionIndex:[800..899] function jsonQueryChecked93() { var input = extract95.call(extract95); 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:803", {cause: {status: 'UNDETERMINED', conditionIndex: 803, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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:804", {cause: {status: 'UNDETERMINED', conditionIndex: 804, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 jsonChecked96() { var input = extract98.call(extract98); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:801", {cause: {status: 'UNDETERMINED', conditionIndex: 801, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The cluster 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 cluster engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract98() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract95() { if (!this.out) { this.out = jsonChecked96(); } return this.out; }; function extract92() { if (!this.out) { this.out = jsonQueryChecked93(); } return this.out; }; try { if (!extract92.call(extract92)) { return {status: 'UNDETERMINED', conditionIndex: 899, conditionText: "not(extract('caJsonQueryBoolean__clusterEngineCalendarWholeDays'))", currentStateMessage: "Standard support for this engine version cannot be confirmed from the reported dates.", 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 dateChecked102() { var dateTimeFrom103 = jsonQueryChecked104(); if (!TemporalLib.checkIso8601(dateTimeFrom103)) { throw new Error("UNDETERMINED condition:905", {cause: {status: 'UNDETERMINED', conditionIndex: 905, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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(dateTimeFrom103); } function jsonQueryChecked104() { var input = extract106.call(extract106); 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__clusterEngineLifecycle').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__clusterEngineLifecycle').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 jsonChecked107() { var input = extract109.call(extract109); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:901", {cause: {status: 'UNDETERMINED', conditionIndex: 901, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The cluster 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 cluster 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 extract101() { if (!this.out) { this.out = dateChecked102(); } return this.out; }; try { if (!(extract101.call(extract101) != null && extract101.call(extract101).getTime() < today)) { return {status: 'COMPLIANT', conditionIndex: 999, conditionText: "not(extract('caDateTimeFrom__clusterEngineStandardEnd').beforeToday())", currentStateMessage: "The cluster's engine major version is within AWS standard support.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[10], conditionIndex:[1000..1099] function jsonQueryChecked114() { var input = extract116.call(extract116); 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:1003", {cause: {status: 'UNDETERMINED', conditionIndex: 1003, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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:1004", {cause: {status: 'UNDETERMINED', conditionIndex: 1004, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 jsonChecked117() { var input = extract119.call(extract119); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:1001", {cause: {status: 'UNDETERMINED', conditionIndex: 1001, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The cluster 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 cluster engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract119() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract116() { if (!this.out) { this.out = jsonChecked117(); } return this.out; }; function extract113() { if (!this.out) { this.out = jsonQueryChecked114(); } return this.out; }; try { if (extract113.call(extract113) == 0.0) { return {status: 'INCOMPLIANT', conditionIndex: 1099, conditionText: "extract('caJsonQueryNumber__clusterEngineExtendedPhaseCount') == number(0.0)", currentStateMessage: "AWS standard support has ended for this engine version, and no Extended Support period is listed.", currentStateReferences: references1.join('\n'), remediation: "Test and upgrade the cluster to an engine major version within AWS standard support.", runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[11], conditionIndex:[1100..1199] function dateChecked123() { var dateTimeFrom124 = jsonQueryChecked125(); if (!TemporalLib.checkIso8601(dateTimeFrom124)) { throw new Error("UNDETERMINED condition:1105", {cause: {status: 'UNDETERMINED', conditionIndex: 1105, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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(dateTimeFrom124); } function jsonQueryChecked125() { var input = extract127.call(extract127); 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:1103", {cause: {status: 'UNDETERMINED', conditionIndex: 1103, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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:1104", {cause: {status: 'UNDETERMINED', conditionIndex: 1104, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 jsonChecked128() { var input = extract130.call(extract130); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:1101", {cause: {status: 'UNDETERMINED', conditionIndex: 1101, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The cluster 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 cluster 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 extract122() { if (!this.out) { this.out = dateChecked123(); } return this.out; }; try { if (extract122.call(extract122) != null && extract122.call(extract122).getTime() < today) { return {status: 'INCOMPLIANT', conditionIndex: 1199, conditionText: "extract('caDateTimeFrom__clusterEngineExtendedEnd').beforeToday()", currentStateMessage: "The cluster's engine major version is past the end of AWS support, including Extended Support.", currentStateReferences: references1.join('\n'), remediation: "Prioritize a tested engine upgrade and confirm the cluster's current version and support status with AWS.", runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } // condition[12], conditionIndex:[1200..1299] function dateChecked135() { var dateTimeFrom136 = jsonQueryChecked137(); if (!TemporalLib.checkIso8601(dateTimeFrom136)) { throw new Error("UNDETERMINED condition:1205", {cause: {status: 'UNDETERMINED', conditionIndex: 1205, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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(dateTimeFrom136); } function jsonQueryChecked137() { var input = extract139.call(extract139); 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:1203", {cause: {status: 'UNDETERMINED', conditionIndex: 1203, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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:1204", {cause: {status: 'UNDETERMINED', conditionIndex: 1204, conditionText: "extract('caJsonFrom__clusterEngineLifecycle').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 jsonChecked140() { var input = extract142.call(extract142); if (TextLib.isEmpty(input)) { throw new Error("UNDETERMINED condition:1201", {cause: {status: 'UNDETERMINED', conditionIndex: 1201, conditionText: "extract('CA10A2__engineLifecycleSupportInfo__c').asJson().isEmpty()", currentStateMessage: "The cluster 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 cluster engine support calendar is invalid JSON.", currentStateReferences: references1.join('\n'), remediation: null, runtimeError: e.message}}); } return out; } function extract142() { if (!this.out) { this.out = obj.CA10A2__engineLifecycleSupportInfo__c; } return this.out; }; function extract139() { if (!this.out) { this.out = jsonChecked140(); } return this.out; }; function extract134() { if (!this.out) { this.out = dateChecked135(); } return this.out; }; try { if (extract134.call(extract134) != null && extract134.call(extract134).getTime() >= todayPlus1Day) { return {status: 'INCOMPLIANT', conditionIndex: 1299, conditionText: "extract('caDateTimeFrom__clusterEngineExtendedStart').afterToday()", currentStateMessage: "AWS standard support has ended for this engine version, and its listed Extended Support period has not started.", currentStateReferences: references1.join('\n'), remediation: "Test and upgrade to an engine major version within AWS standard support, and confirm support coverage with AWS.", runtimeError: null}; } } catch (err) { if (err.cause && err.cause.status) { return err.cause; } else { throw err; } } return {status: 'INCOMPLIANT', conditionIndex: 1300, conditionText: "otherwise", currentStateMessage: "The cluster's engine major version is outside AWS standard support but within the published RDS Extended Support period.", currentStateReferences: references1.join('\n'), remediation: "Plan a tested engine upgrade or approve a temporary exception after verifying Extended Support enrollment and costs.", 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__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__CaAwsDbCluster__c( STRUCT( sObject.CA10__disappearanceTime__c AS CA10__disappearanceTime__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__CaAwsDbCluster__c()) AS sObject ) sObject ON sObject.Id = expectedResult.Id;