[GitHub] [incubator-shardingsphere] tuohai666 commented on issue #2195: Support Stored Procedure for Sharding-Proxy IF not sharding

[GitBox]

tuohai666 commented on issue #2195: Support Stored Procedure for Sharding-Proxy 
IF not sharding
URL: 
https://github.com/apache/incubator-shardingsphere/issues/2195#issuecomment-485374983
 
 
   CREATE PROCEDURE and CREATE FUNCTION Syntax both supported. Here are the 
test cases:
   
   For CREATE PROCEDURE:
   ```
   delimiter $$
   CREATE PROCEDURE insert_procedure()
   BEGIN
           insert into t_order (order_id, user_id, status) values (123, 123, 
"123");
           insert into t_order (order_id, user_id, status) values (456, 456, 
"456");
   END$$
   delimiter;
   call insert_procedure();
   ```
   
   For CREATE FUNCTION:
   ```
   DELIMITER $$
   CREATE FUNCTION hello ( ) RETURNS VARCHAR ( 255 ) 
   BEGIN
           RETURN 'Hello  world!';
   END $$DELIMITER;
   SELECT hello ();
   ```

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services