This repository was archived by the owner on Aug 28, 2024. It is now read-only.
Adding the table_exists() procedure which determines whether a table … #58
Conversation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
…exists and if so whether it's a BASE TABLE, TEMPORARY table, or a VIEW
procedures/table_exists.sql
Outdated
Member
|
Need to clean up the SQL SECURITY characteristic. I prefer in fact that all characteristics are explicitly set for all objects (like DETERMINISTIC, READS SQL DATA, in this case), just as a personal preference. |
Contributor
Author
|
Not sure how I missed the SQL SECURITY characteristics. Completely agree that it should be INVOKER and also that it's best to define the other characteristics (though I guess it's technically NOT DETERMINISTIC (the result doesn't only depend on the input parameters but also the state) and it's CONTAINS SQL as it may create a temporary table (and remove it again). |
MarkLeith
added a commit
that referenced
this pull request
Jun 3, 2015
Adding the table_exists() procedure which determines whether a table …
Sign up for free
to subscribe to this conversation on GitHub.
Already have an account?
Sign in.
2 participants
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
…exists and if so whether it's a BASE TABLE, TEMPORARY table, or a VIEW