Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Case (in)sensitive varchar fields as primary key #198

Open
chalkos opened this issue May 13, 2016 · 0 comments
Open

Case (in)sensitive varchar fields as primary key #198

chalkos opened this issue May 13, 2016 · 0 comments
Labels
bug Issue type mysql My SQL database module
Milestone
Screening

Comments

@chalkos
Copy link
Contributor

chalkos commented May 13, 2016

Description: Converting a SQL Server DB to SIARD 2 and then converting it to MySQL produces "duplicate primary key" errors.

Steps required to reproduce the bug:

  1. Create a SQL Server Database with a table which primary key is a varchar field
  2. Insert 2 rows with values "bug" and "Bug".
  3. Convert database to SIARD 2
  4. Convert database to MySQL
  5. "duplicate key on row 2"
@chalkos chalkos self-assigned this May 13, 2016
@chalkos chalkos added bug Issue type mysql My SQL database module labels May 13, 2016
@chalkos chalkos added this to the v2.0.0 milestone May 13, 2016
@luis100 luis100 modified the milestones: v2.1.0, Unplanned Jan 9, 2019
@luis100 luis100 added this to the Screening milestone Apr 24, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Issue type mysql My SQL database module
Projects
None yet
Milestone
Screening
Development

No branches or pull requests
2 participants
@chalkos @luis100