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

tSQLt doesn't support contained databases #41

Open
unclefr3d0 opened this issue Feb 5, 2019 · 4 comments · May be fixed by #193
Open

tSQLt doesn't support contained databases #41

unclefr3d0 opened this issue Feb 5, 2019 · 4 comments · May be fixed by #193

Comments

@unclefr3d0
Copy link

tSQLt doesn't support contained/partially contained databases. A number of collation issues (due to the changed in system catalogs - the sys* tables) means that tSQLt cannot be installed if the database collation is not Latin1_General_100_CI_AS_KS_WS_SC.

Msg 468, Level 16, State 9, Procedure Private_GetCursorForRunNew, Line 10 Cannot resolve the collation conflict between "Latin1_General_100_CI_AS_KS_WS_SC" and "Latin1_General_CI_AS" in the equal to operation. Msg 451, Level 16, State 1, Procedure Private_ScriptIndex, Line 32 Cannot resolve collation conflict between "Latin1_General_CI_AS" and "Latin1_General_100_CI_AS_KS_WS_SC" in add operator occurring in SELECT statement column 6. Msg 451, Level 16, State 1, Procedure Private_GetForeignKeyDefinition, Line 17 Cannot resolve collation conflict between "Latin1_General_CI_AS" and "Latin1_General_100_CI_AS_KS_WS_SC" in add operator occurring in SELECT statement column 1. Msg 451, Level 16, State 1, Procedure Private_GetForeignKeyDefinition, Line 17 Cannot resolve collation conflict between "Latin1_General_CI_AS" and "Latin1_General_100_CI_AS_KS_WS_SC" in add operator occurring in SELECT statement column 2. Msg 451, Level 16, State 1, Procedure Private_GetDataTypeOrComputedColumnDefinition, Line 4 Cannot resolve collation conflict between "Latin1_General_100_CI_AS_KS_WS_SC" and "Latin1_General_CI_AS" in CASE operator occurring in SELECT statement column 2. Msg 208, Level 16, State 1, Procedure Private_GetUniqueConstraintDefinition, Line 47 Invalid object name 'tSQLt.Private_GetDataTypeOrComputedColumnDefinition'.

@mbt1
Copy link
Collaborator

mbt1 commented Jan 2, 2022

Thank you for reporting this. We'll prioritize it.

@nharris18
Copy link

Has this issue been investigated? We have run into the same problem and it's preventing us from using tSQLt.

@mvelzel
Copy link

mvelzel commented Mar 27, 2023

Any updates on this issue? We are also running into this problem and cannot use tSQLt because of this.

@asos-martinsmith
Copy link

Thank you for reporting this. We'll prioritize it.

@mbt1 I think this existing PR likely already resolves this issue (by adding COLLATE DATABASE_DEFAULT to places where the collations aren't guaranteed to be the same)

#51

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
5 participants