|
7 | 7 | DESCRIPTION: |
8 | 8 | JIRA: CORE-3419 |
9 | 9 | FBTEST: bugs.core_3419 |
| 10 | +NOTES: |
| 11 | + [27.06.2025] pzotov |
| 12 | + Reimplemented: it is enought to check that first lines of error message appear, w/o name of trigger. |
| 13 | +
|
| 14 | + Checked on 6.0.0.876; 5.0.3.1668; 4.0.6.3214; 3.0.13.33813. |
10 | 15 | """ |
11 | 16 |
|
| 17 | +import locale |
12 | 18 | import pytest |
13 | 19 | from firebird.qa import * |
10000
14 | 20 |
|
15 | 21 | db = db_factory() |
16 | | - |
17 | 22 | test_script = """ |
18 | 23 | set autoddl off; |
19 | 24 | commit; |
20 | 25 | recreate table test(id int); |
21 | 26 | commit; |
22 | 27 | set term ^; |
23 | 28 | -- This trigger will fire 1001 times before exception raising: |
24 | | - create or alter trigger trg_trans_start |
| 29 | + create or alter trigger tx_trg |
25 | 30 | active on transaction start position 0 |
26 | 31 | as |
27 | 32 | begin |
|
34 | 39 | set transaction; |
35 | 40 | """ |
36 | 41 |
|
37 | | -act = isql_act('db', test_script, substitutions=[('line: [0-9]+, col: [0-9]+', 'line: , col: ')]) |
| 42 | +act = isql_act('db', substitutions=[('(-)?At trigger .*', '')]) |
38 | 43 |
|
39 | | -expected_stderr = """ |
| 44 | +expected_out = f""" |
40 | 45 | Statement failed, SQLSTATE = 54001 |
41 | 46 | Too many concurrent executions of the same request |
42 | | - -At trigger 'TRG_TRANS_START' line: 5, col: 9 |
43 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
44 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
45 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
46 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
47 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
48 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
49 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
50 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
51 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
52 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
53 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
54 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
55 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
56 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
57 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
58 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
59 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
60 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
61 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
62 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
63 | | - At trigger 'TRG_TRANS_START' line: 5, col: 9 |
64 | | - At trigger 'TRG_TRANS_START' ... |
65 | 47 | """ |
66 | 48 |
|
67 | | -@pytest.mark.version('>=3') |
68 | | -def test_1(act: Action): |
69 | | - act.expected_stderr = expected_stderr |
70 | | - act.execute(charset='utf8') |
71 | | - assert act.clean_stderr == act.clean_expected_stderr |
72 | | - |
| 49 | +@pytest.mark.version('>=3.0') |
| 50 | +def test_2(act: Action): |
| 51 | + act.expected_stdout = expected_out |
| 52 | + act.isql(switches=['-q'], input = test_script, combine_output = True) |
| 53 | + assert act.clean_stdout == act.clean_expected_stdout |
0 commit comments