Document the Requirement for SchemaBinding on Deterministic User-Defined Functions - by CouldYouMakeHelpingYouAnyMorePainful

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 800991 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 9/16/2013 12:34:21 PM
Access Restriction Public


The documentation for CREATE FUNCTION does not indicate that user-defined functions lacking WITH SCHEMABINDING will always be non-deterministic.  For example:

create function MyPi()
  returns float
  return 3.14159265358979324

would appear to the unitiated to be deterministic, i.e. it will always return the same result for the same (unsupported) input.  In fact, without adding WITH SCHEMABINDING it remains non-deterministic according to INFORMATION_SCHEMA.ROUTINES.
Sign in to post a comment.
Posted by Rick [MSFT] on 10/28/2013 at 8:17 AM
Thank you for submitting this. I have added the requirement "Functions must be created with schema binding to be deterministic." in the appropriate section of CREATE FUNCTION (Transact-SQL). This will show up in the MSDN version in a week or two.
Posted by Microsoft on 10/3/2013 at 6:44 PM
Thanks for calling this to our attention. We're investigating and will post an update shortly.