Hi Henson, >> Here do you have "ONE ROW PER MATCH" option of RPR in your mind? In my >> understanding it's in MATCH_RECOGNIZE clause, but not in RPR in Window >> clause. (ALL ROWS PER MATCH is not applicable either in RPR in >> Window clause). >> >> > You're absolutely right - thank you for the correction! > > I'm currently exploring what this NFA structure could theoretically > support, rather than strictly binding to the spec yet. Since I'm > still learning from Oracle manuals and your code without access to > the full SQL:2016 standard, I mixed up MATCH_RECOGNIZE syntax with > Window clause RPR - sorry for the confusion!
No problem at all. MATCH_RECOGNIZE and Window clause RPR are quite similar. In the mean time "Trino" manual maybe useful for you if you don't have access to the SQL standard. https://trino.io/docs/current/sql/pattern-recognition-in-window.html Best regards, -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp
