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)

WHERE CURRENT OF doesn't work

Automatic not null in PK columns incomplete

Sequence of commands crash server

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

Bug with ALL keyword

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

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

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

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

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

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

Optimization problem with COALESCE

Ambiguous statements return unpredictable results

Permissions are checked case-insensitively

Inconsistent results using STARTING WITH and COALESCE

Before triggers are firing after checks

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

Grouping on derived fields processing NULL data kills IB

Blob Type 1 compatibility with VarChar

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

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'

DateTime math imprecision

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

Containing not working correctly

Server crash when using UDF

Sorting is allowed for blobs and arrays

Removing a NOT NULL constraint is not visible until reconnect

Incorrect handling of null within view - returns 0

Problem when dropping column that is a primary key

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

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

SPs in views

DDL - object in use

SUBSTRING with NULL offset or length don't return NULL

Problems with explicit cursors in unwanted states

New value of column is accessable before update

Server crash on violation of NOT NULL constraint

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

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

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

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

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

LIKE doesn't work for computed values (at least in a view)

Extend returning support added in ver 2 in update record of table and in updateble view

Wrong single-segment ascending index on character field with NULL and empty string values

Wrong parameter matching for self-referenced procedures

A query could produce different results, depending on the presence of an index

ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation

Server hangs eating CPU and performs huge I/O copying different codepage fields

SINGULAR buggy when nulls present

Services Manager and gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition

View with equally named source fields not faisible

User (not SYSDBA) what have privileges with grant option, can't revoke privileges, granted by other user or SYSDBA

Wrong ordering with views, distinct, left join and order by

Error msg "Could not find UNIQUE INDEX" when in fact one is present

Support BETWEEN predicate for select expressions

Wrong results with GROUP BY on constants

Crash when dealing with a string literal longer than 32K

Remove or extend limit of command text length (64K)

Conversion from string to number is not standard compliant

Recursive Query bug in FB2.1

Incorrect results when left join on subquery with constant column

Bad optimization -- <procedure> left join <subquery> (or <view>)

Cannot alter generator's comment to the same value

Server locks up while attempting to commit a deletion of an expression index

AV in rse\invalidate_child_rpbs for recursive queies

Every user can view server log using services API

Error conversion error from string " " using outer join on int64 and int fields

Cannot erase a table with check constraints referencing more than a single columns

Activating index change "STARTING" working as "LIKE" in join condition

Prepare fails when having a parameter in a DSQL statement before a sub query

Problem altering numeric field type

WHEN <list of exceptions> tracks only the dependency on the first exception in PSQL

CHARACTER SET GBK is not installed

ISQL exponential format of numbers has zero pad on windows

Symbols ignored for ES_ES_CI_AI collation

Expression index based on computed fields

Error "Data type unknown" when any UDF argument is a built-in function containing a DSQL parameter reference

"CH" and "LL" are not separate spanish alphabet letters since 1994

Union returns inconsistent field names

View cannot be created if its WHERE clause contains IN <subquery> with a procedure reference

Select Starting with :Param (Empty string) doesn't work if using index with many fields

Long SQL statements break TCP/IP connection

CURRENT OF support views

Wrong SELECT query results using index to evaluate >= condition

LIST() function seems not work if used twice or more in a query

Server crash on select * from <recursive CTE>

Incorrect column values with outer joins and views

Incorrect column values with outer joins and derived tables

Incorrect timestamp arithmetic when one of operands is negative number

Full shutdown mode doesn't work on Classic if there are other connections to the database

LIST(DISTINCT) concatenate VARCHAR values as CHAR

Problem with DISTINCT and insensitive collations

String truncation error when concatenating _UTF8 string onto extract(year result

Table columns hide destination variables of RETURNING INTO

GSec incorrectly processes some switches

Small bug with default value for domains in PSQL

Ceation of invalid procedures/triggers allowed

Wrong results when PLAN MERGE is chosen and datatypes of the equality predicate arguments are different

isql: zero divide + coredump when use "-pag 0" command switch & set heading on inside .sql script

Can't transliterate character set when look at procedure text in database just created from script (and thus in ODS 11.1)

Can't create table using long username and UTF8 as attachment charset