Aias00 opened a new issue, #6688:
URL: https://github.com/apache/shenyu/issues/6688
- severity: Medium
- files:
`shenyu-admin/src/main/resources/mappers/auth-path-sqlmap.xml:48-63`;
`shenyu-admin/src/main/resources/sql-script/h2/schema.sql:211-220`;
`shenyu-admin/src/main/java/org/apache/shenyu/admin/mapper/AuthPathMapper.java:89,97`
- description: `findByNamespaceId` / `findByNamespaceIds` issue `WHERE
namespace_id = #{...}`, but the `auth_path` table definition in the shipped H2
schema has no `namespace_id` column (columns: id, auth_id, app_name, path,
enabled, date_created, date_updated). The `Base_Column_List`, resultMap,
`save`, and `batchSave` also never reference namespace_id. The mapper methods
have no Java callers (AppAuthServiceImpl resolves paths via
`findByAuthIdList`), so this is latent.
- impact: Runtime SQL failure if the methods are ever wired up; indicates
auth_path was never namespace-ported consistently.
- suggested_fix: Either drop the methods, or add a real `namespace_id`
column to the `auth_path` schema and populate it on `save`/`batchSave`.
- confidence: High
- related_existing: none. Distinct from #6161 (Oracle schema DDL).
---
_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]
