jstastny-cz opened a new issue, #2394: URL: https://github.com/apache/incubator-kie-issues/issues/2394
#### **Problem** Our query logic builds inline parameter lists using the SQL `VALUES` syntax (e.g., `VALUES (?, ?)`). Some database engines reject this keyword inside subqueries or fail to detect parameter data types. This causes query crashes across both our **runtime persistence** and **data audit storage** components. #### **Solution** Replace the `VALUES` syntax with standard, highly compatible ANSI SQL elements: * Fetch parameters using a standard query anchored to a single indexed row (`MIN(id)`). * Wrap the first row with standard `CAST(? AS VARCHAR(255))` expressions to guarantee data types are recognized. * Maintain a flat query structure so that sorting and pagination work correctly down the line. #### **Impact** * **Unified Fix:** Resolves query errors for both **runtime persistence** and **data audit storage** simultaneously. * **Broad Database Support:** Code runs cleanly across multiple databases and local test environments. * **Zero Performance Loss:** Primary key indexing keeps the parameter selection ultra-fast. -- 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]
