TODOs for my SQL comparison page:
- Does the command line interface auto-commit, or not
- Viewing event log
- Getting a list of schemas
- COALESCE and similar functions
- Temporary table handling
- Is MySQL's CHAR behaviour perhaps really because MySQL changes CHAR to VARCHAR under certain circumstances?
- IDENTITY: How to grab the value of the generated identity? (see Frans Bouma's notes here for inspiration)
- Verify if a tool like rlwrap can make the brain-dead command-line processors work reasonably (thanks to Phil Pennock).
- COLLATION support
- better, more general, coverage of row value constructors
- getting meta-information (like list of tables) in non-CLI situations (e.g. add Lennarts hint)
- add info for more products (Ingres comes to mind, as does Firebird, Mimer, SQLite and MaxDB)
- batch SQL handling
- more documentation links
- quoting/escaping strings
- explicit NULL (DB2: exception; MSSQL: required...)
- explicit AS for column aliases: required, accepted or rejected
- case sensitivity
- varchar max-sizes
- select to a new table
- available numeric data types and their precisions
- see if MySQL's GROUP_CONCAT functionality is available in other DBMSes
- String concatenation: || vs CONCAT et al
- Date/time arithmetic
- Are there interesting differences in support for window functions?
Will probably have to split up the page at some point. First split should
probably be into SQL and command line operations.
To Troels' home page.
Version control information: $Date: 2011-01-02 23:45:04 +0100 (Sun, 02 Jan 2011) $.