search

ibmdb / python-ibmdbsa

Automatically exported from code.google.com/p/ibm-db.ibm-db-sa
Apache License 2.0
41 stars 59 forks source link

Fix for reflection get_primary_keys #60

Closed sasa-tomic closed 1 year ago

sasa-tomic commented 5 years ago

Reflection wasn't working on DB2 Warehouse on Cloud, and possibly wasn't working with some other recent DB2 versions, which do not have a valid SYSCOL.INDEXES.COLNAMES From the documentation: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0001047.html

This column is no longer used and will be removed in the next release. Use SYSCAT.INDEXCOLUSE for this information.

Other changes in ibm_db_sa may be necessary due to the same backwards-incompatible change in DB2, for example, in get_indexes, which should return the index columns

praveen-db2 commented 2 years ago

@sasa-tomic can you please rebase and resolve conflicts so we can merge this.

bimalkjha commented 1 year ago

Closing it as a duplicate of pull #62 . Thanks.