Miscellaneous Issues
From InterBase
Go Up to Features and Dialects
IN
clauses have a limit of 1500 elements
Resolution If you have more than 1500 elements, place the values in a temporary table and use a SELECT subquery in place of the list elements.
- Arithmetic operations on character fields are no longer permitted in client dialect 3.
Resolution Explicitly cast the information before performing arithmetic calculations.
- Using
isql
to select from aTIMESTAMP
column displays all information when client dialect is 3.
Resolution In versions of InterBase prior to 6.0, the time portion of a timestamp displayed only if SET TIME ON
was in effect. In 6.0 and later client dialect 3, the time portion of the timestamp always displays.