pjfanning opened a new issue, #483: URL: https://github.com/apache/pekko-persistence-jdbc/issues/483
https://github.com/pjfanning/incubator-pekko-persistence-jdbc/pull/2#issuecomment-4188994169 > @copilot investigate why Oracle tests failed and suggest changes. Comment with the results on this PR or provide a link to your agent analysis. The oracle test failures can be seen in https://github.c... Root cause: all 5 tests in `OracleDurableStateStoreTCKSpec` failed with `ORA-01400: cannot insert NULL into ("SYSTEM"."DURABLE_STATE"."TAG")`. The Oracle `DURABLE_STATE.TAG` column has a `NOT NULL` constraint (unlike PostgreSQL/MySQL/MariaDB/SQL Server which allow NULL). The TCK tests were calling `upsertObject(pid, X, value, "")` with an empty string tag. `JdbcDurableStateStore` converts `""` → `None` → SQL `NULL`, which Oracle rejects. We shouldn't have to hack the TCK tests to suit the Oracle setup. We should probably change the DDL for Oracle databases so that null and/or empty tags are supported. -- 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]
