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 2019/08/15 07:54:37 UTC
[GitHub] [incubator-shardingsphere] yangjwInRiver opened a new issue #2878:
Fail to execute create dynamic table sql
yangjwInRiver opened a new issue #2878: Fail to execute create dynamic table sql
URL: https://github.com/apache/incubator-shardingsphere/issues/2878
### Which version of ShardingSphere did you use?
4.0.0-RC1
### Which project did you use? Sharding-JDBC or Sharding-Proxy?
Sharding-JDBC
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
```
2019-08-15 15:26:02.973 INFO 34352 --- [ scheduling-1] ShardingSphere-SQL : Rule Type: sharding
2019-08-15 15:26:02.973 INFO 34352 --- [ scheduling-1] ShardingSphere-SQL : Logic SQL: CREATE TABLE IF NOT EXISTS t_xxx_201909 (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID 自增',
`record_no` varchar(50) NOT NULL ,
`account_no` varchar(50) NOT NULL ,
`order_no` varchar(50) DEFAULT NULL ,
`status` tinyint(1) NOT NULL ,
`track` varchar(50) NOT NULL ,
`gmt8_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt8_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
`extend` varchar(5000) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_record_no` (`record_no`) USING BTREE,
KEY `index_account_no` (`account_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;
2019-08-15 15:26:02.973 INFO 34352 --- [ scheduling-1] ShardingSphere-SQL : SQLStatement: AbstractSQLStatement(type=DDL, tables=Tables(tables=[Table(name=t_xxx_201909, alias=Optional.absent())]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=t_xxx_201909, quoteCharacter=NONE, schemaNameLength=0), IndexToken(stopIndex=1585, tableName=t_xxx_201909), IndexToken(stopIndex=1645, tableName=t_xxx_201909)], parametersIndex=0, logicSQL=CREATE TABLE IF NOT EXISTS t_xxx_201909 (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID 自增',
`record_no` varchar(50) NOT NULL ,
`account_no` varchar(50) NOT NULL ,
`order_no` varchar(50) DEFAULT NULL ,
`status` tinyint(1) NOT NULL ,
`track` varchar(50) NOT NULL ,
`gmt8_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt8_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
`extend` varchar(5000) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_record_no` (`record_no`) USING BTREE,
KEY `index_account_no` (`account_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;)
2019-08-15 15:26:02.973 INFO 34352 --- [ scheduling-1] ShardingSphere-SQL : Actual SQL: master ::: CREATE TABLE IF NOT EXISTS t_xxx_201909 (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID 自增',
`record_no` varchar(50) NOT NULL ,
`account_no` varchar(50) NOT NULL ,
`order_no` varchar(50) DEFAULT NULL ,
`status` tinyint(1) NOT NULL ,
`track` varchar(50) NOT NULL ,
`gmt8_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
`gmt8_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
`extend` varchar(5000) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_record_no`_t_xxx_201909 (`record_no`) USING BTREE,
KEY `index_account_no`_t_xxx_201909 (`account_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;
```
----------------------------------------------------------------
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
With regards,
Apache Git Services