Dummy test

Server shutdown

Incorrect value returned with execute statement calculation

Navigation vs IS NULL vs compound index

Trigger do it wrong

Error "no current record for fetch operation" on view select

Cannot create procedure with long chain of else-if clauses

FIRST 1 vs ORDER DESC vs explicit plan (ODS11)

FIRST 1 vs ORDER DESC vs explicit plan (ODS11)

WHERE CURRENT OF doesn't work

WHERE CURRENT OF doesn't work

Automatic not null in PK columns incomplete

Automatic not null in PK columns incomplete

Sequence of commands crash server

Expression index regression since 2.0a3

Expression index regression since 2.0a3

Invalid ROW_COUNT variable value after DELETE

Query with not in (select) returns wrong result

Index bug

Join on diffrent datatypes

Wrong return from simple SQL

Recreate and self-referencing indexes

Strange/Inconsistent query results

JOIN the same table - problem with alias names

Dropping and recreating a table in the same txn disables PK

Dropping and recreating a table in the same txn disables PK

Bug with ALL keyword

Bug with ALL keyword

BLOBs in external tables

BLOBs in external tables

Expression evaluation not supported on LEFT JOIN

Numeric div in dialect 3 mangles data

Index breaks = ANY result

Using where params in SUM return incorrect results

SELECT '1' UNION SELECT '12'

Left joining views with null fails

Sqlsubtype incorrect on timestamp math, constant arithmetic

Query using VIEW with UNION causes crash

Cannot specify PLAN in UPDATE statement

Cannot specify PLAN in UPDATE statement

DB crashes if trigger BU deletes own row

Trigger on view with union receive nulls

trigger with except-s on view with union

Bugcheck 291

Bugcheck 291

SYSDBA can grant non existent roles

SYSDBA can grant non existent roles

Wrong order by in table join storedproc

Empty column names with aggregate funcs

ORDER BY works wrong with collate PT_PT

CREATE VIEW ignores PLAN

CREATE VIEW ignores PLAN

CHECK constraints fire twice

CHECK constraints fire twice

CS server crash altering SP in 2 connect

SELECT...HAVING...NOT IN crashes server

Count (DISTINCT ...) is too slow

Count (DISTINCT ...) is too slow

Too many grants lose privileges

ALTER TABLE altering to VARCHAR

ALTER TABLE altering to VARCHAR

DOMAINs don't register their dependency on other objects

DOMAINs don't register their dependency on other objects

Blob comparison with constant

IB server stalled by simple script

Any user can drop procedures, generators, exceptions

Any user can drop procedures, generators, exceptions

Unsuccessful execution caused by system error <...> bad BLR -- invalid stream

DateTime math imprecision

ISQL and database dialect

Complex view crashes server

NULLS FIRST does not work with unions

Garbage vs indices/constraints

Wrong sort order when using es_ES collate

JOIN including a complex view kills the server

Redundant evaluations in COALESCE

ORDER BY has no effect

Grants overwrite previous rdb$security_classes entries

Foreign key relation VARCHAR <-> INT

Foreign key relation VARCHAR <-> INT

Optimization problem with COALESCE

Optimization problem with COALESCE

Ambiguous statements return unpredictable results

Permissions are checked case-insensitively

Permissions are checked case-insensitively

Inconsistent results using STARTING WITH and COALESCE

Before triggers are firing after checks

Before triggers are firing after checks

Tricky role defeats basic SQL security

Tricky role defeats basic SQL security

FIRST is applied before aggregation

SKIP is off by one

ORDER BY on a VIEW turns values in fields into NULL

Token unknown in simple SELECT with GROUP BY and ORDER BY

Token unknown in simple SELECT with GROUP BY and ORDER BY

Grouping on derived fields processing NULL data kills IB

Blob Type 1 compatibility with VarChar

Support for time zones [CORE694]

User Account maintanance in SQL

Compress Data over the Network

Wildcards/Regular Expressions in WHERE clause - SIMILAR TO predicate

Ability to run ALTER VIEW statement without dropping dependencies

Easy metadata extract improvements

Easy metadata extract improvements

Privileges of dynamic statements in SP

Accent ignoring collation for unicode

Specific query crashing server

Computed field can't be changed to non-computed using 'alter table alter column type xy'

Computed field can't be changed to non-computed using 'alter table alter column type xy'

DateTime math imprecision

DateTime math imprecision

Field can be used multiple times in multi-segment index definition

Field can be used multiple times in multi-segment index definition

substring(current_user from 4) fails

Aggregates in the WHERE clause vs derived tables

Unable to set FName, MName, LName fields in security to blank

Unable to set FName, MName, LName fields in security to blank

Containing not working correctly

Sorting is allowed for blobs and arrays

Removing a NOT NULL constraint is not visible until reconnect

Removing a NOT NULL constraint is not visible until reconnect

Incorrect handling of null within view - returns 0

Column involved in the constraint (e.g. PK) could NOT be dropped if constraint has user-defined name

Column involved in the constraint (e.g. PK) could NOT be dropped if constraint has user-defined name

Dependencies are not cleared when creation of expression index fails

Dependencies are not cleared when creation of expression index fails

Singleton isn't respected in COMPUTED BY expressions

The built-in BLR printer doesn't support all FB2 features

The built-in BLR printer doesn't support all FB2 features

It is impossible to take away rights on update of a column

It is impossible to take away rights on update of a column

Ability to query a stored procedur from view.

Ability to query a stored procedur from view.

DDL - object in use

SUBSTRING with NULL offset or length don't return NULL

Problems with explicit cursors in unwanted states

Problems with explicit cursors in unwanted states

New value of column is accessable before update

Server crash on violation of NOT NULL constraint

Server crash on violation of NOT NULL constraint

Garbage in plan output of complex statement

Garbage in plan output of complex statement

An attempt to select DB_KEY from a procedure crashes the server

ALL predicate works incorrectly for some subqueries

Grants don't work for procedures used inside views

Bug in DSQL parameter

Comment in create database

Bad error message when tring to create FK to non-existent table

Bad error message when tring to create FK to non-existent table

AV when blob is used in expression index

GSTAT does not work using the localhost connection string

Many aggregate functions within a single select list may cause a server crash

SQL with incorrect characters (outside the ASCII range) may be processed wrongly

Case insensitive collation for UTF-8

Make RDB$DB_KEY in outer joins return NULL when appropriate

Non-ASCII quoted identifiers are not converted to metadata (UNICODE_FSS) charset

select with FIRST and LEFT JOIN needs excess SORT in plan

select with FIRST and LEFT JOIN needs excess SORT in plan

Keyword AS not recognized in clause FROM

Incorrect results when left join on subquery with constant column

Bad handling of /*/ comments in ISQL

Context already in use (BLR error)

DISTINCT vs NULLS LAST clause: wrong order of NULLs

AV at rollback and/or garbage collection if updated table have expression index with SELECT in it

Restoring RDB$BASE_FIELD for expression

Local buffer overrun in DYN_error() that takes down the server

Local buffer overrun in DYN_error() that takes down the server

Provide mechanism to get engine version without needing to call API function

Make information available regading ODS Version and Dialect via SQL

Server crashes at runtime when an explicit MERGE plan is specified over a few JOIN ones

Estonian collation in UTF8 charset

Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)

Bad plan in outer joins with IS NULL clauses (dependent on order of predicates)