MySQL/MemSQL/SAP sqlanywhere/SAP IQ – 3 migration issues, isnull & any subquery

 

Numeric data type

ISNULL vs IFNULL

  • SAP IQ – supports isnull
  • memSQL – supports ifnull

Not Any subquery

SAP allows ANY subquery syntax

 

memSQL/mysql syntax error with ANY keyword; revised as:

Rey Wang
Author: Rey Wang

Leave a Reply

Your email address will not be published. Required fields are marked *