You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
COMMIT statement that was occasionally inserted after DROP DATABASE prevents ISQL from executing code that follows after this (useless) COMMIT. [CORE5272]
#5550
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
The text was updated successfully, but these errors were encountered:
Submitted by: @pavel-zotov
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
The text was updated successfully, but these errors were encountered: