dble icon indicating copy to clipboard operation
dble copied to clipboard

Data type set is not supported

Open ikarishinjieva opened this issue 7 years ago • 0 comments

Raised by: @zhunina
Steps:

  1. 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)

ikarishinjieva avatar Aug 24 '17 13:08 ikarishinjieva