red-soft-ru / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
0 stars 1 forks source link

T152 fix (need to complete) #88

Closed makssent closed 1 month ago

makssent commented 1 month ago

Fixes #42.

request: EXECUTE block RETURNS (s VARCHAR(100)) AS BEGIN IF (NULL IS NOT DISTINCT FROM NULL) THEN BEGIN s = 'null is not distinct from null'; suspend; END END;

error message: You have an error in your SQL syntax: EXECUTE block RETURNS (s VARCHAR(100)) AS BEGIN IF (NULL IS NOT DISTINCT FROM NULL) THEN BEGIN s = 'null is not distinct from null'; suspend; END END; no viable alternative at input 'EXECUTE' at line 1 position 1 near @01:7='EXECUTE'<264>1:1

new error message: You have an error in your SQL syntax: EXECUTE block RETURNS (s VARCHAR(100)) AS BEGIN IF (NULL IS NOT DISTINCT FROM NULL) THEN BEGIN s = 'null is not distinct from null'; suspend; END END; null

Remaining tasks: complete implementation of EXECUTE BLOCK, including `ifStatement`, `assignmentStatement`, and other related changes.