Class: Sequel::JDBC::HSQLDB::Dataset

Inherits:
JDBC::Dataset
  • Object
show all
Defined in:
lib/sequel/adapters/jdbc/hsqldb.rb

Instance Method Summary collapse

Instance Method Details

#complex_expression_sql_append(sql, op, args) ⇒ Object

Handle HSQLDB specific case insensitive LIKE and bitwise operator support.



144
145
146
147
148
149
150
151
152
153
 
# File 'lib/sequel/adapters/jdbc/hsqldb.rb', line 144

def complex_expression_sql_append(sql, op, args)
  case op
  when :ILIKE, :"NOT ILIKE"
    super(sql, (op == :ILIKE ? :LIKE : :"NOT LIKE"), args.map{|v| SQL::Function.new(:ucase, v)})
  when :&, :|, :^, :%, :<<, :>>, :'B~'
    complex_expression_emulate_append(sql, op, args)
  else
    super
  end
end

#recursive_cte_requires_column_aliases? ⇒ Boolean

HSQLDB requires recursive CTEs to have column aliases.

Returns:

  • (Boolean) 


156
157
158
 
# File 'lib/sequel/adapters/jdbc/hsqldb.rb', line 156

def recursive_cte_requires_column_aliases?
  true
end

#requires_sql_standard_datetimes? ⇒ Boolean

HSQLDB requires SQL standard datetimes in some places.

Returns:

  • (Boolean) 


161
162
163
 
# File 'lib/sequel/adapters/jdbc/hsqldb.rb', line 161

def requires_sql_standard_datetimes?
  true
end

#supports_cte?(type = :select) ⇒ Boolean

HSQLDB does support common table expressions, but the support is broken. CTEs operate more like temprorary tables or views, lasting longer than the duration of the expression. CTEs in earlier queries might take precedence over CTEs with the same name in later queries. Also, if any CTE is recursive, all CTEs must be recursive. If you want to use CTEs with HSQLDB, you'll have to manually modify the dataset to allow it.

Returns:

  • (Boolean) 


170
171
172
 
# File 'lib/sequel/adapters/jdbc/hsqldb.rb', line 170

def supports_cte?(type=:select)
  false
end

#supports_is_true? ⇒ Boolean

HSQLDB does not support IS TRUE.

Returns:

  • (Boolean) 


175
176
177
 
# File 'lib/sequel/adapters/jdbc/hsqldb.rb', line 175

def supports_is_true?
  false
end

#supports_lateral_subqueries? ⇒ Boolean

HSQLDB supports lateral subqueries.

Returns:

  • (Boolean) 


180
181
182
 
# File 'lib/sequel/adapters/jdbc/hsqldb.rb', line 180

def supports_lateral_subqueries?
  true
end

#supports_merge? ⇒ Boolean

HSQLDB 2.3.4+ supports MERGE. Older versions also support MERGE, but not all features that are in Sequel's tests.

Returns:

  • (Boolean) 


186
187
188
 
# File 'lib/sequel/adapters/jdbc/hsqldb.rb', line 186

def supports_merge?
  db.db_version >= 20304
end