wiltondb / wiltondb

RDBMS that can work with applications written for Microsoft SQL Server
https://wiltondb.com
Apache License 2.0
46 stars 1 forks source link

TINYINT type cannot be used with sequences and IDENTITY columns #75

Open staticlibs opened 4 hours ago

staticlibs commented 4 hours ago

Identity columns of type tinyint results in error:

create table tab1 (col1 tinyint identity(1,1))
identity column type must be smallint, integer, or bigint

The same error is returned for tinyint sequences:

create sequence seq1 as tinyint start with 1 increment by 1
sequence type must be smallint, integer, or bigint
staticlibs commented 4 hours ago

This is a side-effect of a #53 fix, the workaround is to use the type smallint instead.