Bug report for MonetDB
4.4.0 on Windows XP:
- Unique constraint doesn’t work.
MonetDB simply allows duplicate entries.
- LIKE comparisons don’t work
correctly. For example LIKE “%math%” will also match with “path”.
- 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 …. .
- Auto commit can not be turned
off via the JDBC driver.
- 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.
- (Security)The password, after
shadow typed, can be recalled just by pressing the key “UP”