Method: Sequel::JDBC::H2::Dataset#complex_expression_sql

Defined in:
lib/sequel/adapters/jdbc/h2.rb

#complex_expression_sql(op, args) ⇒ Object

Work around H2’s lack of a case insensitive LIKE operator



80
81
82
83
84
85
86
87
88
89
 
# File 'lib/sequel/adapters/jdbc/h2.rb', line 80

def complex_expression_sql(op, args)
  case op
  when :ILIKE
    super(:LIKE, [SQL::PlaceholderLiteralString.new("CAST(? AS VARCHAR_IGNORECASE)", [args.at(0)]), args.at(1)])
  when :"NOT ILIKE"
    super(:"NOT LIKE", [SQL::PlaceholderLiteralString.new("CAST(? AS VARCHAR_IGNORECASE)", [args.at(0)]), args.at(1)])
  else
    super(op, args)
  end
end