Working DML Test scripts that failed:

Compare failed - working_dml/misc/notnullconstraint.negative.sql

Details from queryTester:

Total Local Passed   = 81

Total Local Failed   = 0

Total Ref Passed     = 0

Total Fef Failed     = 0

Total Compare Passed = 80

Total Compare Failed = 1

Total Selects        = 1251

Total Inserts        = 558

Total Updates        = 142

Total Deletes        = 34

Total Creates        = 361

Total Drops          = 484

Failing requests in: working_dml/misc/notnullconstraint.negative.sql

--- ../../working_dml/misc/notnullconstraint.negative.sql.ref.log	2023-04-05 22:02:23.000000000 +0000

+++ ../../working_dml/misc/notnullconstraint.negative.sql.bad.log	2023-04-05 22:52:21.951571441 +0000

@@ -3,9 +3,11 @@

 ERROR 1048 (23000) at line 32: Column 'col1' cannot be null

 ERROR 1048 (23000) at line 34: Column 'col2' cannot be null

 ERROR 1815 (HY000) at line 36: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col1' cannot be null.

-ERROR 1815 (HY000) at line 38: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col1' cannot be null.

+ERROR 1815 (HY000) at line 38: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.

+ERROR 1815 (HY000) at line 42: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.

+ERROR 1815 (HY000) at line 53: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.

 ERROR 1815 (HY000) at line 55: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col2' cannot be null.

-ERROR 1815 (HY000) at line 57: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col2' cannot be null.

+ERROR 1815 (HY000) at line 57: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.

 col_1

 1

 2

Failing requests in: working_dml/misc/notnullconstraint.negative.sql

--- ../../working_dml/misc/notnullconstraint.negative.sql.ref.log	2023-04-05 22:02:23.000000000 +0000

+++ ../../working_dml/misc/notnullconstraint.negative.sql.bad.log	2023-04-05 22:52:21.951571441 +0000

@@ -3,9 +3,11 @@

 ERROR 1048 (23000) at line 32: Column 'col1' cannot be null

 ERROR 1048 (23000) at line 34: Column 'col2' cannot be null

 ERROR 1815 (HY000) at line 36: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col1' cannot be null.

-ERROR 1815 (HY000) at line 38: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col1' cannot be null.

+ERROR 1815 (HY000) at line 38: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.

+ERROR 1815 (HY000) at line 42: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.

+ERROR 1815 (HY000) at line 53: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.

 ERROR 1815 (HY000) at line 55: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col2' cannot be null.

-ERROR 1815 (HY000) at line 57: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col2' cannot be null.

+ERROR 1815 (HY000) at line 57: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.

 col_1

 1

 2