MySQL UUID has no dash in value

Support
#1

cuba version 6.10
%E4%BC%81%E4%B8%9A%E5%BE%AE%E4%BF%A1%E6%88%AA%E5%9B%BE_20190227102321
this is mysql, the id type is UUD
%E4%BC%81%E4%B8%9A%E5%BE%AE%E4%BF%A1%E6%88%AA%E5%9B%BE_20190227102310
this is mssql, the id type also is UUD

the UUID in mysql has no “-”,but in java code,the id has ‘-’ like as in mssql,
so when query,i couldn’t select the id in mysql

1 Like
Why is mySQL the table with ID Column not in UUID format
#2

oh sorry,this is not a bug
but why i query a null result
%E4%BC%81%E4%B8%9A%E5%BE%AE%E4%BF%A1%E6%88%AA%E5%9B%BE_20190227104208
this is my code, i set the Permission for user,but the query result is null

#3

Hi,
You can enable detailed SQL logging by turning “eclipselink.sql” on:
https://doc.cuba-platform.com/manual-6.10/logging_useful_loggers.html

Then you can find SQL query generated by ORM with parameter values in the logs and understand why it does not return expected result.

Regards,