wangjing112 opened a new issue #5609:
URL: https://github.com/apache/shardingsphere/issues/5609
cfg:
`
t_role_shop:
actualDataNodes: r_game_sub${0..1}.t_role_shop${0..2}
defaultDataSourceName: r_sub0
defaultDatabaseStrategy:
standard:
shardingColumn: roleId
preciseAlgorithmClassName:
com.cg.raid.db.sharding.PreciseShardingDatabaseAlgorithm
rangeAlgorithmClassName:
com.cg.raid.db.sharding.RangeShardingDatabaseAlgorithm
defaultTableStrategy:
standard:
shardingColumn: roleId
preciseAlgorithmClassName:
com.cg.raid.db.sharding.PreciseShardingTableAlgorithm
rangeAlgorithmClassName:
com.cg.raid.db.sharding.RangeShardingTableAlgorithm
`
log:
`
[INFO ] 18:47:32.889 [ShardingSphere-Command-11] ShardingSphere-SQL - Logic
SQL: create table t_role_shop (roleId bigint not null, shopId integer not null,
awakeEndTime bigint, awakeStatus integer, buyAmount int(11) default 0, buyTimes
integer, goodsData varchar(20000), reflashTimes integer, resetTime bigint,
status integer, type integer, primary key (roleId, shopId)) ENGINE=InnoDB
[INFO ] 18:47:32.889 [ShardingSphere-Command-11] ShardingSphere-SQL -
SQLStatement:
CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.ddl.CreateTableStatement@3353d4ea,
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@61b88403)
[INFO ] 18:47:32.889 [ShardingSphere-Command-11] ShardingSphere-SQL - Actual
SQL: r_sub0 ::: create table t_role_shop (roleId bigint not null, shopId
integer not null, awakeEndTime bigint, awakeStatus integer, buyAmount int(11)
default 0, buyTimes integer, goodsData varchar(20000), reflashTimes integer,
resetTime bigint, status integer, type integer, primary key (roleId, shopId))
ENGINE=InnoDB
`
the same config is wark fine in sharding-jdbc4.0.0
----------------------------------------------------------------
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:
[email protected]
