Mercurial > hg > monetdb-java
diff ChangeLog @ 652:6a34d2c36dec
Improved and optimized DatabaseMetaData.getBestRowIdentifier().
author | Martin van Dinther <martin.van.dinther@monetdbsolutions.com> |
---|---|
date | Wed, 24 Aug 2022 22:02:32 +0200 (2022-08-24) |
parents | 03e0f577db00 |
children | 0b564ae68ac1 |
line wrap: on
line diff
--- a/ChangeLog +++ b/ChangeLog @@ -1,6 +1,15 @@ # ChangeLog file for monetdb-java # This file is updated with Maddlog +* Wed Aug 24 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> +- Improved DatabaseMetaData.getBestRowIdentifier(). When there are multiple + unique constraints and no pkey for a table it used to return the columns + of all the table unique constraints. Now it only returns the columns of + the first table unique constraint. + Also optimized the performance of getBestRowIdentifier(). It used to + send a separate query first to find out if the table had a pkey or not. + This extra query is now integrated so less queries are send to the server. + * Wed Mar 30 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier() and getIndexInfo() for local temporary tables located in schema tmp. They