Skip to content

Changing column type and repairing database causes reader to return wrong column data #1

@Bysza

Description

@Bysza

Hi.
Please find the attached repro solution: Bug01-repro-sln.zip
Reading data from the [Identifier] column returns data from [number01] column.

How we got here:

  1. Create Access db with a single table: Id Autonumber, Number1 shortstring, Number2 shortstring
  2. Insert a few different integers into Number1 and Number2 columns
  3. Open table in JetDatabaseReader and expect data to be read properly
  4. Change type of the Number1 column to numeric
  5. Open table in JetDatabaseReader and expect exception informing that data cannot be read and a db repair is needed
  6. Repair the database
  7. Open table in JetDatabaseReader again and expect wrong column to be read (check repro code).

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions