While I'm about to leave ASA 8.0.3 behind, I made some comparisons with ASA 8.0.3.5574 and SA 12.0.0.2566 and accidently used EXCEPT and INTERSECT on ASA 8.0.3. I had strongly expected a syntax error as I was absolutely sure both set operators were introduced with ASA9 (and they are not at all documented with ASA 8), but they work. Just couldn't believe it: Have I deliberately - but unfounded! - left out these handy operators all those years when working with ASA 8 (while using them on newer version)? Or have I missed a relevant piece of information? But wait and calm down, Volker - they seem to get accepted syntactically in ASA 8.0.3 but don't seem to work correctly, i.e. a
does return the same resultset as without the EXCEPT clause or with an INTERSECT clause. So it seems I have not missed an important feature... My pulse is still accelerating... |
Just to complete and answer the title question (whereas Bruce has answered the real question): As already stated in my question - both set operators were introduced with ASA 9.0. |
Shh, don't tell anyone, but historically speaking the parser has been known to allow syntax for which no semantics exist :)