Comven opened a new issue #11978:
URL: https://github.com/apache/shardingsphere/issues/11978
## Bug Report
shardingsphere-jdbc-core 5.0.0-beta
logistic table 'order_info' divided by month，format just like
'order_info_yyyyMM',
where I configured the actual node as
`db1.order_info_20210${6..9},db1.order_info_2021${10..12}`, Executed SQL like
this
```
==> Preparing: insert into order_info ( order_no, user_id, add_time )
values ( ?, ?, ? )
==> Parameters: 20210824152041814(String), 张三(String), 2021-08-24
15:20:41.818(Timestamp)
```
The actual SQL executed is like this
```
Actual SQL: db1 ::: insert into order_info_202108
( order_no,
user_id,
add_time )
values (?, ?, ?) ::: [20210824152041814, 张三, 2021-08-24
15:20:41.818]
```
it's right。
when I changed the actual node as
`db1.order_info_20${21..25}0${1..9},db1.order_info_20${21..25}${10..12}`,
Executed SQL like this
```
==> Preparing: insert into order_info ( order_no, user_id, add_time )
values ( ?, ?, ? )
==> Parameters: 20210824152136055(String), 张三(String), 2021-08-24
15:21:36.058(Timestamp)
```
But the actual SQL executed is like this
```
Actual SQL: db1 ::: insert into order_info_202108
( order_no,
user_id,
add_time , id)
values (?, ?, ?, ?) ::: [20210824152136055, 张三, 2021-08-24
15:21:36.058, 636947412484620288]
```
No other code changed，the field `id` is automatically generated with
snowflake. but we don't want to be like this. What's the reason ?
By the way, we configured the shardingsphere by JAVA API instead of using
properties or yaml.
--
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-unsubscr...@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
