Issue Details (XML | Word | Printable)

Key: CORE-5272
Type: Bug Bug
Status: Open Open
Priority: Minor Minor
Assignee: Unassigned
Reporter: Pavel Zotov
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

COMMIT statement that was occasionally inserted after DROP DATABASE prevents ISQL from executing code that follows after this (useless) COMMIT.

Created: 12/Jun/16 06:04 PM   Updated: 12/Jun/16 06:04 PM
Component/s: ISQL
Affects Version/s: 2.5.5, 4.0 Initial, 3.0.0
Fix Version/s: None

QA Status: No test


 Description  « Hide
Run this script:
===
shell del c:\temp\tmp4test1.fdb 2>nul;
shell del c:\temp\tmp4test2.fdb 2>nul;
set bail on;
set list on;
set wng off;
--set echo on;

create database 'localhost:c:\temp\tmp4test1.fdb' user 'sysdba' password 'masterke';
select mon$database_name from mon$database;
commit;
drop database;

-- commit; ------------------ [ A ]

create database 'localhost:c:\temp\tmp4test2.fdb' user 'sysdba' password 'masterke';
select mon$database_name from mon$database;
commit;
drop database;
===

It's output will be:
===
MON$DATABASE_NAME C:\TEMP\TMP4TEST1.FDB

MON$DATABASE_NAME C:\TEMP\TMP4TEST2.FDB
===

Now UNCOMMENT statement 'COMMIT' that is marked as [ A ] and repeat script.
Output will be:
===
MON$DATABASE_NAME C:\TEMP\TMP4TEST1.FDB
===



 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.