Submitted by: Fabio Schunig (fschunig)

It seems a bug on columns "computed by" and "generated always as".

When I use the function POSITION in these columns, Firebird includes the next columns inside the expression.
And, if the next field has a default value, it changes to a parenthesis.

Example to clarify:

CREATE TABLE TABELA1 (
NOME_COMPLETO COMPUTED BY ('Fabio ' || POSITION('X','Schunig')),
TESTE NUMERIC(8,2) DEFAULT 0
);

With this command, the default value of "TESTE" changes from "0" to ")".
Besides, the column "NOME_COMPLETO" includes the following text in its expression.

- Example of show table in iSQL:

SQL> SHOW TABLE TABELA1;
NOME_COMPLETO Computed by: ('Fabio ' || POSITION('X','Schunig')),
TESTE NUMERIC(8,2) DEFAULT 0
)
TESTE NUMERIC(8, 2) Nullable )

- Example of DDL extraction in IBExpert:

CREATE TABLE TABELA1 (
NOME_COMPLETO COMPUTED BY ('Fabio ' || POSITION('X','Schunig')),
TESTE NUMERIC(8,2) DEFAULT 0
),
TESTE NUMERIC(8,2) )
);

In my tests, this doesn't occurs if I didn't use the POSITION function.