Emulate the case insensitive LIKE operator and the bitwise operators.
# File lib/sequel/adapters/jdbc/h2.rb, line 183 def complex_expression_sql_append(sql, op, args) case op when :ILIKE, :"NOT ILIKE" super(sql, (op == :ILIKE ? :LIKE : :"NOT LIKE"), [SQL::PlaceholderLiteralString.new(ILIKE_PLACEHOLDER, [args[0]]), args[1]]) when :&, :|, :^, :<<, :>>, :'B~' complex_expression_emulate_append(sql, op, args) else super end end
H2 does not support derived column lists
# File lib/sequel/adapters/jdbc/h2.rb, line 195 def supports_derived_column_lists? false end
H2 doesn’t support IS TRUE
# File lib/sequel/adapters/jdbc/h2.rb, line 205 def supports_is_true? false end
H2 doesn’t support JOIN USING
# File lib/sequel/adapters/jdbc/h2.rb, line 210 def supports_join_using? false end
H2 doesn’t support multiple columns in IN/NOT IN
# File lib/sequel/adapters/jdbc/h2.rb, line 215 def supports_multiple_column_in? false end