On Friday, July 19, 2019 at 5:13:09 PM UTC-4, Tim Fielder wrote: > > > On Friday, July 19, 2019 at 3:49:24 PM UTC-4, Noel Grandin wrote: >> >> >> The weird stack trace you are seeing in .197 is because you have a >> varchar column that you are querying against, but you are passing in a very >> large integer value, which tends to hit a rather unfortunate fallback path >> in our conversion code (which has been fixed in master). >> >> You would do better to write your query something like >> SELECT title, abstract FROM document WHERE docid = '0001179973' >> so that the comparison happens on a char basis, instead of having H2 >> trying to convert both sides to some integer type. >> >> In fact, that might fix your problem with .199 too >> > > Thanks. I'll try it when I get back to work on Monday and get back to > you. >
Wrapping all of the %s in my format strings seems to have solved the problem, at least in .199 - haven't tested with .197. Thanks for the help. -- 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/65b98642-6112-4902-8e12-ea49c08d53a2%40googlegroups.com.
