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

Dataset class for H2 datasets accessed via JDBC.

Methods

complex_expression_sql_append   requires_sql_standard_datetimes?   supports_is_true?   supports_join_using?   supports_multiple_column_in?  

Constants

SELECT_CLAUSE_METHODS = clause_methods(:select, %w'select distinct columns from join where group having compounds order limit')
BITWISE_METHOD_MAP = {:& =>:BITAND, :| => :BITOR, :^ => :BITXOR}
APOS = Dataset::APOS
HSTAR = "H*".freeze
BITCOMP_OPEN = "((0 - ".freeze
BITCOMP_CLOSE = ") - 1)".freeze
ILIKE_PLACEHOLDER = "CAST(? AS VARCHAR_IGNORECASE)".freeze
TIME_FORMAT = "'%H:%M:%S'".freeze
H2_CLOB_METHOD = TYPE_TRANSLATOR_INSTANCE.method(:h2_clob)

Public Instance methods

complex_expression_sql_append(sql, op, args)

Emulate the case insensitive LIKE operator and the bitwise operators.

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 122
122:         def complex_expression_sql_append(sql, op, args)
123:           case op
124:           when :ILIKE, "NOT ILIKE""NOT ILIKE"
125:             super(sql, (op == :ILIKE ? :LIKE : "NOT LIKE""NOT LIKE"), [SQL::PlaceholderLiteralString.new(ILIKE_PLACEHOLDER, [args.at(0)]), args.at(1)])
126:           when :&, :|, :^
127:             sql << complex_expression_arg_pairs(args){|a, b| literal(SQL::Function.new(BITWISE_METHOD_MAP[op], a, b))}
128:           when :<<
129:             sql << complex_expression_arg_pairs(args){|a, b| "(#{literal(a)} * POWER(2, #{literal(b)}))"}
130:           when :>>
131:             sql << complex_expression_arg_pairs(args){|a, b| "(#{literal(a)} / POWER(2, #{literal(b)}))"}
132:           when 'B~''B~'
133:             sql << BITCOMP_OPEN
134:             literal_append(sql, args.at(0))
135:             sql << BITCOMP_CLOSE
136:           else
137:             super
138:           end
139:         end
requires_sql_standard_datetimes?()

H2 requires SQL standard datetimes

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 142
142:         def requires_sql_standard_datetimes?
143:           true
144:         end
supports_is_true?()

H2 doesn‘t support IS TRUE

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 147
147:         def supports_is_true?
148:           false
149:         end
supports_join_using?()

H2 doesn‘t support JOIN USING

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 152
152:         def supports_join_using?
153:           false
154:         end
supports_multiple_column_in?()

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

[Source]

     # File lib/sequel/adapters/jdbc/h2.rb, line 157
157:         def supports_multiple_column_in?
158:           false
159:         end

[Validate]