Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

getIndexInformationQueryString pulling info from unrelated indexes #19

Open
jmdedalus opened this issue Sep 5, 2024 · 0 comments
Open

Comments

@jmdedalus
Copy link

The SQL in getIndexInformationQueryString() is missing table join filter.

Currently,

        FROM SYS.ALL_INDEXES ix
          LEFT JOIN SYS.ALL_CONSTRAINTS pc ON ix.INDEX_NAME = pc.INDEX_NAME
          LEFT JOIN SYS.ALL_IND_COLUMNS cols ON ix.INDEX_NAME = cols.INDEX_NAME

...means CONSTRAINT and COLUMN information for any index with the same name across the entire database (ie, all other schemas/owners) is being captured.

In the case of very large databases, this is having the secondary effect of exceeding the 4k character limit on the LISTAGG aggregating function, resulting in the error message ORA-01489: result of string concatenation is too long

jmdedalus added a commit to jmdedalus/mdm-plugin-database-oracle that referenced this issue Sep 5, 2024
…schema; and ensure that, when information exceeds 4k characters, data is still returned without error.

Issue MauroDataMapper-Plugins#19
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

No branches or pull requests

1 participant