postgresql - hsqldb indexOutOfBoundException -

i have relation, has 5000 records.

problem:

suppose have 1 record:

name : 'adam' , family : 'white' , data:'003*12/12/12' , father:'jack'

when search:

select * tbl_r1 1=1 , father='adam';//return 0 record

select * tbl_r1 1=1 , father='jack';//return 1 record

it works well, but:

select * tbl_r1 1=1 , father='adam' ,      convert(substring(data 1 3),bigint)= 3;

it throws exception "

stringindexoutofboundsexception :-7" or -80

and on

this query ok in postgresql because filtered father name...

this works fine latest version of hsqldb (2.3.3).

UV code