azexcy opened a new issue, #28317:
URL: https://github.com/apache/shardingsphere/issues/28317
## Bug Report
When use ShardingSphere-Proxy, Some SQL of Oracle not support now.
1. batch insert
```
mysql> INSERT ALL
-> INTO T_MASK(ID,EMAIL,NAME,PHONE,ADDRESS) VALUES (1,'2','3','4','5')
-> INTO T_MASK(ID,EMAIL,NAME,PHONE,ADDRESS) VALUES (2,'2','3','4','5')
-> INTO T_MASK(ID,EMAIL,NAME,PHONE,ADDRESS) VALUES (3,'2','3','4','5')
-> SELECT 1 FROM DUAL;
ERROR 12000 (42000): You have an error in your SQL syntax: INSERT ALL
INTO T_MASK(ID,EMAIL,NAME,PHONE,ADDRESS) VALUES (1,'2','3','4','5')
INTO T_MASK(ID,EMAIL,NAME,PHONE,ADDRESS) VALUES (2,'2','3','4','5')
INTO T_MASK(ID,EMAIL,NAME,PHONE,ADDRESS) VALUES (3,'2','3','4','5')
SELECT 1 FROM DUAL, no viable alternative at input 'ALL' at line 1, position
7, near [@1,7:9='ALL',<93>,1:7]
mysql>
```
<img width="780" alt="image"
src="https://github.com/apache/shardingsphere/assets/101622833/6b633e6b-4020-4008-acda-8ceff4cb8fc2";>
2. Not support `VARCHAR2`
```
mysql> ALTER TABLE T_MASK ADD new_column VARCHAR2(100);
ERROR 12000 (42000): You have an error in your SQL syntax: ALTER TABLE
T_MASK ADD new_column VARCHAR2(100), no viable alternative at input 'VARCHAR2'
at line 1, position 34, near [@5,34:41='VARCHAR2',<862>,1:34]
```
### Which version of ShardingSphere did you use?
master
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
SQL execute success.
### Actual behavior
Parse failed
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule
configuration, when exception occur etc.
1. server.yaml
```
...
props:
...
proxy-frontend-database-protocol-type: MySQL
```
2. config-sharding.yaml
```
databaseName: sharding_db
dataSources:
ds_0:
url: jdbc:oracle:thin:@localhost:1542:XE
username: test
password: 123456
maxPoolSize: 50
minPoolSize: 1
```
### Example codes for reproduce this issue (such as a github link).
--
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.
To unsubscribe, e-mail:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
