Aias00 opened a new issue, #6693:
URL: https://github.com/apache/shenyu/issues/6693
- severity: Medium
- files:
`shenyu-admin/src/main/resources/mappers/ai-proxy-api-key-sqlmap.xml:132,155,156,169,181,188`
- description: `insert`, `insertSelective`, `update`, `updateSelective`, and
`updateEnableBatch` hardcode `NOW(3)` (MySQL fractional-second `NOW`).
H2/PostgreSQL/OpenGauss/Oracle do not accept `NOW(3)`. Unlike
`plugin`/`operation-record-log`, this mapper has no `databaseId` variants. It
also bypasses the DO's `dateCreated`/`dateUpdated` fields entirely.
- impact: The ai-proxy-api-key CRUD path is broken on every non-MySQL
dialect; the entity timestamp fields are ignored on insert.
- suggested_fix: Bind `#{dateCreated}`/`#{dateUpdated}` from the entity
(consistent with every other mapper) and let the service set timestamps, or add
`databaseId`-specific variants.
- confidence: High
- related_existing: none. Distinct from #5631 (Oracle rule-sqlmap `;`) and
#6161 (Oracle schema).
---
_Identified during the 2026-08-02 deep re-scan; full list in
[`docs/scan2-2026-08-02/06-medium-tiers.md`](docs/scan2-2026-08-02/06-medium-tiers.md)._
--
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]
