You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "cjj2010 (via GitHub)" <gi...@apache.org> on 2024/07/18 07:36:58 UTC
[I] [Bug] MySQL protocol cannot obtain decimal precision when SSL is enabled [doris]
cjj2010 opened a new issue, #38065:
URL: https://github.com/apache/doris/issues/38065
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Version
2.1.0-2.1.4、master
### What's Wrong?
MySQL protocol cannot obtain decimal precision when SSL is enabled
Steps to enable SSL，https://doris.apache.org/zh-CN/docs/admin-manual/auth/certificate
Using JDBC to query data of type decimalv3 (38, 10)
e.g
```
String url = "jdbc:mysql://192.168.83.177:33/demo?"
+ "useSSL=true"
+ "&requireSSL=true";
String user = "root";
String password = "123456";
System.out.println("连接数据库");
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println("连接正常!");
PreparedStatement preparedStatement = conn.prepareStatement("select 603B91D1989D_06a2 from dwd_1813421496594669569 where 1 = 1");
ResultSet rs= preparedStatement.executeQuery();
ResultSetMetaData metaData =rs.getMetaData();
int scale = metaData.getScale(1);
System.out.println(scale);
```
Scale will return 0
### What You Expected?
Return to normal accuracy
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] MySQL protocol cannot obtain decimal precision when SSL is enabled [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on issue #38065:
URL: https://github.com/apache/doris/issues/38065#issuecomment-2235974177
Let me look at this question
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] MySQL protocol cannot obtain decimal precision when SSL is enabled [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk closed issue #38065: [Bug] MySQL protocol cannot obtain decimal precision when SSL is enabled
URL: https://github.com/apache/doris/issues/38065
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] MySQL protocol cannot obtain decimal precision when SSL is enabled [doris]
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk closed issue #38065: [Bug] MySQL protocol cannot obtain decimal precision when SSL is enabled
URL: https://github.com/apache/doris/issues/38065
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org