huangxinjian opened a new issue, #19766:
URL: https://github.com/apache/shardingsphere/issues/19766
## Feature Request
I think the class `H2Repository` can change internal sql
```sql
CREATE TABLE repository(id varchar(36) PRIMARY KEY, key TEXT, value TEXT,
parent TEXT);
```
to
```sql
CREATE TABLE repository(id_ varchar(36) PRIMARY KEY, key_ TEXT, value_ TEXT,
parent_ TEXT)
```
because `key` is key word on mysql / mariadb that can't execute successful.
Why I use H2Repository with mysql, because the class has args `props`, So I
found this problem.
```sql
return new ModeConfiguration("Standalone", new
StandalonePersistRepositoryConfiguration("H2", new Properties(){{
put(JDBCRepositoryPropertyKey.JDBC_URL.getKey(), "your jdbc
url");
put(JDBCRepositoryPropertyKey.USER.getKey(), "your jdbc name");
put(JDBCRepositoryPropertyKey.PASSWORD.getKey(), "your jdbc
password");
}}), true);
```
--
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:
notifications-unsubscr...@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
