IDB logo InstantDB

Problems
faq & bugs
status
bugs
feedback
debug

Known Bugs and Limitations<

  • Limitation on the use of the UNIQUE keyword in a CREATE TABLE statment.

    If several columns are included in a UNIQUE clause, then InstantDB ensures that each column is individually unique. This deviates from the ANSI SQL specification where the columns should be collectively unique.

  • Doesn't understand the standard timstamp escape sequence.
  • Doesn't understand repeated single quotes '' or double quotes "" as a single character.
  • Doesn't support REPEATABLE_READ and READ_COMMITTED transaction isolation levels.
  • Only supports a single active results set per statement - This is in accordance with the JDBC specification. However some other drivers do support this.