diff options
| author | Jeremy Kemper <jeremy@bitsweat.net> | 2005-09-27 20:24:52 +0000 |
|---|---|---|
| committer | Jeremy Kemper <jeremy@bitsweat.net> | 2005-09-27 20:24:52 +0000 |
| commit | 3fa38c4dba8382753c528003f97f7d1e164f01b0 (patch) | |
| tree | f2fd0093dbb9eea841bc43643806eb31c6251e16 | |
| parent | fe0ffe406e831378a2864a706e9648b05023df1e (diff) | |
| download | rails-3fa38c4dba8382753c528003f97f7d1e164f01b0.tar.gz rails-3fa38c4dba8382753c528003f97f7d1e164f01b0.tar.bz2 rails-3fa38c4dba8382753c528003f97f7d1e164f01b0.zip | |
Oops, swapped order of params to COALESCE! Upcoming patch has test cases.
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2370 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
| -rwxr-xr-x | activerecord/lib/active_record/fixtures.rb | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/activerecord/lib/active_record/fixtures.rb b/activerecord/lib/active_record/fixtures.rb index eb97c0f469..5a7ccc8384 100755 --- a/activerecord/lib/active_record/fixtures.rb +++ b/activerecord/lib/active_record/fixtures.rb @@ -254,7 +254,7 @@ class Fixtures < Hash pk = table_class.columns_hash[table_class.primary_key] if pk and pk.type == :integer connection.execute( - "SELECT setval('#{table}_#{pk.name}_seq', (SELECT COALESCE(0, MAX(#{pk.name}))+1 FROM #{table}), false)", + "SELECT setval('#{table}_#{pk.name}_seq', (SELECT COALESCE(MAX(#{pk.name}), 0)+1 FROM #{table}), false)", 'Setting Sequence' ) end |