Other Quirks

• The following DBMS's require result sets to be freed:
  • InterBase: before dropping a table
  • FrontBase: before re-running the same query or dropping a table
• FrontBase: can only do ORDER BY on columns named in the select
  • GOOD: SELECT a, b, c FROM t ORDER BY a;
  • BAD: SELECT b, c FROM t ORDER BY a;