dble icon indicating copy to clipboard operation
dble copied to clipboard

Published 20 hours ago • verified publisher icon actiontech

Some syntax, druid parser does not recognize

Open FlyingMao opened this issue 6 years ago • 10 comments

  • dble version：
    5.6.29-dble-9.9.9.9-359645c-20181029082136
  • preconditions ：
    no
  • configs：

schema.xml

<?xml version="1.0"?>
<!DOCTYPE dble:schema SYSTEM "schema.dtd">
<dble:schema xmlns:dble="http://dble.cloud/">
	<schema name="mytest" sqlMaxLimit="100" dataNode="dn5">
        <table name="sharding_one_1" primaryKey="id" dataNode="dn1" />
		<table name="sharding_one_2" primaryKey="id" dataNode="dn1" />
		<table name="a_two" primaryKey="id" dataNode="dn1,dn2" rule="hash-two" />
        <table name="a_three" primaryKey="id" dataNode="dn1,dn2,dn3" rule="hash-three" />
		<table name="BAMS_FLOW_LOG" primaryKey="id" dataNode="dn1,dn2" rule="hash-two" />
		
		<!--固定Hash分区(string)-->
        <table name="fixed_patch_uniform_string" dataNode="dn1,dn2,dn3,dn4" rule="fixed_uniform_string_rule" />
        <table name="fixed_patch_nonuniform_string" dataNode="dn1,dn2,dn3" rule="fixed_nonuniform_string_rule" />

        <!--枚举方式分区-->
        <table name="enum_patch_integer" dataNode="dn1,dn2,dn3,dn4" rule="enum_integer_rule"/>
		<table name="enum_patch_string" dataNode="dn1,dn2,dn3,dn4" rule="enum_string_rule"/>

		<!--数字范围分区-->
		<table name="range_patch" dataNode="dn1,dn2,dn3,dn4" rule="range_rule" />

        <!--按日期分区-->
		<table name="date_patch" dataNode="dn1,dn2,dn3,dn4" rule="date_rule" />
		<table name="date_patch_default" dataNode="dn1,dn2,dn3,dn4" rule="date_default_rule" />

		<!--全局表-->
		<table name="global_table1" primaryKey="id" type="global" dataNode="dn1,dn2,dn3,dn4" />
		<table name="global_table2" primaryKey="id" type="global" dataNode="dn1,dn2,dn3,dn4" />
		<table name="global_table3" primaryKey="id" type="global" dataNode="dn1,dn2" />
		<table name="test_global" dataNode="dn1,dn2,dn3,dn4" type="global"/>

		<!-- 取模 -->
		<table name="aly_test" dataNode="dn1,dn2,dn3,dn4" rule="hash-four" />
		<table name="aly_order" dataNode="dn1,dn2,dn3,dn4" rule="hash-four" />
		<table name="a_manager" primaryKey="id" dataNode="dn1,dn2,dn3,dn4" rule="hash-four" />
		<table name="mytest_auto_test1" dataNode="dn1,dn2,dn3,dn4" rule="hash-four" primaryKey="R_REGIONKEY" autoIncrement="true"/>
		<table name="test_shard" dataNode="dn1,dn2,dn3,dn4" rule="hash-four"/>
	</schema>
	<schema name="testdb" sqlMaxLimit="100">
		<table name="tb_test" dataNode="dn1,dn2,dn3,dn4" rule="hash-four" />
	</schema>

	<dataNode name="dn1" dataHost="172.100.9.5" database="db1" />
	<dataNode name="dn2" dataHost="172.100.9.6" database="db1" />
	<dataNode name="dn3" dataHost="172.100.9.5" database="db2" />
	<dataNode name="dn4" dataHost="172.100.9.6" database="db2" />
	<dataNode name="dn5" dataHost="172.100.9.5" database="db3" />

	<dataHost name="172.100.9.5" maxCon="1000" minCon="10" balance="0" switchType="1"  slaveThreshold="100">
		<heartbeat>select user()</heartbeat>
		<writeHost host="hostM1" url="172.100.9.5:3306" user="test"
				   password="111111">
		</writeHost>
	</dataHost>

	<dataHost name="172.100.9.6" maxCon="1000" minCon="10" balance="0" switchType="1"  slaveThreshold="100">
		<heartbeat>select user()</heartbeat>
		<writeHost host="hostM2" url="172.100.9.6:3306" user="test"
				   password="111111">
		</writeHost>
	</dataHost>
	
</dble:schema>

rule.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dble:rule SYSTEM "rule.dtd">
<dble:rule xmlns:dble="http://dble.cloud/">
	<tableRule name="fixed_uniform_string_rule">
		<rule>
			<columns>id</columns>
			<algorithm>fixed_uniform_string</algorithm>
		</rule>
	</tableRule>
	<tableRule name="fixed_nonuniform_string_rule">
		<rule>
			<columns>id</columns>
			<algorithm>fixed_nonuniform_string</algorithm>
		</rule>
	</tableRule>
	<tableRule name="enum_integer_rule">
		<rule>
			<columns>id</columns>
			<algorithm>enum_integer</algorithm>
		</rule>
	</tableRule>
	<tableRule name="enum_string_rule">
		<rule>
			<columns>id</columns>
			<algorithm>enum_string</algorithm>
		</rule>
	</tableRule>
	<tableRule name="range_rule">
		<rule>
			<columns>id</columns>
			<algorithm>range</algorithm>
		</rule>
	</tableRule>
	<tableRule name="date_rule">
		<rule>
			<columns>id</columns>
			<algorithm>date</algorithm>
		</rule>
	</tableRule>
	<tableRule name="date_default_rule">
		<rule>
			<columns>id</columns>
			<algorithm>date_default</algorithm>
		</rule>
	</tableRule>

	<tableRule name="hash-two">
        <rule>
            <columns>id</columns>
            <algorithm>two-long</algorithm>
        </rule>
    </tableRule>
    <tableRule name="hash-three">
        <rule>
            <columns>id</columns>
            <algorithm>three-long</algorithm>
        </rule>
    </tableRule>
	<tableRule name="hash-four">
        <rule>
            <columns>id</columns>
            <algorithm>four-long</algorithm>
        </rule>
    </tableRule>
    <function name="two-long" class="Hash">
        <property name="partitionCount">2</property>
        <property name="partitionLength">1</property>
    </function>
    <function name="three-long" class="Hash">
        <property name="partitionCount">3</property>
        <property name="partitionLength">1</property>
    </function>
	<function name="four-long" class="Hash">
		<property name="partitionCount">4</property>
		<property name="partitionLength">1</property>
	</function>
	<function name="fixed_uniform" class="Hash">
		<property name="partitionCount">4</property>
		<property name="partitionLength">256</property>
	</function>		
	<function name="fixed_nonuniform" class="Hash">
		<property name="partitionCount">2,1</property>
		<property name="partitionLength">256,512</property>
	</function>
	<function name="fixed_uniform_string" class="StringHash">
		<property name="partitionCount">4</property>
		<property name="partitionLength">256</property>
		<property name="hashSlice">0:2</property>
	</function>		
	<function name="fixed_nonuniform_string" class="StringHash">
		<property name="partitionCount">2,1</property>
		<property name="partitionLength">256,512</property>
		<property name="hashSlice">0:2</property>
	</function>	
	<function name="enum_integer" class="Enum">
		<property name="mapFile">enum-integer.txt</property>
		<property name="type">0</property>
		<property name="defaultNode">0</property>
	</function>	
	<function name="enum_string" class="Enum">
		<property name="mapFile">enum-string.txt</property>
		<property name="type">1</property>
		<property name="defaultNode">0</property>
	</function>	
	<function name="range" class="NumberRange">
		<property name="mapFile">range.txt</property>
		<!--<property name="defaultNode">0</property>-->
	</function>	
	<function name="range_string" class="NumberRange">
		<property name="mapFile">range_default.txt</property>
		<property name="defaultNode">3</property>
	</function>	
	<function name="date" class="Date">
		<property name="dateFormat">yyyy-MM-dd</property>
		<property name="sBeginDate">2016-12-01</property>
		<property name="sEndDate">2017-01-9</property>
		<property name="sPartionDay">10</property>
		<!--<property name="defaultNode">0</property>-->
	</function>	
	<function name="date_default" class="Date">
		<property name="dateFormat">yyyy-MM-dd</property>
		<property name="sBeginDate">2016-12-01</property>
		<property name="sEndDate">2017-01-9</property>
		<property name="sPartionDay">10</property>
		<property name="defaultNode">0</property>
	</function>

</dble:rule>

server.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dble:server SYSTEM "server.dtd">
<dble:server xmlns:dble="http://dble.cloud/">
	<system>
		<property name="useGlobleTableCheck">1</property>
		<!--<property name="useExtensions">true</property>-->
		<property name="serverPort">8066</property>

	</system>
	
	<user name="test">
		<property name="password">111111</property>
		<property name="schemas">mytest,testdb</property>
	</user>
	<user name="root">
		<property name="password">111111</property>
		<property name="manager">true</property>
	</user>

</dble:server>
  • steps：
    step1. prepare tables in dble
drop table if exists test_shard;
create table test_shard (id int(11) primary key,R_REGIONKEY float,R_NAME varchar(50),R_COMMENT varchar(50));
insert into test_shard (id,R_REGIONKEY,R_NAME,R_COMMENT) values (1,1, 'a string','test001'),(3,3, 'another string','test003'),(2,2, 'a\nstring','test002'),(4,4, '中','test004'),(5,5, 'a\'string\'','test005'),(6,6, 'a\""string\""','test006'),(7,7, 'a\bstring','test007'),(8,8, 'a\nstring','test008'),(9,9, 'a\rstring','test009'),(10,10, 'a\tstring','test010'),(11,11, 'a\zstring','test011'),(12,12, 'a\\string','test012'),(13,13, 'a\%string','test013'),(14,14, 'a\_string','test014'),(15,15, 'MySQL','test015'),(16,16, 'binary','test016'),(65,16, 'binary','test016'),(17,12345678901234567890123.4567890,17,17),(18,18, 'A','test018'),(19,19, '','test019');

drop table if exists test_global ;
create table test_global (id int,`OUTFILE` int);
insert into test_global (id,`OUTFILE`) values (1,1),(2,3),(3,4),(4,5);

drop table if exists test_no_shard;
create table test_no_shard (id int(11) primary key,R_REGIONKEY float,R_NAME varchar(50),R_COMMENT varchar(50))DEFAULT CHARSET=UTF8;
insert into test_no_shard (id,R_REGIONKEY,R_NAME,R_COMMENT) values (1,1, 'a string','test001'),(3,3, 'another string','test003'),(2,2, 'a\nstring','test002'),(4,4, '中','test004'),(5,5, 'a\'string\'','test005'),(6,6, 'a\""string\""','test006'),(7,7, 'a\bstring','test007'),(8,8, 'a\nstring','test008'),(9,9, 'a\rstring','test009'),(10,10, 'a\tstring','test010'),(11,11, 'a\zstring','test011'),(12,12, 'a\\string','test012'),(13,13, 'a\%string','test013'),(14,14, 'a\_string','test014'),(15,15, 'MySQL','test015'),(16,16, 'binary','test016'),(65,16, 'binary','test016'),(17,12345678901234567890123.4567890,17,17),(18,18, 'A','test018'),(19,19, '','test019');

step2 . execute select in dble

mysql> select * from test_no_shard where id=@var1 := 1;
mysql>  select * from test_global order by `OUTFILE` limit 10;
mysql> select * from test_shard where R_NAME=B'1000001';
mysql> lock table test_shard write,test_no_shard write;
  • expect result：
    1.
mysql> select * from test_no_shard where id=@var1 := 1;
+----+-------------+----------+-----------+
| id | R_REGIONKEY | R_NAME   | R_COMMENT |
+----+-------------+----------+-----------+
|  1 |           1 | a string | test001   |
+----+-------------+----------+-----------+
1 row in set (0.00 sec)

mysql> select * from test_global order by `OUTFILE` limit 10;
+------+---------+
| id   | OUTFILE |
+------+---------+
|    1 |       1 |
|    2 |       3 |
|    3 |       4 |
|    4 |       5 |
+------+---------+
4 rows in set (0.00 sec)

mysql> select * from test_shard where R_NAME=B'1000001';
+----+-------------+--------+-----------+
| id | R_REGIONKEY | R_NAME | R_COMMENT |
+----+-------------+--------+-----------+
| 18 |          18 | A      | test018   |
+----+-------------+--------+-----------+
1 row in set (0.01 sec)

mysql> lock table test_shard write,test_no_shard write;
Query OK, 0 rows affected (0.00 sec)
  • real result：
    1.
mysql> select * from test_no_shard where id=@var1 := 1;
ERROR 1064 (HY000): sql syntax error, no terminated. COLONEQ
mysql> select * from test_global order by `OUTFILE` limit 10;
ERROR 1064 (HY000): sql syntax error, no terminated. LITERAL_INT
mysql> select * from test_shard where R_NAME=B'1000001';
ERROR 1064 (HY000): sql syntax error, no terminated. LITERAL_CHARS
mysql> lock table test_shard write,test_no_shard write;
ERROR 1064 (HY000): sql syntax error, no terminated. COMMA
  • supplements：
    1. the error in dble.log like that:
2018-10-29 23:17:00.639  INFO [BusinessExecutor0] (com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:37)) - rou
com.alibaba.druid.sql.parser.ParserException: sql syntax error, no terminated. COLONEQ
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatement(SQLStatementParser.java:2741) ~[druid-1.1.10.jar:1.1.10]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:35) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.routeNormalSqlWithAST(DefaultRouteStrategy.java:73) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:50) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.RouteService.route(RouteService.java:112) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:316) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.execute(ServerConnection.java:259) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.handler.SelectHandler.handle(SelectHandler.java:99) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerQueryHandler.query(ServerQueryHandler.java:89) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:319) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:335) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handleData(FrontendCommandHandler.java:77) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:55) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontEndHandlerRunnable.run(FrontEndHandlerRunnable.java:44) [dble-9.9.9.9.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
2018-10-29 23:17:00.640  INFO [BusinessExecutor0] (com.actiontech.dble.server.ServerConnection.executeException(ServerConnection.java:371)) - ServerCsolation=3, autocommit=true, schema=mytest]select * from test_no_shard where id=@var1 := 1 err:sql syntax error, no terminated. COLONEQ

/label ~BUG

FlyingMao avatar Oct 30 '18 06:10 FlyingMao

https://github.com/alibaba/druid/pull/2865

yanhuqing666 avatar Oct 30 '18 09:10 yanhuqing666

2. Durid parser error when index_list of USE INDEX is omitted

steps:

  1. prepare table in dble
drop table if exists aly_test;
CREATE TABLE aly_test(`id` int(10) unsigned NOT NULL,`t_id` int(10) unsigned NOT NULL DEFAULT '0',`name` char(120) NOT NULL DEFAULT '',`pad` int(11) NOT NULL,PRIMARY KEY (`id`),KEY `k_1` (`t_id`))DEFAULT CHARSET=UTF8;
insert into aly_test values(1,1,'test中id为1',1),(2,2,'test_2',2),(3,3,'test中id为3',4),(4,4,'$test$4',3),(5,5,'test...5',1),(6,6,'test6',6);
create index pad_index on aly_test(pad);
  1. execute query in dble
SELECT * FROM aly_test  use INDEX () ;

expect result:

mysql> SELECT * FROM aly_test  use INDEX () ;                                                                                                       
+----+------+---------------+-----+
| id | t_id | name          | pad |
+----+------+---------------+-----+
|  1 |    1 | test中id为1   |   1 |
|  2 |    2 | test_2        |   2 |
|  3 |    3 | test中id为3   |   4 |
|  4 |    4 | $test$4       |   3 |
|  5 |    5 | test...5      |   1 |
|  6 |    6 | test6         |   6 |
+----+------+---------------+-----+
6 rows in set (0.00 sec)

real result:

mysql> SELECT * FROM aly_test  use INDEX () ;
ERROR 1064 (HY000): error pos 36, line 1, column 36, token RPAREN

for tester:

suggest autotest position: sqls/select/reference.sql (reference line 14、15、38、39、40)

FlyingMao avatar Oct 31 '18 06:10 FlyingMao

3.

query:

mysql> CREATE TABLE aly_test(id int, data1 varchar(10),data2 varchar(10),data3 varchar(20) GENERATED ALWAYS as (concat(data1,' ',data2)))
    -> ;
ERROR 1064 (HY000): syntax error, error in :'(20) GENERATED ALWAYS as (concat(da', expect RPAREN, actual IDENTIFIER pos 93, line 1, column 84, token IDENTIFIER GENERATED

dble log：

2018-11-01 03:06:31.023  INFO [BusinessExecutor2] (com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:37)) - routeNormalSqlWithAST
com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'(20) GENERATED ALWAYS as (concat(da', expect RPAREN, actual IDENTIFIER pos 93, line 1, column 84, token IDENTIFIER GENERATED
	at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:268) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:243) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:161) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatement(SQLStatementParser.java:2738) ~[druid-1.1.10.jar:1.1.10]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:35) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.routeNormalSqlWithAST(DefaultRouteStrategy.java:73) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:50) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.RouteService.route(RouteService.java:112) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:316) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.execute(ServerConnection.java:259) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerQueryHandler.query(ServerQueryHandler.java:166) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:319) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:335) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handleData(FrontendCommandHandler.java:77) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:55) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontEndHandlerRunnable.run(FrontEndHandlerRunnable.java:44) [dble-9.9.9.9.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
2018-11-01 03:06:31.024  INFO [BusinessExecutor2] (com.actiontech.dble.server.ServerConnection.executeException(ServerConnection.java:371)) - ServerConnection [id=2, schema=mytest, host=127.0.0.1, user=test,txIsolation=3, autocommit=true, schema=mytest]CREATE TABLE aly_test(id int, data1 varchar(10),data2 varchar(10),data3 varchar(20) GENERATED ALWAYS as (concat(data1,' ',data2))) err:syntax error, error in :'(20) GENERATED ALWAYS as (concat(da', expect RPAREN, actual IDENTIFIER pos 93, line 1, column 84, token IDENTIFIER GENERATED

for tester: suggest autotest position: sqls/syntax/create_table_definition.sql (reference line 94)

verified on version: 5.6.29-dble-9.9.9.9-978d59b0f2d83f9a46ec7e4c914277be407820aa-20190314102656

FlyingMao avatar Nov 01 '18 07:11 FlyingMao

4.

query:

mysql> CREATE TABLE aly_test ( id int(11),test int,detail varchar(20),CONSTRAINT PRIMARY KEY (id ASC));
ERROR 1064 (HY000): syntax error, expect RPAREN, actual ASC pos 93, line 1, column 90, token ASC

dble log:

2018-11-01 03:22:16.047  INFO [BusinessExecutor0] (com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:37)) - routeNormalSqlWithAST
com.alibaba.druid.sql.parser.ParserException: syntax error, expect RPAREN, actual ASC pos 93, line 1, column 90, token ASC
	at com.alibaba.druid.sql.parser.SQLExprParser.accept(SQLExprParser.java:2639) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parsePrimaryKey(MySqlExprParser.java:769) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseConstraint(MySqlCreateTableParser.java:981) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:187) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:243) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:161) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatement(SQLStatementParser.java:2738) ~[druid-1.1.10.jar:1.1.10]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:35) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.routeNormalSqlWithAST(DefaultRouteStrategy.java:73) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:50) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.RouteService.route(RouteService.java:112) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:316) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.execute(ServerConnection.java:259) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerQueryHandler.query(ServerQueryHandler.java:166) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:319) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:335) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handleData(FrontendCommandHandler.java:77) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:55) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontEndHandlerRunnable.run(FrontEndHandlerRunnable.java:44) [dble-9.9.9.9.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
2018-11-01 03:22:16.049  INFO [BusinessExecutor0] (com.actiontech.dble.server.ServerConnection.executeException(ServerConnection.java:371)) - ServerConnection [id=2, schema=mytest, host=127.0.0.1, user=test,txIsolation=3, autocommit=true, schema=mytest]CREATE TABLE aly_test ( id int(11),test int,detail varchar(20),CONSTRAINT PRIMARY KEY (id ASC)) err:syntax error, expect RPAREN, actual ASC pos 93, line 1, column 90, token ASC

FlyingMao avatar Nov 01 '18 07:11 FlyingMao

5.

query:

mysql> CREATE TABLE aly_test ( id int(11),detail varchar(20),PRIMARY KEY (id) KEY_BLOCK_SIZE = 10);
ERROR 1064 (HY000): syntax error, error in :'(id) KEY_BLOCK_SIZE = 10)', expect RPAREN, actual IDENTIFIER pos 85, line 1, column 71, token IDENTIFIER KEY_BLOCK_SIZE

dble.log:

2018-11-01 03:37:15.857  INFO [BusinessExecutor3] (com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:37)) - routeNormalSqlWithAST
com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'(id) KEY_BLOCK_SIZE = 10)', expect RPAREN, actual IDENTIFIER pos 85, line 1, column 71, token IDENTIFIER KEY_BLOCK_SIZE
	at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:268) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:243) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:161) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatement(SQLStatementParser.java:2738) ~[druid-1.1.10.jar:1.1.10]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:35) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.routeNormalSqlWithAST(DefaultRouteStrategy.java:73) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:50) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.RouteService.route(RouteService.java:112) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:316) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.execute(ServerConnection.java:259) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerQueryHandler.query(ServerQueryHandler.java:166) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:319) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:335) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handleData(FrontendCommandHandler.java:77) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:55) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontEndHandlerRunnable.run(FrontEndHandlerRunnable.java:44) [dble-9.9.9.9.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
2018-11-01 03:37:15.859  INFO [BusinessExecutor3] (com.actiontech.dble.server.ServerConnection.executeException(ServerConnection.java:371)) - ServerConnection [id=2, schema=mytest, host=127.0.0.1, user=test,txIsolation=3, autocommit=true, schema=mytest]CREATE TABLE aly_test ( id int(11),detail varchar(20),PRIMARY KEY (id) KEY_BLOCK_SIZE = 10) err:syntax error, error in :'(id) KEY_BLOCK_SIZE = 10)', expect RPAREN, actual IDENTIFIER pos 85, line 1, column 71, token IDENTIFIER KEY_BLOCK_SIZE

FlyingMao avatar Nov 01 '18 07:11 FlyingMao

6.

query:

mysql> CREATE TABLE aly_test ( id int(11),detail varchar(20),PRIMARY KEY (detail) WITH PARSER ngram);
ERROR 1064 (HY000): syntax error, error in :'ail) WITH PARSER ngram)', expect RPAREN, actual WITH pos 79, line 1, column 75, token WITH

dble.log:

2018-11-01 03:39:12.691  INFO [BusinessExecutor0] (com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:37)) - routeNormalSqlWithAST
com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'ail) WITH PARSER ngram)', expect RPAREN, actual WITH pos 79, line 1, column 75, token WITH
	at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:268) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:243) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:161) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatement(SQLStatementParser.java:2738) ~[druid-1.1.10.jar:1.1.10]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:35) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.routeNormalSqlWithAST(DefaultRouteStrategy.java:73) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:50) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.RouteService.route(RouteService.java:112) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:316) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.execute(ServerConnection.java:259) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerQueryHandler.query(ServerQueryHandler.java:166) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:319) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:335) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handleData(FrontendCommandHandler.java:77) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:55) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontEndHandlerRunnable.run(FrontEndHandlerRunnable.java:44) [dble-9.9.9.9.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
2018-11-01 03:39:12.693  INFO [BusinessExecutor0] (com.actiontech.dble.server.ServerConnection.executeException(ServerConnection.java:371)) - ServerConnection [id=2, schema=mytest, host=127.0.0.1, user=test,txIsolation=3, autocommit=true, schema=mytest]CREATE TABLE aly_test ( id int(11),detail varchar(20),PRIMARY KEY (detail) WITH PARSER ngram) err:syntax error, error in :'ail) WITH PARSER ngram)', expect RPAREN, actual WITH pos 79, line 1, column 75, token WITH

FlyingMao avatar Nov 01 '18 07:11 FlyingMao

7.

query:

mysql> CREATE TABLE aly_test ( id int(11),test int,detail varchar(20),INDEX key_id (id) COMMENT 'string');
ERROR 1064 (HY000): syntax error, error in :'(id) COMMENT 'string')', expect RPAREN, actual COMMENT pos 88, line 1, column 81, token COMMENT

dble log:

2018-11-01 03:47:07.854  INFO [BusinessExecutor0] (com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:37)) - routeNormalSqlWithAST
com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'(id) COMMENT 'string')', expect RPAREN, actual COMMENT pos 88, line 1, column 81, token COMMENT
	at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:268) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:243) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:161) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatement(SQLStatementParser.java:2738) ~[druid-1.1.10.jar:1.1.10]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:35) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.routeNormalSqlWithAST(DefaultRouteStrategy.java:73) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:50) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.RouteService.route(RouteService.java:112) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:316) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.execute(ServerConnection.java:259) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerQueryHandler.query(ServerQueryHandler.java:166) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:319) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:335) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handleData(FrontendCommandHandler.java:77) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:55) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontEndHandlerRunnable.run(FrontEndHandlerRunnable.java:44) [dble-9.9.9.9.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
2018-11-01 03:47:07.855  INFO [BusinessExecutor0] (com.actiontech.dble.server.ServerConnection.executeException(ServerConnection.java:371)) - ServerConnection [id=2, schema=mytest, host=127.0.0.1, user=test,txIsolation=3, autocommit=true, schema=mytest]CREATE TABLE aly_test ( id int(11),test int,detail varchar(20),INDEX key_id (id) COMMENT 'string') err:syntax error, error in :'(id) COMMENT 'string')', expect RPAREN, actual COMMENT pos 88, line 1, column 81, token COMMENT

FlyingMao avatar Nov 01 '18 07:11 FlyingMao

8.

query:

mysql> CREATE TABLE aly_test (id int, data varchar(10), FULLTEXT INDEX idn_id (data));
ERROR 1064 (HY000): error pos 63, line 1, column 58, token INDEX

dble log:

2018-11-01 04:03:56.541  INFO [BusinessExecutor1] (com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:37)) - routeNormalSqlWithAST
com.alibaba.druid.sql.parser.ParserException: error pos 63, line 1, column 58, token INDEX
	at com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:1370) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2486) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLExprParser.parseDataType(SQLExprParser.java:2477) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.parseColumn(MySqlExprParser.java:517) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:178) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreate(MySqlStatementParser.java:243) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:161) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatement(SQLStatementParser.java:2738) ~[druid-1.1.10.jar:1.1.10]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:35) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.routeNormalSqlWithAST(DefaultRouteStrategy.java:73) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:50) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.RouteService.route(RouteService.java:112) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:316) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.execute(ServerConnection.java:259) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerQueryHandler.query(ServerQueryHandler.java:166) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:319) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:335) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handleData(FrontendCommandHandler.java:77) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:55) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontEndHandlerRunnable.run(FrontEndHandlerRunnable.java:44) [dble-9.9.9.9.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
2018-11-01 04:03:56.542  INFO [BusinessExecutor1] (com.actiontech.dble.server.ServerConnection.executeException(ServerConnection.java:371)) - ServerConnection [id=2, schema=mytest, host=127.0.0.1, user=test,txIsolation=3, autocommit=true, schema=mytest]CREATE TABLE aly_test (id int, data varchar(10), FULLTEXT INDEX idn_id (data)) err:error pos 63, line 1, column 58, token INDEX

FlyingMao avatar Nov 01 '18 08:11 FlyingMao

9.

query:

mysql> select {d'2012@12@31'};
ERROR 1064 (HY000): ERROR. pos 8, line 1, column 8, token LBRACE

dble log:

2018-11-01 04:09:32.713  INFO [BusinessExecutor1] (com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:37)) - routeNormalSqlWithAST
com.alibaba.druid.sql.parser.ParserException: ERROR. pos 8, line 1, column 8, token LBRACE
	at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:793) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlExprParser.primary(MySqlExprParser.java:185) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:86) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLExprParser.parseSelectItem(SQLExprParser.java:3249) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLSelectParser.parseSelectList(SQLSelectParser.java:646) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.query(MySqlSelectParser.java:168) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLSelectParser.query(SQLSelectParser.java:207) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:59) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseSelect(MySqlStatementParser.java:113) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:149) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatement(SQLStatementParser.java:2738) ~[druid-1.1.10.jar:1.1.10]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.parserSQL(DefaultRouteStrategy.java:35) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.DefaultRouteStrategy.routeNormalSqlWithAST(DefaultRouteStrategy.java:73) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:50) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.route.RouteService.route(RouteService.java:112) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:316) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerConnection.execute(ServerConnection.java:259) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.handler.SelectHandler.handle(SelectHandler.java:99) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.server.ServerQueryHandler.query(ServerQueryHandler.java:89) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:319) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.FrontendConnection.query(FrontendConnection.java:335) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handleData(FrontendCommandHandler.java:77) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:55) [dble-9.9.9.9.jar:?]
	at com.actiontech.dble.net.handler.FrontEndHandlerRunnable.run(FrontEndHandlerRunnable.java:44) [dble-9.9.9.9.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
2018-11-01 04:09:32.715  INFO [BusinessExecutor1] (com.actiontech.dble.server.ServerConnection.executeException(ServerConnection.java:371)) - ServerConnection [id=2, schema=mytest, host=127.0.0.1, user=test,txIsolation=3, autocommit=true, schema=mytest]select {d'2012@12@31'} err:ERROR. pos 8, line 1, column 8, token LBRACE

for tester: suggest autotest position: sqls/syntax/data_types.sql (reference line 35)

FlyingMao avatar Nov 01 '18 08:11 FlyingMao

verified on version: 5.6.29-dble-9.9.9.9-978d59b0f2d83f9a46ec7e4c914277be407820aa-20190314102656

still not support for the following syntax： select * from test_no_shard where id=@var1 := 1; select * from test_global order by OUTFILE limit 10; SELECT * FROM aly_test use INDEX () ; CREATE TABLE aly_test ( id int(11),test int,detail varchar(20),CONSTRAINT PRIMARY KEY (id ASC)); CREATE TABLE aly_test ( id int(11),detail varchar(20),PRIMARY KEY (id) KEY_BLOCK_SIZE = 10); CREATE TABLE aly_test ( id int(11),test int,detail varchar(20),INDEX key_id (id) COMMENT 'string'); CREATE TABLE aly_test ( id int(11),detail varchar(20),PRIMARY KEY (detail) WITH PARSER ngram); select {d'2012@12@31'};

wjl1619 avatar Mar 18 '19 07:03 wjl1619