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 a TIMESTAMP 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.

Advance To: