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;