search

loopbackio / loopback-connector-oracle

Connect Loopback to Oracle
http://loopback.io/doc/en/lb3/Oracle-connector.html
Other
28 stars 30 forks source link

Not able to distinguish tables in List object response if name is same but with different case in Oracle #147

Closed braj1999 closed 6 years ago

braj1999 commented 6 years ago

If the Oracle instance has two tables named as a_z & A_Z, then both tables are listed in list object calls as AZ. This happens because connector removes the _ if it is in table name and converts the name in camel case.

To reproduce:

  1. Create two tables with same name but with different case e.g "A_Z" and "a_z" in Oracle Database.
  2. Run the discoverModelDefinitions method to get the list to tables available in Oracle.
  3. Check the tables with name "AZ". There should be two entries for it.
  4. Now try to run discoverSchemas method for table AZ. It always gives metadata of first table only.
stale[bot] commented 6 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] commented 6 years ago

This issue has been closed due to continued inactivity. Thank you for your understanding. If you believe this to be in error, please contact one of the code owners, listed in the CODEOWNERS file at the top-level of this repository.