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 2021/06/25 02:13:02 UTC
[GitHub] [shardingsphere] shijinting0321 opened a new issue #11007: INFO： no viable alternative at input 'RANGE'
shijinting0321 opened a new issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007
## Bug Report
### Which version of ShardingSphere did you use?
5.0.0-alpha
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
Execute SQL：
CREATE TABLE `cec_device_param_value_p3051403033191` (
`id` BIGINT ( 20 ) NOT NULL AUTO_INCREMENT COMMENT '自增',
`param_code` VARCHAR ( 32 ) NOT NULL COMMENT '参数code',
`device_code` VARCHAR ( 32 ) NOT NULL COMMENT '设备code',
`value` VARCHAR ( 100 ) NOT NULL COMMENT '值',
`acquisition_time` TIMESTAMP NOT NULL COMMENT '参数采集时间',
`update_time` TIMESTAMP NOT NULL COMMENT '参数入库时间',
PRIMARY KEY ( `id`, `acquisition_time` ) USING BTREE,
KEY `acquisition_time` ( `acquisition_time` ) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 0 DEFAULT CHARSET = utf8
PARTITION BY RANGE (UNIX_TIMESTAMP( acquisition_time )) (
PARTITION `2021` VALUES LESS THAN ( UNIX_TIMESTAMP('2022-01-01 00:00:00')) ENGINE = MyISAM
);
### Actual behavior
Failed to execute, output message：no viable alternative at input 'RANGE'
--
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] strongduanmu commented on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-870274050
> > @shijinting0321 Hi, can you give a feedback?
>
> This has been modified using Markdown
@shijinting0321 I used the latest SQL you provided for testing, and found no exception when execute parsing.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] shijinting0321 edited a comment on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
shijinting0321 edited a comment on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-870146294
> @shijinting0321 Hi, can you give a feedback?
my sql : PARTITION `2021` VALUES LESS THAN ( UNIX_TIMESTAMP('2022-01-01 00:00:00')) ENGINE = MyISAM
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] shijinting0321 edited a comment on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
shijinting0321 edited a comment on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-870146294
> @shijinting0321 Hi, can you give a feedback?
my sql : PARTITION ` 2021 ` VALUES LESS THAN ( UNIX_TIMESTAMP('2022-01-01 00:00:00')) ENGINE = MyISAM
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] shijinting0321 commented on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
shijinting0321 commented on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-870148186
> @shijinting0321 Hi, can you give a feedback?
This has been modified using Markdown
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] shijinting0321 edited a comment on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
shijinting0321 edited a comment on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-870146294
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-870274050
> > @shijinting0321 Hi, can you give a feedback?
>
> This has been modified using Markdown
@shijinting0321 I used the latest SQL you provided for testing, and found no exception when execute parsing.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-869261982
@shijinting0321 Hi, can you give a feedback?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] shijinting0321 commented on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
shijinting0321 commented on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-870450167
> > > @shijinting0321 Hi, can you give a feedback?
> >
> >
> > This has been modified using Markdown
>
> @shijinting0321 I used the latest SQL you provided for testing, and found no exception when execute parsing.
>
> 
I will try to build a demo project to restore the problem
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-873743407
@shijinting0321 Can you provide more infomation?
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] shijinting0321 edited a comment on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
shijinting0321 edited a comment on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-870146294
> @shijinting0321 Hi, can you give a feedback?
my sql : PARTITION **`2021`** VALUES LESS THAN ( UNIX_TIMESTAMP('2022-01-01 00:00:00')) ENGINE = MyISAM
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-868281875
@shijinting0321 Thanks for your feedback, I will investigate this issue.
--
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] shijinting0321 commented on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
shijinting0321 commented on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-870146294
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-868285389
@shijinting0321 Is this a legal mysql statement?
--
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] shijinting0321 edited a comment on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
shijinting0321 edited a comment on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-870146294
> @shijinting0321 Hi, can you give a feedback?
my code:
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] shijinting0321 edited a comment on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
shijinting0321 edited a comment on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-870146294
> @shijinting0321 Hi, can you give a feedback?
my sql code:
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-927263464
Long time no response.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] shijinting0321 commented on issue #11007: INFO： no viable alternative at input 'RANGE'
Posted by GitBox <gi...@apache.org>.
shijinting0321 commented on issue #11007:
URL: https://github.com/apache/shardingsphere/issues/11007#issuecomment-870146294
> @shijinting0321 Hi, can you give a feedback?
The SQL is correct in my code, but it was written wrong in issue,I have corrected 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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org