Topic: SUBSTRING and field size
SELECT SUBSTRING (COLUMN1 from 10 for 20).....
In Firebird 2.5 type of a returned column will be same, as at COLUMN1
Despite explicit restriction of field length in request.
It is specified "for 20" - on idea on an output should receive VarChar (20) if the length of an initial column is more, but FB2.x it does not consider, demands explicit CAST.
In FB 3/4 and remains, the forced reduction of length of the text in SUBSTRING is not considered?