hanicz opened a new pull request, #1470: URL: https://github.com/apache/knox/pull/1470
… tables [KNOX-3495](https://issues.apache.org/jira/browse/KNOX-3495) - DB remote configuration monitor fails on Oracle with ORA-00904 on 21c and 19c ## What changes were proposed in this pull request? createKnoxProvidersTableOracle.sql and createKnoxDescriptorsTableOracle.sql declared `deleted NUMBER(1) DEFAULT false NOT NULL`. Oracle has no FALSE literal before 23ai, so table creation failed with `ORA-00904: "FALSE": invalid identifier` and the gateway did not start when the DB-backed remote config monitor was enabled. Changed the default to `DEFAULT 0`, matching the other Oracle scripts. ## How was this patch tested? ran both scripts against Oracle XE 21c in Docker. The scripts before this change fail with ORA-00904, and the fixed scripts create both tables. -- 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]
