Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

Disable table joins for ObjectExists #27

Closed
hisystems opened this Issue Mar 5, 2012 · 0 comments

Comments

Projects
None yet
1 participant
Owner

hisystems commented Mar 5, 2012

Currently, when the Database.ObjectExists function is called and there are table joins because:

  • the key field can not be used in the WHERE clause because it will not have the alisas or prefix that is required and the SQL statement will fail.
  • in most circumstances it will unnecessarily burden the database server with a table join when the key field is typically located in the main table - not in a joined table.

@ghost ghost assigned hisystems Mar 5, 2012

@hisystems hisystems closed this in 4fab384 Mar 10, 2012

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment