This is an automated email from the ASF dual-hosted git repository.
fanningpj pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/pekko-persistence-jdbc.git
The following commit(s) were added to refs/heads/main by this push:
new add8ce1 Change Oracle DELETED column type from CHAR to NUMBER (#323)
add8ce1 is described below
commit add8ce140eb8fadfd41505f415acd1ad4abfbc55
Author: PJ Fanning <[email protected]>
AuthorDate: Sun Sep 21 17:34:42 2025 +0100
Change Oracle DELETED column type from CHAR to NUMBER (#323)
* Change Oracle DELETED column type from CHAR to NUMBER
* Change 'deleted' column type from char to NUMBER
---
core/src/main/resources/schema/oracle/oracle-create-schema-legacy.sql | 4 ++--
core/src/main/resources/schema/oracle/oracle-create-schema.sql | 2 +-
2 files changed, 3 insertions(+), 3 deletions(-)
diff --git
a/core/src/main/resources/schema/oracle/oracle-create-schema-legacy.sql
b/core/src/main/resources/schema/oracle/oracle-create-schema-legacy.sql
index ae0afc5..c58d9ab 100644
--- a/core/src/main/resources/schema/oracle/oracle-create-schema-legacy.sql
+++ b/core/src/main/resources/schema/oracle/oracle-create-schema-legacy.sql
@@ -3,7 +3,7 @@ CREATE SEQUENCE "ordering_seq" START WITH 1 INCREMENT BY 1
NOMAXVALUE
CREATE TABLE "journal" (
"ordering" NUMERIC,
- "deleted" char check ("deleted" in (0,1)) NOT NULL,
+ "deleted" NUMBER(1) check ("deleted" in (0,1)) NOT NULL,
"persistence_id" VARCHAR(255) NOT NULL,
"sequence_number" NUMERIC NOT NULL,
"tags" VARCHAR(255) DEFAULT NULL,
@@ -41,4 +41,4 @@ CREATE TABLE "snapshot" (
"snapshot" BLOB NOT NULL,
PRIMARY KEY ("persistence_id", "sequence_number")
)
-/
\ No newline at end of file
+/
diff --git a/core/src/main/resources/schema/oracle/oracle-create-schema.sql
b/core/src/main/resources/schema/oracle/oracle-create-schema.sql
index 11a91aa..63501b2 100644
--- a/core/src/main/resources/schema/oracle/oracle-create-schema.sql
+++ b/core/src/main/resources/schema/oracle/oracle-create-schema.sql
@@ -3,7 +3,7 @@ CREATE SEQUENCE EVENT_JOURNAL__ORDERING_SEQ START WITH 1
INCREMENT BY 1 NOMAXVAL
CREATE TABLE EVENT_JOURNAL (
ORDERING NUMERIC UNIQUE,
- DELETED CHAR(1) DEFAULT 0 NOT NULL check (DELETED in (0, 1)),
+ DELETED NUMBER(1) DEFAULT 0 NOT NULL check (DELETED in (0, 1)),
PERSISTENCE_ID VARCHAR(255) NOT NULL,
SEQUENCE_NUMBER NUMERIC NOT NULL,
WRITER VARCHAR(255) NOT NULL,
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
