Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Complete boolean evaluation or not |
Wed, Dec 23 2009 11:47 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
When you recover from an excess of good cheer, out of interest does ElevateDB carry out complete boolean evaluation or not? eg in this SELECT _ID FROM Companies WHERE _Name LIKE SUBSTR(:Value,1,3)+'%' AND StrippedCompanyName(_Name) = StrippedCompanyName(:Value) if the first part is false will the second still be evaluated? Roy Lambert |
Thu, Dec 24 2009 5:57 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< When you recover from an excess of good cheer, out of interest does ElevateDB carry out complete boolean evaluation or not? >> No, it always uses short-circuit evaluation for AND. There's no point in doing so. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Dec 24 2009 7:34 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< When you recover from an excess of good cheer, out of interest does >ElevateDB carry out complete boolean >evaluation or not? >> > >No, it always uses short-circuit evaluation for AND. There's no point in >doing so. I agree, but I just got to wondering with the 1011 error where I'd put a length test in so I suppose the error was raised before the tests were carried out. Seems fair enough and I now know. Roy Lambert |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |