Hi, is this a correct behavior? If I prepare statement with a limit statement, e.g. *SELECT * FROM system_range(1,10) LIMIT ?* and then get the parameter meta data, I would get VARCHAR as a data type of the limit related placeholder. I am expecting a numeric data type, because *LIMIT 'abc' *is not a valid call (AFAIK).
This is a test case which fails for H2 1.3.171: public class BugDemo { public static void main(String[] args) throws SQLException { Connection conn = DriverManager.getConnection("jdbc:h2:mem:test"); PreparedStatement stmt = conn.prepareStatement("SELECT * FROM system_range(1,10) LIMIT ?"); ParameterMetaData pmd = stmt.getParameterMetaData(); System.out.println("type = " + pmd.getParameterTypeName(1)); // = VARCHAR (expected numeric) conn.close(); } } Workaround: just replace "LIMIT ?" with "LIMIT (select id FROM items WHERE id=?)" where id is INTEGER type Thank you for any help or better workaround. Vojta -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.