You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/03/07 03:05:42 UTC
[GitHub] [incubator-doris] morningman opened a new pull request #3050:
[MysqlProtocol] Support MySQL multiple statements protocal
morningman opened a new pull request #3050: [MysqlProtocol] Support MySQL multiple statements protocal
URL: https://github.com/apache/incubator-doris/pull/3050
Support multiple statements in one request like:
```
select 10; select 20; select 30;
```
ISSUE: #3049
For simple testing this CL, you can using mysql-client shell command tools:
```
mysql> delimiter 0
mysql> select 10; select 20
+------+
| 1 |
+------+
| 1 |
+------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
+------+
| 2 |
+------+
| 2 |
+------+
1 row in set (0.01 sec)
```
The delimiter to `0` because with default delimiter `;`, the mysql-client shell will
automatically split the statements with delimiter.
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman merged pull request #3050:
[MysqlProtocol] Support MySQL multiple statements protocol
Posted by GitBox <gi...@apache.org>.
morningman merged pull request #3050: [MysqlProtocol] Support MySQL multiple statements protocol
URL: https://github.com/apache/incubator-doris/pull/3050
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] wutiangan commented on issue #3050:
[MysqlProtocol] Support MySQL multiple statements protocol
Posted by GitBox <gi...@apache.org>.
wutiangan commented on issue #3050: [MysqlProtocol] Support MySQL multiple statements protocol
URL: https://github.com/apache/incubator-doris/pull/3050#issuecomment-596203454
Your example is inconsistent with MySQL.
mysql> delimiter 0
mysql> select 10; select 20
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; select 2' at line 1
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman commented on issue #3050:
[MysqlProtocol] Support MySQL multiple statements protocol
Posted by GitBox <gi...@apache.org>.
morningman commented on issue #3050: [MysqlProtocol] Support MySQL multiple statements protocol
URL: https://github.com/apache/incubator-doris/pull/3050#issuecomment-596345278
> Your example is inconsistent with MySQL.
No , the example is only used for testing Doris. Because in Doris grammar, we define "; " as the delimiter. Set delimiter 0 is just to trick the mysql-client.
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org