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
4ead2c2667 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_04.py: minor change: added comments 2023-11-26 00:58:16 +03:00
pavel-zotov
cb59e14caa Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_04.py: Writing code requires more care since 6.0.0.150: ISQL does not allow specifying duplicate delimiters without any statements between them (two semicolon, two carets etc). Merge expression defined in 'SQL_TO_BE_RESTARTED' must NOT end with semicolon 2023-11-26 00:56:49 +03:00
pavel-zotov
2778a39a9b Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_03.py: Writing code requires more care since 6.0.0.150: ISQL does not allow specifying duplicate delimiters without any statements between them (two semicolon, two carets etc). Merge expression defined in 'SQL_TO_BE_RESTARTED' must NOT end with semicolon 2023-11-26 00:55:15 +03:00
pavel-zotov
3e3a3dd666 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_02.py: Writing code requires more care since 6.0.0.150: ISQL does not allow specifying duplicate delimiters without any statements between them (two semicolon, two carets etc). Merge expression defined in 'SQL_TO_BE_RESTARTED' must NOT end with semicolon 2023-11-26 00:54:23 +03:00
pavel-zotov
02b4278725 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_01.py: Writing code requires more care since 6.0.0.150: ISQL does not allow specifying duplicate delimiters without any statements between them (two semicolon, two carets etc). Merge expression defined in 'SQL_TO_BE_RESTARTED' must NOT end with semicolon 2023-11-26 00:53:24 +03:00
pavel-zotov
5d853cd444 Added/Updated tests\functional\transactions\test_read_consist_sttm_merge_deny_multiple_matches.py: Writing code requires more care since 6.0.0.150: ISQL does not allow specifying duplicate delimiters without any statements between them (two semicolon, two carets etc). Merge expression defined in 'SQL_TO_BE_RESTARTED' must NOT end with semicolon 2023-11-26 00:49:51 +03:00
pavel-zotov
6b9b99b0f7 Same correction: writing code requires more care since 6.0.0.150: ISQL does not allow to specify THE SAME terminator twice 2023-11-26 00:42:52 +03:00
pavel-zotov
13a43748c4 Added/Updated tests\functional\tabloid\test_join_transformation_002.py: Writing code requires more care since 6.0.0.150: ISQL does not allow to specify THE SAME terminator twice 2023-11-26 00:40:02 +03:00
pavel-zotov
7395da09e2 Added/Updated tests\functional\tabloid\test_join_transformation_001.py: Writing code requires more care since 6.0.0.150: ISQL does not allow to specify THE SAME terminator twice 2023-11-26 00:39:14 +03:00
pavel-zotov
0d3d3f186c Added/Updated tests\functional\gtcs\test_time_zone.py: removed wrong start o multi-line comment that had no appropriate end. Adjusted expected_out to actual results. 2023-11-26 00:36:59 +03:00
pavel-zotov
e6fcd41311 Added/Updated tests\functional\gtcs\test_computed_fields_16.py: added substitutions in order to avoid dependency on line/column numbers 2023-11-26 00:26:16 +03:00
pavel-zotov
3c00e1998c Updated tests\functional\basic\isql\test_00.py: adjust expected stdout/stderr to current FB version. 2023-11-26 00:22:14 +03:00
pavel-zotov
be937b7214 Added/Updated tests\functional\basic\isql\test_autoterm_02.py: Checked on 6.0.0.139. Check ability to handle long DDL in one line without 'set term'. 2023-11-23 22:06:20 +03:00
pavel-zotov
26b89416bd Added/Updated tests\functional\basic\isql\test_autoterm_01.py: Checked on 6.0.0.139. Basic test. 2023-11-23 22:05:55 +03:00
pavel-zotov
e33c46eb86 Added/Updated tests\functional\tabloid\test_333be4bf.py: added user/password pair to gbak call 2023-11-19 13:11:23 +03:00
pavel-zotov
b0cf00c942 Added/Updated tests\functional\tabloid\test_333be4bf.py: Checked on 5.0.0.1271 (CS/SS), 6.0.0.132 (CS/SS) 2023-11-18 23:32:48 +03:00
pavel-zotov
c81e7f964e Added/Updated tests\functional\replication\test_invalid_msg_if_target_db_has_no_replica_flag.py: Refactored: make code to explain details if any error occurred. 2023-11-11 23:15:20 +03:00
pavel-zotov
50cee0ddcd Added/Updated tests\functional\tabloid\test_comment_in_object_names.py: added 'combine_output = True' to show the result when the test fails 2023-10-09 12:14:46 +03:00
pavel-zotov
0875bebc8c Added/Updated tests\functional\domain\create\test_31.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-09 11:11:23 +03:00
pavel-zotov
fa5337f1cf Added/Updated tests\functional\domain\create\test_28.py: Replaced TITLE according to essence: we have to check ability to specify NUMERIC index for domain sub_type. 2023-10-09 10:54:16 +03:00
pavel-zotov
6369ebc7d8 Added/Updated tests\functional\domain\create\test_27.py: Replaced TITLE according to essence: we have to check ability to specify NUMERIC index for domain sub_type. 2023-10-09 10:50:58 +03:00
pavel-zotov
932a2c5d5c Added/Updated tests\functional\domain\create\test_27.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-09 10:43:29 +03:00
pavel-zotov
ad6641ad8a Added/Updated tests\functional\view\create\test_10.py: Test not needed: there are lot tests which use this functionality. 2023-10-07 22:43:31 +03:00
pavel-zotov
5b6507ac3d Added/Updated tests\functional\table\create\test_03.py: added SKIP mark: this test will be fully re-implemented later. Currently SHOW TABLE command brokes it. 2023-10-07 22:42:00 +03:00
pavel-zotov
4c49623f34 Added/Updated tests\functional\table\create\test_02.py: added SKIP mark: this test will be fully re-implemented later. Currently SHOW TABLE command brokes it. 2023-10-07 22:41:02 +03:00
pavel-zotov
0f5d4eb1fb Added/Updated tests\functional\table\create\test_01.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 13:57:46 +03:00
pavel-zotov
9c7b98a00d Added/Updated tests\functional\table\alter\test_11.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 13:21:25 +03:00
pavel-zotov
efe86d26e8 Added/Updated tests\functional\table\alter\test_10.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 13:17:48 +03:00
pavel-zotov
66da0b53ad Added/Updated tests\functional\table\alter\test_07.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 13:12:57 +03:00
pavel-zotov
a4ea7d921d Added/Updated tests\functional\table\alter\test_06.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 13:07:44 +03:00
pavel-zotov
fe5d398207 Added/Updated tests\functional\table\alter\test_01.py: added forgotten sub-section title (NOTES) 2023-10-07 13:00:37 +03:00
pavel-zotov
0a28e27e90 Added/Updated tests\functional\table\alter\test_02.py: Changed datatype from text to integer (SHOW command output often changes for textual fields). 2023-10-07 12:59:32 +03:00
pavel-zotov
a98430a677 Added/Updated tests\functional\table\alter\test_01.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 12:52:34 +03:00
pavel-zotov
e33fe939cb Updated tests\functional\procedure\create\test_03.py: adjust expected stdout/stderr to current FB version. 2023-10-07 12:32:38 +03:00
pavel-zotov
0814c1ed92 Updated tests\functional\procedure\create\test_02.py: adjust expected stdout/stderr to current FB version. 2023-10-07 12:31:26 +03:00
pavel-zotov
5202752942 renamed the file so that the new name reflects the essence of the test. 2023-10-07 12:19:32 +03:00
pavel-zotov
c3c9c9762e Added/Updated tests\functional\gtcs\test_isql_show_command_collation.py: refactored: removed SHOW commands. It is enough to extract metadata and APPLY it to test DB. See notes. 2023-10-07 12:15:24 +03:00
pavel-zotov
c6e6ebe531 Added/Updated tests\functional\domain\create\test_40.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 11:45:56 +03:00
pavel-zotov
c2b58de0e6 Added/Updated tests\functional\domain\create\test_39.py: added SKIP mark. Test is covered by bugs/core_6336_test.py and some tests from domain/cretate/ which check text-based domains. 2023-10-07 11:32:06 +03:00
pavel-zotov
8bd09eeb13 Added/Updated tests\functional\domain\create\test_32.py: Fixed wrong datatype: need to check VARCHAR instead of BLOB. 2023-10-07 10:55:52 +03:00
pavel-zotov
c45ebd2333 Added/Updated tests\functional\domain\create\test_33.py: Fixed wrong datatype: need to check VARCHAR instead of BLOB. 2023-10-07 10:54:52 +03:00
pavel-zotov
c96c46364b Added/Updated tests\functional\domain\create\test_34.py: Fixed wrong datatype: need to check VARCHAR instead of BLOB. 2023-10-07 10:53:54 +03:00
pavel-zotov
820113048b Added/Updated tests\functional\domain\create\test_36.py: Fixed wrong datatype: need to check VARCHAR instead of BLOB. 2023-10-07 10:52:42 +03:00
pavel-zotov
9025e12972 Added/Updated tests\functional\domain\create\test_37.py: Fixed wrong datatype: need to check VARCHAR instead of BLOB. 2023-10-07 10:50:58 +03:00
pavel-zotov
2ebc5bf3fd Added/Updated tests\functional\domain\create\test_38.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 10:48:27 +03:00
pavel-zotov
ca3ea0decd Added/Updated tests\functional\domain\create\test_37.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 10:33:25 +03:00
pavel-zotov
995a2ce590 Added/Updated tests\functional\domain\create\test_36.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 02:56:16 +03:00
pavel-zotov
b57870beb4 Added/Updated tests\functional\domain\create\test_35.py: added SKIP mark: this test is covered by test_26.py and test_29.py 2023-10-07 02:08:24 +03:00
pavel-zotov
ae03b21af9 Added/Updated tests\functional\domain\create\test_34.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 02:07:06 +03:00
pavel-zotov
8937d25bff Added/Updated tests\functional\domain\create\test_33.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 02:04:16 +03:00
pavel-zotov
14471a3130 Added/Updated tests\functional\domain\create\test_32.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 02:02:07 +03:00
pavel-zotov
ce61a1c0fc Added/Updated tests\functional\domain\create\test_30.py: added SKIP mark: this test is covered by test_26.py and test_29.py 2023-10-07 01:48:28 +03:00
pavel-zotov
b61a2c0a0c Added/Updated tests\functional\domain\create\test_29.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 01:33:24 +03:00
pavel-zotov
f7db9a128f Added/Updated tests\functional\domain\create\test_26.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 01:23:25 +03:00
pavel-zotov
cdf44e6503 Added/Updated tests\functional\domain\create\test_19.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 01:06:01 +03:00
pavel-zotov
ee40e302f8 Added/Updated tests\functional\domain\create\test_18.py: minor change: added comment 2023-10-07 00:57:55 +03:00
pavel-zotov
d5adfa9ecc Added/Updated tests\functional\domain\create\test_18.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. Created view and stored function to obtain type name by rdb$fields.rdb$field_type and .rdb$field_sub_type. 2023-10-07 00:49:51 +03:00
pavel-zotov
46a65575be Added/Updated tests\functional\domain\create\test_17.py: Removed SHOW command for check result because its output often changes. See notes. 2023-10-06 16:04:29 +03:00
pavel-zotov
3c5cc4e31b Added/Updated tests\functional\domain\create\test_16.py: Removed SHOW command for check result because its output often changes. See notes. 2023-10-06 15:50:35 +03:00
pavel-zotov
b5078cdf48 Added/Updated tests\functional\domain\create\test_15.py: Removed SHOW command for check result because its output often changes. It is enough for this test to obtain similar data from RDB tables. 2023-10-06 14:19:20 +03:00
pavel-zotov
23acc4e983 Added/Updated tests\functional\procedure\create\test_15.py: Test not needed, see test_02.py and test_03.py. Added mark.skip(). 2023-09-30 11:35:57 +03:00
pavel-zotov
d27e02648e Added/Updated tests\functional\procedure\create\test_03.py: Added all supported data types that did appear since FB 4.x. Expected output differ in FB 3.x vs 4.x/5.x vs 6.x. Added splitting. 2023-09-30 11:32:36 +03:00
pavel-zotov
2f563be3e9 Added/Updated tests\functional\procedure\create\test_02.py: minor change: aded forgotten substitution 2023-09-30 11:20:34 +03:00
pavel-zotov
0e345c8698 Added/Updated tests\functional\procedure\create\test_02.py: Added all supported data types that did appear since FB 4.x. Expected output differ in FB 3.x vs 4.x/5.x vs 6.x. Added splitting. 2023-09-30 11:19:39 +03:00
pavel-zotov
4f0d7d88b5 Updated tests\functional\basic\isql\test_02.py: adjust expected stdout/stderr to current FB version. 2023-09-30 10:40:46 +03:00
pavel-zotov
89ac37919c Updated tests\functional\basic\isql\test_00.py: adjust expected stdout/stderr to current FB version. 2023-09-30 10:35:17 +03:00
pavel-zotov
78dc4bafd8 Added/Updated tests\functional\transactions\test_read_consist_sttm_merge_deny_multiple_matches.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-29 17:10:55 +03:00
pavel-zotov
57d84b449d Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_max_limit.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-27 11:25:58 +03:00
pavel-zotov
d1e428111d Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_03.py: restored substitutions which have been commented for debug 2023-09-26 13:12:04 +03:00
pavel-zotov
1acccdf888 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_02.py: restored substitutions which have been commented for debug 2023-09-26 12:59:48 +03:00
pavel-zotov
1d9a570c35 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_01.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-26 12:27:10 +03:00
pavel-zotov
4edaf5b7f8 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_delete_03.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-26 11:43:39 +03:00
pavel-zotov
d36db9712a Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_delete_02.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-26 11:28:59 +03:00
pavel-zotov
3ba2df6b63 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_delete_01.py: restored substitutions which have been commented for debug 2023-09-26 11:11:33 +03:00
pavel-zotov
2611ad109c Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_delete_01.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-26 11:09:59 +03:00
pavel-zotov
23f4b76a48 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_03.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-26 10:54:43 +03:00
pavel-zotov
9fb038aedf Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_02.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-26 01:55:14 +03:00
pavel-zotov
0b2f313971 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_01.py: restored substitutions which have been commented for debug 2023-09-25 22:30:24 +03:00
pavel-zotov
8dbe8d7b67 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_01.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-25 22:22:17 +03:00
pavel-zotov
fb18a3ea23 Adjusted info about minimal build numbers of FB 4.x and 5.x that can be used for these tests 2023-09-25 21:59:36 +03:00
pavel-zotov
96230acefb Added/Updated tests\functional\transactions\test_read_consist_statement_delete_undone_01.py: cleanup, added comments, adjust min_version to 4.0.3 because of using trace with watching for EXECUTE_STATEMENT_RESTART event that first appeared in 4.0.2.2807 2023-09-25 21:37:09 +03:00
pavel-zotov
f27e30a24a Added/Updated tests\functional\transactions\test_read_consist_statement_delete_undone_02.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-25 21:33:00 +03:00
pavel-zotov
b5282e080c Added/Updated tests\functional\transactions\test_read_consist_statement_delete_undone_01.py: restored substitutions which have been commented for debug 2023-09-25 21:03:29 +03:00
pavel-zotov
3bfca00d36 Added/Updated tests\functional\transactions\test_read_consist_statement_delete_undone_01.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-25 20:33:28 +03:00
pavel-zotov
44098cdfba Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_04.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-25 14:58:15 +03:00
pavel-zotov
d60709d08d Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_delete_04.py: removed unneded block 2023-09-25 14:23:15 +03:00
pavel-zotov
4066b05eaa Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_delete_04.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-25 14:22:20 +03:00
pavel-zotov
da9edd067d Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_04.py: one more re-implementing in order to prevent raises and get execution order predictable. See notes. 2023-09-25 02:18:42 +03:00
pavel-zotov
f7714da147 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_max_limit.py: added pytest.mark.skip tag 2023-09-24 17:09:36 +03:00
pavel-zotov
5c63d404db Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_01.py: removed pytest.mark.skip tag 2023-09-24 17:09:08 +03:00
pavel-zotov
dd89167945 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_max_limit.py: TEST MUST BE REIMPLEMENTED. Currently only replaced verification method of worker attachment presense (which tries DML and waits for resource). 2023-09-23 23:38:47 +03:00
pavel-zotov
a7af825275 Added/Updated tests\functional\transactions\test_read_consist_sttm_merge_deny_multiple_matches.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 22:59:37 +03:00
pavel-zotov
ac4ba3ba0c Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_04.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 22:55:50 +03:00
pavel-zotov
8df943a710 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_03.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 22:51:31 +03:00
pavel-zotov
a90f57e309 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_02.py: minor change: added forgotten call to func 'wait_for_attach_showup_in_monitoring()' 2023-09-23 22:50:18 +03:00
pavel-zotov
8a5a65cdb4 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_02.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 22:47:02 +03:00
pavel-zotov
50d446bb0c Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_01.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 22:43:26 +03:00
pavel-zotov
1bd26f85b4 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_04.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 22:36:26 +03:00
pavel-zotov
05f77f0d7f Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_03.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 22:32:30 +03:00
pavel-zotov
d826a44139 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_02.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 22:28:51 +03:00
pavel-zotov
ebd880b4a3 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_merge_01.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 22:24:00 +03:00
pavel-zotov
53a808b62a Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_delete_04.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 22:18:19 +03:00
pavel-zotov
fa14a01083 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_delete_03.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 22:11:37 +03:00
pavel-zotov
8619513297 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_delete_02.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 21:44:41 +03:00
pavel-zotov
ec97ce85b1 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_delete_01.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 21:39:41 +03:00
pavel-zotov
f5e419ccfa Added/Updated tests\functional\transactions\test_read_consist_statement_delete_undone_02.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 21:15:43 +03:00
pavel-zotov
184c0f0caa Added/Updated tests\functional\transactions\test_read_consist_statement_delete_undone_01.py: Replaced verification method of worker attachment presense (which tries DML and waits for resource). Loop with query to mon$statements is used instead. Maximal duration of this loop is limited - see notes. 2023-09-23 21:02:56 +03:00
pavel-zotov
2e7d814168 Added/Updated tests\functional\tabloid\test_8816d5c8.py: see notes 2023-09-13 11:23:20 +03:00
pavel-zotov
c50bfc4ed8 Updated tests\functional\tabloid\test_e260ced8.py: adjust expected stdout/stderr to current FB version. 2023-09-09 08:47:45 +03:00
pavel-zotov
7e3ddec61c Added/Updated tests\functional\tabloid\test_e260ced8.py: see notes 2023-09-08 12:40:11 +03:00
pavel-zotov
8f7d779d97 Added/Updated tests\functional\replication\test_oltp_emul_ddl.py: Added code for running test when no port is specified in the firebird-driver.conf and it has default (commented) value in the firebird.conf. Added check that port is actually listening. Replaced hard-coded SYSDBA/masterkey -- see notes. 2023-09-07 00:31:03 +03:00
pavel-zotov
9bbc395773 Added/Updated tests\functional\replication\test_oltp_emul_ddl.py: added more info when test fails: show diff between old and new replication.log. Added input arg 'cleanup_repl_dirs' to func reset_replication() in order to have ability to investigate segments when test fails. 2023-08-23 21:37:32 +03:00
pavel-zotov
e093f78c03 Added/Updated tests\functional\intfunc\encryption\test_sha3.py: Checked on 5.0.0.1163 2023-08-12 15:50:28 +03:00
pavel-zotov
cae18186f8 Added/Updated tests\functional\arno\optimizer\test_opt_full_join_04.py: Adjusted plan to actual for FB 5.x after letter from dimitr. 2023-08-01 02:02:56 +03:00
pavel-zotov
9bf25ac8e6 Added/Updated tests\functional\arno\optimizer\test_opt_left_join_11.py: excluded from execution under FB 5.x: no more sense in it for this FB version. Discussed with dimitr, letter 30.07.2023 2023-07-31 00:16:39 +03:00
pavel-zotov
451f4d9ef1 Added/Updated tests\functional\arno\optimizer\test_opt_left_join_07.py: excluded from execution under FB 5.x: no more sense in it for this FB version. Discussed with dimitr, letter 30.07.2023 2023-07-31 00:15:38 +03:00
pavel-zotov
f524c3d410 Added/Updated tests\functional\arno\optimizer\test_opt_left_join_06.py: excluded from execution under FB 5.x: no more sense in it for this FB version. Discussed with dimitr, letter 30.07.2023 2023-07-31 00:14:33 +03:00
pavel-zotov
c6705b92c1 Added/Updated tests\functional\arno\optimizer\test_opt_left_join_03.py: excluded from execution under FB 5.x: no more sense in it for this FB version. Discussed with dimitr, letter 30.07.2023 2023-07-31 00:13:09 +03:00
pavel-zotov
a1e3da0865 Added/Updated tests\functional\tabloid\test_crash_when_too_long_username_for_auth.py: see notes 2023-07-20 00:17:29 +03:00
pavel-zotov
5628999229 ENABLED execution of on Linux when ServerMode = Classic after letter from dimitr 13-JUL-2023 12:58. 2023-07-18 17:40:55 +03:00
pavel-zotov
5054542f21 Added/Updated tests\functional\basic\isql\test_02.py: adjusted output after commit that fixed #7475 2023-06-27 00:28:22 +03:00
pavel-zotov
878e1a2553 Added/Updated tests\functional\basic\isql\test_03.py: adjusted output after commit that fixed #7475 2023-06-27 00:26:04 +03:00
pavel-zotov
8796afbfac Added/Updated tests\functional\datatypes\test_int128_binary_operations.py: Adjusted output - see notes. 2023-06-20 09:30:03 +03:00
pavel-zotov
ea1febdeda Added/Updated tests\functional\replication\test_shutdown_during_applying_segments_leads_to_crash.py: Refactored, see notes. 2023-06-08 17:35:15 +03:00
pavel-zotov
0bab0127c1 Added/Updated tests\functional\datatypes\test_decfloat_exceptions_trapping.py: Adjusted expected-section after discuss with Alex. 2023-06-02 22:18:57 +03:00
pavel-zotov
8eb64cae2c Added/Updated tests\functional\replication\test_disallow_rdb_backup_history_replication.py: Checked on 4.0.3.2943 - both SS and CS. 2023-05-29 23:08:14 +03:00
pavel-zotov
2891ca222a Added/Updated tests\functional\replication\test_shutdown_during_applying_segments_leads_to_crash.py: increased max time for wait, only for THIS test. Otherwise it fails too often. 2023-05-22 18:08:01 +03:00
pavel-zotov
43944f044c Added/Updated tests\functional\basic\isql\test_05.py: minor corrections of test 'ID' tag 2023-05-13 18:57:47 +03:00
pavel-zotov
5f049e0b2e Added/Updated tests\functional\basic\isql\test_06.py: minor corrections of test 'ID' tag 2023-05-13 18:57:35 +03:00
pavel-zotov
f3103bf720 Added/Updated tests\functional\basic\isql\test_03.py: minor corrections of test 'ID' tag 2023-05-13 18:57:26 +03:00
pavel-zotov
e079282fdf Updated tests\functional\basic\isql\test_02.py: adjust expected stdout/stderr to current FB version. 2023-05-13 18:51:31 +03:00
pavel-zotov
d2b2d5a204 Added/Updated tests\functional\basic\isql\test_00.py: minor corrections of test 'ID' tag 2023-05-13 18:46:04 +03:00
pavel-zotov
6b83cfc9e1 Updated tests\functional\basic\isql\test_01.py: adjust expected stdout/stderr to current FB version. 2023-05-13 18:45:04 +03:00
pavel-zotov
96bb653557 Added/Updated tests\functional\trigger\table\test_alter_07.py: changed substitutions so that only relevant lines from full error text will be filtered and checked. 2023-05-11 11:15:19 +03:00
Anton Zuev
dc470155a7 Add substitutions to provide tests compatibility with different versions. 2023-05-03 15:56:21 +03:00
Anton Zuev
7a3ea7e442 Add tests tests/functional/trigger/table/test_alter lost when migrating from fbtest. Correct ID for test_alter_12.py and test_alter_13.py tests. 2023-05-03 12:38:31 +03:00
pavel-zotov
d39cd9ead4 Added/Updated tests\functional\replication\test_oltp_emul_ddl.py: Reimplemented. We have to query replica database for presense of data that we know there must appear. Replication log must NOT be scanned every N seconds for that task. 2023-04-22 10:55:16 +03:00
pavel-zotov
e25627a66f Added/Updated tests\functional\replication\test_generator_could_not_be_transferred_to_replica.py: minor correction (comments) 2023-04-21 06:31:39 +03:00
pavel-zotov
ea747328a4 Added/Updated tests\functional\basic\isql\test_08.py: added notes 2023-04-20 21:27:38 +03:00
pavel-zotov
4ac099fb64 Added/Updated tests\functional\basic\isql\test_08.py: Checked on 5.0.0.1022 (intermediate build) 2023-04-20 21:24:33 +03:00
pavel-zotov
418d515ac8 Added/Updated tests\functional\basic\isql\test_07.py: Checked on 4.0.3.2931 2023-04-20 07:34:30 +03:00
pavel-zotov
d6a9820b29 Added/Updated tests\functional\replication\test_some_updates_crash_server_on_replica_side.py: Reimplemented. We have to query replica database for presense of data that we know there must appear. Replication log must NOT be scanned every N seconds for that task. 2023-04-19 19:39:01 +03:00
pavel-zotov
21e793383b Added/Updated tests\functional\replication\test_shutdown_during_applying_segments_leads_to_crash.py: removed unneeded variable 2023-04-19 18:22:17 +03:00
pavel-zotov
2db9e37d33 Added/Updated tests\functional\replication\test_ddl_triggers_must_not_fire_on_replica.py: minor corr. 2023-04-18 18:20:17 +03:00
pavel-zotov
adbd0c0af2 Added/Updated tests\functional\replication\test_generator_could_not_be_transferred_to_replica.py: Reimplemented. We have to query replica database for presense of data that we know there must appear. Replication log must NOT be scanned every N seconds for that task. 2023-04-18 17:37:10 +03:00
pavel-zotov
41a4aac6f6 Added/Updated tests\functional\replication\test_failed_DDL_commands_can_be_replicated.py: Reimplemented. We have to query replica database for presense of data that we know there must appear. Replication log must NOT be scanned every N seconds for that task. 2023-04-18 14:26:44 +03:00
pavel-zotov
610ddcd2a5 Added/Updated tests\functional\replication\test_permission_error_on_ddl_issued_by_non_sysdba.py: removed old comments and add new ones. 2023-04-18 11:22:39 +03:00
pavel-zotov
ccb7a79e5a Added/Updated tests\functional\replication\test_duplicates_in_rw_replica_after_conflicting_insert.py: Reimplemented. We have to query replica database for presense of data that we know there must appear. Replication log must NOT be scanned every N seconds for that task. 2023-04-18 11:18:00 +03:00
pavel-zotov
0ff4bf84c4 Added/Updated tests\functional\replication\test_updating_blob_with_empty_string_stops_replication.py: Reimplemented. We have to query replica database for presense of data that we know there must appear. Replication log must NOT be scanned every N seconds for that task. 2023-04-18 10:10:06 +03:00
pavel-zotov
9ea26713a0 Added/Updated tests\functional\replication\test_shutdown_during_applying_segments_leads_to_crash.py: Reimplemented. We have to query replica database for presense of data that we know there must appear. Replication log must NOT be scanned every N seconds for that task. 2023-04-18 09:04:21 +03:00
pavel-zotov
313cb0b42d Added/Updated tests\functional\replication\test_permission_error_on_ddl_issued_by_non_sysdba.py: Reimplemented. We have to query replica database for presense of data that we know there must appear. Replication log must NOT be scanned every N seconds for that task. 2023-04-17 18:59:09 +03:00
pavel-zotov
ac4a58b2fb Added/Updated tests\functional\replication\test_blob_not_found_in_rw_replica_if_target_row_exists.py: minor change: added comments 2023-04-17 16:29:21 +03:00
pavel-zotov
e4e2ba2bec Added/Updated tests\functional\replication\test_blob_segments_longer_32kb_are_not_replicated.py: misc adjustings 2023-04-17 16:28:17 +03:00
pavel-zotov
981014306e Added/Updated tests\functional\replication\test_blob_not_found_in_rw_replica_if_target_row_exists.py: adjusted comments 2023-04-17 15:07:46 +03:00
pavel-zotov
b8a489b256 Added/Updated tests\functional\replication\test_blob_not_found_in_rw_replica_if_target_row_exists.py: Reimplemented. We have to query replica database for presense of data that we know there must appear. Replication log must NOT be scanned every N seconds for that task. 2023-04-17 14:46:33 +03:00
pavel-zotov
ae99cda2a6 Added/Updated tests\functional\replication\test_ddl_triggers_must_not_fire_on_replica.py: removed old comments. Aded note about unconditional changing FW to OFF. Adjustings. 2023-04-16 09:48:32 +03:00
pavel-zotov
e7cfc134a3 Added/Updated tests\functional\replication\test_ddl_triggers_must_not_fire_on_replica.py: Reimplemented. We have to query replica database for presense of data that we know there must appear. Replication log must NOT be scanned every N seconds for that task. 2023-04-16 00:56:11 +03:00
pavel-zotov
17665d2d1e Added/Updated tests\functional\replication\test_dblevel_triggers_must_not_fire_on_replica.py: Reimplemented. We have to query replica database for presense of data that we know there must appear. Replication log must NOT be scanned every N seconds for that task. 2023-04-15 10:48:52 +03:00
pavel-zotov
9e234779b2 Added/Updated tests\functional\replication\test_blob_segments_longer_32kb_are_not_replicated.py: minor change: removed unneeded import, replaced with existing feature of 'os' package 2023-04-15 08:40:20 +03:00
pavel-zotov
664684f7b5 Added/Updated tests\functional\replication\test_blob_segments_longer_32kb_are_not_replicated.py: fixed wrong varname 2023-04-15 08:24:29 +03:00
pavel-zotov
85a0d2028b Added/Updated tests\functional\replication\test_blob_segments_longer_32kb_are_not_replicated.py: Temporary DISABLED execution on Linux when ServerMode = Classic. Replication can unexpectedly stop with message 'Engine is shutdown' appears in replication.log. Sent report to dimitr, waiting for fix. 2023-04-14 15:54:42 +03:00
pavel-zotov
f3980f7673 Added/Updated tests\functional\replication\test_blob_segments_longer_32kb_are_not_replicated.py: Reimplemented. We have to query replica database for presense of data that we know there must appear. Replication log must NOT be scanned every N seconds for that task. 2023-04-14 00:16:56 +03:00
pavel-zotov
19b19eaced Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_01.py: TEMPORARY DISABLED. DISCUSSION WITH FB-TEAM REQUIRED 2023-03-19 01:44:14 +03:00
pavel-zotov
221c1b6a59 Added/Updated tests\functional\transactions\test_read_consist_sttm_restart_on_update_01.py: Make sure that ISQL process really established its attachment and started DML statement: see loop with 'found_worker_pid' 2023-03-18 18:00:13 +03:00
Anton Zuev
1ab319fbfa Add a test tests/functional/gtcs/test_cast_datatypes.py from fbtest. 2023-03-13 17:45:24 +03:00
pavel-zotov
0b548e5968 Added/Updated tests\functional\util\test_gbak_zip.py: Removed unused variable 2023-03-11 11:01:19 +03:00
Anton Zuev
091a25f6c8 Add tests for ALTER TRIGGER from fbtest. 2023-03-10 16:41:49 +03:00
Pavel Zotov
bc76b654c8
Merge pull request #10 from ant-zuev/add_test_trunc_function
Add a test for TRUNC function
2023-03-10 13:52:59 +03:00
pavel-zotov
48025dfd6e Added/Updated tests\functional\datatypes\test_miscelan_binding.py: minor change: backslash for regexp special characters must be specified twise in order to avoit warnings 2023-03-10 13:51:13 +03:00
Anton Zuev
116ab4a4b2 Add a test for TRUNC function. 2023-03-10 12:39:13 +03:00
Anton Zuev
9feb70a5b8 Add a test tests/functional/datatypes/test_miscelan_binding.py from fbtest. 2023-03-10 10:47:00 +03:00
Anton Zuev
1d6878f080 Add a test tests/functional/datatypes/test_int128_agregate_functions.py from fbtest 2023-03-10 10:47:00 +03:00
Anton Zuev
208855b192 Add a test tests/functional/datatypes/test_decfloat_ordering_rules.py from fbtest. 2023-03-10 10:47:00 +03:00
Anton Zuev
a463953ed9 Revert "Merge branch 'master' of github.com:ant-zuev/firebird-qa-ant"
This reverts commit 99a3aebc58, reversing
changes made to 7f14175f7a.
2023-03-10 10:46:19 +03:00
Anton Zuev
034b469851 Merge remote-tracking branch 'upstream/master' 2023-03-10 10:15:38 +03:00
pavel-zotov
16d07d6101 Added/Updated tests\functional\arno\optimizer\test_opt_multi_index_selection_06.py: -m Adjusted allowed versions: FB 3.x and 4.x issue same execution plan. Plan in FB 5.x differs. Version 5.x is not checked currently. Wait for resolution. 2023-03-09 14:10:06 +03:00
Anton Zuev
ec8a2227a3 Merge branch 'add_tests_optimizer' 2023-03-09 13:46:04 +03:00
Anton Zuev
99a3aebc58 Merge branch 'master' of github.com:ant-zuev/firebird-qa-ant 2023-03-09 13:45:37 +03:00
Anton Zuev
479e885476
Merge pull request #1 from ant-zuev/add_tests_derived_table
Add tests derived table
2023-03-09 13:42:37 +03:00
Pavel Zotov
bb2a02d75f
Merge pull request #8 from ant-zuev/add_tests_optimizer
Add tests for optimizer from fbtest.
2023-03-09 12:46:31 +03:00
Anton Zuev
68492ca2a0 Restrict a version of the test tests/functional/arno/optimizer/test_opt_multi_index_selection_06.py to 3.0. 2023-03-09 10:38:13 +03:00
Anton Zuev
07b7af8652 Add a test tests/functional/arno/optimizer/test_opt_single_index_selection_04.py from fbtest. 2023-03-09 10:25:37 +03:00
pavel-zotov
7d2a86717f Added tests that were missed after migration from FBT. Thanks to Anton Zuev. Checked on 3.0.11.33665, 4.0.3.2904, 5.0.0.970 2023-03-09 10:23:44 +03:00
Anton Zuev
841cdcb554 Add a test tests/functional/arno/optimizer/test_opt_multi_index_selection_06.py from fbtest. 2023-03-09 10:19:29 +03:00
Anton Zuev
c889f96846 Add a test tests/functional/arno/derived_tables/test_27.py from fbtest. 2023-03-09 09:41:36 +03:00
Anton Zuev
6f5894e085 Add a test tests/functional/arno/derived_tables/test_26.py from fbtest. 2023-03-09 09:41:25 +03:00
Anton Zuev
5191587217 Add a test tests/functional/arno/derived_tables/test_25.py from fbtest. 2023-03-09 09:29:55 +03:00
Anton Zuev
fe8a91ee0f Add a test tests/functional/arno/derived_tables/test_24.py from fbtest. 2023-03-09 09:29:45 +03:00
Anton Zuev
c3bb73e10a Add a test tests/functional/arno/derived_tables/test_23.py from fbtest. 2023-03-09 09:23:18 +03:00
pavel-zotov
67ff49b951 Added/Updated tests\functional\arno\optimizer\test_opt_full_join_03.py: Replaced WHERE-expr: added coalesce() after discussion with dimitr. Checked on 3.0.11.33665, 4.0.3.2904, 5.0.0.970 2023-03-07 17:19:59 +03:00
pavel-zotov
796854a2f6 Added/Updated tests\functional\arno\optimizer\test_opt_full_join_02.py: Replaced WHERE-expr: added coalesce() after discussion with dimitr. Checked on 3.0.11.33665, 4.0.3.2904, 5.0.0.970 2023-03-07 17:16:17 +03:00
pavel-zotov
20d7865c0f Added/Updated tests\functional\blob\test_rdb_blob_util_basic.py: elevated min_version to 5.0 because rdb$blob_util package does not exists in FB 4.x 2023-03-05 08:57:02 +03:00
pavel-zotov
97f7d166d8 Updated tests\functional\basic\isql\test_02.py: adjust expected stdout/stderr to current FB version. 2023-03-04 21:47:44 +03:00
pavel-zotov
b671a259ad Added/Updated tests\functional\tabloid\test_remote_access_to_security_db.py: DISABLED execution: see notes. 2023-03-04 01:48:28 +03:00
pavel-zotov
f10a91fa8a Added/Updated tests\functional\tabloid\test_dsqlrequests.py: Checked on 5.0.0.964, 4.0.3.2903, 3.0.11.33664. 2023-03-01 00:33:15 +03:00
pavel-zotov
a03ba1685b Added/Updated tests\functional\trigger\database\test_disconnect_06.py: Checked on 5.0.0.964 SS/CS. 2023-02-28 20:51:31 +03:00
pavel-zotov
d850b6ca9d Added/Updated tests\functional\trigger\database\test_disconnect_05.py: Checked on 5.0.0.467 (07-apr-2022), 5.0.0.964 SS/CS - all OK. 2023-02-28 19:51:19 +03:00
pavel-zotov
0251370389 Added/Updated tests\functional\trigger\database\test_disconnect_04.py: Checked on 5.0.0.961 2023-02-28 13:29:16 +03:00
pavel-zotov
97cd5e5b39 Added/Updated tests\functional\trigger\database\test_disconnect_02.py: elevated min_version, added combine_output = True 2023-02-28 12:35:30 +03:00
pavel-zotov
c3a4b71047 Added/Updated tests\functional\trigger\database\test_disconnect_03.py: Checked on 5.0.0.961 2023-02-28 12:34:15 +03:00