340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
|
# File 'lib/sequel/adapters/shared/oracle.rb', line 340
def complex_expression_sql_append(sql, op, args)
case op
when :&
complex_expression_arg_pairs_append(sql, args, &BITAND_PROC)
when :|
complex_expression_arg_pairs_append(sql, args){|a, b| Sequel.lit(["(", " - ", " + ", ")"], a, complex_expression_arg_pairs([a, b], &BITAND_PROC), b)}
when :^
complex_expression_arg_pairs_append(sql, args) do |*x|
s1 = complex_expression_arg_pairs(x){|a, b| Sequel.lit(["(", " - ", " + ", ")"], a, complex_expression_arg_pairs([a, b], &BITAND_PROC), b)}
s2 = complex_expression_arg_pairs(x, &BITAND_PROC)
Sequel.lit(["(", " - ", ")"], s1, s2)
end
when :~, :'!~', :'~*', :'!~*'
raise InvalidOperation, "Pattern matching via regular expressions is not supported in this Oracle version" unless supports_regexp?
if op == :'!~' || op == :'!~*'
sql << 'NOT '
end
sql << 'REGEXP_LIKE('
literal_append(sql, args[0])
sql << ','
literal_append(sql, args[1])
if op == :'~*' || op == :'!~*'
sql << ", 'i'"
end
sql << ')'
when :%, :<<, :>>, :'B~'
complex_expression_emulate_append(sql, op, args)
else
super
end
end
|