View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001354 | Database Comparer VCL | General | public | 2018-04-17 20:53 | 2020-02-23 08:00 |
| Reporter | shirokov | Assigned To | barry | ||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 8.0.0.1913.Beta | ||||
| Summary | 0001354: MS SQL CTE SQL parse error when there is more that one CTE within the script | ||||
| Description | The error occurs: Missing: SELECT (<,>) Script: Line 5 pos 148 See the attached SchemaComplete.sql script. | ||||
| Steps To Reproduce | MSSQLDBExtract.DBStructure.Objs.MSSQLServerOptions.SQLServerVersion := st_MSSQL2008; MSSQLDBExtract.ExtractObjects := MSSQLDBExtract.ExtractObjects - [coRole]; if MSSQLDBExtract.ExtractDatabase then begin ------------------------------------- object MSSQLDBExtract: TMSSQLDBExtract DBCConnection = DBCConnectionUniDAC DBStructure = DBStructure Left = 384 Top = 56 end object DBStructure: TDBStructure Left = 280 Top = 80 end object DBCConnectionUniDAC: TDBCConnectionUniDAC Connection = WinfuelConnection.Connection Left = 208 Top = 56 end | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-04-17 20:53 | shirokov | New Issue | |
| 2018-04-17 20:53 | shirokov | Status | new => assigned |
| 2018-04-17 20:53 | shirokov | Assigned To | => barry |
| 2018-04-17 20:53 | shirokov | File Added: SchemaComplete.zip | |
| 2019-12-28 00:04 | barry | Status | assigned => resolved |
| 2019-12-28 00:04 | barry | Resolution | open => fixed |
| 2019-12-28 00:04 | barry | Fixed in Version | => 8.0.0.1913.Beta |
| 2020-02-23 08:00 | barry | Status | resolved => closed |
