今天测试了一下Mycat中的MySQL随机函数,又发现一个这样的Bug
2016-12-10 22:38:39,109 [INFO ][$_NIOREACTOR-2-RW] close connection,reason:quit cmd ,ServerConnection [id=4, schema=TESTDB, host=127.0.0.1, user=root,txIsolation=3, autocommit=true, schema=TESTDB] (io.mycat.net.AbstractConnection:AbstractConnection.java:508)
2016-12-10 22:40:22,953 [WARN ][$_NIOREACTOR-3-RW] caught exception java.lang.IllegalArgumentException: all columns in order by clause should be in the selected column list!RAND()
at io.mycat.sqlengine.mpp.DataMergeService.onRowMetaData(DataMergeService.java:156)
at io.mycat.backend.mysql.nio.handler.MultiNodeQueryHandler.fieldEofResponse(MultiNodeQueryHandler.java:650)
at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handleFieldEofPacket(MySQLConnectionHandler.java:192)
at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handleData(MySQLConnectionHandler.java:118)