01. Total results for each kind of outcome and server mode, for previous 30 runs
02. NEW CRASHES/BUGCHECKS: tests that caused FB abnormal termination for LAST run (0 rows)
[CURRENT] 03. NEW FAILS: tests which failed for LAST run (271 rows)
04. NEW ERRORS: tests which raised runtime error for LAST run (0 rows)
04. STILL FAILS: tests which fail for at least TWO LAST runs (958 rows)
05. NEW SLOWDOWN: tests with performance problem for LAST 5 runs (22 rows)
06. STILL SLOWDOWN: tests with performance problem for MORE THAN 5 last runs (50 rows)
07. Has fails: tests with at least one fail for previous 30 runs (1874 rows)
08. Has runtime errors: tests with at least one runtime error for previous 30 runs (4 rows)
09. Has crashes/bugchecks: tests that caused FB abnormal termination for previous 30 runs (0 rows)
10. NEW PASSED: successful tests for last run and outcome = FAIL/ERROR/SKIPPED or absent previously (76 rows)
11. All tests: outcomes for previous 30 runs (3633 rows)
12. Skipped: tests which was intentionally excluded from execution (78 rows)

Generated UTC 01.07.2025 03:20
Tested: FB60.   Build / date: 6.0.0.884-f7e5f554 / 2025.06.30;
Test machine: Linux 6.11.5-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.11.5-1 (2024-10-27); logical CPUs: 2; RAM: 7 Gb 
QA software: Python: 3.11.9; pytest: 7.4.4; firebird.driver: 1.10.9; firebird.Qa: 0.19.3 
Loading data. Please wait...

Jump to the list of unique test names from this report
Jump to the list with last developing commits information

Tests with result = "FAIL" for LAST run:

NN Test name mode
6.0.0.884
2025.06.30
6.0.0.881
2025.06.27
6.0.0.877
2025.06.26
6.0.0.876
2025.06.25
6.0.0.863
2025.06.24
6.0.0.858
2025.06.23
6.0.0.849
2025.06.20
6.0.0.848
2025.06.19
6.0.0.845
2025.06.18
6.0.0.843
2025.06.16
6.0.0.840
2025.06.14
6.0.0.838
2025.06.13
6.0.0.835
2025.06.12
6.0.0.834
2025.06.11
6.0.0.800
2025.06.10
6.0.0.799
2025.06.07
6.0.0.797
2025.06.06
6.0.0.795
2025.05.29
6.0.0.792
2025.05.28
6.0.0.791
2025.05.27
6.0.0.789
2025.05.21
6.0.0.787
2025.05.20
6.0.0.783
2025.05.12
6.0.0.779
2025.05.11
6.0.0.778
2025.05.07
6.0.0.776
2025.05.06
6.0.0.770
2025.05.05
6.0.0.767
2025.05.01
6.0.0.762
2025.04.30
6.0.0.755
2025.04.29
Test TITLE
1 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Index bug
2 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Index bug
3 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Blob comparison with constant
4 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Blob comparison with constant
5 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ORDER BY on a VIEW turns values in fields into NULL
6 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ORDER BY on a VIEW turns values in fields into NULL
7 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Grouping on derived fields processing NULL data kills IB
8 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Grouping on derived fields processing NULL data kills IB
9 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect handling of null within view - returns 0
10 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect handling of null within view - returns 0
11 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New value of column is accessable before update
12 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New value of column is accessable before update
13 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect results when left join on subquery with constant column
14 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect results when left join on subquery with constant column
15 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DISTINCT vs NULLS LAST clause: wrong order of NULLs
16 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DISTINCT vs NULLS LAST clause: wrong order of NULLs
17 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
18 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
19 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Estonian collation in UTF8 charset
20 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Estonian collation in UTF8 charset
21 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIKE doesn't work for computed values (at least in a view)
22 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIKE doesn't work for computed values (at least in a view)
23 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"CH" and "LL" are not separate spanish alphabet letters since 1994
24 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"CH" and "LL" are not separate spanish alphabet letters since 1994
25 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Long SQL statements break TCP/IP connection
26 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Long SQL statements break TCP/IP connection
27 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIST() function seems not work if used twice or more in a query
28 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
LIST() function seems not work if used twice or more in a query
29 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect column values with outer joins and views
30 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect column values with outer joins and views
31 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect column values with outer joins and derived tables
32 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect column values with outer joins and derived tables
33 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
34 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
35 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Joins with NULL RDB$DB_KEY crash the server
36 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Joins with NULL RDB$DB_KEY crash the server
37 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
French insensitive collation FR_FR_CI_AI
38 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
French insensitive collation FR_FR_CI_AI
39 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields
40 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields
41 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Collation not propagated between record formats
42 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Collation not propagated between record formats
43 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DATEADD wrong work with NULL arguments
44 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DATEADD wrong work with NULL arguments
45 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New builtin function DATEADD() implements wrong choice of keywords for expanded syntax
46 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
New builtin function DATEADD() implements wrong choice of keywords for expanded syntax
47 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
POSITION(string_exp1, string_exp2 [, start])
48 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
POSITION(string_exp1, string_exp2 [, start])
49 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
JOIN on first record of ordered derived table returns wrong record
50 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
JOIN on first record of ordered derived table returns wrong record
51 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ABS() rounds NUMERIC values
52 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ABS() rounds NUMERIC values
53 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
MERGE not correctly worked with parameters in MATCHING clause
54 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
MERGE not correctly worked with parameters in MATCHING clause
55 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV when recursive query used MERGE JOIN in execution plan
56 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV when recursive query used MERGE JOIN in execution plan
57 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Infinite row generation in "select gen_id(..) from rdb$database" with "group by"
58 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Infinite row generation in "select gen_id(..) from rdb$database" with "group by"
59 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Floor & ceiling functions give wrong results with exact numeric arguments
60 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Floor & ceiling functions give wrong results with exact numeric arguments
61 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong variable initialization in recursive procedures
62 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong variable initialization in recursive procedures
63 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT
64 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT
65 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Consistency check when subquery is ordered by aggregate function from other context
66 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Consistency check when subquery is ordered by aggregate function from other context
67 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DEFAULT values are unnecessary evaluated
68 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DEFAULT values are unnecessary evaluated
69 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support SQL 2008 syntax for MERGE statement with DELETE extension
70 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Support SQL 2008 syntax for MERGE statement with DELETE extension
71 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Null in the first record in a condition on rdb$db_key
72 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Null in the first record in a condition on rdb$db_key
73 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
update or insert with gen_id() with wrong generator value
74 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
update or insert with gen_id() with wrong generator value
75 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
76 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
77 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GROUP by and RDB$DB_KEY problems
78 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
GROUP by and RDB$DB_KEY problems
79 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parts of RDB$DB_KEY of views may be inverted when using outer joins
80 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parts of RDB$DB_KEY of views may be inverted when using outer joins
81 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Grouping by function doesn't work properly
82 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Grouping by function doesn't work properly
83 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Firebird float support does not conform to Interbase spec
84 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Firebird float support does not conform to Interbase spec
85 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV using recursive query as subquery in SELECT list and ORDER'ing by them
86 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
AV using recursive query as subquery in SELECT list and ORDER'ing by them
87 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Outer ORDER BY clause has no effect
88 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Outer ORDER BY clause has no effect
89 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong field position after ALTER POSITION
90 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong field position after ALTER POSITION
91 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them
92 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them
93 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"conversion error from string" after change of field type from BIGINT to VARCHAR(21)
94 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
"conversion error from string" after change of field type from BIGINT to VARCHAR(21)
95 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect LEFT JOIN result using table and derived constant subquery
96 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect LEFT JOIN result using table and derived constant subquery
97 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Lateral derived tables
98 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Lateral derived tables
99 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
100 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
101 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Window Function: frame (rows / range) clause
102 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Window Function: frame (rows / range) clause
103 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause
104 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause
105 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset
106 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset
107 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Server crashes while preparing a query with DISTINCT and ORDER BY
108 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Regression: Server crashes while preparing a query with DISTINCT and ORDER BY
109 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
In PSQL modules with declared cursors engine could assign value to the wrong variable
110 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
In PSQL modules with declared cursors engine could assign value to the wrong variable
111 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Regression: recursive query in SQL query returns incorrect results if more than one branch bypass
112 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Regression: recursive query in SQL query returns incorrect results if more than one branch bypass
113 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parametrized queries using RDB$DB_KEY do not work
114 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Parametrized queries using RDB$DB_KEY do not work
115 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong result of join when joined fields are created via row_number() function
116 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong result of join when joined fields are created via row_number() function
117 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Duplicate tags for CREATE/ALTER USER not handled correctly
118 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Duplicate tags for CREATE/ALTER USER not handled correctly
119 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block
120 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block
121 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ISQL pads blob columns wrongly when the column alias has more than 17 characters
122 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
ISQL pads blob columns wrongly when the column alias has more than 17 characters
123 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Provide ability to do: REcreate user <user_name> password <user_pwd>
124 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Provide ability to do: REcreate user <user_name> password <user_pwd>
125 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions
126 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions
127 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SEC$ tables and tag/attributes
128 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SEC$ tables and tag/attributes
129 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Window Function: named window
130 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Window Function: named window
131 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern)
132 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern)
133 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Reject non-constant date/time/timestamp literals
134 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Reject non-constant date/time/timestamp literals
135 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Date-time parsing is very weak
136 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Date-time parsing is very weak
137 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect query result when using named window
138 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Incorrect query result when using named window
139 SS F P P P P P P P P P F P P P P P P P P P F P P P P P P P P F
Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query()
140 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unexpected results after creating partial index
141 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unexpected results after creating partial index
142 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Simple derived table
143 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Simple derived table
144 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unnamed (no relation alias) derived table
145 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Unnamed (no relation alias) derived table
146 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Explicit column names for derived table
147 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Explicit column names for derived table
148 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Outer reference to upper scope-level is allowed
149 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Outer reference to upper scope-level is allowed
150 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Outer reference to upper scope-level is allowed
151 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Outer reference to upper scope-level is allowed
152 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Outer reference to upper scope-level is allowed
153 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Outer reference to upper scope-level is allowed
154 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
FIRST / SKIP inside derived table
155 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
FIRST / SKIP inside derived table
156 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UNION inside derived table
157 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UNION inside derived table
158 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Simple derived table with aggregate inside
159 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Simple derived table with aggregate inside
160 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Aggregate inside derived table
161 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Aggregate inside derived table
162 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Aggregate inside derived table
163 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Aggregate inside derived table
164 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sub-select inside derived table
165 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sub-select inside derived table
166 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sub-select inside derived table
167 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Sub-select inside derived table
168 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Implicit derived table by IN predicate
169 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Implicit derived table by IN predicate
170 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Derived table outer reference (triggers)
171 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Derived table outer reference (triggers)
172 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword.
173 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword.
174 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword.
175 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword.
176 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Non-Recursive CTEs
177 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Non-Recursive CTEs
178 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Recursive CTEs
179 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Recursive CTEs
180 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
MERGE statement
181 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
MERGE statement
182 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Check result or CAST() for misc agruments // from GTCS.
183 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Check result or CAST() for misc agruments // from GTCS.
184 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Computed fields
185 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Computed fields
186 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Verify result of INSERT DEFAULT VALUES into a table with domain fields when domains are defined with DEFAULT value.
187 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Verify result of INSERT DEFAULT VALUES into a table with domain fields when domains are defined with DEFAULT value.
188 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Verify result of INSERT DEFAULT for domain-based fields which have their own default values
189 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Verify result of INSERT DEFAULT for domain-based fields which have their own default values
190 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Verify result of INSERT DEFAULT for domain-based fields which are declared as NOT NULL and have their own default values
191 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Verify result of INSERT DEFAULT for domain-based fields which are declared as NOT NULL and have their own default values
192 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Verify result of ALTER DOMAIN SET/DROP DEFAULT when a table exists with field based on this domain
193 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Verify result of ALTER DOMAIN SET/DROP DEFAULT when a table exists with field based on this domain
194 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-11
195 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-11
196 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-15
197 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-15
198 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-16
199 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
gtcs-proc-isql-16
200 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Test for select from SP that deletes record after its output
201 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Test for select from SP that deletes record after its output
202 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern>
203 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern>
204 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CAST CHAR -> TIME
205 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CAST CHAR -> TIME
206 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CAST CHAR -> TIME
207 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CAST CHAR -> TIME
208 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CAST TIMESTAMP -> TIME
209 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CAST TIMESTAMP -> TIME
210 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
COUNT
211 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
COUNT
212 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DATEADD
213 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DATEADD
214 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DATEADD
215 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
DATEADD
216 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Dateadd milliseconds
217 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Dateadd milliseconds
218 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
EXTRACT(WEEK FROM DATE)
219 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
EXTRACT(WEEK FROM DATE)
220 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
TRUNC( <number> [, <number> ] )
221 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
TRUNC( <number> [, <number> ] )
222 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
POSITION( <string> IN <string> )
223 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
POSITION( <string> IN <string> )
224 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Test for TRUNC function
225 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Test for TRUNC function
226 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UNLIST function. Check output for different returning types
227 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
UNLIST function. Check output for different returning types
228 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login.
229 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login.
230 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P F P
External Connections Pool, functionality test 01
231 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
External Connections Pool, functionality test 01
232 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
233 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
234 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
235 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Common SQL. Check correctness of the results
236 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction)
237 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction)
238 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
239 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
240 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
241 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
242 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
243 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
244 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
245 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
246 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
247 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
248 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
249 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
250 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03.
251 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03.
252 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
253 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
254 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
255 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
256 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
257 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
258 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03.
259 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03.
260 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
261 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
262 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
263 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
264 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
265 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
266 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
267 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
268 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
269 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
270 CS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE VIEW
271 SS F P P P P P P P P P P P P P P P P P P P P P P P P P P P P P
CREATE VIEW

Elapsed time, milliseconds:

NN Test name mode median_ms
6.0.0.884
2025.06.30
6.0.0.881
2025.06.27
6.0.0.877
2025.06.26
6.0.0.876
2025.06.25
6.0.0.863
2025.06.24
6.0.0.858
2025.06.23
6.0.0.849
2025.06.20
6.0.0.848
2025.06.19
6.0.0.845
2025.06.18
6.0.0.843
2025.06.16
6.0.0.840
2025.06.14
6.0.0.838
2025.06.13
6.0.0.835
2025.06.12
6.0.0.834
2025.06.11
6.0.0.800
2025.06.10
6.0.0.799
2025.06.07
6.0.0.797
2025.06.06
6.0.0.795
2025.05.29
6.0.0.792
2025.05.28
6.0.0.791
2025.05.27
6.0.0.789
2025.05.21
6.0.0.787
2025.05.20
6.0.0.783
2025.05.12
6.0.0.779
2025.05.11
6.0.0.778
2025.05.07
6.0.0.776
2025.05.06
6.0.0.770
2025.05.05
6.0.0.767
2025.05.01
6.0.0.762
2025.04.30
6.0.0.755
2025.04.29
Test TITLE
1 CS 1664 2089 1853 1823 946 1618 1699 1542 1030 1318 1030 1028 1144 1020 998 1633 1875 1867 1887 1799 1824 1085 1752 1169 1670 1371 1711 1659 1828 1683 1896
Index bug
2 SS 766 936 676 724 811 783 851 699 809 748 861 762 725 860 861 724 770 800 751 848 747 754 654 798 714 806 637 683 781 748 786
Index bug
3 CS 1281 1237 902 811 1198 745 765 763 1303 787 779 1316 1298 752 746 1243 1293 1456 1442 1444 1529 1345 1253 908 1456 1344 1382 1475 1481 1269 1500
Blob comparison with constant
4 SS 521 503 521 537 531 472 544 496 598 529 630 472 540 503 514 498 468 521 530 601 513 505 540 530 552 579 518 560 502 457 484
Blob comparison with constant
5 CS 1066 609 795 608 1055 689 643 747 1158 636 571 1123 1159 597 1100 1178 1094 1171 1243 1204 1118 1142 1104 725 1057 1075 676 623 1180 1013 1193
ORDER BY on a VIEW turns values in fields into NULL
6 SS 450 484 469 425 485 413 464 432 408 478 475 410 443 386 472 472 457 459 403 490 499 409 412 429 496 436 474 372 442 418 457
ORDER BY on a VIEW turns values in fields into NULL
7 CS 1169 719 769 652 1133 681 733 808 1157 637 790 1198 1191 632 1216 1245 1219 1314 1170 1392 1278 1217 1199 744 1213 1168 1325 812 1241 681 1338
Grouping on derived fields processing NULL data kills IB
8 SS 516 410 524 509 516 531 517 498 501 568 518 478 457 442 514 442 561 478 546 539 512 527 537 533 572 503 528 574 560 476 510
Grouping on derived fields processing NULL data kills IB
9 CS 1295 812 1332 707 1289 1395 690 1308 726 708 839 779 760 1355 1352 1321 1388 1396 1428 1433 1460 1277 1301 843 1332 1325 794 755 1357 1285 903
Incorrect handling of null within view - returns 0
10 SS 532 555 500 482 512 513 568 551 509 534 536 450 601 515 563 486 515 529 494 537 585 553 500 566 484 562 562 544 522 530 574
Incorrect handling of null within view - returns 0
11 CS 1068 829 777 768 1207 1269 742 1366 765 757 741 841 779 776 1343 1333 1293 1374 1362 1334 1391 1445 1483 894 1329 1224 916 851 866 1189 947
New value of column is accessable before update
12 SS 544 536 515 528 672 544 560 566 562 591 610 506 565 537 595 576 490 545 560 572 525 548 508 542 540 573 531 523 505 543 554
New value of column is accessable before update
13 CS 1270 1353 1427 693 706 1305 729 1396 736 736 1264 783 754 1231 1277 1301 1154 1410 1341 1530 1308 1345 1532 867 1349 1377 1199 780 782 745 1502
Incorrect results when left join on subquery with constant column
14 SS 542 526 569 482 499 511 542 520 566 553 583 486 573 533 548 539 549 526 542 542 548 498 521 525 558 547 550 525 553 562 604
Incorrect results when left join on subquery with constant column
15 CS 1227 832 1285 731 812 1192 765 1189 736 811 1265 1044 1199 1255 1259 1297 1269 1285 1350 1382 1408 1383 1353 848 1361 1287 1173 851 903 767 1387
DISTINCT vs NULLS LAST clause: wrong order of NULLs
16 SS 539 500 546 455 477 547 544 550 532 548 582 556 539 515 550 487 509 523 525 531 550 539 548 538 575 561 568 534 554 522 496
DISTINCT vs NULLS LAST clause: wrong order of NULLs
17 CS 1240 850 1290 753 727 1330 989 1303 754 792 1301 776 744 1425 1302 1267 1211 1225 1315 1451 1897 1255 1280 833 1389 1408 1297 879 767 696 774
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
18 SS 529 483 513 517 571 527 592 575 511 544 558 480 530 522 528 513 536 503 555 565 562 550 536 542 544 516 524 510 508 545 471
Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones
19 CS 1139 1490 1389 703 698 1211 1249 1227 789 724 1009 934 659 1255 881 1376 1130 1318 1371 1269 2040 1148 1272 907 1366 1253 1098 958 764 736 676
Estonian collation in UTF8 charset
20 SS 541 877 545 496 492 495 564 534 540 521 555 553 542 519 476 538 519 539 518 638 546 579 552 576 523 553 558 491 446 563 603
Estonian collation in UTF8 charset
21 CS 1207 777 1350 765 813 1199 1098 1189 713 915 1215 1005 744 1230 1273 1307 1356 1223 1391 1321 1480 1420 1427 851 1392 1283 1323 915 778 773 813
LIKE doesn't work for computed values (at least in a view)
22 SS 538 501 516 520 498 518 557 608 542 525 582 516 552 549 514 544 537 529 532 528 599 492 522 538 570 577 562 549 552 585 538
LIKE doesn't work for computed values (at least in a view)
23 CS 1070 635 1047 1099 1054 1013 609 1000 564 1172 1093 711 1208 1102 1129 1185 1094 1132 1086 995 1178 1413 1133 788 1201 1199 664 952 1023 750 607
"CH" and "LL" are not separate spanish alphabet letters since 1994
24 SS 436 404 408 457 474 436 436 448 395 455 436 425 456 433 476 457 446 382 401 470 445 433 385 473 421 405 413 445 457 414 453
"CH" and "LL" are not separate spanish alphabet letters since 1994
25 CS 1143 716 1114 1167 1127 973 618 1189 1169 1232 1197 743 1199 1132 757 1130 1189 1252 1151 1249 1193 1164 1192 757 1160 1135 671 1133 1252 705 783
Long SQL statements break TCP/IP connection
26 SS 482 509 457 509 391 466 517 428 505 529 511 452 500 450 455 494 552 488 455 433 508 520 474 480 472 462 485 492 518 480 469
Long SQL statements break TCP/IP connection
27 CS 1269 783 1052 1291 1236 735 813 1357 1465 1479 1241 1024 744 1387 722 1334 1282 1516 1323 1376 1410 1321 1241 872 1338 1274 954 1292 1265 849 904
LIST() function seems not work if used twice or more in a query
28 SS 534 518 509 451 479 540 508 531 510 548 593 569 517 496 560 501 556 553 503 550 553 492 556 542 551 571 556 537 524 522 513
LIST() function seems not work if used twice or more in a query
29 CS 1308 812 856 1231 1283 733 1323 777 1420 1235 1334 1420 785 1223 729 1400 1351 1375 1388 1468 1352 1444 1407 940 1293 1343 784 1350 1333 801 866
Incorrect column values with outer joins and views
30 SS 544 476 590 477 542 523 580 528 560 553 572 530 540 578 603 534 545 553 494 575 544 574 501 497 539 559 587 542 566 539 562
Incorrect column values with outer joins and views
31 CS 1263 840 805 1287 1287 936 1214 764 1401 1262 1240 1295 776 1264 763 1413 1350 1451 1281 1420 1429 1381 1321 951 1195 1316 747 1477 1204 1156 826
Incorrect column values with outer joins and derived tables
32 SS 521 510 601 512 587 476 551 559 517 569 520 501 484 529 525 523 530 514 594 500 572 520 514 485 514 534 547 496 510 564 528
Incorrect column values with outer joins and derived tables
33 CS 1236 756 893 1147 1241 1318 731 691 1227 1331 1370 754 1497 787 741 1231 1361 1396 1412 1473 1350 1456 1312 854 1308 1254 825 750 1307 1200 872
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
34 SS 541 605 466 566 527 551 599 580 484 540 576 492 621 542 579 498 546 513 481 509 578 560 608 516 510 547 523 540 539 530 558
Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different
35 CS 1253 809 872 1304 1240 758 1223 1291 900 940 1234 1487 1367 783 798 1257 1506 1414 1372 1449 1396 1274 1249 943 1311 1344 995 776 905 1374 1291
Joins with NULL RDB$DB_KEY crash the server
36 SS 541 582 553 469 473 530 541 612 584 603 554 524 542 552 565 529 552 604 558 537 503 562 559 503 502 536 573 523 468 509 489
Joins with NULL RDB$DB_KEY crash the server
37 CS 1041 641 635 1038 990 690 1092 1146 669 601 1133 1351 1105 678 616 1152 1041 1343 1088 1191 1274 1251 1155 789 1042 1043 679 610 596 974 1065
French insensitive collation FR_FR_CI_AI
38 SS 453 399 394 468 448 429 445 510 460 511 474 442 465 438 437 482 477 478 386 455 407 427 482 451 489 449 414 470 430 474 482
French insensitive collation FR_FR_CI_AI
39 CS 1192 768 770 1310 1298 687 1322 1017 780 751 1183 1314 1202 778 757 1288 1359 1724 1486 1473 1346 1397 1384 980 1296 1250 868 863 816 1133 1143
Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields
40 SS 537 596 520 491 515 491 496 518 518 568 583 511 567 520 548 561 527 508 592 552 498 563 559 525 566 527 597 568 566 553 507
Incorrect result of recursive CTE query when recursive member's SELECT list contains expression using self-referenced fields
41 CS 1260 773 793 1245 1222 792 1344 1280 803 842 718 1375 1354 759 708 1336 1325 1392 1198 1598 1425 1377 1582 838 1461 1304 1361 801 828 847 1276
Collation not propagated between record formats
42 SS 553 574 527 461 553 485 509 600 512 608 553 553 609 496 530 508 553 552 577 560 575 595 566 530 524 522 562 498 580 573 557
Collation not propagated between record formats
43 CS 988 584 587 1037 1039 981 889 896 566 600 749 1070 1040 572 567 1105 1136 1149 1116 1114 1076 1076 1057 667 995 1117 1021 671 639 616 627
DATEADD wrong work with NULL arguments
44 SS 405 348 411 382 406 436 456 411 368 451 375 382 445 395 412 430 378 404 407 438 440 414 355 383 417 382 354 398 413 342 395
DATEADD wrong work with NULL arguments
45 CS 1009 543 619 938 980 977 1043 1116 592 606 695 1133 1111 574 593 1097 1132 1170 1134 1186 1099 1133 1050 697 1102 1039 1092 611 676 605 558
New builtin function DATEADD() implements wrong choice of keywords for expanded syntax
46 SS 398 363 407 389 435 413 410 399 362 426 407 438 438 462 436 394 376 380 392 404 426 398 361 393 433 330 383 383 371 392 418
New builtin function DATEADD() implements wrong choice of keywords for expanded syntax
47 CS 1023 601 654 543 1055 1000 1042 1038 575 648 588 1021 1035 567 652 1108 1035 1108 1134 1176 1141 1065 1063 691 1025 1240 1142 594 607 638 596
POSITION(string_exp1, string_exp2 [, start])
48 SS 395 390 376 331 426 402 392 370 398 403 439 400 372 382 410 378 392 369 388 407 428 417 389 341 396 400 427 401 417 395 373
POSITION(string_exp1, string_exp2 [, start])
49 CS 1102 739 764 708 1345 671 1246 1291 777 845 873 1326 1274 748 700 843 1283 1477 1319 1392 1349 1436 1326 884 1256 1291 1357 812 959 884 786
JOIN on first record of ordered derived table returns wrong record
50 SS 547 544 568 503 513 496 507 552 515 567 595 493 577 504 553 542 521 538 574 600 576 642 557 564 561 538 543 551 555 514 498
JOIN on first record of ordered derived table returns wrong record
51 CS 785 685 1091 1020 652 1129 561 635 1053 617 1092 570 582 1068 568 598 627 679 1014 600 1138 878 1063 670 553 1231 693 1111 1094 964 1111
ABS() rounds NUMERIC values
52 SS 402 387 421 385 352 383 382 405 439 384 417 384 410 385 455 461 377 376 494 404 433 401 388 392 404 399 427 392 434 425 436
ABS() rounds NUMERIC values
53 CS 1020 823 1104 1073 569 991 580 577 1049 757 1059 564 672 1053 561 702 614 1129 1079 654 699 641 1064 729 1111 1367 1168 1077 1056 1120 1129
MERGE not correctly worked with parameters in MATCHING clause
54 SS 430 411 493 394 414 393 359 443 449 472 525 415 409 551 432 429 462 410 431 485 425 456 435 353 461 404 408 455 419 394 460
MERGE not correctly worked with parameters in MATCHING clause
55 CS 1280 978 1377 1375 891 1268 806 785 1289 787 1394 804 779 1633 813 796 808 1396 1298 1553 1497 1004 1351 881 1460 1499 1272 1456 1522 1330 1120
AV when recursive query used MERGE JOIN in execution plan
56 SS 572 523 581 551 543 545 547 572 560 631 640 606 597 709 464 568 559 572 625 587 586 570 597 585 627 531 548 590 570 602 568
AV when recursive query used MERGE JOIN in execution plan
57 CS 1233 893 1379 1243 904 1248 799 744 1173 749 1267 916 735 1218 732 799 752 1223 1288 1348 1571 761 1299 841 1281 1339 1321 1479 1392 1282 1343
Infinite row generation in "select gen_id(..) from rdb$database" with "group by"
58 SS 526 486 574 483 524 475 545 520 491 537 562 527 493 586 565 511 532 485 534 479 538 567 565 553 502 471 503 503 555 525 544
Infinite row generation in "select gen_id(..) from rdb$database" with "group by"
59 CS 997 728 1131 948 569 940 548 576 561 634 995 827 565 1036 577 601 747 1100 1000 1207 1135 1054 1176 761 1078 1277 1048 1110 1136 1047 1101
Floor & ceiling functions give wrong results with exact numeric arguments
60 SS 397 339 396 348 412 375 357 395 437 406 400 331 412 413 376 346 357 426 423 454 425 423 356 427 317 391 436 399 386 386 406
Floor & ceiling functions give wrong results with exact numeric arguments
61 CS 1000 729 1048 1051 601 552 608 639 568 632 983 728 590 1104 611 638 613 647 1017 1332 1223 1042 1088 637 1111 1343 1078 1075 1260 1054 1144
Wrong variable initialization in recursive procedures
62 SS 433 388 435 392 433 396 417 397 369 433 468 361 508 476 435 433 449 446 422 451 479 476 422 440 420 393 445 430 393 458 454
Wrong variable initialization in recursive procedures
63 CS 1053 910 1272 774 704 814 700 811 783 785 1272 701 1139 1392 1129 786 795 1261 1426 881 1432 1352 830 873 1404 1381 1436 1423 1324 1336 978
Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT
64 SS 529 581 576 470 498 491 477 555 514 546 568 558 555 530 544 526 552 521 584 475 553 533 500 563 515 516 528 499 509 543 499
Error with EXECUTE PROCEDURE inside EXECUTE STATEMENT
65 CS 857 970 1236 747 789 844 808 842 804 845 1297 748 746 1057 1261 801 784 795 1315 845 1393 1347 849 866 1388 1398 1402 1383 1307 1330 842
Consistency check when subquery is ordered by aggregate function from other context
66 SS 525 605 532 501 460 522 514 559 523 576 523 509 592 564 552 510 473 527 561 520 557 547 520 567 521 521 556 519 546 580 513
Consistency check when subquery is ordered by aggregate function from other context
67 CS 818 870 732 785 759 787 672 784 791 744 1272 710 1383 757 1275 752 727 1312 808 1447 798 774 1290 857 1293 1101 1270 1490 829 1180 1397
DEFAULT values are unnecessary evaluated
68 SS 527 489 567 529 512 489 559 488 557 574 568 517 595 501 534 501 527 546 518 522 527 580 487 572 520 506 501 545 570 513 544
DEFAULT values are unnecessary evaluated
69 CS 723 667 659 608 693 679 1076 596 634 618 568 1064 1184 608 640 722 651 635 1098 725 913 689 1067 755 1163 1036 1147 1214 1221 1054 1200
Support SQL 2008 syntax for MERGE statement with DELETE extension
70 SS 453 401 526 481 399 483 400 434 462 465 398 477 492 451 474 466 471 432 470 484 422 476 433 455 473 442 449 405 441 416 429
Support SQL 2008 syntax for MERGE statement with DELETE extension
71 CS 979 897 1515 767 696 1082 1332 811 720 790 905 1355 1313 818 772 1322 798 752 798 802 1377 727 1459 873 1054 1466 1337 1332 1270 1298 1332
Null in the first record in a condition on rdb$db_key
72 SS 539 522 550 502 562 537 458 555 469 540 512 578 563 521 532 563 539 522 549 527 572 557 560 492 534 541 514 495 556 570 550
Null in the first record in a condition on rdb$db_key
73 CS 956 904 789 731 773 1209 1232 733 772 743 906 1346 1421 788 801 1418 738 922 966 789 1507 914 1353 948 965 1338 1555 1450 1449 1313 1362
update or insert with gen_id() with wrong generator value
74 SS 557 608 606 538 638 536 579 613 563 524 598 546 546 647 596 568 546 553 568 574 559 548 535 569 546 505 556 548 525 535 601
update or insert with gen_id() with wrong generator value
75 CS 904 853 753 783 787 931 1261 779 763 742 794 1294 1251 877 776 1265 933 821 784 832 1479 802 1315 868 1021 1288 1247 1414 1297 1295 1339
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
76 SS 537 468 589 478 517 505 500 544 573 516 522 491 559 563 499 538 554 545 558 486 538 503 520 559 565 527 554 512 536 595 583
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
77 CS 914 908 779 715 709 1315 1288 750 694 809 735 1338 1350 980 733 1227 782 764 817 829 1439 852 865 921 1493 1228 1330 1371 1404 1243 1290
GROUP by and RDB$DB_KEY problems
78 SS 528 540 529 489 504 527 517 544 537 534 524 540 576 522 535 563 547 498 515 528 519 539 531 545 549 529 510 488 476 470 528
GROUP by and RDB$DB_KEY problems
79 CS 1151 1009 1432 780 1324 1324 876 792 753 1304 744 1364 1351 825 847 1393 722 752 842 847 1380 803 970 886 1517 1311 1294 1381 1312 1446 1403
Parts of RDB$DB_KEY of views may be inverted when using outer joins
80 SS 550 548 615 532 506 535 570 549 570 550 590 561 502 514 538 495 555 599 568 516 575 590 568 502 561 529 555 510 550 489 585
Parts of RDB$DB_KEY of views may be inverted when using outer joins
81 CS 832 890 834 755 1220 712 802 788 781 1362 736 1324 798 1344 831 1181 1280 782 763 888 827 816 752 846 820 746 1378 1364 1290 1303 1251
Grouping by function doesn't work properly
82 SS 529 544 533 522 504 487 509 518 490 566 526 557 618 565 618 543 482 550 512 544 498 580 547 524 574 563 526 493 542 500 522
Grouping by function doesn't work properly
83 CS 877 856 747 718 1248 666 890 753 1260 1290 777 1265 1370 739 711 1031 1251 804 768 1143 741 766 865 788 734 1048 1367 1393 1491 1361 1476
Firebird float support does not conform to Interbase spec
84 SS 514 493 571 455 500 478 471 525 529 553 490 465 560 531 485 513 522 575 560 518 515 540 514 491 530 552 470 513 474 498 533
Firebird float support does not conform to Interbase spec
85 CS 899 618 1115 565 982 949 616 585 1092 601 1008 701 587 624 583 1009 1090 680 1337 1121 672 849 1160 700 549 689 1035 1144 1102 974 976
AV using recursive query as subquery in SELECT list and ORDER'ing by them
86 SS 409 443 440 372 333 359 362 434 369 430 452 431 413 375 349 424 424 411 367 438 435 410 388 398 377 399 447 409 401 402 423
AV using recursive query as subquery in SELECT list and ORDER'ing by them
87 CS 1262 1028 859 760 1475 1412 778 800 1474 938 1371 840 822 902 864 1508 1547 1675 1167 1216 1564 1204 1308 919 1440 872 1596 1440 1668 1392 1487
Outer ORDER BY clause has no effect
88 SS 676 699 697 577 579 592 603 698 536 750 723 690 676 703 649 651 710 676 633 698 664 717 677 670 677 723 626 625 683 628 622
Outer ORDER BY clause has no effect
89 CS 1259 851 1250 1236 755 1446 1469 850 1233 1583 1315 808 797 828 776 1520 1349 1384 1057 1268 1491 890 1188 883 1403 888 1425 1524 1420 1441 1519
Wrong field position after ALTER POSITION
90 SS 590 607 575 583 550 572 582 612 557 612 606 596 566 672 549 537 640 615 625 606 598 609 644 542 584 563 577 561 620 646 541
Wrong field position after ALTER POSITION
91 CS 1081 229984 624 982 639 672 580 1095 633 646 1205 667 1142 653 880 1136 1102 1074 1205 1212 801 1170 1206 705 948 1088 1204 1153 1204 1059 1101
rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them
92 SS 463 232930 427 413 397 347 372 459 495 470 463 463 526 528 448 417 426 505 432 497 492 508 472 448 498 428 458 394 501 463 473
rdb$set_context does NOT allow to overwrite any vars after encountering limit (default=1000) of them
93 CS 1248 932 824 780 735 768 697 1312 728 928 860 744 1377 768 766 1344 1283 1417 1315 1504 1383 763 1329 926 1292 1213 1373 1353 1346 1553 1350
"conversion error from string" after change of field type from BIGINT to VARCHAR(21)
94 SS 542 477 591 512 566 484 550 607 544 506 537 524 554 571 586 532 508 550 518 575 600 540 571 537 485 504 538 588 536 569 564
"conversion error from string" after change of field type from BIGINT to VARCHAR(21)
95 CS 1266 856 1361 736 1238 747 1206 745 1310 843 839 749 810 805 793 1272 1384 1368 1333 1378 1369 1349 1536 938 1308 1553 1260 1336 1310 1312 1248
Incorrect LEFT JOIN result using table and derived constant subquery
96 SS 544 473 544 436 513 533 474 563 537 560 572 533 542 536 600 555 496 504 550 537 545 581 557 557 598 512 546 507 566 566 549
Incorrect LEFT JOIN result using table and derived constant subquery
97 CS 2455 2422 1852 1686 1748 3102 1813 2507 1752 2377 2343 1625 3648 2376 2955 3199 2657 2884 3123 2773 2416 2972 2643 1892 2647 2488 1661 2999 1644 2248 2600
Lateral derived tables
98 SS 1748 2015 2085 1808 1536 1755 1628 1874 1934 1950 1914 1682 1932 2203 2041 1741 1698 1695 1864 1741 1682 1769 1644 1808 1665 1714 1738 1706 1779 1714 1498
Lateral derived tables
99 CS 1468 1061 924 1482 811 1277 831 1478 1012 875 1054 849 1699 1021 1127 1535 1501 1654 1537 1726 1733 1638 1531 1078 1624 1693 995 1570 1680 1458 919
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
100 SS 730 801 756 660 688 641 708 726 689 752 758 708 713 775 668 729 714 795 727 713 761 806 734 782 793 738 654 782 734 712 731
Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
101 CS 1323 1041 870 1318 784 1094 808 1343 1254 872 991 764 1450 979 1397 1457 1536 1449 1412 1616 1431 1435 1341 1071 1424 1433 957 1328 1406 834 828
Window Function: frame (rows / range) clause
102 SS 632 633 692 629 584 564 602 656 656 616 606 568 614 674 691 676 659 702 632 576 667 703 670 626 673 685 629 710 625 625 604
Window Function: frame (rows / range) clause
103 CS 1221 816 894 1251 1355 925 1239 1213 1229 756 912 697 788 872 759 1648 1477 1378 1260 1439 1455 1276 1396 954 1305 1345 863 732 767 829 1408
Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause
104 SS 561 524 563 499 520 491 517 594 560 564 582 576 564 601 511 539 553 596 598 642 595 598 584 538 563 549 521 523 571 536 506
Wrong data returned if a sub-query or a computed field refers to the base table in the ORDER BY clause
105 CS 947 742 633 587 634 760 1042 789 1089 1112 816 655 694 746 771 1088 1056 1037 1064 1203 1221 1358 1092 779 1091 1043 858 1086 1046 813 744
EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset
106 SS 424 430 439 440 377 404 425 468 443 487 450 400 422 464 421 434 423 394 401 422 472 498 445 400 384 419 356 483 387 424 436
EXECUTE BLOCK's TYPE OF parameters with NONE charset may have be transformed to the connection charset
107 CS 1097 938 743 727 729 940 1292 898 990 1384 916 785 861 878 871 1352 1279 1340 1301 1496 1452 1564 1278 969 1244 1288 1187 1416 1348 787 1007
Regression: Server crashes while preparing a query with DISTINCT and ORDER BY
108 SS 540 503 607 469 498 541 526 568 562 605 526 568 521 568 637 551 522 539 530 546 542 551 486 512 550 568 464 502 513 523 566
Regression: Server crashes while preparing a query with DISTINCT and ORDER BY
109 CS 1019 876 1107 764 726 850 757 883 751 1368 828 730 873 932 835 861 1269 1294 1215 1372 1375 1249 1353 919 1230 1315 859 1278 1335 1387 1363
In PSQL modules with declared cursors engine could assign value to the wrong variable
110 SS 539 549 582 580 493 448 538 570 514 555 522 488 548 546 572 541 504 558 525 535 545 612 525 511 534 563 525 509 523 542 556
In PSQL modules with declared cursors engine could assign value to the wrong variable
111 CS 984 710 983 1060 564 779 698 834 685 949 705 568 717 646 631 985 1118 1090 1186 1125 1136 1158 1049 700 1097 1096 1174 939 1048 1146 1036
Regression: recursive query in SQL query returns incorrect results if more than one branch bypass
112 SS 410 379 432 346 379 356 404 413 398 485 461 417 469 381 402 416 409 389 405 411 487 435 412 421 431 395 438 386 406 418 403
Regression: recursive query in SQL query returns incorrect results if more than one branch bypass
113 CS 1063 676 1073 1072 594 662 745 752 687 1100 666 564 752 770 728 1032 1088 1289 1116 1068 1180 1165 1059 675 1136 1207 701 1112 1072 1098 1185
Parametrized queries using RDB$DB_KEY do not work
114 SS 442 451 443 433 388 351 393 476 439 481 481 421 421 463 480 394 460 450 417 410 465 493 441 428 483 449 425 511 431 445 403
Parametrized queries using RDB$DB_KEY do not work
115 CS 1428 1080 1344 1338 942 976 962 1021 1130 1385 1022 864 1108 1052 1042 1477 1473 1723 1596 1676 1608 1508 1671 1076 1471 1527 1748 1631 1611 1590 1585
Wrong result of join when joined fields are created via row_number() function
116 SS 731 762 739 631 606 648 575 686 749 766 685 711 711 723 723 806 744 714 759 773 791 756 718 792 657 751 692 777 784 762 712
Wrong result of join when joined fields are created via row_number() function
117 CS 1858 1797 1866 2470 1665 1542 1971 1760 1883 1851 1744 1774 1720 1755 1803 1399 1910 1662 2625 1571 2813 2511 1539 1768 2487 2769 2675 3061 2787 2684 2399
Duplicate tags for CREATE/ALTER USER not handled correctly
118 SS 1042 988 1071 959 977 907 1026 1093 1079 1046 1046 1002 1146 1104 1032 1100 978 1041 1056 1047 1044 1043 984 908 1105 945 1007 1016 1041 1051 1137
Duplicate tags for CREATE/ALTER USER not handled correctly
119 CS 945 886 945 789 867 914 951 945 897 889 879 939 926 928 847 1007 1255 1308 1200 1419 1495 891 1272 952 778 1355 1572 1368 1559 728 1337
Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block
120 SS 574 554 524 499 523 515 581 535 580 593 669 582 561 592 557 608 584 566 584 596 615 568 604 488 588 549 557 527 544 584 619
Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block
121 CS 717 637 626 583 746 632 640 639 659 661 701 660 748 701 671 616 572 1172 1190 1192 789 1052 1117 734 1064 668 968 1209 1115 1033 868
ISQL pads blob columns wrongly when the column alias has more than 17 characters
122 SS 405 393 400 376 419 390 398 400 476 407 421 438 434 441 416 409 375 401 453 456 400 411 403 415 383 392 392 396 424 372 437
ISQL pads blob columns wrongly when the column alias has more than 17 characters
123 CS 1500 1475 1410 1424 1344 1298 1293 1367 1409 1459 1246 1494 1514 1402 1449 1173 1315 1735 2131 2096 1713 2011 2056 1506 1566 1960 2179 2016 2063 1850 2052
Provide ability to do: REcreate user <user_name> password <user_pwd>
124 SS 838 673 870 817 825 787 872 838 837 939 958 895 861 912 901 860 771 904 866 838 835 836 832 820 769 798 800 866 898 841 812
Provide ability to do: REcreate user <user_name> password <user_pwd>
125 CS 770 675 798 712 704 698 768 744 756 759 752 646 730 740 729 1148 680 886 1003 1109 648 874 1217 773 930 1106 1300 1153 1127 1136 1164
Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions
126 SS 456 481 445 475 441 394 373 455 442 468 483 497 471 441 479 462 433 451 496 433 496 533 488 456 514 415 396 457 473 412 444
Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions
127 CS 1027 809 891 805 812 840 879 789 919 870 879 831 956 924 862 1260 1139 1344 1114 1294 1299 1400 1251 896 1172 1385 1360 1356 1098 1372 1220
SEC$ tables and tag/attributes
128 SS 528 756 502 508 461 505 481 644 454 788 692 516 649 718 689 535 541 523 501 515 582 534 493 552 506 544 522 474 554 461 585
SEC$ tables and tag/attributes
129 CS 752 774 788 722 719 715 758 714 687 792 726 677 722 817 684 1176 1176 1108 1144 1153 1220 1176 1175 747 1204 1188 678 684 626 628 547
Window Function: named window
130 SS 490 428 676 404 513 387 531 475 580 632 676 700 703 593 597 447 475 489 499 492 473 525 532 428 473 419 459 478 428 469 500
Window Function: named window
131 CS 9580 9235 9922 8846 9090 9038 8638 9035 9029 9915 9326 9230 9813 10286 9395 10588 10905 11313 10496 10800 11875 11294 9972 9006 9765 11191 10388 6400 5997 6259 6205
Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern)
132 SS 6793 4699 8771 6765 7726 6146 8072 8679 8380 8588 4796 8606 8377 8560 8005 6597 6718 6811 7201 6759 6829 6790 6338 6039 7121 6797 6289 5688 5776 6217 6255
Add ability to backup/restore only those (several) tables which are enumerated as command line argument (pattern)
133 CS 827 706 670 627 741 606 640 636 651 723 651 615 659 713 676 1070 1100 913 1053 1209 1115 1018 1088 737 1027 1188 1096 1173 1149 1150 1092
Reject non-constant date/time/timestamp literals
134 SS 430 639 311 472 358 497 506 552 336 351 536 492 416 597 467 392 404 414 434 418 477 427 402 400 418 381 445 436 443 434 406
Reject non-constant date/time/timestamp literals
135 CS 718 685 676 653 634 664 655 659 662 716 668 710 721 702 654 1127 1117 1124 1159 1310 1113 1098 1172 712 1124 1008 686 1162 1036 1030 1032
Date-time parsing is very weak
136 SS 444 675 519 416 554 565 543 577 344 457 552 419 599 520 490 453 438 440 408 418 452 425 416 417 426 449 394 379 452 417 402
Date-time parsing is very weak
137 CS 684 673 686 636 729 718 668 618 678 770 683 636 696 721 688 639 995 1040 1111 666 665 655 630 710 1159 627 1223 1181 565 763 593
Incorrect query result when using named window
138 SS 449 336 514 361 524 559 593 578 599 545 585 575 597 609 636 456 417 444 441 403 447 450 444 412 448 423 410 412 410 410 459
Incorrect query result when using named window
139 SS 2820 2656 2917 2639 2805 2744 2704 2854 2734 2861 2862 2732 2904 2818 2771 2550 2591 2790 2799 2867 2761 3048 2886 2714 2843 2909 2822 2824 2870 2827 2936
Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query()
140 CS 700 738 758 632 762 683 635 681 660 595 715 705 687 590 704 1123 622 757 619 1251 730 628 603 696 1113 707 1193 1321 686 636 722
Unexpected results after creating partial index
141 SS 548 596 572 443 581 512 389 621 631 597 348 483 651 512 402 454 581 634 556 1029 471 557 657 513 541 353 380 664 591 509 408
Unexpected results after creating partial index
142 CS 839 907 869 783 834 832 827 833 818 805 868 844 825 867 895 1342 709 818 1332 887 1371 1313 1439 831 1350 808 803 1163 1340 766 811
Simple derived table
143 SS 639 740 475 662 548 408 718 534 454 657 635 545 453 712 634 692 431 732 611 532 643 784 588 546 745 502 728 668 772 678 742
Simple derived table
144 CS 854 894 854 918 792 960 831 853 818 905 851 861 908 846 855 1293 712 797 1417 899 1421 1384 1363 950 791 772 848 780 1406 792 768
Unnamed (no relation alias) derived table
145 SS 584 700 516 673 685 427 565 494 426 554 552 539 424 790 654 584 419 843 687 632 864 545 636 584 555 679 641 786 684 584 571
Unnamed (no relation alias) derived table
146 CS 848 977 902 824 841 816 849 913 819 841 787 808 851 856 905 1297 772 780 1466 963 1317 1284 1383 874 808 847 721 805 1345 819 770
Explicit column names for derived table
147 SS 627 703 455 623 613 526 669 516 455 607 527 572 435 526 677 767 457 724 773 538 781 684 784 562 740 620 766 644 631 740 713
Explicit column names for derived table
148 CS 866 828 890 869 793 836 845 924 844 785 863 878 850 906 851 1345 728 751 1316 1433 1271 1389 1371 929 735 1605 1438 811 1280 845 737
Outer reference to upper scope-level is allowed
149 SS 681 784 450 528 695 745 396 494 418 435 733 713 531 837 629 593 589 753 741 575 857 533 751 573 731 776 679 684 687 724 674
Outer reference to upper scope-level is allowed
150 CS 846 818 873 801 842 768 810 851 813 830 837 858 895 827 820 736 796 853 1327 1371 1280 1442 1352 892 788 1321 1250 823 1304 859 768
Outer reference to upper scope-level is allowed
151 SS 669 900 478 726 709 664 419 517 448 451 543 740 483 726 513 720 524 695 767 722 675 748 729 549 631 698 543 780 625 656 779
Outer reference to upper scope-level is allowed
152 CS 872 814 920 840 834 877 867 897 781 821 859 856 824 924 819 756 753 899 1360 1420 1352 1374 1321 913 856 1345 1355 1400 1408 735 700
Outer reference to upper scope-level is allowed
153 SS 616 733 505 542 596 523 418 459 419 513 576 672 471 883 439 789 719 699 633 727 654 685 617 562 660 616 726 683 609 705 581
Outer reference to upper scope-level is allowed
154 CS 885 876 873 852 771 806 894 798 880 889 796 866 881 897 826 1332 727 799 982 1340 1356 1295 1304 945 1263 1480 1388 1327 1528 841 770
FIRST / SKIP inside derived table
155 SS 652 759 467 632 502 617 538 533 413 442 672 708 463 731 430 722 686 577 540 831 867 769 682 562 697 570 739 712 696 633 685
FIRST / SKIP inside derived table
156 CS 869 900 893 788 834 865 854 814 837 803 862 859 874 819 873 1213 741 737 774 1385 1412 1265 1451 924 1265 1399 1469 1380 1608 809 786
UNION inside derived table
157 SS 644 578 468 604 698 702 580 464 417 607 624 648 508 640 435 756 702 775 720 798 703 553 724 583 683 769 555 589 665 716 678
UNION inside derived table
158 CS 871 879 898 838 816 916 834 853 844 833 811 818 863 860 794 1084 711 923 807 1299 1282 1302 1421 944 1433 1417 1548 1167 1403 786 807
Simple derived table with aggregate inside
159 SS 657 760 660 704 689 584 543 486 434 453 712 737 457 636 436 587 756 788 580 739 574 654 769 568 680 528 702 551 700 740 754
Simple derived table with aggregate inside
160 CS 868 842 867 780 835 804 851 816 811 887 900 908 846 872 853 1300 770 844 726 1364 1518 1326 1416 869 1498 1344 1408 814 1356 976 770
Aggregate inside derived table
161 SS 665 724 497 638 711 678 432 458 444 645 501 706 453 777 484 546 689 627 712 551 787 801 759 580 862 651 733 720 653 732 703
Aggregate inside derived table
162 CS 861 827 875 880 848 795 847 852 792 859 838 860 854 880 883 1279 850 760 791 1016 1448 1267 1310 946 1355 1316 1308 863 1559 812 836
Aggregate inside derived table
163 SS 634 591 473 706 669 606 440 488 449 450 612 473 477 779 562 690 723 759 840 773 560 832 679 652 617 728 726 692 515 567 688
Aggregate inside derived table
164 CS 879 871 880 898 823 851 825 851 834 973 878 854 808 819 813 1333 1044 784 797 1147 1455 1378 1434 1007 1471 1458 1257 1054 1357 815 847
Sub-select inside derived table
165 SS 638 625 438 660 763 680 413 525 432 470 517 437 441 723 450 767 645 663 732 632 762 740 765 577 688 661 653 569 544 559 721
Sub-select inside derived table
166 CS 872 892 873 773 869 717 854 789 829 822 832 871 882 844 792 1292 1216 834 781 1328 1369 1295 1432 956 1259 1222 1246 1271 1517 791 783
Sub-select inside derived table
167 SS 650 611 434 695 599 719 448 486 435 481 538 451 451 697 424 739 439 814 641 524 756 659 773 558 713 792 720 749 760 678 712
Sub-select inside derived table
168 CS 877 879 908 803 777 825 885 838 868 846 816 845 846 876 823 1069 1384 720 774 1373 1371 1332 1340 996 1355 1293 1032 1159 1282 803 767
Implicit derived table by IN predicate
169 SS 631 738 431 717 757 507 440 468 449 452 590 718 441 741 430 666 391 735 624 744 687 708 770 563 725 667 900 543 592 588 639
Implicit derived table by IN predicate
170 CS 870 892 858 829 854 833 902 846 883 915 882 839 841 855 845 764 1204 792 810 957 1419 1353 1372 926 1346 1387 1296 786 1357 773 847
Derived table outer reference (triggers)
171 SS 646 754 447 668 647 614 442 455 438 480 570 694 492 712 474 617 444 814 723 768 652 861 645 599 746 741 771 588 697 559 732
Derived table outer reference (triggers)
172 CS 727 737 835 729 687 711 653 736 560 682 708 649 743 761 712 729 762 1022 604 1141 726 742 635 767 1043 728 644 1187 714 725 675
Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword.
173 SS 563 571 335 343 584 427 475 652 606 555 695 388 665 554 571 574 621 653 711 734 663 700 356 447 552 318 498 577 326 534 306
Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword.
174 CS 693 709 751 637 638 705 730 683 648 703 761 676 663 728 672 643 619 576 570 853 672 613 599 800 1037 711 1160 1127 1148 588 1036
Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword.
175 SS 474 616 527 307 492 491 478 639 422 601 470 341 580 416 480 550 320 578 585 334 694 482 358 466 532 311 334 362 449 308 427
Test ability for DECFLOAT values to be represented as other data types using LEGACY keyword.
176 CS 854 824 869 835 854 792 890 885 829 865 829 911 870 850 903 749 869 763 771 842 847 821 782 961 1355 855 1348 1321 1081 824 1428
Non-Recursive CTEs
177 SS 640 710 727 502 632 439 571 808 761 655 536 437 668 694 716 711 438 726 749 465 848 651 649 542 684 472 529 565 603 437 561
Non-Recursive CTEs
178 CS 868 860 850 990 876 874 848 867 865 738 906 807 845 910 883 690 874 816 788 870 982 773 733 967 1240 848 1479 1540 835 1419 1472
Recursive CTEs
179 SS 622 749 662 449 584 574 493 735 815 760 807 493 737 710 640 628 414 642 753 521 766 684 862 601 617 414 598 513 548 424 524
Recursive CTEs
180 CS 861 826 924 822 839 805 806 883 769 914 921 913 883 836 879 720 838 757 757 1363 879 780 835 890 1337 879 1377 1493 843 783 1388
MERGE statement
181 SS 634 437 738 400 556 468 576 655 745 857 734 631 745 746 782 539 637 772 660 816 812 763 819 571 559 425 396 539 566 443 539
MERGE statement
182 CS 6101 5579 6132 5134 5599 5688 5121 5728 5749 5412 5686 5747 6106 5593 5456 7948 6074 6096 8423 9547 6996 5684 10128 6758 7141 6725 8374 7787 8660 9436 6694
Check result or CAST() for misc agruments // from GTCS.
183 SS 7604 7655 6776 5890 7328 6720 8728 5721 6955 7529 7779 6140 7288 7671 8788 8715 8316 7364 8683 7809 8272 8344 9228 5917 8881 8140 8904 7554 6436 7064 6051
Check result or CAST() for misc agruments // from GTCS.
184 CS 795 748 839 743 841 813 769 778 694 720 728 847 846 719 712 1240 836 657 1152 710 945 1394 1213 906 1185 689 757 753 1220 1302 628
Computed fields
185 SS 636 678 456 656 616 697 724 688 656 717 890 614 789 745 669 432 700 772 472 555 753 550 449 581 717 454 591 397 415 471 358
Computed fields
186 CS 886 803 847 859 815 730 774 775 901 892 885 769 854 786 710 1279 835 888 1302 1033 1252 1392 1264 924 1241 784 1246 1439 1341 1257 660
Verify result of INSERT DEFAULT VALUES into a table with domain fields when domains are defined with DEFAULT value.
187 SS 699 778 458 666 729 731 592 519 501 736 769 771 831 741 669 509 747 787 393 791 831 797 809 565 393 754 391 651 464 483 410
Verify result of INSERT DEFAULT VALUES into a table with domain fields when domains are defined with DEFAULT value.
188 CS 785 704 736 773 676 756 682 742 727 715 847 788 779 760 739 1189 783 850 1266 1068 1129 1255 1124 873 1130 782 1353 1304 1305 1103 618
Verify result of INSERT DEFAULT for domain-based fields which have their own default values
189 SS 619 652 384 477 754 455 690 738 659 661 435 709 763 517 575 802 744 648 388 830 441 709 860 511 382 656 402 590 331 451 369
Verify result of INSERT DEFAULT for domain-based fields which have their own default values
190 CS 842 766 907 782 725 645 802 725 741 827 718 864 796 835 741 1158 842 843 1144 1179 1307 1288 1283 863 918 746 1156 957 1182 1293 661
Verify result of INSERT DEFAULT for domain-based fields which are declared as NOT NULL and have their own default values
191 SS 560 644 405 550 700 486 632 523 509 532 526 769 693 499 468 772 505 769 377 794 632 707 851 570 516 737 404 685 389 667 388
Verify result of INSERT DEFAULT for domain-based fields which are declared as NOT NULL and have their own default values
192 CS 914 841 895 834 854 868 951 819 852 830 849 856 914 860 863 1289 915 933 1255 1517 1317 1320 1360 1024 1120 785 1338 1413 1217 1407 700
Verify result of ALTER DOMAIN SET/DROP DEFAULT when a table exists with field based on this domain
193 SS 734 816 462 576 833 641 592 428 858 542 864 798 812 847 545 782 552 793 488 687 919 573 896 668 784 802 461 910 388 783 385
Verify result of ALTER DOMAIN SET/DROP DEFAULT when a table exists with field based on this domain
194 CS 1289 1253 1412 1127 1181 1236 1272 1182 1172 1328 1239 1314 1255 1356 1377 1689 1187 1340 1191 1849 1889 1838 1747 1306 1692 1152 955 994 979 1796 1561
gtcs-proc-isql-11
195 SS 945 554 760 671 703 795 987 993 939 967 1035 1030 1003 808 1085 800 951 928 952 1049 1098 841 1060 817 989 1004 1032 764 524 567 519
gtcs-proc-isql-11
196 CS 1272 1264 1371 1250 1281 1429 1214 1280 1240 1342 1251 1220 1265 1245 1246 1596 1151 1323 1001 1464 2497 1832 1685 1430 1495 942 955 994 1013 1692 1505
gtcs-proc-isql-15
197 SS 868 568 648 686 971 719 850 1076 817 1084 934 1076 960 1109 1061 887 945 1024 768 1018 1057 976 824 847 1132 793 522 716 562 577 510
gtcs-proc-isql-15
198 CS 1253 1239 1391 1251 1214 1373 1199 1199 1164 1255 1282 1215 1450 1241 1198 1221 1240 1271 928 1691 1789 1608 1779 1266 1828 1488 1243 1196 1003 1816 1517
gtcs-proc-isql-16
199 SS 944 601 673 670 1037 903 902 1000 1084 986 987 777 978 965 1056 945 957 944 816 1084 929 1060 1106 792 1136 1074 554 724 602 764 496
gtcs-proc-isql-16
200 CS 1269 1242 1286 1228 1218 1255 1301 1201 1255 1216 1283 1225 1308 1304 1340 926 1243 1339 1875 1182 1716 2033 1707 1389 1050 1145 1448 1079 1016 1815 1693
Test for select from SP that deletes record after its output
201 SS 956 660 856 792 964 1016 1067 976 612 966 927 972 882 988 847 945 977 779 1010 1035 992 1080 925 837 1049 1042 982 847 949 562 522
Test for select from SP that deletes record after its output
202 CS 705 738 698 601 772 697 655 683 734 713 698 671 674 670 760 1075 730 749 1146 673 1194 1094 608 749 628 621 633 763 555 1080 1052
SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern>
203 SS 618 328 623 482 634 618 512 624 669 646 647 654 596 577 446 546 534 657 618 606 668 677 707 463 576 670 628 364 723 323 436
SUBSTRING - miscelaneous tests of <str> SIMILAR TO <pattern>
204 CS 670 661 682 695 673 638 703 696 671 664 647 648 640 644 665 574 670 654 576 823 1035 593 938 684 774 1246 671 599 650 1208 1100
CAST CHAR -> TIME
205 SS 509 342 530 528 560 528 495 488 460 578 381 403 502 581 520 430 546 635 447 505 476 620 573 435 536 535 514 643 382 316 384
CAST CHAR -> TIME
206 CS 678 715 716 657 708 663 667 678 680 663 623 622 679 690 580 669 671 684 587 759 1045 625 1165 752 638 999 713 643 571 1031 1028
CAST CHAR -> TIME
207 SS 527 300 613 570 452 495 548 440 612 451 544 566 571 607 584 557 527 424 460 528 509 569 583 400 477 665 499 597 322 340 335
CAST CHAR -> TIME
208 CS 657 682 726 643 636 723 600 680 650 708 659 684 686 714 656 575 701 684 594 639 599 618 640 754 746 617 642 645 614 819 1060
CAST TIMESTAMP -> TIME
209 SS 524 328 640 564 554 530 594 504 561 524 525 573 461 499 568 559 524 611 491 427 510 502 696 395 544 488 588 463 340 313 318
CAST TIMESTAMP -> TIME
210 CS 846 794 892 968 833 870 906 844 838 838 848 796 922 804 930 774 917 858 865 938 809 816 741 929 909 829 777 776 762 1329 1375
COUNT
211 SS 655 444 633 680 692 756 568 532 551 774 541 567 740 724 737 744 645 601 710 751 760 657 803 540 653 751 624 681 425 421 425
COUNT
212 CS 648 695 779 665 614 636 677 659 614 635 630 709 691 637 610 608 701 701 592 717 691 621 1163 725 692 604 599 609 635 580 1037
DATEADD
213 SS 546 317 584 542 542 539 568 488 472 570 588 429 609 596 550 591 469 578 543 605 514 637 588 415 596 605 366 446 303 562 313
DATEADD
214 CS 674 663 701 662 741 653 761 725 697 609 709 663 670 692 676 612 673 688 724 694 601 662 1084 698 751 602 573 593 629 588 1095
DATEADD
215 SS 542 297 603 514 463 486 540 578 568 528 466 566 575 553 497 628 453 634 544 633 570 531 590 443 611 683 472 622 360 501 316
DATEADD
216 CS 667 666 720 616 690 714 663 700 660 669 671 623 656 701 665 571 672 704 659 710 1073 628 995 755 672 572 655 637 607 657 1060
Dateadd milliseconds
217 SS 529 327 557 496 571 390 507 532 560 606 544 574 516 499 508 453 538 554 573 552 523 551 448 483 527 553 483 680 365 547 323
Dateadd milliseconds
218 CS 673 659 1024 730 628 654 650 654 669 599 674 679 672 649 643 736 628 672 740 782 1064 689 616 701 683 1162 625 713 666 1117 927
EXTRACT(WEEK FROM DATE)
219 SS 483 309 615 535 478 375 393 586 334 460 621 459 439 558 508 439 590 668 447 531 548 567 474 436 401 538 564 447 489 524 311
EXTRACT(WEEK FROM DATE)
220 CS 691 722 724 643 656 657 756 683 734 700 636 632 657 643 663 741 665 642 736 742 1091 1050 705 708 702 1109 631 1040 653 552 623
TRUNC( <number> [, <number> ] )
221 SS 486 346 432 386 548 537 315 538 483 338 581 481 476 593 586 565 484 648 604 568 654 488 534 427 429 379 565 621 423 408 468
TRUNC( <number> [, <number> ] )
222 CS 700 736 715 685 665 645 662 662 734 735 691 731 677 622 733 674 619 710 676 777 732 1192 682 709 627 1059 1062 1140 1075 635 625
POSITION( <string> IN <string> )
223 SS 558 299 572 541 302 408 563 476 408 592 576 320 563 500 540 512 708 708 575 574 562 566 592 462 552 604 591 678 554 296 547
POSITION( <string> IN <string> )
224 CS 696 617 711 655 619 650 605 696 669 639 624 622 711 696 676 707 680 715 696 710 1189 1164 716 688 795 1101 1007 1101 1076 704 561
Test for TRUNC function
225 SS 519 339 454 511 423 512 445 576 433 492 530 413 467 517 458 572 548 718 606 528 657 521 620 436 584 608 618 494 558 307 544
Test for TRUNC function
226 CS 812 714 798 743 768 749 886 642 775 737 777 755 813 903 735 844 799 811 878 901 1305 1211 847 916 875 1394 1312 1340 1245 741 670
UNLIST function. Check output for different returning types
227 SS 676 460 519 672 708 513 707 514 680 719 574 576 730 743 685 587 767 572 730 622 880 584 772 596 714 831 516 588 751 607 764
UNLIST function. Check output for different returning types
228 CS 2863 2806 3144 2844 2787 2817 2832 2899 2771 2816 2780 2876 2943 2678 2853 2930 2782 2942 2789 3054 3171 2873 3027 3116 3009 2998 4319 4600 2639 2612 2363
SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login.
229 SS 1848 1003 1835 1823 1548 1743 1821 1867 1764 2017 1838 1883 1828 2008 1858 2008 2089 1774 2097 1879 2001 1948 1885 1551 1800 1735 2000 1812 1037 1929 2039
SYSDBA must see all attachments and their transactions, non-privileged user - only those which was of his login.
230 CS 29835 30046 30071 29694 29626 29699 29693 29613 29576 29702 29684 29459 29922 29816 29913 29962 29821 29714 29883 29950 29919 29870 29850 29992 30153 29870 29495 29409 29373 31984 29891
External Connections Pool, functionality test 01
231 SS 27939 28049 28202 27914 27993 27851 28069 27855 27965 28201 28123 27897 28347 27238 28118 27764 27702 27856 27580 27866 27505 27735 27791 27808 28119 28066 27420 28013 27995 28176 28183
External Connections Pool, functionality test 01
232 CS 1331 1228 1345 1386 1322 1284 1246 1406 1337 1273 1393 1283 1296 1378 1305 1297 1327 1370 1313 1383 1432 1374 1335 1334 1325 1452 1418 1298 1353 1328 1229
Common SQL. Check correctness of the results
233 SS 1090 1228 1208 1108 1102 1151 1092 892 639 1028 636 1091 951 618 945 930 1080 1139 1130 1210 1090 1129 924 954 1255 1180 1099 1072 1128 993 595
Common SQL. Check correctness of the results
234 CS 1357 1354 1508 1329 1389 1338 1274 1339 1167 1246 1265 1402 1352 1210 1326 1398 1463 1472 1419 1464 1558 1522 1550 1390 1295 1354 1436 1314 1521 1360 1275
Common SQL. Check correctness of the results
235 SS 1029 912 1215 740 1004 810 642 1038 656 1099 597 929 1253 688 907 1217 872 1268 1009 1346 1233 1421 1095 1013 1217 1265 1198 1165 1109 1020 733
Common SQL. Check correctness of the results
236 CS 932 941 999 942 951 831 863 958 842 919 888 932 965 863 840 823 915 943 959 892 888 991 912 915 864 932 995 993 973 938 975
Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction)
237 SS 664 824 852 765 452 767 611 494 468 556 581 487 635 456 473 820 862 776 780 699 616 693 830 611 763 795 478 478 703 395 757
Avoid info duplication when statements in call stack attached to different transactions (for example: monitoring snapshot is created in autonomous transaction)
238 CS 7391 3873 7437 7144 7290 7258 7179 7293 7189 7277 7293 7290 7362 7122 8334 7372 7396 7552 7467 7622 7558 7401 7386 7504 7328 7453 7557 7434 7456 7407 7432
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
239 SS 6856 3653 6701 6836 6752 6604 6360 7433 6812 6771 5959 6965 6432 5951 6030 6720 6982 6959 6854 7277 7104 7163 6859 6650 6863 7040 7296 7351 7080 7169 6940
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-01
240 CS 7252 3908 7259 7037 7162 7269 7217 7291 7219 7209 7224 7173 7246 7071 7138 7224 7346 7358 7431 7275 7458 7418 7297 7434 7219 7504 7329 7419 7235 7455 7212
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
241 SS 6660 3460 6577 6645 6313 6572 6692 5965 6612 6629 5966 6623 5912 5912 5962 7033 6947 6866 6742 6892 6868 6814 6676 6451 6799 6911 7015 7296 6356 6782 7002
READ CONSISTENCY. Changes produced by DELETE statement must be UNDONE when cursor resultset becomes empty after this statement start. Test-02
242 CS 7431 3875 7472 7171 7279 7306 7241 7247 7248 7354 7417 7480 7416 7393 7374 7495 7445 7451 7470 7471 7494 7554 7417 7464 7547 7500 7613 7403 7532 7355 7515
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
243 SS 6653 3468 6839 6639 6127 6823 6600 5968 6652 7368 5851 6501 6221 6074 6036 6543 6593 6991 6441 6791 6849 6806 6996 6299 7112 6957 6880 6665 6654 6771 6901
READ CONSISTENCY. MERGE must reject multiple matches, regardless on statement-level restart.
244 CS 53838 4145 53937 51640 53349 52336 52187 52296 52195 52582 52500 52336 52818 53504 52982 53808 54937 53809 54444 56098 55182 56316 53867 55407 54807 54190 54691 54449 54308 55420 56074
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
245 SS 51815 3779 52197 50178 48983 48341 48888 43103 48638 51616 44388 49773 50040 46143 43149 53231 54122 54958 53187 54660 53827 53847 53933 49198 52012 53684 54157 54107 51618 53853 53300
READ CONSISTENCY. Maximal number of statement-level restarts must be 10.
246 CS 7316 3822 7243 7297 7178 7153 7258 7215 7244 7154 7219 7165 7370 7193 7208 7218 7343 7314 7318 7343 7438 7375 7364 7494 11296 7350 7341 7350 7506 7338 7423
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
247 SS 6675 3363 6694 5922 6377 6355 6776 5988 6450 6248 6644 5966 6157 6626 5985 7256 6779 6709 6949 6762 6942 6809 7042 6548 6672 6679 6670 6867 6946 7698 6832
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-01.
248 CS 7286 3812 7233 7134 7112 7087 7239 7171 7223 7205 7267 7316 7327 7151 7173 7294 7501 7429 7322 7316 7450 8260 7457 7533 7441 7360 7278 8255 7241 7259 7337
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
249 SS 6771 3560 6378 5978 6780 7122 6817 6028 6640 6665 6597 6309 5971 6563 6056 8225 6863 6936 6897 6740 6806 6985 6903 6280 6836 6837 6763 6911 6718 6802 7072
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-02.
250 CS 7721 3990 7673 7628 7496 7732 7570 7582 7569 7715 7713 7598 7652 7624 7628 7828 7786 7827 7728 7747 7820 8727 7742 7995 8859 7864 7748 7766 7575 7784 7660
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03.
251 SS 7028 3295 6265 6970 7066 6150 6875 6124 6520 7054 6724 7055 6293 7234 6336 6908 7264 7529 7014 7206 7288 7147 7259 6745 7032 6837 7024 7122 7192 7170 7279
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-03.
252 CS 7266 3770 7230 7179 7241 7274 7152 7256 7168 7277 7225 7189 7241 7169 7259 7231 7252 7534 7211 7418 7310 7367 7464 7536 7456 7309 7400 7409 7418 7348 8348
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
253 SS 6778 3038 7443 6472 6814 6028 6114 5939 6268 6772 5923 6740 5975 6876 5960 6047 6985 7215 7002 6848 7547 6808 6640 6584 6867 6715 6814 7077 6785 6862 7021
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by DELETE. Test-04.
254 CS 7303 3807 7321 7153 7114 7143 7193 7272 7090 7189 7171 7304 7263 7076 7158 7272 8373 7384 7304 7367 7360 7187 7331 7436 7476 7352 7302 7317 7343 7361 7305
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
255 SS 6784 3089 6788 7481 6636 6922 6514 5920 6436 6565 5903 6458 5917 6696 5928 6872 7178 6908 6781 6841 6938 6943 6936 6440 6890 6591 6800 6911 6811 6836 6662
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-01.
256 CS 7295 3794 7361 7190 7202 7250 7176 7072 7223 7088 7207 7114 7258 7250 7268 7267 7511 7388 7203 7478 7341 7366 7429 7337 7524 7322 7335 7330 7323 7426 7396
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
257 SS 6770 3056 6669 7418 6776 5971 5941 5917 5944 6760 5955 6814 6027 6525 5931 6481 7242 7284 6764 7129 7143 6917 6871 6417 6835 6870 6822 6924 7020 6823 6750
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-02.
258 CS 7711 3987 7718 7622 7588 7419 7684 7625 7603 7745 7558 7575 7705 7558 7684 7579 8833 7694 7721 7756 7897 7883 7786 7966 7880 7914 7622 7807 7821 7751 7726
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03.
259 SS 7062 3163 6703 7045 7222 6184 6223 6172 6213 7032 6482 6652 6220 7243 6217 7209 7139 7280 7249 7239 7356 7221 7101 6792 7249 6987 7079 7121 7327 7040 7324
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-03.
260 CS 7341 3730 7268 7165 7170 7098 7306 7345 7079 7173 7137 7169 7383 7124 7265 7369 7337 7348 7406 7260 7391 7360 7379 7405 8371 7399 7428 7329 7488 7524 8327
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
261 SS 6794 3133 7005 6635 6280 5939 5948 5916 6042 6096 5893 6456 5974 6879 7000 6989 6949 7165 6784 6795 7000 6899 6793 6496 6932 6850 7060 7084 6915 6897 6667
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by MERGE. Test-04.
262 CS 7338 3815 7419 7028 7223 7240 7209 7374 7241 7212 7143 7285 8178 7201 7229 7350 7275 8309 7288 7312 7346 7441 7501 7427 7389 7345 7400 7381 7382 7535 7331
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
263 SS 6588 3126 6631 6390 5937 5924 5914 5945 5960 6489 5955 6484 5935 6485 5936 6849 6764 7111 6828 6988 7072 6972 7033 6494 6546 6853 7064 6663 6858 6769 7033
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-01.
264 CS 7380 3945 7327 7244 7157 7292 7200 7377 7357 7270 7309 7217 7386 7216 7427 7419 7346 8327 7557 7368 7417 7467 7451 7515 8408 7477 8360 7357 7390 7460 7384
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
265 SS 6673 3094 6817 6643 5954 5944 5990 5959 6067 6083 6015 5944 6055 6812 5980 6649 6121 6928 6868 6776 7013 8048 6993 6698 7026 6639 6780 6924 6964 7047 6972
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-02.
266 CS 7396 3861 8325 7297 7280 8290 7265 7254 7250 7231 8116 7291 7296 7222 7395 7359 7262 7512 7358 8347 7513 7556 7398 7676 7448 8321 7463 7394 7420 8562 7493
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
267 SS 6731 3092 6850 6735 5999 5966 5938 6028 6006 6003 6157 5967 5825 6808 5984 6415 6586 6805 6876 7317 7283 6728 7108 6474 7110 6954 6995 7140 7245 7180 7136
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-03.
268 CS 7327 3834 7252 7185 7051 7116 7130 7378 7183 7238 8316 7160 7380 7234 7476 7354 7371 7462 7286 7312 7314 7339 7459 7644 7439 7357 7416 7315 7477 7456 7272
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
269 SS 6701 3084 6701 6701 5904 5968 5944 5927 5928 6047 6028 5966 6105 6881 5947 6556 6593 6995 6765 7108 6999 7016 6744 6555 7222 6963 6957 7111 6944 6898 6737
READ CONSISTENCY. Check creation of new statement-level snapshot and restarting changed caused by UPDATE. Test-04.
270 CS 879 813 910 867 808 807 774 818 861 848 902 916 974 848 860 849 899 902 882 904 928 876 910 929 942 914 886 829 854 821 895
CREATE VIEW
271 SS 624 547 749 768 403 445 495 533 437 476 764 590 487 506 430 501 697 460 753 628 792 620 670 586 699 703 675 730 859 784 707
CREATE VIEW

List of tests in this report:


http://tracker.firebirdsql.org/browse/CORE-1000
http://tracker.firebirdsql.org/browse/CORE-1005
http://tracker.firebirdsql.org/browse/CORE-1025
http://tracker.firebirdsql.org/browse/CORE-1026
http://tracker.firebirdsql.org/browse/CORE-1033
http://tracker.firebirdsql.org/browse/CORE-1179
http://tracker.firebirdsql.org/browse/CORE-1196
http://tracker.firebirdsql.org/browse/CORE-1227
http://tracker.firebirdsql.org/browse/CORE-1245
http://tracker.firebirdsql.org/browse/CORE-1246
http://tracker.firebirdsql.org/browse/CORE-1274
http://tracker.firebirdsql.org/browse/CORE-1334
http://tracker.firebirdsql.org/browse/CORE-1366
http://tracker.firebirdsql.org/browse/CORE-1373
http://tracker.firebirdsql.org/browse/CORE-1432
http://tracker.firebirdsql.org/browse/CORE-1489
http://tracker.firebirdsql.org/browse/CORE-1497
http://tracker.firebirdsql.org/browse/CORE-1511
http://tracker.firebirdsql.org/browse/CORE-1533
http://tracker.firebirdsql.org/browse/CORE-1582
http://tracker.firebirdsql.org/browse/CORE-1624
http://tracker.firebirdsql.org/browse/CORE-1649
http://tracker.firebirdsql.org/browse/CORE-1650
http://tracker.firebirdsql.org/browse/CORE-1677
http://tracker.firebirdsql.org/browse/CORE-1716
http://tracker.firebirdsql.org/browse/CORE-1784
http://tracker.firebirdsql.org/browse/CORE-1787
http://tracker.firebirdsql.org/browse/CORE-1842
http://tracker.firebirdsql.org/browse/CORE-2005
http://tracker.firebirdsql.org/browse/CORE-2031
http://tracker.firebirdsql.org/browse/CORE-2041
http://tracker.firebirdsql.org/browse/CORE-2044
http://tracker.firebirdsql.org/browse/CORE-2067
http://tracker.firebirdsql.org/browse/CORE-2075
http://tracker.firebirdsql.org/browse/CORE-2265
http://tracker.firebirdsql.org/browse/CORE-2315
http://tracker.firebirdsql.org/browse/CORE-2783
http://tracker.firebirdsql.org/browse/CORE-284
http://tracker.firebirdsql.org/browse/CORE-2871
http://tracker.firebirdsql.org/browse/CORE-2932
http://tracker.firebirdsql.org/browse/CORE-2969
http://tracker.firebirdsql.org/browse/CORE-3045
http://tracker.firebirdsql.org/browse/CORE-3090
http://tracker.firebirdsql.org/browse/CORE-3435
http://tracker.firebirdsql.org/browse/CORE-3639
http://tracker.firebirdsql.org/browse/CORE-3647
http://tracker.firebirdsql.org/browse/CORE-3806
http://tracker.firebirdsql.org/browse/CORE-4140
http://tracker.firebirdsql.org/browse/CORE-4142
http://tracker.firebirdsql.org/browse/CORE-4233
http://tracker.firebirdsql.org/browse/CORE-4240
http://tracker.firebirdsql.org/browse/CORE-4255
http://tracker.firebirdsql.org/browse/CORE-4261b
http://tracker.firebirdsql.org/browse/CORE-4464
http://tracker.firebirdsql.org/browse/CORE-4488
http://tracker.firebirdsql.org/browse/CORE-4706
http://tracker.firebirdsql.org/browse/CORE-4726
http://tracker.firebirdsql.org/browse/CORE-4791
http://tracker.firebirdsql.org/browse/CORE-5162
http://tracker.firebirdsql.org/browse/CORE-5346
http://tracker.firebirdsql.org/browse/CORE-5538
http://tracker.firebirdsql.org/browse/CORE-5717
http://tracker.firebirdsql.org/browse/CORE-5750
http://tracker.firebirdsql.org/browse/CORE-623
http://tracker.firebirdsql.org/browse/CORE-629
http://tracker.firebirdsql.org/browse/CORE-6460
http://tracker.firebirdsql.org/browse/CORE-86
http://tracker.firebirdsql.org/browse/CORE-871
http://tracker.firebirdsql.org/browse/CORE-903
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_10.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_11.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_12.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_14.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_15.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_16.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_17.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_18.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_19.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_20.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_21.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/arno/derived_tables/test_22.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/datatypes/test_decfloat_binding_to_legacy.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/datatypes/test_miscelan_binding.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/dml/cte/test_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/dml/cte/test_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/dml/merge/test_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_cast_datatypes.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_computed_fields_07.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_dsql_domain_12.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_dsql_domain_13.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_dsql_domain_15.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_dsql_domain_20.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_gtcs_proc_isql_11.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_gtcs_proc_isql_15.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_gtcs_proc_isql_16.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_gtcs_select_delete_isql.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/gtcs/test_regexp_substring_similar_to.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/cast/test_10.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/cast/test_11.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/cast/test_23.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/count/test_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/date/test_dateadd_05.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/date/test_dateadd_06.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/date/test_dateadd_08.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/date/test_extract_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/math/test_trunc_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_position_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/string/test_trunc_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/intfunc/unlist/unlist_returning_types_test.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/monitoring/test_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/session/test_ext_conn_pool_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_dbp_4137_combo_full_join_and_windowed_funcs.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_dbp_5125_windowed_funcs.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/tabloid/test_no_dups_in_call_stack.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_statement_delete_undone_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_statement_delete_undone_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_merge_deny_multiple_matches.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_max_limit.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_delete_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_delete_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_delete_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_delete_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_merge_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_merge_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_merge_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_merge_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_01.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_02.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_03.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/transactions/test_read_consist_sttm_restart_on_update_04.py
https://github.com/FirebirdSQL/firebird-qa/tree/master/tests/functional/view/create/test_05.py
https://github.com/FirebirdSQL/firebird/issues/7141
https://github.com/FirebirdSQL/firebird/issues/7995
=== end of list ===

Last commits information (all timestamps in UTC):