fjtirado commented on code in PR #3484:
URL: 
https://github.com/apache/incubator-kie-kogito-runtimes/pull/3484#discussion_r1580738221


##########
addons/common/persistence/jdbc/src/main/resources/db/ansi/V1.35.0__create_runtime_ansi.sql:
##########
@@ -1,10 +1,10 @@
 CREATE TABLE process_instances
 (
-    id              CHAR(36)      NOT NULL,
-    payload         BLOB          NOT NULL,
-    process_id      VARCHAR(4000) NOT NULL,
-    version         BIGINT(19),
-    process_version VARCHAR(4000),
+    id              character(36)      NOT NULL,
+    payload         varbinary(1000000) NOT NULL,

Review Comment:
   yes, I put a ridicolous high value, hoping that it exceeds the max allowed 
by an implementation, it wont fail and will be capped to the max. In any case, 
it is more "standard" than blob (which is supported only by oracle and mysql)



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to