SQL Features

• strlst/IN Changes and New SUBSET/INTERSECT Operators
  • IN behavior change - Caveat
  • New operators SUBSET and INTERSECT - Caveat
  • Relational operators with strlst changed - Caveat
  • stringcomparemode used with strlst - Caveat
  • varchartostrlstsep default is now create - Caveat
  • Duplicate multi-item strlst index results removed - Caveat
  • multivaluetomultirow defaults off - Caveat
• ALTER INDEX Syntax Added
• CREATE INDEX ... WITH options Syntax - Caveat
• Metamorph Index Default Type Is INVERTED - Caveat
• byte / char Conversion As-is Without Hexifying - Caveat