Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
3.0.7
-
Server: Win2019 + mariadb-10.7.5-winx64, Client: MacOS + mariadb-java-client 3.0.7
Description
Consider the following code:
SQL
create table uuid_test (id uuid); |
Java
var rs = stmt.executeQuery("select * from uuid_test"); |
var md = rs.getMetaData();
|
var s = md.getColumnTypeName(1) + ", " + md.getColumnType(1) + ", " + md.getColumnClassName(1); |
For MariaDB, the result of s is "CHAR, 1, java.lang.String".
For PostgreSQL, the result of s is "uuid, 1111, java.util.UUID".
The latter is more reasonable. For the former, we does not know it's a UUID column or a CHAR column with size = 36.
Attachments
Issue Links
- duplicates
-
CONJ-899 Support UUID Object
- Closed