SQLProvider icon indicating copy to clipboard operation
SQLProvider copied to clipboard

When row is created, auto_increment column is created as UInt64

Open JP3BGY opened this issue 6 years ago • 0 comments
trafficstars

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

JP3BGY avatar Sep 13 '19 13:09 JP3BGY