E532 [CG] Fix Oracle schema qualification in table queries by gudetimes1234 · Pull Request #5978 · mage-ai/mage-ai · GitHub
[go: up one dir, main page]

Skip to content

[CG] Fix Oracle schema qualification in table queries#5978

Draft
gudetimes1234 wants to merge 6 commits intomage-ai:masterfrom
gudetimes1234:master
Draft

[CG] Fix Oracle schema qualification in table queries#5978
gudetimes1234 wants to merge 6 commits intomage-ai:masterfrom
gudetimes1234:master

Conversation

@gudetimes1234
Copy link

Description

Fixes #4969

Oracle DB data integration was failing with ORA-00942: table or view does not exist because table names in queries were not being schema-qualified. Oracle requires SCHEMA.TABLE format when accessing tables outside the default schema.

Changes

  • Added schema prefix to table names in query building logic
  • Ensures queries use {schema}.{table} format when schema is configured

How Has This Been Tested?

  • Lint check passes (./scripts/server/lint.sh)
  • Self-review of code changes

Checklist

  • The PR is tagged with proper labels (bug)
  • I have performed a self-review of my own code
  • I have added unit tests that prove my fix is effective or that my feature works
  • I have commented my code, particularly in hard-to-understand areas
  • I have made corresponding changes to the documentation

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

[BUG] Oracle DB data integration not working

2 participants

0