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

SQL Anywhere allows object identifiers containing blanks #4521

Open
2 tasks done
mkarg opened this issue Jul 21, 2023 · 0 comments · May be fixed by #4535
Open
2 tasks done

SQL Anywhere allows object identifiers containing blanks #4521

mkarg opened this issue Jul 21, 2023 · 0 comments · May be fixed by #4535

Comments

@mkarg
Copy link
Contributor

mkarg commented Jul 21, 2023

Search first

  • I searched and no similar issues were found

Description

SQL Anywhere distinguishes names with and without names as separate objects.

For example, it is pretty valid to have three table or columns (and possibly more object types) that are named E, E and E.

generateChangelog currently trims identifiers, leading to duplicate names in the changelog. As a result, update fails as the JDBC driver reports an exception due to duplication identifiers.`

Steps To Reproduce

CREATE TABLE T ("C", "C ", " C")
liquibase generateChangelog
liquibase update

Expected/Desired Behavior

generateChangelog shall not trim identifiers

Liquibase Version

master

Database Vendor & Version

SAP SQL Anywhere 17.0.11

Liquibase Integration

N/A

Liquibase Extensions

N/A

OS and/or Infrastructure Type/Provider

Windows 10 Pro (German)

Additional Context

N/A

Are you willing to submit a PR?

  • I'm willing to submit a PR (Thank you!)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: In Development PR Issues
2 participants