firebird-qa/tests/bugs/core_3557_test.py

#coding:utf-8

"""
ID:          issue-3913
ISSUE:       3913
TITLE:       AV in engine when preparing query against dropping table
DESCRIPTION:
JIRA:        CORE-3557
FBTEST:      bugs.core_3557
"""

import pytest
from firebird.qa import *

db = db_factory()

test_script = """
    create table test (id int primary key);
    commit;

    -- RECONNECT IS MANDATORY HERE IN ORDER TO GET CRASH:
    -- ##################################################
    connect '$(DSN)' user 'SYSDBA' password 'masterkey';

    -- Confirmed for 2.5.0 only: server crashes on running the following EB. 26.02.2015
    -- All subsequent releases should produce no stdout & stderr.
    set term ^;
    execute block as
    begin
      execute statement 'drop table test';
      in autonomous transaction do
        execute statement ('insert into test values (1)');
    end ^
"""

act = isql_act('db', test_script)

@pytest.mark.version('>=3')
def test_1(act: Action):
    act.execute()