Class Sequel::JDBC::H2::Dataset
In: lib/sequel/adapters/jdbc/h2.rb
Parent: JDBC::Dataset

Methods

Constants

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

Public Instance methods

Emulate the case insensitive LIKE operator and the bitwise operators.

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 172
172:         def complex_expression_sql_append(sql, op, args)
173:           case op
174:           when :ILIKE, "NOT ILIKE""NOT ILIKE"
175:             super(sql, (op == :ILIKE ? :LIKE : "NOT LIKE""NOT LIKE"), [SQL::PlaceholderLiteralString.new(ILIKE_PLACEHOLDER, [args[0]]), args[1]])
176:           when :&, :|, :^, :<<, :>>, 'B~''B~'
177:             complex_expression_emulate_append(sql, op, args)
178:           else
179:             super
180:           end
181:         end

H2 requires SQL standard datetimes

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 189
189:         def requires_sql_standard_datetimes?
190:           true
191:         end

H2 does not support derived column lists

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 184
184:         def supports_derived_column_lists?
185:           false
186:         end

H2 doesn‘t support IS TRUE

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 194
194:         def supports_is_true?
195:           false
196:         end

H2 doesn‘t support JOIN USING

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 199
199:         def supports_join_using?
200:           false
201:         end

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

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 204
204:         def supports_multiple_column_in?
205:           false
206:         end

[Validate]