Bug report for MonetDB 4.4.0 on Windows XP:

1. Unique constraint doesn’t work. MonetDB simply allows duplicate entries.
2. LIKE comparisons don’t work correctly. For example LIKE “%math%” will also match with “path”.
3. Updates don’t take effect until session is closed. In particular: We deleted all entries from a table. Then if you say SELECT * FROM Table MonetDB correctly gives an empty result set. However, after inserting new data and then selecting again, every entry shows up duplicated! The only way around this is to close the session and login again or to drop the whole table L. Also implementing a command like TRUNCATE TABLE would be nice …. .
4. Auto commit can not be turned off via the JDBC driver.
5. The user name doesn’t get retrieved correctly through JDBC. When checking the ConnectionMetaData the user name is always “monetdb” even when connected as a different user.
6. (Security)The password, after shadow typed, can be recalled just by pressing the key “UP”