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
 
-