Invalid size for id and correlation_id fields in DDL scripts kogito-ddl-1.24.0.Final

[tokarenko]

Describe the bug

Jobs service fails with the following error when PostgreSQL database are initialized with DDL scripts kogito-ddl-1.24.0.Final

jobs-service | 2022-07-25 15:16:57,453 nb-g53 ERROR [org.kie.kogito.jobs.service.resource.error.DefaultErrorMapper:-1] (executor-thread-0) Handling HTTP Error: io.vertx.pgclient.PgException: ERROR: value too long for type character varying(40) (22001)

Expected behavior

No error message

Actual behavior

id and correlation_id should be VARCHAR(50) in jobs_service_create.sql

CREATE TABLE job_details
(
id VARCHAR(40) PRIMARY KEY,
correlation_id VARCHAR(40),
status JOB_STATUS,
last_update TIMESTAMPTZ,
retries INT4,
execution_counter INT4,
scheduled_id VARCHAR(40),
payload JSONB,
type JOB_TYPE,
priority INT4,
recipient JSONB,
trigger JSONB
);

How to Reproduce?

No response

Output of uname -a or ver

No response

Output of java -version

No response

GraalVM version (if different from Java)

No response

Kogito version or git rev (or at least Quarkus version if you are using Kogito via Quarkus platform BOM)

No response

Build tool (ie. output of mvnw --version or gradlew --version)

No response

Additional information

No response

[cristianonicolai]

@tiagodolphine can you take a look?

[cristianonicolai]

Created JIRA to track this issue https://issues.redhat.com/browse/KOGITO-7642