Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

This project is archived and is in readonly mode.

Add unique index test fails on sqlite2

#30

The test_add_index in migration_test.rb fails on sqlite2 when attempting to add a unique index on a column. The value of that column is null for all rows, which sqlite2 considers violates the uniqueness constrain (other databases don't seem to care). Seeding some data into that column fixes the problem.

Reported by Frederick Cheung · April 21st, 2008 @ 09:18 AM

State: resolved
Milestone: none
Assigned to: nobody
Importance: none

Activity

  1. Michael Koziarski
    Michael Koziarski

    This causes failures on mysql. I believe because key is a reserved word?

    April 21st, 2008 @ 09:36 AM

  2. Frederick Cheung
    Frederick Cheung

    D'oh, should have quoted that column name

    April 21st, 2008 @ 10:00 AM

  3. Frederick Cheung
    Frederick Cheung

    Quoting the column name fixes it as expected

    April 21st, 2008 @ 10:10 AM

  4. Repository
    Repository

    (from [ae51013c3f7b8a8579fcb99d889ed80e9dd75797]) Provide data for the key column otherwise adding a unique index will fail. [#30 state:closed]

    http://github.com/rails/rails/co...

    April 23rd, 2008 @ 03:25 AM

  5. Michael Koziarski
    Michael Koziarski
    • State changed from new to resolved

    April 23rd, 2008 @ 03:25 AM