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

Dataset class for H2 datasets accessed via JDBC.

Methods

Constants

APOS = Dataset::APOS
HSTAR = "H*".freeze
ILIKE_PLACEHOLDER = ["CAST(".freeze, " AS VARCHAR_IGNORECASE)".freeze].freeze
TIME_FORMAT = "'%H:%M:%S'".freeze
ONLY_OFFSET = " LIMIT -1 OFFSET ".freeze

Public Instance methods

Emulate the case insensitive LIKE operator and the bitwise operators.

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 164
164:         def complex_expression_sql_append(sql, op, args)
165:           case op
166:           when :ILIKE, "NOT ILIKE""NOT ILIKE"
167:             super(sql, (op == :ILIKE ? :LIKE : "NOT LIKE""NOT LIKE"), [SQL::PlaceholderLiteralString.new(ILIKE_PLACEHOLDER, [args.at(0)]), args.at(1)])
168:           when :&, :|, :^, :<<, :>>, 'B~''B~'
169:             complex_expression_emulate_append(sql, op, args)
170:           else
171:             super
172:           end
173:         end

H2 requires SQL standard datetimes

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 181
181:         def requires_sql_standard_datetimes?
182:           true
183:         end

H2 does not support derived column lists

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 176
176:         def supports_derived_column_lists?
177:           false
178:         end

H2 doesn‘t support IS TRUE

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 186
186:         def supports_is_true?
187:           false
188:         end

H2 doesn‘t support JOIN USING

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 191
191:         def supports_join_using?
192:           false
193:         end

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

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 196
196:         def supports_multiple_column_in?
197:           false
198:         end

[Validate]