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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/c655efee-360b-469e-8167-1370f4f26e4en%40googlegroups.com.
