Methods
Public Instance
Included modules
Public Instance methods
case_expression_sql_append(sql, ce)
Derby
doesn’t support an expression between CASE and WHEN, so remove conditions.
[show source]
# File lib/sequel/adapters/jdbc/derby.rb 190 def case_expression_sql_append(sql, ce) 191 super(sql, ce.with_merged_expression) 192 end
cast_sql_append(sql, expr, type)
If the type is String, trim the extra spaces since CHAR is used instead of varchar. This can cause problems if you are casting a char/varchar to a string and the ending whitespace is important.
[show source]
# File lib/sequel/adapters/jdbc/derby.rb 197 def cast_sql_append(sql, expr, type) 198 if type == String 199 sql << "RTRIM(" 200 super 201 sql << ')' 202 else 203 super 204 end 205 end
complex_expression_sql_append(sql, op, args)
[show source]
# File lib/sequel/adapters/jdbc/derby.rb 207 def complex_expression_sql_append(sql, op, args) 208 case op 209 when :%, :'B~' 210 complex_expression_emulate_append(sql, op, args) 211 when :&, :|, :^, :<<, :>> 212 raise Error, "Derby doesn't support the #{op} operator" 213 when :** 214 sql << 'exp(' 215 literal_append(sql, args[1]) 216 sql << ' * ln(' 217 literal_append(sql, args[0]) 218 sql << "))" 219 when :extract 220 sql << args[0].to_s << '(' 221 literal_append(sql, args[1]) 222 sql << ')' 223 else 224 super 225 end 226 end
supports_group_rollup?()
Derby
supports GROUP BY ROLLUP (but not CUBE)
[show source]
# File lib/sequel/adapters/jdbc/derby.rb 229 def supports_group_rollup? 230 true 231 end
supports_is_true?()
Derby
does not support IS TRUE.
[show source]
# File lib/sequel/adapters/jdbc/derby.rb 234 def supports_is_true? 235 false 236 end
supports_merge?()
Derby
10.11+ supports MERGE.
[show source]
# File lib/sequel/adapters/jdbc/derby.rb 239 def supports_merge? 240 db.svn_version >= 1616546 241 end
supports_multiple_column_in?()
Derby
does not support IN/NOT IN with multiple columns
[show source]
# File lib/sequel/adapters/jdbc/derby.rb 244 def supports_multiple_column_in? 245 false 246 end