diff options
| author | Raimonds Simanovskis <raimonds.simanovskis@gmail.com> | 2010-06-19 16:02:51 +0300 |
|---|---|---|
| committer | Raimonds Simanovskis <raimonds.simanovskis@gmail.com> | 2010-06-19 16:02:51 +0300 |
| commit | 0ffaa8d4628702bc44a1302fb9a37b92a52f9a22 (patch) | |
| tree | 7ae0a55b92415dd733a2a21b441903f3584f709f /spec/engines/sql/unit | |
| parent | bbddfe7641bf1f81ba47bd3deaa56edd13d5083c (diff) | |
| download | rails-0ffaa8d4628702bc44a1302fb9a37b92a52f9a22.tar.gz rails-0ffaa8d4628702bc44a1302fb9a37b92a52f9a22.tar.bz2 rails-0ffaa8d4628702bc44a1302fb9a37b92a52f9a22.zip | |
use subquery to get first records if DISTINCT is used (in Oracle compiler)
Diffstat (limited to 'spec/engines/sql/unit')
| -rw-r--r-- | spec/engines/sql/unit/relations/take_spec.rb | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/spec/engines/sql/unit/relations/take_spec.rb b/spec/engines/sql/unit/relations/take_spec.rb index 9f2967a0bd..cc3c3dbbf5 100644 --- a/spec/engines/sql/unit/relations/take_spec.rb +++ b/spec/engines/sql/unit/relations/take_spec.rb @@ -34,6 +34,14 @@ module Arel ORDER BY "USERS"."ID" ASC) where rownum <= 4 }) + + sql_with_distinct = Take.new(@relation.project('DISTINCT "USERS"."ID"'), @taken).to_sql + sql_with_distinct.should be_like(%Q{ + select * from + (SELECT DISTINCT "USERS"."ID" + FROM "USERS") + where rownum <= 4 + }) end adapter_is_not :mysql, :oracle do |