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/08/11 06:47:25 UTC
[GitHub] [shardingsphere] ccMoriarty opened a new issue #11759: Time Format in MySQL is yyyy-MM-dd HH:mm:ss, in ss-proxy is yyyy-MM-ddTHH:mm:ss there is more T'
ccMoriarty opened a new issue #11759:
URL: https://github.com/apache/shardingsphere/issues/11759
## Bug Report
### Which version of ShardingSphere did you use?
sharding-proxy 5.0.0-beta , MySQL version: 5.7.26
### Which project did you use?
ShardingSphere-proxy
### Example codes for reproduce this issue (such as a github link).
In MySQL:
my table structure is:
![image](https://user-images.githubusercontent.com/35559210/128980937-3ccae9eb-ce96-4035-82d2-1af320890f3b.png)
the Fcreate_time type is datetime
when i select it in MySQL
![image](https://user-images.githubusercontent.com/35559210/128981095-996716a5-4aae-4ec9-b112-5d6fb5bf02cb.png)
the Fcreate_time value is yyyy-MM-dd HH:mm:ss (2021-08-11 14:27:48)
but in ShardingSphere-proxy
![image](https://user-images.githubusercontent.com/35559210/128981429-5fcef9cb-f557-4f84-912b-a611b6de8175.png)
i got yyyy-MM-ddTHH:mm:ss (2021-08-11T14:27:48), there is more 'T'
when i want to get this value from my program,i can't get this value.
![image](https://user-images.githubusercontent.com/35559210/128982083-298eab77-fb18-446a-871f-e426495008d6.png)
my sharding-proxy config is:
schemaName: db_test
#
dataSources:
db_test:
url: jdbc:mysql://127.0.0.1/db_test?serverTimezone=UTC&useSSL=false&autoReconnect=true
username: root
password: root
connectionTimeoutMilliseconds: 3000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 500
minPoolSize: 1
# maintenanceIntervalMilliseconds: 30000
#
rules:
- !READWRITE_SPLITTING
dataSources:
db_test:
writeDataSourceName: db_test
readDataSourceNames:
- db_test
loadBalancerName: load1
loadBalancers:
load1:
type: RANDOM
--
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] ccMoriarty edited a comment on issue #11759: Time Format in MySQL is yyyy-MM-dd HH:mm:ss, in ss-proxy is yyyy-MM-ddTHH:mm:ss there is more 'T'
Posted by GitBox <gi...@apache.org>.
ccMoriarty edited a comment on issue #11759:
URL: https://github.com/apache/shardingsphere/issues/11759#issuecomment-896685399
Others in sharding-proxy 5.0.0-beta , MySQL version: 5.7.26
<img width="1343" alt="wecom-temp-6e01ae881cf33d2a537699e38ce2d8ce" src="https://user-images.githubusercontent.com/35559210/129009412-791ba9e8-8d4c-4446-b2d6-20f6bf21d3ea.png">
use diff where case get diff format
this conf is:
tableStrategy:
standard:
shardingColumn: fuid
shardingAlgorithmName: tb_inline
defaultDatabaseStrategy:
standard:
shardingColumn: fcreate_time
shardingAlgorithmName: database_inline
defaultTableStrategy:
none:
shardingAlgorithms:
database_inline:
type: INTERVAL
props:
datetime-lower: '2021-07-01 00:00:00'
datetime-interval-unit: Months
datetime-interval-amount: 1
datetime-pattern: yyyy-MM-dd HH:mm:ss
sharding-suffix-pattern: yyyyMM
tb_inline:
type: MOD
props:
sharding-count: 100
--
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] ccMoriarty closed issue #11759: Time Format in MySQL is yyyy-MM-dd HH:mm:ss, in ss-proxy is yyyy-MM-ddTHH:mm:ss there is more 'T'
Posted by GitBox <gi...@apache.org>.
ccMoriarty closed issue #11759:
URL: https://github.com/apache/shardingsphere/issues/11759
--
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] ccMoriarty edited a comment on issue #11759: Time Format in MySQL is yyyy-MM-dd HH:mm:ss, in ss-proxy is yyyy-MM-ddTHH:mm:ss there is more 'T'
Posted by GitBox <gi...@apache.org>.
ccMoriarty edited a comment on issue #11759:
URL: https://github.com/apache/shardingsphere/issues/11759#issuecomment-896685399
Others in sharding-proxy 5.0.0-beta , MySQL version: 5.7.26
<img width="1343" alt="wecom-temp-6e01ae881cf33d2a537699e38ce2d8ce" src="https://user-images.githubusercontent.com/35559210/129009412-791ba9e8-8d4c-4446-b2d6-20f6bf21d3ea.png">
use diff where case get diff format
this conf is:
tableStrategy:
standard:
shardingColumn: fuid
shardingAlgorithmName: tb_inline
defaultDatabaseStrategy:
standard:
shardingColumn: fcreate_time
shardingAlgorithmName: database_inline
defaultTableStrategy:
none:
shardingAlgorithms:
database_inline:
type: INTERVAL
props:
datetime-lower: '2021-07-01 00:00:00'
datetime-interval-unit: Months
datetime-interval-amount: 1
datetime-pattern: yyyy-MM-dd HH:mm:ss
sharding-suffix-pattern: yyyyMM
tb_inline:
type: MOD
props:
sharding-count: 100
--
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] ccMoriarty commented on issue #11759: Time Format in MySQL is yyyy-MM-dd HH:mm:ss, in ss-proxy is yyyy-MM-ddTHH:mm:ss there is more 'T'
Posted by GitBox <gi...@apache.org>.
ccMoriarty commented on issue #11759:
URL: https://github.com/apache/shardingsphere/issues/11759#issuecomment-896685399
Others in sharding-proxy 5.0.0-beta , MySQL version: 5.7.26
<img width="1343" alt="wecom-temp-6e01ae881cf33d2a537699e38ce2d8ce" src="https://user-images.githubusercontent.com/35559210/129009412-791ba9e8-8d4c-4446-b2d6-20f6bf21d3ea.png">
use diff where case get diff format
this conf is:
tableStrategy:
standard:
shardingColumn: fuid
shardingAlgorithmName: tb_inline
#keyGenerateStrategy:
# # column: id
# # keyGeneratorName: snowflake
#
defaultDatabaseStrategy:
standard:
shardingColumn: fcreate_time
shardingAlgorithmName: database_inline
defaultTableStrategy:
none:
#
shardingAlgorithms:
database_inline:
type: INTERVAL
props:
datetime-lower: '2021-07-01 00:00:00'
datetime-interval-unit: Months
datetime-interval-amount: 1
datetime-pattern: yyyy-MM-dd HH:mm:ss
sharding-suffix-pattern: yyyyMM
tb_inline:
type: MOD
props:
sharding-count: 100
--
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