Problem
ComplexPropertiesStructuralEqualityTestBase exposes query shapes where complex collection properties are compared structurally, for example:
e.RequiredAssociate.NestedCollection == e.OptionalAssociate!.NestedCollection
and where a nested complex collection is compared with an inline or parameter value.
DynamoDB can store nested list/map attributes, and PartiQL should be able to compare document values. This looks like a provider translation gap rather than a DynamoDB storage limitation.
Desired support
Translate structural equality for list-valued complex properties / nested complex collections to PartiQL document equality where DynamoDB supports it, including:
- attribute-to-attribute comparison
- attribute-to-inline-list comparison
- attribute-to-parameter comparison
Related current spec coverage
ComplexPropertiesStructuralEqualityDynamoTest skips these inherited tests pending this support:
Two_nested_collectionsNested_collection_with_inlineNested_collection_with_parameter
Separate but nearby gap: translating Contains over complex collection elements may also need investigation, potentially via DynamoDB PartiQL contains(...) semantics for map/list element values.
Notes
When implementing, verify DynamoDB Local and AWS PartiQL semantics for list/map equality, including list order sensitivity and parameter serialization for list-of-map values.
Problem
ComplexPropertiesStructuralEqualityTestBaseexposes query shapes where complex collection properties are compared structurally, for example:and where a nested complex collection is compared with an inline or parameter value.
DynamoDB can store nested list/map attributes, and PartiQL should be able to compare document values. This looks like a provider translation gap rather than a DynamoDB storage limitation.
Desired support
Translate structural equality for list-valued complex properties / nested complex collections to PartiQL document equality where DynamoDB supports it, including:
Related current spec coverage
ComplexPropertiesStructuralEqualityDynamoTestskips these inherited tests pending this support:Two_nested_collectionsNested_collection_with_inlineNested_collection_with_parameterSeparate but nearby gap: translating
Containsover complex collection elements may also need investigation, potentially via DynamoDB PartiQLcontains(...)semantics for map/list element values.Notes
When implementing, verify DynamoDB Local and AWS PartiQL semantics for list/map equality, including list order sensitivity and parameter serialization for list-of-map values.