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.

Sign up for GitHub

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

Jump to bottom

Microsoft SQL Server: "COLLATE clause cannot be used on expressions containing a COLLATE clause" #9

Closed
eirikbakke opened this issue May 4, 2022 · 2 comments
Closed

Microsoft SQL Server: "COLLATE clause cannot be used on expressions containing a COLLATE clause" #9

eirikbakke opened this issue May 4, 2022 · 2 comments
Labels
bug Something isn't working Microsoft SQL Server
Milestone
1.2.0

Comments

@eirikbakke
Copy link
Contributor

eirikbakke commented May 4, 2022 •
edited
Loading

A user reported a warning "COLLATE clause cannot be used on expressions containing a COLLATE clause" while working with a visual query against a Microsoft SQL Server database.

This is due to Ultorg generating a SQL query of a form that is not supported by SQL Server. I'll have to fix this in Ultorg.
@eirikbakke eirikbakke changed the title SQL Server: "COLLATE clause cannot be used on expressions containing a COLLATE clause" Microsoft SQL Server: "COLLATE clause cannot be used on expressions containing a COLLATE clause" May 4, 2022
@eirikbakke eirikbakke added bug Something isn't working Microsoft SQL Server labels May 4, 2022
@eirikbakke
Copy link
Contributor Author

This bug was observed on Microsoft SQL Server 2012 and 2014, but not on Microsoft SQL Server 2017 or later. Will be fixed in the next Ultorg version.

@eirikbakke eirikbakke added this to the Ultorg 1.1.1 milestone Aug 21, 2022
@eirikbakke eirikbakke modified the milestones: Ultorg 1.1.1, 1.2.0 Sep 2, 2022
@eirikbakke
Copy link
Contributor Author

This issue is now fixed in Ultorg 1.2.0! Existing users can find the new version at their old download link.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working Microsoft SQL Server
Projects
None yet
Milestone
1.2.0
Development

No branches or pull requests
1 participant
@eirikbakke