I am happy to try to create a standalone test case, however that might be easier said than done.
As I pointed out, I replicated the code in another method, used the same input variables, and the update statement worked. I do have another update statement that assigns a UUID that I suspect might have the same issue. If i can find a commonality between them that would give me enough to work with for a test case i will certainly build that and provide it here. Until then, I will use CAST for this case. Thank you for your help. On Thursday, January 21, 2021 at 5:02:46 AM UTC-5 Noel Grandin wrote: > That smells like the kind of bug that H2 sometimes has with determining > the type of a parameter in a PreparedStatement. > > Normally it can be worked around by using CAST around the ? so that H2 > knows exactly what type to use there. > > Possibly we could track down the bug if you can provide a standalone > test-case. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/c655efee-360b-469e-8167-1370f4f26e4en%40googlegroups.com.
