LET $locationNode = (SELECT FROM #10:1 LIMIT 1);
LET $locationTextNormalized = $locationNode.identity[0].normalize().toLowerCase();
LET $linkedChunks = (SELECT @rid, text FROM CHUNK WHERE IN('in').@rid CONTAINS $locationNode.@rid);
LET $PREVIEW_LEFT_CHARS = 15;
LET $PREVIEW_RIGHT_CHARS = 15;

LET $cuttedIndexes = (
SELECT @rid as chunkRID, 
        text.substring(
        text.toLowerCase().normalize().indexOf($locationTextNormalized) - $PREVIEW_LEFT_CHARS, 
        text.toLowerCase().normalize().indexOf($locationTextNormalized) + $locationTextNormalized.length() + $PREVIEW_RIGHT_CHARS
        ) AS preview
FROM CHUNK 
WHERE $linkedChunks.@rid CONTAINS @rid
AND text.toLowerCase().normalize().indexOf($locationTextNormalized) > -1
);

RETURN $cuttedIndexes

2026-03-16 10:06:41.873 INFO  [PostQueryHandler] <ArcadeDB_0> Error on command execution (PostQueryHandler): Query 'LET $locationNode = (SELECT FROM :id_location LIMIT 1);
        LET $locationTextNormalized = $locationNode.identity[0].normalize().toLowerCase();
        LET $linkedChunks = (SELECT @rid, text FROM CHUNK WHERE IN('in').@rid CONTAINS $locationNode.@rid);
        LET $PREVIEW_LEFT_CHARS = 15;
        LET $PREVIEW_RIGHT_CHARS = 15;

        LET $cuttedIndexes = (
        SELECT @rid as chunkRID,
                text.substring(
                text.toLowerCase().normalize().indexOf($locationTextNormalized) - $PREVIEW_LEFT_CHARS,
                text.toLowerCase().normalize().indexOf($locationTextNormalized) + $locationTextNormalized.length() + $PREVIEW_RIGHT_CHARS
                ) AS preview
        FROM CHUNK
        WHERE $linkedChunks.@rid CONTAINS @rid
        AND text.toLowerCase().normalize().indexOf($locationTextNormalized) > -1
        );

        RETURN $cuttedIndexes;' is not idempotent