derby_migration_test.rb

require 'jdbc_common'
require 'db/derby'

class CreateDummies < ActiveRecord::Migration
  def self.up
    create_table :dummies, :force => true do |t|
      t.string :year, :default => "", :null => false
    end
    add_index :dummies, :year, :unique => true
  end
  
end

class ChangeColumn < ActiveRecord::Migration
  def self.up
    create_table :people, :id => false, :force => true do |t|
      t.string :id, :limit => 22, :null => false
      t.string :name, :null => false
    end
    change_column(:people, :name, :string, {:limit=>22})
    execute("SELECT id FROM people WHERE id = 'some string'")
  end

  def self.down
  end

end

class CreateIndex < ActiveRecord::Migration
  def self.up
    create_table :people, :id => false, :force => true do |t|
      t.string :id, :limit => 22, :null => false
      t.string :first_name, :null => false
      t.string :last_name, :null => false
      t.string :nickname, :null => false
      t.string :long_name, :null => false
      t.string :very_long_name, :null => false
      t.string :extremely_long_name, :null => false
    end
    add_index(:people, [:first_name, :last_name, :nickname, :long_name, :very_long_name, :extremely_long_name], :unique => true)
    remove_index(:people, [:first_name, :last_name, :nickname, :long_name, :very_long_name, :extremely_long_name])
  end

  def self.down
  end

end

class DerbyMigrationTest < Test::Unit::TestCase
  include FixtureSetup

  def test_create_table_column_quoting_vs_keywords
    CreateDummies.up
  end
  
  def test_migrate_change_column_for_non_standard_id
    ChangeColumn.up
    ChangeColumn.down
  end
  
  def test_migrate_create_index
    CreateIndex.up
    CreateIndex.down
  end
  
end

Test output 2.3.5

macbeth:activerecord-jdbc-adapter uwe$ jruby -S rake test_derby
(in /Users/uwe/workspace/aifudis/activerecord-jdbc-adapter)
no such file to load -- hoe
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
/Users/uwe/workspace/aifudis/activerecord-jdbc-adapter/rakelib/package.rake:13
/Users/uwe/workspace/aifudis/activerecord-jdbc-adapter/rakelib/package.rake:1620:in `load'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1620:in `load'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2451:in `load_imports'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2390:in `raw_load_rakefile'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2017:in `load_rakefile'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2016:in `load_rakefile'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2000:in `run'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:19:in `load'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby/bin/rake:19
Problem loading Hoe; please check the error above to ensure that Hoe is installed correctly
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby/bin/jruby -I"lib:drivers/derby/lib:adapters/derby/lib:test" -rjdbc/derby "/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake/rake_test_loader.rb" "test/derby_date_time_test.rb" "test/derby_migration_test.rb" "test/derby_multibyte_test.rb" "test/derby_simple_test.rb" 
Using activerecord version 2.3.5
Specify version with AR_VERSION=={version} or RUBYLIB={path}
Loaded suite /Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake/rake_test_loader
Started
..........................................
Finished in 10.777 seconds.

42 tests, 61 assertions, 0 failures, 0 errors
macbeth:activerecord-jdbc-adapter uwe$ 

Test output 2.3.8

macbeth:activerecord-jdbc-adapter uwe$ jruby -S rake test_derby
(in /Users/uwe/workspace/aifudis/activerecord-jdbc-adapter)
no such file to load -- hoe
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
/Users/uwe/workspace/aifudis/activerecord-jdbc-adapter/rakelib/package.rake:13
/Users/uwe/workspace/aifudis/activerecord-jdbc-adapter/rakelib/package.rake:1620:in `load'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1620:in `load'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2451:in `load_imports'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2390:in `raw_load_rakefile'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2017:in `load_rakefile'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2016:in `load_rakefile'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2000:in `run'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:19:in `load'
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby/bin/rake:19
Problem loading Hoe; please check the error above to ensure that Hoe is installed correctly
/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby/bin/jruby -I"lib:drivers/derby/lib:adapters/derby/lib:test" -rjdbc/derby "/Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake/rake_test_loader.rb" "test/derby_date_time_test.rb" "test/derby_migration_test.rb" "test/derby_multibyte_test.rb" "test/derby_simple_test.rb" 
Using activerecord version 2.3.8
Specify version with AR_VERSION=={version} or RUBYLIB={path}
Loaded suite /Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake/rake_test_loader
Started
....E.....................................
Finished in 16.229 seconds.

  1) Error:
test_migrate_create_index(DerbyMigrationTest):
NoMethodError: private method `warn' called for nil:NilClass
    /Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/connection_adapters/abstract/schema_statements.rb:282:in `add_index'
    /Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:352:in `method_missing'
    /Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:328:in `say_with_time'
    /Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby/lib/ruby/1.8/benchmark.rb:293:in `measure'
    /Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:328:in `say_with_time'
    /Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:348:in `method_missing'
    ./test/derby_migration_test.rb:40:in `up'
    /Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:282:in `migrate'
    /Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby/lib/ruby/1.8/benchmark.rb:293:in `measure'
    /Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:282:in `migrate'
    /Users/uwe/workspace/aifudis/aifudis.operator/platform/jruby-1.5.1/lib/ruby/gems/1.8/gems/activerecord-2.3.8/lib/active_record/migration.rb:265:in `up_with_benchmarks'
    ./test/derby_migration_test.rb:62:in `test_migrate_create_index'

42 tests, 61 assertions, 0 failures, 1 errors
rake aborted!
Command failed with status (1): [/Users/uwe/workspace/aifudis/aifudis.opera...]

(See full trace by running task with --trace)
macbeth:activerecord-jdbc-adapter uwe$