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

2019-04-22 Thread GitBox 
tuohai666 edited a comment 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

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

2019-04-22 Thread GitBox 
tuohai666 edited a comment 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