You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/06/29 03:10:33 UTC
[GitHub] [shardingsphere] JOYS369 opened a new issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
JOYS369 opened a new issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-core</artifactId>
<version>4.0.1</version>
</dependency>
<!-- for spring namespace -->
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-namespace</artifactId>
<version>4.0.1</version>
</dependency>
<dependency>
<groupId>org.antlr</groupId>
<artifactId>antlr4-runtime</artifactId>
<version>4.7.1</version>
</dependency>
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC 4.0.1，antlr 4.7.1
### Expected behavior
1、the project can start Running in MAC ，but can't start Running in window.（Multiple computers tests，It's all like this）
2、update statement error
UPDATE HMDM_MD_FIN001
SET REQUEST_ID = ?,PROGRAM_ID = ?,OBJECT_VERSION_NUMBER=?+1,LAST_UPDATED_BY=?,
LAST_UPDATE_DATE=CURRENT_TIMESTAMP,LAST_UPDATE_LOGIN=?,MD_DESCRIPTION = ?,
MD_TOP_CATE_CODE = ?,MD_CATE_CODE = ?,STATUS_CODE = ?,LAST_UPDATED_SOURCE_CODE = ?,
START_DATE = ?,END_DATE = ?,REF_ORG_ID = ?,APPLY_ID = ?,APPLY_ITEM = ?,APPLIED_BY = ?,
APPLIED_AT = ?,ENTITY_LAST_UPDATE_DATE = ?,LAST_DISTRIBUTE_DATE = ?,
FLEX_VALUE_DISP= ?,STRUCTURED_HIERARCHY_NAME= ?,FLEX_VALUE_MEANING= ?,
CHILD_FLEX_VALUE_HIGH_DISP= ?,SUB_ACC= ?,TAX_TARE= ?,RANGE_ATTRIBUTE= ?,
THIRD_PARTY_CONTROL_ACCOUNT= ?,SEGMENT_TYPE= ?,ADJUST= ?,REV_ITEM= ?,REV_INFOR= ?,
DESCRIPTION= ?,ENABLED_FLAG= ?,ACTIVITITY_INFOR= ?,CHILD_FLEX_VALUE_LOW_DISP= ?,
VAT_AC_TYPE= ?,ALLOW_BUDGET= ?,HIERARCHY_LEVEL= ?,ALLOW_POSTING= ?,BUSINESS_TYPE= ?,
SUMMARY_FLAG= ?,SOURCE= ?,CONTEXT= ?,PROCESS_NODE= ?,ACCOUNT_TYPE= ?
WHERE ID = ?
error message：
mismatched input 'SOURCE' expecting {TRUNCATE, POSITION, VIEW, ANY, OFFSET, BEGIN, COMMIT, ROLLBACK, SAVEPOINT, BOOLEAN, DATE, TIME, TIMESTAMP, YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND, MICROSECOND, MAX, MIN, SUM, COUNT, AVG, CURRENT, ENABLE, DISABLE, INSTANCE, DO, DEFINER, CASCADED, LOCAL, CLOSE, OPEN, NEXT, NAME, TYPE, TABLES, TABLESPACE, COLUMNS, FIELDS, INDEXES, STATUS, MODIFY, VALUE, DUPLICATE, FIRST, LAST, AFTER, OJ, ACCOUNT, USER, ROLE, START, TRANSACTION, WITHOUT, ESCAPE, SUBPARTITION, STORAGE, SUPER, TEMPORARY, THAN, UNBOUNDED, UPGRADE, VALIDATION, ROLLUP, SOUNDS, UNKNOWN, OFF, ALWAYS, COMMITTED, LEVEL, NO, PASSWORD, PRIVILEGES, ACTION, ALGORITHM, AUTOCOMMIT, BTREE, CHAIN, CHARSET, CHECKSUM, CIPHER, CLIENT, COALESCE, COMMENT, COMPACT, COMPRESSED, COMPRESSION, CONNECTION, CONSISTENT, DATA, DISCARD, DISK, ENCRYPTION, END, ENGINE, EVENT, EXCHANGE, EXECUTE, FILE, FIXED, FOLLOWING, GLOBAL, HASH, IMPORT_, LESS, MEMORY, NONE, PARSER, PARTIAL, PARTITIONING, PERSIST, PRECEDING, PROCESS, PROXY, QUICK, REBUILD, REDUNDANT, RELOAD, REMOVE, REORGANIZE, REPAIR, REVERSE, SESSION, SHUTDOWN, SIMPLE, SLAVE, VISIBLE, INVISIBLE, ENFORCED, AGAINST, LANGUAGE, MODE, QUERY, EXTENDED, EXPANSION, VARIANCE, MAX_ROWS, MIN_ROWS, SQL_BIG_RESULT, SQL_BUFFER_RESULT, SQL_CACHE, SQL_NO_CACHE, STATS_AUTO_RECALC, STATS_PERSISTENT, STATS_SAMPLE_PAGES, ROW_FORMAT, WEIGHT_STRING, COLUMN_FORMAT, INSERT_METHOD, KEY_BLOCK_SIZE, PACK_KEYS, PERSIST_ONLY, BIT_AND, BIT_OR, BIT_XOR, GROUP_CONCAT, JSON_ARRAYAGG, JSON_OBJECTAGG, STD, STDDEV, STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP, AUTO_INCREMENT, AVG_ROW_LENGTH, DELAY_KEY_WRITE, ROTATE, MASTER, BINLOG, ERROR, SCHEDULE, COMPLETION, EVERY, HOST, SOCKET, PORT, SERVER, WRAPPER, OPTIONS, OWNER, RETURNS, CONTAINS, SECURITY, INVOKER, TEMPTABLE, MERGE, UNDEFINED, DATAFILE, FILE_BLOCK_SIZE, EXTENT_SIZE, INITIAL_SIZE, AUTOEXTEND_SIZE, MAX_SIZE, NODEGROUP, WAIT, LOGFILE, UNDOFILE, UNDO_BUFFER_SIZE, REDO_BUFFER_SIZE, HANDLER, PREV, ORGANIZATION, DEFINITION, DESCRIPTION, REFERENCE, FOLLOWS, PRECEDES, IMPORT, CONCURRENT, XML, DUMPFILE, SHARE, CODE, CONTEXT, CHANNEL, CLONE, AGGREGATE, INSTALL, UNINSTALL, RESOURCE, EXPIRE, NEVER, HISTORY, OPTIONAL, REUSE, MAX_QUERIES_PER_HOUR, MAX_UPDATES_PER_HOUR, MAX_CONNECTIONS_PER_HOUR, MAX_USER_CONNECTIONS, RETAIN, RANDOM, OLD, ISSUER, SUBJECT, CACHE, GENERAL, SLOW, USER_RESOURCES, EXPORT, RELAY, HOSTS, FLUSH, RESET, RESTART, UNIX_TIMESTAMP, LOWER, UPPER, IDENTIFIER_}
### Actual behavior
1、can't start Running in window
2、can't update data
### Reason analyze (If you can)
my table's attribute SOURCE,
the KEYWORD is conflicted？
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jingshanglu commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651531494
@JOYS369 @tristaZero There is no wrong with sharding parser, i have tried it. Now everything works well on Mac, may be the problem with the windows environment.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-650920186
Or try with a back quota:
> `source`
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jingshanglu commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651612015
@JOYS369 @tristaZero Well , i reproduce it, the pr #6211 fix it.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651492289
@jingshanglu Hi, could you give a look at his SQL, especially the keywords `source` and`CURRENT_TIMESTAMP `? Do you think there is something wrong with sharding parser?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] JOYS369 edited a comment on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
JOYS369 edited a comment on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651617345
> > > Hi @JOYS369 you can try the newest version `4.1.1`.
> >
> >
> > Hi, I tried it，but can't start the project .
> > mismatched input 'text' expecting {TRUNCATE, ..., IDENTIFIER_}
>
> @JOYS369 use version '4.1.1' ,will the second question occur? i have tried it on mysql use '4.1.1' , it's ok. Can you show more detail info(eg:log stack).
I tried it，but can't start the project use version 4.1.1 （window and MAC）.
It will throw an errormismatched input 'text' expecting {TRUNCATE, ..., IDENTIFIER_}
so I use version '4.0.1',my computer is window10，my partner computer is MAC
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jingshanglu commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651597129
> > Hi @JOYS369 you can try the newest version `4.1.1`.
>
> Hi, I tried it，but can't start the project .
> mismatched input 'text' expecting {TRUNCATE, ..., IDENTIFIER_}
@JOYS369 use version '4.1.1' ,will the second question occur? i have tried it on '4.1.1' , it's ok. Can you show more detail info(eg:log stack).
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] JOYS369 edited a comment on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
JOYS369 edited a comment on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651617345
> > > Hi @JOYS369 you can try the newest version `4.1.1`.
> >
> >
> > Hi, I tried it，but can't start the project .
> > mismatched input 'text' expecting {TRUNCATE, ..., IDENTIFIER_}
>
> @JOYS369 use version '4.1.1' ,will the second question occur? i have tried it on mysql use '4.1.1' , it's ok. Can you show more detail info(eg:log stack).
I tried it，but can't start the project use version 4.1.1 （window and MAC）.
It will throw an errormismatched input 'text' expecting {TRUNCATE, ..., IDENTIFIER_}
so I use version '4.0.1',my computer is window10，my partner computer is MAC
1、the project can start Running in MAC ，but can't start Running in window.（Multiple computers tests，It's all like this）
It's very inconvenient，because I need to user other computer to test.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] JOYS369 edited a comment on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
JOYS369 edited a comment on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-650988988
> Or try with a back quota:
>
> > `source`
error message：
mismatched input 'source' expecting {TRUNCATE, ..., IDENTIFIER_}
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] JOYS369 commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
JOYS369 commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-650988988
> Or try with a back quota:
>
> > `source`
error message：
mismatched input 'source' expecting {TRUNCATE, POSITION, VIEW, ANY, OFFSET, BEGIN, COMMIT, ROLLBACK, SAVEPOINT, BOOLEAN, DATE, TIME, TIMESTAMP, YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND, MICROSECOND, MAX, MIN, SUM, COUNT, AVG, CURRENT, ENABLE, DISABLE, INSTANCE, DO, DEFINER, CASCADED, LOCAL, CLOSE, OPEN, NEXT, NAME, TYPE, TABLES, TABLESPACE, COLUMNS, FIELDS, INDEXES, STATUS, MODIFY, VALUE, DUPLICATE, FIRST, LAST, AFTER, OJ, ACCOUNT, USER, ROLE, START, TRANSACTION, WITHOUT, ESCAPE, SUBPARTITION, STORAGE, SUPER, TEMPORARY, THAN, UNBOUNDED, UPGRADE, VALIDATION, ROLLUP, SOUNDS, UNKNOWN, OFF, ALWAYS, COMMITTED, LEVEL, NO, PASSWORD, PRIVILEGES, ACTION, ALGORITHM, AUTOCOMMIT, BTREE, CHAIN, CHARSET, CHECKSUM, CIPHER, CLIENT, COALESCE, COMMENT, COMPACT, COMPRESSED, COMPRESSION, CONNECTION, CONSISTENT, DATA, DISCARD, DISK, ENCRYPTION, END, ENGINE, EVENT, EXCHANGE, EXECUTE, FILE, FIXED, FOLLOWING, GLOBAL, HASH, IMPORT_, LESS, MEMORY, NONE, PARSER, PARTIAL, PARTITIONING, PERSIST, PRECEDING, PROCESS, PROXY, QUICK, REBUILD, REDUNDANT, RELOAD, REMOVE, REORGANIZE, REPAIR, REVERSE, SESSION, SHUTDOWN, SIMPLE, SLAVE, VISIBLE, INVISIBLE, ENFORCED, AGAINST, LANGUAGE, MODE, QUERY, EXTENDED, EXPANSION, VARIANCE, MAX_ROWS, MIN_ROWS, SQL_BIG_RESULT, SQL_BUFFER_RESULT, SQL_CACHE, SQL_NO_CACHE, STATS_AUTO_RECALC, STATS_PERSISTENT, STATS_SAMPLE_PAGES, ROW_FORMAT, WEIGHT_STRING, COLUMN_FORMAT, INSERT_METHOD, KEY_BLOCK_SIZE, PACK_KEYS, PERSIST_ONLY, BIT_AND, BIT_OR, BIT_XOR, GROUP_CONCAT, JSON_ARRAYAGG, JSON_OBJECTAGG, STD, STDDEV, STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP, AUTO_INCREMENT, AVG_ROW_LENGTH, DELAY_KEY_WRITE, ROTATE, MASTER, BINLOG, ERROR, SCHEDULE, COMPLETION, EVERY, HOST, SOCKET, PORT, SERVER, WRAPPER, OPTIONS, OWNER, RETURNS, CONTAINS, SECURITY, INVOKER, TEMPTABLE, MERGE, UNDEFINED, DATAFILE, FILE_BLOCK_SIZE, EXTENT_SIZE, INITIAL_SIZE, AUTOEXTEND_SIZE, MAX_SIZE, NODEGROUP, WAIT, LOGFILE, UNDOFILE, UNDO_BUFFER_SIZE, REDO_BUFFER_SIZE, HANDLER, PREV, ORGANIZATION, DEFINITION, DESCRIPTION, REFERENCE, FOLLOWS, PRECEDES, IMPORT, CONCURRENT, XML, DUMPFILE, SHARE, CODE, CONTEXT, CHANNEL, CLONE, AGGREGATE, INSTALL, UNINSTALL, RESOURCE, EXPIRE, NEVER, HISTORY, OPTIONAL, REUSE, MAX_QUERIES_PER_HOUR, MAX_UPDATES_PER_HOUR, MAX_CONNECTIONS_PER_HOUR, MAX_USER_CONNECTIONS, RETAIN, RANDOM, OLD, ISSUER, SUBJECT, CACHE, GENERAL, SLOW, USER_RESOURCES, EXPORT, RELAY, HOSTS, FLUSH, RESET, RESTART, UNIX_TIMESTAMP, LOWER, UPPER, IDENTIFIER_}
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jingshanglu commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651598730
@JOYS369 You use pg?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jingshanglu edited a comment on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
jingshanglu edited a comment on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651597129
> > Hi @JOYS369 you can try the newest version `4.1.1`.
>
> Hi, I tried it，but can't start the project .
> mismatched input 'text' expecting {TRUNCATE, ..., IDENTIFIER_}
@JOYS369 use version '4.1.1' ,will the second question occur? i have tried it on mysql use '4.1.1' , it's ok. Can you show more detail info(eg:log stack).
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] JOYS369 commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
JOYS369 commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651017407
> did not work, did it?
Hi,I tried it , change 'SOURCE' to 'source'。Still reporting errors。
analogous error message：
mismatched input 'source' expecting {TRUNCATE, ..., IDENTIFIER_}
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] JOYS369 commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
JOYS369 commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-650948278
> Hi @JOYS369 you can try the newest version `4.1.1`.
Hi, I tried it，but can't start the project Running in window .
mismatched input 'text' expecting {TRUNCATE, ..., IDENTIFIER_}
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651014304
Hi @JOYS369
`source` did not work, did it?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] dongzl commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-650880992
Hi @JOYS369 you can try the newest version `4.1.1`.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-653308234
@JOYS369 Hi thanks for your feedback.
#6211 made `test` parsed fine. Besides, `CURRENT_TIMESTAMP ` and `source ` could also work well on master branch.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero closed issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] JOYS369 edited a comment on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
JOYS369 edited a comment on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-650948278
> Hi @JOYS369 you can try the newest version `4.1.1`.
Hi, I tried it，but can't start the project .
mismatched input 'text' expecting {TRUNCATE, ..., IDENTIFIER_}
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] JOYS369 commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
JOYS369 commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651573234
> @JOYS369 @tristaZero There is no wrong with sharding parser, i have tried it. Now everything works well on Mac, may be the problem with the windows environment.
project can't start Running in window；
the second question is found Running in MAC.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] JOYS369 commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
JOYS369 commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651617345
> > > Hi @JOYS369 you can try the newest version `4.1.1`.
> >
> >
> > Hi, I tried it，but can't start the project .
> > mismatched input 'text' expecting {TRUNCATE, ..., IDENTIFIER_}
>
> @JOYS369 use version '4.1.1' ,will the second question occur? i have tried it on mysql use '4.1.1' , it's ok. Can you show more detail info(eg:log stack).
I tried it，but can't start the project use version 4.1.1 .
It will throw an errormismatched input 'text' expecting {TRUNCATE, ..., IDENTIFIER_}
so I use version '4.0.1',my computer is window10，my partner computer is MAC
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651491189
Everything works well on Mac, however, does not work well on win?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] JOYS369 commented on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
JOYS369 commented on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651454482
> > did not work, did it?
>
> Hi,I tried it , change 'SOURCE' to 'source'。Still reporting errors。
> analogous error message：
> mismatched input 'source' expecting {TRUNCATE, ..., IDENTIFIER_}
I tried use table's alias, update data sucess.
but, log also has error message,
line 1:136 no viable alternative at input 'CURRENT_TIMESTAMP,'
line 1:136 no viable alternative at input 'CURRENT_TIMESTAMP,'
line 1:828 mismatched input 'source' expecting {TRUNCATE, ..., IDENTIFIER_}
Do you know how to slave first question?
1、the project can start Running in MAC ，but can't start Running in window.（Multiple computers tests，It's all like this）
It's very inconvenient，because I need to user other computer to test.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jingshanglu removed a comment on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
jingshanglu removed a comment on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651598730
@JOYS369 You use pg?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jingshanglu edited a comment on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
jingshanglu edited a comment on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-651612015
@JOYS369 @tristaZero Well , i reproduce it, the pr #6211 fix it. new version will fix it.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking edited a comment on issue #6204: mismatched input 'SOURCE' expecting {TRUNCATE, ..., IDENTIFIER_}
Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #6204:
URL: https://github.com/apache/shardingsphere/issues/6204#issuecomment-650920186
Or try with a back quota:
> \`source\`
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org