[IGNITE-12764] Regression: Thin JDBC streaming fails/BatchUpdateException if function is used

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 2.8
• Fix Version/s: 2.8.1
• Component/s: sql
• Assignee: Dmitriy Sorokin
• Reporter: Ilya Kasnacheev
• Created: 10/Mar/20 14:35
• Updated: 10/Apr/20 14:55
• Resolved: 10/Apr/20 14:55

Description

insert INTO city1(id,name,name1) VALUES(?,?,RANDOM_UUID())

happily worked in 2.7.6 but will fail on 2.8.0 with:

Exception in thread "main" java.sql.BatchUpdateException: class org.apache.ignite.IgniteCheckedException: null
at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection$StreamState.readResponses(JdbcThinConnection.java:1364)
at java.base/java.lang.Thread.run(Thread.java:834)

Suspected reason is that function RANDOM_UUID() is not processed correctly here. Column type does not matter between UUID and VARCHAR.

Issue Links

• links to: GitHub Pull Request #7615
• links to: Userlist post