# E141-08: NOT NULL inferred on PRIMARY KEY

statement ok
CREATE TABLE TABLE_E141_08_01_01 ( ID INT PRIMARY KEY, A INT, B INT, CONSTRAINT CONST_E141_08_01_01 UNIQUE ( A ) )

statement ok
CREATE TABLE TABLE_E141_08_01_02 ( ID INT PRIMARY KEY, A INT, B INT, CONSTRAINT CONST_E141_08_01_02 UNIQUE ( A , B ) )

statement ok
CREATE TABLE TABLE_E141_08_01_03 ( ID INT PRIMARY KEY, A INT, B INT, UNIQUE ( A ) )

statement ok
CREATE TABLE TABLE_E141_08_01_04 ( ID INT PRIMARY KEY, A INT, B INT, UNIQUE ( A , B ) )

statement ok
CREATE TABLE TABLE_E141_08_02_01 ( ID INT PRIMARY KEY, A INT CONSTRAINT CONST_E141_08_02_01 UNIQUE )

statement ok
CREATE TABLE TABLE_E141_08_02_02 ( ID INT PRIMARY KEY, A INT UNIQUE )

statement ok
CREATE TABLE TABLE_E141_08_03_01 ( A INT, B INT, CONSTRAINT CONST_E141_08_03_01 PRIMARY KEY ( A ) )

statement ok
CREATE TABLE TABLE_E141_08_03_02 ( A INT, B INT, CONSTRAINT CONST_E141_08_03_02 PRIMARY KEY ( A , B ) )

statement ok
CREATE TABLE TABLE_E141_08_03_03 ( A INT, B INT, PRIMARY KEY ( A ) )

statement ok
CREATE TABLE TABLE_E141_08_03_04 ( A INT, B INT, PRIMARY KEY ( A , B ) )

statement ok
CREATE TABLE TABLE_E141_08_04_01 ( A INT CONSTRAINT CONST_E141_08_04_01 PRIMARY KEY )

statement ok
CREATE TABLE TABLE_E141_08_04_02 ( A INT PRIMARY KEY )
