[
https://issues.apache.org/jira/browse/IGNITE-9183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16572879#comment-16572879
]
Sergey Kozlov commented on IGNITE-9183:
---------------------------------------
I suppose that the issue below is related to this ticket. The output from
sqlline
{noformat}
132/2758 CREATE TABLE t444 ( id INT NOT NULL, col_1 UUID NOT NULL, col_2
UUID, col_3 UUID NOT NULL, col_4 UUID, PRIMARY KEY (id)
....
138/2758 INSERT INTO t444 (id,col_1,col_2,col_3,col_4) VALUES
(5,'fe0ac430-9a7d-11e8-8005-000000000005','fe0ac6ee-9a <..skipped..>
Error: Value conversion failed [from=java.lang.String, to=[B]
(state=0700B,code=0)
java.sql.SQLException: Value conversion failed [from=java.lang.String, to=[B]
at
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:753)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:210)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:473)
at sqlline.Commands.execute(Commands.java:823)
at sqlline.Commands.sql(Commands.java:733)
at sqlline.SqlLine.dispatch(SqlLine.java:795)
at sqlline.SqlLine.runCommands(SqlLine.java:1706)
at sqlline.Commands.run(Commands.java:1317)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
at sqlline.SqlLine.dispatch(SqlLine.java:791)
at sqlline.SqlLine.initArgs(SqlLine.java:595)
at sqlline.SqlLine.begin(SqlLine.java:643)
at sqlline.SqlLine.start(SqlLine.java:373)
at sqlline.SqlLine.main(SqlLine.java:265)
{noformat}
> Proper handling UUID columns, that are added by DDL.
> ----------------------------------------------------
>
> Key: IGNITE-9183
> URL: https://issues.apache.org/jira/browse/IGNITE-9183
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.5, 2.6
> Reporter: Ivan Daschinskiy
> Assignee: Ivan Daschinskiy
> Priority: Major
> Fix For: 2.7
>
>
> Currently, if we added new UUID columnt thru DDL, it is saved to schema as
> byte[]. So it's impossible to use it with DML without placeholders and put
> values thru cache api without converting UUID to byte[].
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
