search

zettadb / kunlun-storage-081809

Kunlun-storage is the storage component for Kunlun distributed DBMS. It's developed based on percona-mysql-8.0.x and contains exclusive features used by Kunlun distributed DBMS, performance enhancements and XA transaction crash safety enhancements without which MySQL would not be able to execute XA transactions reliably.
Other
31 stars 6 forks source link

store procedure not support for and while #8

Closed jd-zhang closed 2 years ago

jd-zhang commented 3 years ago

Issue migrated from trac ticket # 154

component: kunlun-storage | priority: major | resolution: fixed

2021-09-06 19:19:45: @charleszettadb created the issue

1. CREATE OR REPLACE FUNCTION LOOP1() RETURNS void AS $$ DECLARE i integer=1; begin for i in 1..6 LOOP RAISE NOTICE '%',i; END LOOP; END; $$ LANGUAGE PLPGSQL; ERROR: syntax error at or near "1" LINE 9: for i in 1..6 LOOP

  1. ^ CREATE OR REPLACE FUNCTION LOOP1() RETURNS void AS $$ DECLARE a integer=1; begin while a <= 6 loop a = a+1 select n; END LOOP; END; $$ LANGUAGE PLPGSQL; ERROR: syntax error at or near "select" LINE 9: select n; ^
jd-zhang commented 2 years ago

2021-10-25 15:34:27: @david-zhao commented

For case 2, need to add ; at end of 'a=a+1' line, then it's valid grammar.

jd-zhang commented 2 years ago

2021-10-25 17:06:25: @david-zhao changed status from assigned to accepted

jd-zhang commented 2 years ago

2021-12-18 18:16:57: @vito4172 commented

It has been confirmed that the above problems do not exist

jd-zhang commented 2 years ago

2021-12-18 18:16:57: @vito4172 set resolution to fixed

jd-zhang commented 2 years ago

2021-12-18 18:16:57: @vito4172 changed status from accepted to closed