# File lib/active_record/connection_adapters/db2_adapter.rb, line 94 def add_limit_offset!(sql, options) if options[:limit] and !options[:limit].nil? # "FETCH FIRST 0 ROWS ONLY" is not allowed, so we have # to use a cheap trick. if options[:limit] == 0 if sql =~ /WHERE/i sql.sub!(/WHERE/i, 'WHERE 1 = 2 AND ') elsif sql =~ /ORDER\s+BY/i sql.sub!(/ORDER\s+BY/i, 'WHERE 1 = 2 ORDER BY') else sql << 'WHERE 1 = 2' end else sql << " FETCH FIRST #{options[:limit]} ROWS ONLY" end end if options[:offset] and !options[:offset].nil? raise ArgumentError, ':offset option is not yet supported!' end end