View Issue Details

IDProjectCategoryView StatusLast Update
0001435Database Comparer utility[All Projects] Generalpublic2018-09-26 12:21
ReportershirokovAssigned Tobarry 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version[Database Comparer] 7.0.0.1670 
Target Version[Database Comparer] 7.0.0.1670Fixed in Version[Database Comparer] 7.0.0.1674 
Summary0001435: MS SQL Server CTE doesn't work
DescriptionMS SQL Server 2008 R2

There are the following problems when parsing the script:
1. ALTER ROLE ... ADD MEMBER
2. Multiple CTE in statement, see VehiclePmRead_CTE
3. ALTER TABLE ... ON DELETE SET NULL

See the provided scripts within the winfuel_cte.zip archive:
1. winfuel_cte_error.sql - the script that causes the errors;
2. winfuel_cte_success.sql - the same script after removing of the mentioned statements.

TagsNo tags attached.

Activities

shirokov

2018-06-14 19:38

administrator  

winfuel_cte.zip (75,505 bytes)

Issue History

Date Modified Username Field Change
2018-06-14 19:38 shirokov New Issue
2018-06-14 19:38 shirokov Status new => assigned
2018-06-14 19:38 shirokov Assigned To => barry
2018-06-14 19:38 shirokov File Added: winfuel_cte.zip
2018-09-26 12:21 barry Status assigned => resolved
2018-09-26 12:21 barry Resolution open => fixed
2018-09-26 12:21 barry Fixed in Version => 7.0.0.1674