sql-psi icon indicating copy to clipboard operation
sql-psi copied to clipboard

MySQL complaining about UNSIGNED type

Open ScottPierce opened this issue 3 years ago • 0 comments

Dialect

MySQL

Failing SQL

CREATE TABLE Permissions (
    id INTEGER AUTO_INCREMENT PRIMARY KEY,
    userId VARCHAR(32) NOT NULL,
    type UNSIGNED TINYINT NOT NULL,
    FOREIGN KEY (userId) REFERENCES Users(id),
    INDEX(userId)
);

Description

I'm getting an IDE error for the above SQL. It doesn't seem to like my use of UNSIGNED.

ScottPierce avatar Jan 17 '22 19:01 ScottPierce