cobar支持空间数据库嘛?

[justlooks]

我们在实际应用中发现通过cobar使用astext函数报错

mysql> SELECT rider_shape,astext(rider_shape) from sp_rider_space where city_id=1 and rider_id=1 and shardx=254
-> ;
ERROR 1064 (HY000): You have an error in your SQL syntax; Error occurs around this fragment: {er_shape,astext(rider_shap}. Error cause: SQL syntax error!

后端日志报
11:40:31,964 DEBUG [thread=Processor2-H2,class=ServerConnection,host=192.168.1.155,port=38701,schema=dwd_shardc]SELECT rider_shape,astext(rider_shape) from sp_rider_space where city_id=1 and rider_id=1 and shardx=254
11:40:31,965 WARN [thread=Processor2-H2,class=ServerConnection,host=192.168.1.155,port=38701,schema=dwd_shardc]SELECT rider_shape,astext(rider_shape) from sp_rider_space where city_id=1 and rider_id=1 and shardx=254
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; Error occurs around this fragment: {er_shape,astext(rider_shap}. Error cause: SQL syntax error!
at com.alibaba.cobar.parser.recognizer.SQLParserDelegate.parse(SQLParserDelegate.java:155)
at com.alibaba.cobar.parser.recognizer.SQLParserDelegate.parse(SQLParserDelegate.java:160)
at com.alibaba.cobar.route.ServerRouter.route(ServerRouter.java:99)
at com.alibaba.cobar.server.ServerConnection.execute(ServerConnection.java:146)
at com.alibaba.cobar.server.handler.SelectHandler.handle(SelectHandler.java:90)
at com.alibaba.cobar.server.ServerQueryHandler.query(ServerQueryHandler.java:63)
at com.alibaba.cobar.net.FrontendConnection.query(FrontendConnection.java:266)
at com.alibaba.cobar.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:48)
at com.alibaba.cobar.net.FrontendConnection$1.run(FrontendConnection.java:372)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLSyntaxErrorException: SQL syntax error!
at com.alibaba.cobar.parser.recognizer.SQLParserDelegate.parse(SQLParserDelegate.java:150)
... 11 more
11:40:42,492 DEBUG [thread=Processor0-R,class=ServerConnection,host=192.168.1.188,port=57651,schema=dwd_shardc]
java.io.EOFException
at com.alibaba.cobar.net.AbstractConnection.read(AbstractConnection.java:163)
at com.alibaba.cobar.net.NIOReactor$R.read(NIOReactor.java:130)
at com.alibaba.cobar.net.NIOReactor$R.run(NIOReactor.java:98)
at java.lang.Thread.run(Thread.java:662)
11:40:42,492 DEBUG [thread=Processor3-R,class=ServerConnection,host=192.168.1.188,port=57650,schema=dwd_shardc]
java.io.EOFException
at com.alibaba.cobar.net.AbstractConnection.read(AbstractConnection.java:163)
at com.alibaba.cobar.net.NIOReactor$R.read(NIOReactor.java:130)
at com.alibaba.cobar.net.NIOReactor$R.run(NIOReactor.java:98)
at java.lang.Thread.run(Thread.java:662)

貌似cobar的语法校验通不过

[liuhuanting]

Cobar的解析器中，对空间数据类型以及部分数据类型（如时间戳、SERIAL、布尔等），部分函数，存储过程，预编译语句，部分DDL（视图，外键等）等都不支持。