Database hangs when the query contains multibyte space.

543 views
Skip to first unread message

Yosei Ito

unread,
Aug 31, 2022, 11:37:24 AM8/31/22
to H2 Database

Hi. (I am sorry but I am not sure if it's appropriate place to ask about bug)

I've tested on 2.1.214. If the multibyte space was passed as argument, the database hangs(never return any errors).

sql> select floor( );
Error: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "select floor( [*])"; expected "INTERSECTS (, NOT, EXISTS, UNIQUE, INTERSECTS"; SQL statement:
select floor( ) [42001-214]

sql> select floor( );
(Hang up here)

Evgenij Ryazanov

unread,
Sep 1, 2022, 5:08:53 AM9/1/22
to H2 Database
Hello!

This issue was fixed, the fix will be included into the next version.

If you need this fix right now, you can compile H2 from its current sources:
Building instructions are here:

LM 伊藤陽生

unread,
Sep 1, 2022, 8:06:18 PM9/1/22
to h2-da...@googlegroups.com
Thank you so much for the quick fix..!

(because it's not so urgent for us) we look forward to the new release.
> --
> You received this message because you are subscribed to a topic in the Google Groups "H2 Database" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/topic/h2-database/XVwEhtvvV7s/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to h2-database...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/3792ee2c-5e0e-4c81-b1f4-f624ca8159fdn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages