The Wayback Machine - https://web.archive.org/web/20201110213517/https://github.com/fsprojects/SQLProvider/issues/638
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.

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

When row is created, auto_increment column is created as UInt64 #638

Open
JP3BGY opened this issue Sep 13, 2019 · 0 comments
Open

When row is created, auto_increment column is created as UInt64 #638

JP3BGY opened this issue Sep 13, 2019 · 0 comments

Comments

@JP3BGY
Copy link

@JP3BGY JP3BGY commented Sep 13, 2019

Description

When row is created by Created(columnOne,columnTwo...) , object mapping to auto_increment column is made as UInt64 even if the column's type is Int.

Repro steps

  1. Create Table containing auto_increment column typed INT in MariaDB
  2. Create row by Create(columnOne,columnTwo,...)()
  3. Get the object of the column from ColumnValues and call GetType() method or call MapTo<> and get type error.

Expected behavior

Int32 or int is returned

Actual behavior

UInt64 is returned

Known workarounds

Type of row.auto_incremented_column is int.
Type of the object in row gotten from query{} is also int.
It occurs when row is created by Create() .

Related information

  • MariaDB 10.3.17
  • Ubuntu19.04
  • dotnet core 2.2.401
  • SQLProvider 1.1.68
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
1 participant
You can’t perform that action at this time.