[
https://issues.apache.org/jira/browse/IGNITE-19701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich updated IGNITE-19701:
----------------------------------------
Epic Link: IGNITE-22700
> Type exception on insert into uuid columns with gen_random_uuid
> ---------------------------------------------------------------
>
> Key: IGNITE-19701
> URL: https://issues.apache.org/jira/browse/IGNITE-19701
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0
> Reporter: Alexander Belyak
> Priority: Major
> Labels: ignite-3
>
> Step to reproduce:
> {noformat}
> create table tdd(a uuid default gen_random_uuid, b int, primary key (a) );
> insert into tdd(b) values(22)
> {noformat}
> Expected result: row with autogenerated primary key a inserted
> Actual result:
> {noformat}
> [Code: 0, SQL State: 50000] Exception while executing query [query=insert
> into tdd(b) values(22)]. Error message:Query remote fragment execution
> failed: nodeName=DropColumnsTest_cluster_1,
> queryId=e0a9b944-74a5-4d9d-a4a9-7962cb821c81, fragmentId=20,
> originalMessage=storageType is class java.util.UUID value must also be class
> java.util.UUID but it was: 1726917f-f47f-4ccc-94a0-59ac518e101b{noformat}
> It is possibly to insert row with generated UUID:
> {noformat}
> insert into tdd(a, b) values('1726917f-f47f-4ccc-94a0-59ac518e101b',
> 22){noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
