Class | Sequel::JDBC::H2::Dataset |
In: |
lib/sequel/adapters/jdbc/h2.rb
|
Parent: | JDBC::Dataset |
SELECT_CLAUSE_METHODS | = | clause_methods(:select, %w'distinct columns from join where group having compounds order limit') |
Work around H2‘s lack of a case insensitive LIKE operator
# File lib/sequel/adapters/jdbc/h2.rb, line 80 80: def complex_expression_sql(op, args) 81: case op 82: when :ILIKE 83: super(:LIKE, [SQL::PlaceholderLiteralString.new("CAST(? AS VARCHAR_IGNORECASE)", [args.at(0)]), args.at(1)]) 84: when "NOT ILIKE""NOT ILIKE" 85: super("NOT LIKE""NOT LIKE", [SQL::PlaceholderLiteralString.new("CAST(? AS VARCHAR_IGNORECASE)", [args.at(0)]), args.at(1)]) 86: else 87: super(op, args) 88: end 89: end