Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 35 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/match_recognize/permute.sql b/yql/essentials/tests/sql/suites/match_recognize/permute.sql
new file mode 100644
index 0000000000..614f5b77e0
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/match_recognize/permute.sql
@@ -0,0 +1,35 @@
+$data = [
+<|dt:1688910000, event:"A"|>,
+<|dt:1688910100, event:"B"|>,
+<|dt:1688910200, event:"C"|>,
+<|dt:1688910300, event:"A"|>,
+<|dt:1688910400, event:"C"|>,
+<|dt:1688910500, event:"D"|>,
+<|dt:1688910500, event:"C"|>,
+<|dt:1688910600, event:"B"|>,
+<|dt:1688910800, event:"A"|>,
+<|dt:1688910900, event:"C"|>,
+<|dt:1688911000, event:"B"|>,
+];
+
+pragma FeatureR010="prototype";
+
+SELECT *
+FROM AS_TABLE($data) MATCH_RECOGNIZE(
+    ORDER BY CAST(dt as Timestamp)
+    MEASURES
+        FIRST(A.dt) as a,
+        FIRST(B.dt) as b,
+        FIRST(C.dt) as c
+    ONE ROW PER MATCH
+    AFTER MATCH SKIP TO NEXT ROW
+    PATTERN (
+      PERMUTE(A, B, C)
+    )
+    DEFINE
+        A as A.event = "A",
+        B as B.event = "B",
+        C as C.event = "C"
+    ) AS MATCHED
+;
+