6
0
mirror of https://github.com/FirebirdSQL/firebird-qa.git synced 2025-01-22 13:33:07 +01:00
Commit Graph

509 Commits

Author SHA1 Message Date
pavel-zotov
eb99deb2ee Added/Updated tests\functional\tabloid\test_aae2ae32.py: Resultset of cursor that executes using instance of selectable PreparedStatement must be stored in some variable in order to have ability close it EXPLICITLY, before PS will be freed. Otherwise access violation can raises when Python runs garbage collection. 2025-01-18 14:46:39 +03:00
pavel-zotov
ef33e8f8a6 Added/Updated tests\functional\database\create\test_02.py: Added (temporary ?) 'credentials = False' to prevent ISQL from using '-USER ... -PASS ...'. IMO, this is bug; see https://github.com/FirebirdSQL/firebird/issues/8385 2025-01-13 14:44:35 +03:00
pavel-zotov
fab53758ab Added/Updated tests\functional\shadow\test_create_01.py: splitted expected output for 6.x since some columns in rdb$files now have NULLS instead of zeroes - see notes. 2024-12-30 12:05:43 +03:00
pavel-zotov
4af274b8e8 Added/Updated tests\functional\shadow\test_create_02.py: Added restriction for FB 6.x: this test now must be skipped since implemented GH-8047 (Wipe out multi-file database support) 2024-12-29 11:47:54 +03:00
pavel-zotov
baa278f259 Added/Updated tests\functional\database\alter\test_03.py: Added restriction for FB 6.x: this test now must be skipped, see commit f0740d2a: Wipe out multi-file database support 2024-12-29 11:34:00 +03:00
pavel-zotov
62a0c1f7fb Added/Updated tests\functional\database\alter\test_02.py: Added restriction for FB 6.x: this test now must be skipped, see commit f0740d2a: Wipe out multi-file database support 2024-12-29 11:33:51 +03:00
pavel-zotov
ff9db383f1 Added/Updated tests\functional\database\alter\test_01.py: Added restriction for FB 6.x: this test now must be skipped, see commit f0740d2a: Wipe out multi-file database support 2024-12-29 11:33:40 +03:00
pavel-zotov
4bd6685186 Added/Updated tests\functional\database\create\test_10.py: Added restriction for FB 6.x: this test now must be skipped, see commit f0740d2a: Wipe out multi-file database support 2024-12-29 10:59:58 +03:00
pavel-zotov
a4e9f3dc09 Added/Updated tests\functional\database\create\test_09.py: Added restriction for FB 6.x: this test now must be skipped, see commit f0740d2a: Wipe out multi-file database support 2024-12-29 10:59:46 +03:00
pavel-zotov
be4d4cb2e4 Added/Updated tests\functional\database\create\test_08.py: Added restriction for FB 6.x: this test now must be skipped, see commit f0740d2a: Wipe out multi-file database support 2024-12-29 10:59:32 +03:00
pavel-zotov
605ded6cf0 Added/Updated tests\functional\replication\test_grantor_not_changes_in_replica_if_owner_not_sysdba.py: added notes 2024-12-15 13:36:43 +03:00
pavel-zotov
7afd1647d0 Added/Updated tests\functional\replication\test_grantor_not_changes_in_replica_if_owner_not_sysdba.py: Checked on 6.0.0.552, 5.0.2.1569, 4.0.6.3170. 2024-12-15 01:20:30 +03:00
pavel-zotov
ea82a1e919 Added/Updated tests\functional\replication\test_make_async_reinit_reliable.py: removed limitation for verions: execution allowed since 4.0.6. Adjusted comments. 2024-12-10 18:35:52 +03:00
pavel-zotov
eaa2d07ef2 Added/Updated tests\functional\replication\test_make_async_reinit_reliable.py: Checked on Windows, 5.0.2.1569. Temporary marked as to be SKIPPED on 4.x and 6.x until back- and front-port will be done. 2024-12-10 18:00:07 +03:00
pavel-zotov
3225efe192 Added/Updated tests\functional\basic\isql\test_00.py: adjust output: added lines related to wire stat 2024-11-21 07:57:46 +03:00
pavel-zotov
9435ab18f4 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_03.py: added 'ROWS nn' after 'ORDER BY ...' clause, otherwise engine can choose 'PLAN SORT' which leads to materialization of cursor resultset and, in turn, to increased statement restart count. See notes. 2024-11-20 20:14:46 +03:00
pavel-zotov
4337828fb5 Added/Updated tests\functional\transactions\test_read_consist_statement_delete_undone_02.py: added 'ROWS nn' after 'ORDER BY ...' clause, otherwise engine can choose 'PLAN SORT' which leads to materialization of cursor resultset and, in turn, to increased statement restart count. See notes. 2024-11-20 20:14:32 +03:00
pavel-zotov
890ebd9201 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_01.py: added 'ROWS nn' after 'ORDER BY ...' clause, otherwise engine can choose 'PLAN SORT' which leads to materialization of cursor resultset and, in turn, to increased statement restart count. See notes. 2024-11-20 20:14:16 +03:00
pavel-zotov
50b088f0f6 Added/Updated tests\functional\tabloid\test_35f56933.py: Checked on 6.0.0.532 2024-11-18 13:13:17 +03:00
pavel-zotov
5709c6696c Added/Updated tests\functional\arno\optimizer\test_opt_sort_by_index_18.py: 'OPTIMIZE FOR FIRST ROWS' is used for 6.x - suggesed by dimitr, letter 16.11.2024 15:15. Checked on 6.0.0.532; 5.0.2.1567 2024-11-17 13:51:40 +03:00
pavel-zotov
aabe3479b7 Added/Updated tests\functional\arno\optimizer\test_opt_sort_by_index_18.py: re-implemented after #26e64e9c: Cost-based decision between ORDER and SORT plans (#8316). Checked on 6.0.0.532; 5.0.2.1567; 4.0.6.3168; 3.0.13.33794. 2024-11-17 12:55:43 +03:00
pavel-zotov
a438838b7c Adjusted expected output after check on 6.0.0.530. 2024-11-16 13:58:12 +03:00
pavel-zotov
b3bd8f7851 Updated tests\functional\basic\isql\test_autoterm_01.py: adjust expected stdout/stderr to current FB version. 2024-11-16 13:55:56 +03:00
pavel-zotov
ec113ab750 Updated tests\functional\basic\isql\test_00.py: adjust expected stdout/stderr to current FB version. 2024-11-16 13:54:46 +03:00
pavel-zotov
6ea1301610 Added/Updated tests\functional\intfunc\string\test_rpad_01.py: Finished adjusting for work both on Linux and Windows. Checked on 6.0.0.511 (Windows/Linux); 5.0.2.1550; 4.0.6.3165; 3.0.13.33794 2024-10-31 22:23:52 +03:00
pavel-zotov
e42745b7a4 Added/Updated tests\functional\intfunc\string\test_lpad_01.py: Finished adjusting for work both on Linux and Windows. Checked on 6.0.0.511 (Windows/Linux); 5.0.2.1550; 4.0.6.3165; 3.0.13.33794 2024-10-31 22:17:41 +03:00
pavel-zotov
920dd0fc36 Added/Updated tests\functional\arno\optimizer\test_opt_inner_join_05.py: changed comment about explained plan in 6.x 2024-10-31 15:48:16 +03:00
pavel-zotov
19c51597e5 Added pytest.mark.intl to have ability filtering these files if only QA-run related to non-ascii data is needed. 2024-10-31 11:28:06 +03:00
pavel-zotov
a8d5d389f7 Added/Updated tests\functional\arno\optimizer\test_opt_inner_join_05.py: Adjusted expected_out discuss with dimitr. Explained plans for 5.x and 6.x are now identical. Checked on 3.0.13.33794, 4.0.6.3165, 5.0.2.1551, 6.0.0.515 2024-10-31 11:19:40 +03:00
pavel-zotov
b57a88bd18 Added/Updated tests\functional\arno\optimizer\test_opt_inner_join_05.py: Splitted expected_out : added separate block for FB 5.x after discuss with dimitr. 2024-10-30 11:48:01 +03:00
pavel-zotov
44dd2cdb34 Added/Updated tests\functional\tabloid\test_aae2ae32.py: Checked on 5.0.2.1516-92316F0 -- all ok: two hash joins instead of subquery. 2024-09-26 10:47:01 +03:00
pavel-zotov
a60b8c72cb Added/Updated tests\functional\tabloid\test_cc183f59.py: Checked on 6.0.0.467. See notes about MERGE JOIN selecting. 2024-09-25 00:09:52 +03:00
pavel-zotov
9d34fda531 Added/Updated tests\functional\arno\optimizer\test_opt_inner_join_05.py: Changed substitutions: one need to suppress '(keys: N, total key length: M)' in FB 6.x after commit c50b0aa6 ('Add key info to the hash join plan output'). 2024-09-24 00:01:37 +03:00
pavel-zotov
140ba94f6c Added/Updated tests\functional\tabloid\test_883200d1.py: Checked on 6.0.0.457 - all OK. 2024-09-13 22:09:28 +03:00
pavel-zotov
fb31b6c739 Added/Updated tests\functional\intl\test_non_ascii_firebird_and_trace_utf8.py: Checked 6.0.0.450, 5.0.2.1493, 4.0.6.3142 (on Windows). 2024-09-04 20:06:13 +03:00
pavel-zotov
0f8d782ff4 Added/Updated tests\functional\tabloid\test_3b372197.py: Checked on 6.0.0.446, 5.0.2.1487 2024-09-02 00:47:33 +03:00
pavel-zotov
92df06e66d Added/Updated tests\functional\tabloid\test_657d86fe.py: Checked on 6.0.0.4444, 5.0.2.1487, 4.0.6.3142 2024-08-31 22:00:49 +03:00
pavel-zotov
980cf2950e Added/Updated tests\functional\tabloid\test_80fd0682.py: Checked on 4.0.0.2372. Checked on 6.0.0.423, 5.0.2.1477. 2024-08-12 14:47:01 +03:00
pavel-zotov
a363977696 Added/Updated tests\functional\tabloid\test_fd0fa8a3.py: Checked on Windows/Linux, 6.0.0.423, 5.0.2.1477, 4.0.6.3141. 2024-08-12 09:58:06 +03:00
pavel-zotov
bd5fe2c0df Added/Updated tests\functional\gtcs\test_ref_integ_inactive_pk_index_2.py: Splitted expected* text because system triggers now are created in C++/GDML code 2024-08-07 01:38:58 +03:00
pavel-zotov
47b81fc6f4 Added/Updated tests\functional\gtcs\test_ref_integ_inactive_pk_index.py: Splitted expected* text because system triggers now are created in C++/GDML code 2024-08-07 01:31:43 +03:00
pavel-zotov
fd73e3eaab Added/Updated tests\functional\gtcs\test_ref_integ_inactive_fk_index.py: Splitted expected* text because system triggers now are created in C++/GDML code 2024-08-07 01:29:17 +03:00
pavel-zotov
4ab82edc5a Added/Updated tests\functional\gtcs\test_ref_integ_drop_pk_index.py: Splitted expected* text because system triggers now are created in C++/GDML code 2024-08-07 01:26:18 +03:00
pavel-zotov
853f255dd3 Added/Updated tests\functional\gtcs\test_ref_integ_drop_pk_constraint.py: Splitted expected* text because system triggers now are created in C++/GDML code 2024-08-07 01:20:50 +03:00
pavel-zotov
157052b60f Added/Updated tests\functional\gtcs\test_ref_integ_drop_fk_index.py: Splitted expected* text because system triggers now are created in C++/GDML code 2024-08-07 01:17:37 +03:00
pavel-zotov
030a0e0946 Added/Updated tests\functional\index\alter\test_05.py: Splitted expected* text because system triggers now are created in C++/GDML code 2024-08-07 01:09:00 +03:00
pavel-zotov
55f51e5a3d Added/Updated tests\functional\index\alter\test_04.py: minor change: removed empty line 2024-08-07 01:08:47 +03:00
pavel-zotov
c9ff6c7cc9 Added/Updated tests\functional\index\alter\test_04.py: Splitted expected* text because system triggers now are created in C++/GDML code 2024-08-07 01:02:29 +03:00
pavel-zotov
e98d03db83 Added/Updated tests\functional\tabloid\test_6cfc9b5d.py: Checked on 6.0.0.396, 5.0.1.1440 (both SS/CS). See notes. 2024-07-21 00:01:46 +03:00
pavel-zotov
f5b7ac0ec1 Added/Updated tests\functional\tabloid\test_c8849946.py: Checked on 6.0.0.396, 5.0.1.1440. See notes. 2024-07-19 18:33:33 +03:00