Broken db2 sql for INT_LOCK [INT-4574]

[spring-operator]

Glenn Renfro opened INT-4574 and commented

When trying to create a int_lock table we get a failure from DB2:
Error: The column named "LOCK_KEY" cannot be a column of a primary key or unique key constraint because it can contain null values.. SQLCODE=-542, SQLSTATE=42831, DRIVER=4.11.77
SQLState: 42831
ErrorCode: -542

 

As discussed in the (look in REFERENCE_URL) the resolution is to add not null to the lock key and region.   

---

Affects: 5.1.2

Reference URL: spring-cloud/spring-cloud-task#500

Referenced from: pull request #2697

Backported to: 5.0.12, 4.3.20

[spring-operator]

Artem Bilan commented

This is really a bug and this is not a breaking change and easy to fix in all the affected versions.

[spring-operator]

Artem Bilan commented

Backport PR: #2698