Consider supporting PostgreSQL declare cursor, open, fetch, move, close statement

[strongduanmu]

Background

After we complete the cursor feature of openGauss in issue #17825, we need to adapt the cursor feature of PostgreSQL. In general, their logic are similar, and the logic of the existing kernel can be supported, but some adaptations are required in the part of SQL syntax parsing and sql statement context extraction.

Subtasks

• [x] support PostgreSQL declare cursor, open, fetch, move, close statement parse
• [ ] support declare cursor, open, fetch, move, close statement in read-write splitting scenario
• [ ] support declare cursor, open, fetch, close statement in sharding scenario
• [ ] add test case

[chakkk309]

Hi @strongduanmu, I want to try it.

[strongduanmu]

@chakkk309 Welcome, I will assign this issue to you.

[github-actions[bot]]

Hello , this issue has not received a reply for several days. This issue is supposed to be closed.

[ThanoshanMV]

Hi @strongduanmu, shall I try this? 😄

[strongduanmu]

@ThanoshanMV Of course, I will assign this issue to you.

[ThanoshanMV]

Thank you @strongduanmu. I'll take this opportunity to learn read-write splitting and sharding scenarios of the SQL statements 😃