# E141-04: Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action

# SKIP: No need to support foreign keys

# statement ok
# CREATE TABLE TABLE_E141_04_01_011 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_01_012 ( B INT NOT NULL CONSTRAINT CONST_E141_04_01_01 REFERENCES TABLE_E141_04_01_011 ( A ) )

# statement ok
# CREATE TABLE TABLE_E141_04_01_021 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_01_022 ( B INT NOT NULL CONSTRAINT CONST_E141_04_01_02 REFERENCES TABLE_E141_04_01_021 ( A ) ON DELETE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_01_031 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_01_032 ( B INT NOT NULL CONSTRAINT CONST_E141_04_01_03 REFERENCES TABLE_E141_04_01_031 ( A ) ON UPDATE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_01_041 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_01_042 ( B INT NOT NULL CONSTRAINT CONST_E141_04_01_04 REFERENCES TABLE_E141_04_01_041 ( A ) ON UPDATE NO ACTION ON DELETE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_01_051 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_01_052 ( B INT NOT NULL REFERENCES TABLE_E141_04_01_051 ( A ) )

# statement ok
# CREATE TABLE TABLE_E141_04_01_061 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_01_062 ( B INT NOT NULL REFERENCES TABLE_E141_04_01_061 ( A ) ON DELETE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_01_071 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_01_072 ( B INT NOT NULL REFERENCES TABLE_E141_04_01_071 ( A ) ON UPDATE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_01_081 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_01_082 ( B INT NOT NULL REFERENCES TABLE_E141_04_01_081 ( A ) ON UPDATE NO ACTION ON DELETE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_02_011 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_02_012 ( B INT NOT NULL CONSTRAINT CONST_E141_04_02_01 REFERENCES TABLE_E141_04_02_011 ( A ) ON DELETE NO ACTION ON UPDATE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_02_021 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_02_022 ( B INT NOT NULL REFERENCES TABLE_E141_04_02_021 ( A ) ON DELETE NO ACTION ON UPDATE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_03_011 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_03_012 ( B INT NOT NULL, CONSTRAINT CONST_E141_04_03_01 FOREIGN KEY ( B ) REFERENCES TABLE_E141_04_03_011 ( A ) )

# statement ok
# CREATE TABLE TABLE_E141_04_03_021 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_03_022 ( B INT NOT NULL, CONSTRAINT CONST_E141_04_03_02 FOREIGN KEY ( B ) REFERENCES TABLE_E141_04_03_021 ( A ) ON DELETE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_03_031 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_03_032 ( B INT NOT NULL, CONSTRAINT CONST_E141_04_03_03 FOREIGN KEY ( B ) REFERENCES TABLE_E141_04_03_031 ( A ) ON UPDATE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_03_041 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_03_042 ( B INT NOT NULL, CONSTRAINT CONST_E141_04_03_04 FOREIGN KEY ( B ) REFERENCES TABLE_E141_04_03_041 ( A ) ON UPDATE NO ACTION ON DELETE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_03_051 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_03_052 ( B INT NOT NULL, FOREIGN KEY ( B ) REFERENCES TABLE_E141_04_03_051 ( A ) )

# statement ok
# CREATE TABLE TABLE_E141_04_03_061 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_03_062 ( B INT NOT NULL, FOREIGN KEY ( B ) REFERENCES TABLE_E141_04_03_061 ( A ) ON DELETE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_03_071 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_03_072 ( B INT NOT NULL, FOREIGN KEY ( B ) REFERENCES TABLE_E141_04_03_071 ( A ) ON UPDATE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_03_081 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_03_082 ( B INT NOT NULL, FOREIGN KEY ( B ) REFERENCES TABLE_E141_04_03_081 ( A ) ON UPDATE NO ACTION ON DELETE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_04_011 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_04_012 ( B INT NOT NULL, CONSTRAINT CONST_E141_04_04_01 FOREIGN KEY ( B ) REFERENCES TABLE_E141_04_04_011 ( A ) ON DELETE NO ACTION ON UPDATE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_04_021 ( A INT NOT NULL, UNIQUE ( A ) );

# statement ok
# CREATE TABLE TABLE_E141_04_04_022 ( B INT NOT NULL, FOREIGN KEY ( B ) REFERENCES TABLE_E141_04_04_021 ( A ) ON DELETE NO ACTION ON UPDATE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_05_011 ( A INT NOT NULL, B INT NOT NULL, UNIQUE ( A, B ) );

# statement ok
# CREATE TABLE TABLE_E141_04_05_012 ( C INT NOT NULL, D INT NOT NULL, CONSTRAINT CONST_E141_04_05_01 FOREIGN KEY ( C, D ) REFERENCES TABLE_E141_04_05_011 ( A, B ) )

# statement ok
# CREATE TABLE TABLE_E141_04_05_021 ( A INT NOT NULL, B INT NOT NULL, UNIQUE ( A, B ) );

# statement ok
# CREATE TABLE TABLE_E141_04_05_022 ( C INT NOT NULL, D INT NOT NULL, CONSTRAINT CONST_E141_04_05_02 FOREIGN KEY ( C, D ) REFERENCES TABLE_E141_04_05_021 ( A, B ) ON DELETE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_05_031 ( A INT NOT NULL, B INT NOT NULL, UNIQUE ( A, B ) );

# statement ok
# CREATE TABLE TABLE_E141_04_05_032 ( C INT NOT NULL, D INT NOT NULL, CONSTRAINT CONST_E141_04_05_03 FOREIGN KEY ( C, D ) REFERENCES TABLE_E141_04_05_031 ( A, B ) ON UPDATE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_05_041 ( A INT NOT NULL, B INT NOT NULL, UNIQUE ( A, B ) );

# statement ok
# CREATE TABLE TABLE_E141_04_05_042 ( C INT NOT NULL, D INT NOT NULL, CONSTRAINT CONST_E141_04_05_04 FOREIGN KEY ( C, D ) REFERENCES TABLE_E141_04_05_041 ( A, B ) ON UPDATE NO ACTION ON DELETE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_05_051 ( A INT NOT NULL, B INT NOT NULL, UNIQUE ( A, B ) );

# statement ok
# CREATE TABLE TABLE_E141_04_05_052 ( C INT NOT NULL, D INT NOT NULL, FOREIGN KEY ( C, D ) REFERENCES TABLE_E141_04_05_051 ( A, B ) )

# statement ok
# CREATE TABLE TABLE_E141_04_05_061 ( A INT NOT NULL, B INT NOT NULL, UNIQUE ( A, B ) );

# statement ok
# CREATE TABLE TABLE_E141_04_05_062 ( C INT NOT NULL, D INT NOT NULL, FOREIGN KEY ( C, D ) REFERENCES TABLE_E141_04_05_061 ( A, B ) ON DELETE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_05_071 ( A INT NOT NULL, B INT NOT NULL, UNIQUE ( A, B ) );

# statement ok
# CREATE TABLE TABLE_E141_04_05_072 ( C INT NOT NULL, D INT NOT NULL, FOREIGN KEY ( C, D ) REFERENCES TABLE_E141_04_05_071 ( A, B ) ON UPDATE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_05_081 ( A INT NOT NULL, B INT NOT NULL, UNIQUE ( A, B ) );

# statement ok
# CREATE TABLE TABLE_E141_04_05_082 ( C INT NOT NULL, D INT NOT NULL, FOREIGN KEY ( C, D ) REFERENCES TABLE_E141_04_05_081 ( A, B ) ON UPDATE NO ACTION ON DELETE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_06_011 ( A INT NOT NULL, B INT NOT NULL, UNIQUE ( A, B ) );

# statement ok
# CREATE TABLE TABLE_E141_04_06_012 ( C INT NOT NULL, D INT NOT NULL, CONSTRAINT CONST_E141_04_06_01 FOREIGN KEY ( C, D ) REFERENCES TABLE_E141_04_06_011 ( A, B ) ON DELETE NO ACTION ON UPDATE NO ACTION )

# statement ok
# CREATE TABLE TABLE_E141_04_06_021 ( A INT NOT NULL, B INT NOT NULL, UNIQUE ( A, B ) );

# statement ok
# CREATE TABLE TABLE_E141_04_06_022 ( C INT NOT NULL, D INT NOT NULL, FOREIGN KEY ( C, D ) REFERENCES TABLE_E141_04_06_021 ( A, B ) ON DELETE NO ACTION ON UPDATE NO ACTION )
