class Sequel::JDBC::H2::Dataset

  1. lib/sequel/adapters/jdbc/h2.rb
Superclass: Dataset

Constants

ILIKE_PLACEHOLDER = ["CAST(".freeze, " AS VARCHAR_IGNORECASE)".freeze].freeze  

Public Instance methods

complex_expression_sql_append(sql, op, args)

Emulate the case insensitive LIKE operator and the bitwise operators.

[show source] 
    # File lib/sequel/adapters/jdbc/h2.rb
204 def complex_expression_sql_append(sql, op, args)
205   case op
206   when :ILIKE, :"NOT ILIKE"
207     super(sql, (op == :ILIKE ? :LIKE : :"NOT LIKE"), [SQL::PlaceholderLiteralString.new(ILIKE_PLACEHOLDER, [args[0]]), args[1]])
208   when :&, :|, :^, :<<, :>>, :'B~'
209     complex_expression_emulate_append(sql, op, args)
210   else
211     super
212   end
213 end
requires_sql_standard_datetimes?()

H2 requires SQL standard datetimes

[show source] 
    # File lib/sequel/adapters/jdbc/h2.rb
221 def requires_sql_standard_datetimes?
222   true
223 end
supports_derived_column_lists?()

H2 does not support derived column lists

[show source] 
    # File lib/sequel/adapters/jdbc/h2.rb
216 def supports_derived_column_lists?
217   false
218 end
supports_is_true?()

H2 doesn’t support IS TRUE

[show source] 
    # File lib/sequel/adapters/jdbc/h2.rb
226 def supports_is_true?
227   false
228 end
supports_join_using?()

H2 doesn’t support JOIN USING

[show source] 
    # File lib/sequel/adapters/jdbc/h2.rb
231 def supports_join_using?
232   false
233 end
supports_merge?()

H2 supports MERGE

[show source] 
    # File lib/sequel/adapters/jdbc/h2.rb
236 def supports_merge?
237   true
238 end
supports_multiple_column_in?()

H2 doesn’t support multiple columns in IN/NOT IN

[show source] 
    # File lib/sequel/adapters/jdbc/h2.rb
241 def supports_multiple_column_in?
242   false
243 end