Array indexing with multiple parameters selecting support

SQL++
1

Hi
We are create this index and want to use this index multiple queries, but optional array parameters bu not working query need to all parameters to parsing

index like this

CREATE INDEX index-name ON BucketName((all (array [(listing.barcode), (listing.supplierId), (listing.fulfilmentType)] for listing in listings end))) WHERE (type = “content”)

and this sample queries not works
SELECT meta©.id FROM BucketName c UNNEST c.listings listing
WHERE c.type = ‘content’ AND [listing.barcode, listing.supplierId, listing.fulfilmentType] = [“3471356”];

SELECT meta©.id FROM BucketName c UNNEST c.listings listing
WHERE c.type = ‘content’ AND [listing.barcode, listing.supplierId, listing.fulfilmentType] = [“3471356”, 11];

but this work, why index need all parameters ?

SELECT meta©.id FROM BucketName c UNNEST c.listings listing
WHERE c.type = ‘content’ AND [listing.barcode, listing.supplierId, listing.fulfilmentType] = [“3471356”, 11, “deliver”];

2

These are too complex . If looking equality only.

SELECT meta©.id FROM
 BucketName c 
UNNEST c.listings listing
LET fltr =  [listing.barcode, listing.supplierId, listing.fulfilmentType]
WHERE c.type = ‘content’ 
AND  fltr >= [“3471356”] AND fltr < [SUCCESSOR(“3471356”);

SELECT meta©.id FROM
 BucketName c 
UNNEST c.listings listing
LET fltr =  [listing.barcode, listing.supplierId, listing.fulfilmentType]
WHERE c.type = ‘content’ 
AND fltr >=  [“3471356”, 11] AND  fltr <  [“3471356”, SUCCESSOR(11)];
4

thanks a lot now much more clear for me :grinning: