Commented by: @pavel-zotov

It seems that not all build-in functions are covered (among them which can be used in expression index).

Consider following script:

set list on;
recreate table test(
id int
,x int
,y int
,r double precision
,s char(12) default 'DB_NAME'
);
commit;
create index test_eval1 on test computed by ( x/id );
create index test_eval2 on test computed by ( log10(r-15) );
create index test_eval3 on test computed by ( rdb$get_context('SYSTEM', s) );
create index test_eval4 on test computed by ( mod(x , (y-x) ) );
create index test_eval5 on test computed by ( substring(s from x for id+y) );

commit;

set count on;
set echo on;

insert into test(id, x) values(0, 1);

insert into test(id, r) values(1, 12);

insert into test(id, s) values(2, 'ENGINE_VERSION');

insert into test(id, x, y) values(3, 10, 10);

insert into test(id, x, y, s) values( 4, 3, -7, 'qwerty' );

set echo off;

select id, s from test;

Now run it with filtering only STDERR and 'test_eval' prefix from it:

C:\MIX\firebird\fb40\isql /:e40 -i c5606.sql 2>&1 | findstr /i /c:test_eval

None rows will be added into table: every declared expressions will get actual arguments that break evaluating process (runtime errors will be in every of them).
Output will contain only one row:

Expression evaluation error for index "TEST_EVAL1" on table "TEST"

Where are messages about indices TEST_EVAL2 ... TEST_EVAL5 ?

PS. WI-T4.0.0.743

Commented by: @asfernandes

Fixed.

Commented by: @pavel-zotov

Unfort., in the build WI-T4.0.0.744 (13-sep-2017) output contains only common text of exceptions but INDEX names are not mentioned at all.
Even 'TEST_EVAL1' not present in STDERR like it was before.

PS.
I did minor mistake in the script. One need to change (in the table DDL):

,s char(12) default 'DB_NAME'

to:

,s varchar(12) default 'DB_NAME'

Commented by: @asfernandes

> Even 'TEST_EVAL1' not present in STDERR like it was before.

I cannot reproduce.

For the "s" case, error happens on the field constraint level, before index update, so it's correct to not have the new message.

SQL> recreate table test(
CON> id int
CON> ,x int
CON> ,y int
CON> ,r double precision
CON> ,s varchar(12) default 'DB_NAME'
CON> );
SQL> commit;
SQL> create index test_eval1 on test computed by ( x/id );
SQL> create index test_eval2 on test computed by ( log10(r-15) );
SQL> create index test_eval3 on test computed by ( rdb$get_context('SYSTEM', s) );
SQL> create index test_eval4 on test computed by ( mod(x , (y-x) ) );
SQL> create index test_eval5 on test computed by ( substring(s from x for id+y) );
SQL>
SQL> commit;
SQL>
SQL> insert into test(id, x) values(0, 1);
Statement failed, SQLSTATE = 22012
Expression evaluation error for index "TEST_EVAL1" on table "TEST"
-arithmetic exception, numeric overflow, or string truncation
-Integer divide by zero. The code attempted to divide an integer value by an integer divisor of zero.
SQL>
SQL> insert into test(id, r) values(1, 12);
Statement failed, SQLSTATE = 42000
Expression evaluation error for index "TEST_EVAL2" on table "TEST"
-expression evaluation not supported
-Argument for LOG10 must be positive
SQL>
SQL> insert into test(id, s) values(2, 'ENGINE_VERSION');
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 12, actual 14
SQL>
SQL> insert into test(id, x, y) values(3, 10, 10);
Statement failed, SQLSTATE = 22012
Expression evaluation error for index "TEST_EVAL4" on table "TEST"
-arithmetic exception, numeric overflow, or string truncation
-Integer divide by zero. The code attempted to divide an integer value by an integer divisor of zero.
SQL>
SQL> insert into test(id, x, y, s) values( 4, 3, -7, 'qwerty' );
Statement failed, SQLSTATE = 22011
Expression evaluation error for index "TEST_EVAL5" on table "TEST"
-Invalid length parameter -3 to SUBSTRING. Negative integers are not allowed.
SQL>

Commented by: @pavel-zotov

Sorry, me wrong: i used old client library. On build 744 all works fine.

Commented by: @livius2

Thank you for adding this :)
Tested and work ok.