View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000885 | Database Comparer VCL | General | public | 2015-11-09 12:37 | 2019-04-18 19:46 |
| Reporter | shirokov | Assigned To | barry | ||
| Priority | high | Severity | crash | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 6.2.0.1659 | ||||
| Summary | 0000885: Access violation when loading the update script to the TIBSQLExec component. | ||||
| Description | The script parsing causes the AV exception. The reason: the fData.Objs property is Nil (see the TIbParser.ParseFieldDesc method). The problem is reproduced when loading the "Skript.sql" (attached to this bugreport) and parsing the "Auftrags_StatusErmitteln" stored procedure. This procedure declares the "Erledigt" local variable of "d_DatumZeit" type. This domain type is not declared within the script. This script was produced by the Database Comparer demo (see DBComparer1.SQLExec.GetScript(MemoResult.Lines) in the "DBComparerDemoFib" project). Anyway, the script parsing should not raise AV. The standalone edition of the Database Comparer raises AV when loading this script as well. | ||||
| Steps To Reproduce | Place a new button on to the form in the DBComparerDemoFib demo project. procedure TForm1.Button1Click(Sender: TObject); begin IBSQLExec1.LoadFromFile('d:\Progects\DBComparer\Work\Skript.sql'); // end; | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
|
|
|
The update script is valid and successfully updates the Target DB. The "d_DatumZeit" domain should not be in the update script because it was not changed. So the error is in script loading and parsing. The problem is urgent because the user cannot update remote databases with saved script! |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-11-09 12:37 | shirokov | New Issue | |
| 2015-11-09 12:37 | shirokov | File Added: Skript.sql | |
| 2015-11-09 13:56 | shirokov | File Added: DBs.7z | |
| 2015-11-09 13:59 | shirokov | Note Added: 0002192 | |
| 2016-02-03 23:48 | barry | Status | new => resolved |
| 2016-02-03 23:48 | barry | Fixed in Version | => 6.2.0.1659 |
| 2016-02-03 23:48 | barry | Resolution | open => fixed |
| 2016-02-03 23:48 | barry | Assigned To | => barry |
| 2019-04-18 19:46 | barry | Status | resolved => closed |
