dble
dble copied to clipboard
Data type set is not supported
Raised by: @zhunina
Steps:
- Execute
create table set_columns(
id int primary key,
c_set set('s','m','x')
);
return error: ERROR 1064 (HY000): error SET
Log:
2016-12-09 11:26:40,556 [WARN ][$_NIOREACTOR-3-RW] ServerConnection [id=1, schema=TESTDB, host=10.186.21.74, user=test,txIsolation=3, autocommit=true, schema=TESTDB]create table set_columns(
INFO | jvm 1 | 2016/12/09 11:26:40 | id int primary key,
INFO | jvm 1 | 2016/12/09 11:26:40 | c_set set('s','m','x')
INFO | jvm 1 | 2016/12/09 11:26:40 | ) err:com.alibaba.druid.sql.parser.ParserException: error SET com.alibaba.druid.sql.parser.ParserException: error SET
INFO | jvm 1 | 2016/12/09 11:26:40 | at com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:974)
INFO | jvm 1 | 2016/12/09 11:26:40 | at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:1624)
INFO | jvm 1 | 2016/12/09 11:26:40 | at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:537)
INFO | jvm 1 | 2016/12/09 11:26:40 | at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCrateTable(MySqlCreateTableParser.java:114)
INFO | jvm 1 | 2016/12/09 11:26:40 | at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:342)
INFO | jvm 1 | 2016/12/09 11:26:40 | at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:194)
INFO | jvm 1 | 2016/12/09 11:26:40 | at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatement(SQLStatementParser.java:2065)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.server.interceptor.impl.GlobalTableUtil.handleDDLSQL(GlobalTableUtil.java:127)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.server.interceptor.impl.GlobalTableUtil.consistencyInterceptor(GlobalTableUtil.java:100)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.server.interceptor.impl.GlobalTableUtil.interceptSQL(GlobalTableUtil.java:83)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.server.interceptor.impl.DefaultSqlInterceptor.interceptSQL(DefaultSqlInterceptor.java:56)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:43)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.route.RouteService.route(RouteService.java:133)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:273)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.server.ServerConnection.execute(ServerConnection.java:222)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.server.ServerQueryHandler.query(ServerQueryHandler.java:136)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.net.FrontendConnection.query(FrontendConnection.java:317)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.net.FrontendConnection.query(FrontendConnection.java:337)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:71)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.net.FrontendConnection.rawHandle(FrontendConnection.java:478)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.net.FrontendConnection.handle(FrontendConnection.java:460)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.net.AbstractConnection.onReadData(AbstractConnection.java:321)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.net.NIOSocketWR.asynRead(NIOSocketWR.java:190)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.net.AbstractConnection.asynRead(AbstractConnection.java:273)
INFO | jvm 1 | 2016/12/09 11:26:40 | at io.mycat.net.NIOReactor$RW.run(NIOReactor.java:102)
INFO | jvm 1 | 2016/12/09 11:26:40 | at java.lang.Thread.run(Thread.java:722)
INFO | jvm 1 | 2016/12/09 11:26:40 | (io.mycat.server.ServerConnection:ServerConnection.java:281)