strongduanmu opened a new issue, #21954: URL: https://github.com/apache/shardingsphere/issues/21954
## Feature Request ### Is your feature request related to a problem? #21894 #15782 ### Describe the feature you would like. At present, the dateType of the field is stored in the ShardingSphere metadata. When SQL Federation is initialized, the Java type of the field will be initialized according to the dateType. In the JDBC specification, the mapping relationship between JDBC Type and Java Type is declared, but there will be differences in database implementation. For example, MySQL supports UNSIGNED, which will cause the Java Type and specification of JDBC Type mapping to be different. <img width="1246" alt="image" src="https://user-images.githubusercontent.com/10829171/199914090-e7723333-1fbb-43be-84dd-7c6093fdd5a2.png";> ```java /** * ShardingSphere column. */ @RequiredArgsConstructor @Getter @EqualsAndHashCode @ToString public final class ShardingSphereColumn { private final String name; private final int dataType; private final boolean primaryKey; private final boolean generated; private final boolean caseSensitive; private final boolean visible; private final boolean signed; } ``` - [ ] MySQL signed column(support——https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-type-conversions.html) - [ ] PostgreSQL signed column (todo) - [ ] openGauss signed column (todo) - [ ] Oracle signed column (todo) - [ ] SQLServer signed column (todo) - [ ] H2 signed column (todo) -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
![https://user-images.githubusercontent.com/10829171/199914090-e7723333-1fbb-43be-84dd-7c6093fdd5a2.png"](https://user-images.githubusercontent.com/10829171/199914090-e7723333-1fbb-43be-84dd-7c6093fdd5a2.png"){kind=link}