View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001435 | Database Comparer utility | General | public | 2018-06-14 19:38 | 2019-04-18 19:46 |
| Reporter | shirokov | Assigned To | barry | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 7.0.0.1670 | ||||
| Target Version | 7.0.0.1670 | Fixed in Version | 7.0.0.1674 | ||
| Summary | 0001435: MS SQL Server CTE doesn't work | ||||
| Description | MS 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. | ||||
| Tags | No tags attached. | ||||
| 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 |
| 2019-04-18 19:46 | barry | Status | resolved => closed |
