mirror of
https://github.com/FirebirdSQL/firebird-qa.git
synced 2025-01-22 13:33:07 +01:00
38 lines
1.3 KiB
Python
38 lines
1.3 KiB
Python
#coding:utf-8
|
|
|
|
"""
|
|
ID: issue-4530
|
|
ISSUE: 4530
|
|
TITLE: ISQL -x does not output the START WITH clause of generators/sequences
|
|
DESCRIPTION:
|
|
JIRA: CORE-4205
|
|
FBTEST: bugs.core_4205
|
|
"""
|
|
|
|
import pytest
|
|
from firebird.qa import *
|
|
|
|
init_script = """
|
|
recreate sequence tmp_gen_42051 start with 9223372036854775807 increment by -2147483647;
|
|
recreate sequence tmp_gen_42052 start with -9223372036854775808 increment by 2147483647;
|
|
recreate sequence tmp_gen_42053 start with 9223372036854775807 increment by 2147483647;
|
|
recreate sequence tmp_gen_42054 start with -9223372036854775808 increment by -2147483647;
|
|
"""
|
|
|
|
db = db_factory(sql_dialect=3, init=init_script)
|
|
|
|
act = python_act('db', substitutions=[('^((?!(SQLSTATE|CREATE GENERATOR)).)*$', '')])
|
|
|
|
expected_stdout = """
|
|
CREATE GENERATOR TMP_GEN_42051 START WITH 9223372036854775807 INCREMENT -2147483647;
|
|
CREATE GENERATOR TMP_GEN_42052 START WITH -9223372036854775808 INCREMENT 2147483647;
|
|
CREATE GENERATOR TMP_GEN_42053 START WITH 9223372036854775807 INCREMENT 2147483647;
|
|
CREATE GENERATOR TMP_GEN_42054 START WITH -9223372036854775808 INCREMENT -2147483647;
|
|
"""
|
|
|
|
@pytest.mark.version('>=3.0')
|
|
def test_1(act: Action):
|
|
act.expected_stdout = expected_stdout
|
|
act.isql(switches=['-x'], combine_output = True)
|
|
assert act.clean_stdout == act.clean_expected_stdout
|