Emulate the case insensitive LIKE operator and the bitwise operators.
# File lib/sequel/adapters/jdbc/h2.rb, line 155 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.at(0)]), args.at(1)]) when :&, :|, :^ sql << complex_expression_arg_pairs(args){|a, b| literal(SQL::Function.new(BITWISE_METHOD_MAP[op], a, b))} when :<< sql << complex_expression_arg_pairs(args){|a, b| "(#{literal(a)} * POWER(2, #{literal(b)}))"} when :>> sql << complex_expression_arg_pairs(args){|a, b| "(#{literal(a)} / POWER(2, #{literal(b)}))"} when :'B~' sql << BITCOMP_OPEN literal_append(sql, args.at(0)) sql << BITCOMP_CLOSE else super end end
H2 doesn't support IS TRUE
# File lib/sequel/adapters/jdbc/h2.rb, line 180 def supports_is_true? false end
H2 doesn't support JOIN USING
# File lib/sequel/adapters/jdbc/h2.rb, line 185 def supports_join_using? false end
H2 doesn't support multiple columns in IN/NOT IN
# File lib/sequel/adapters/jdbc/h2.rb, line 190 def supports_multiple_column_in? false end
Generated with the Darkfish Rdoc Generator 2.