5.2 Supported SQL Modes

Default DB System SQL modes are supported, which include ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION. See Server SQL Modes.

In addition, the following SQL modes are supported:

• ANSI_QUOTES

• HIGH_NOT_PRECEDENCE

• IGNORE_SPACE

• NO_BACKSLASH_ESCAPES

• REAL_AS_FLOAT

• TIME_TRUNCATE_FRACTIONAL

Temporal types are supported only with strict SQL mode. See Strict SQL Mode.

What's Next

• Learn how to perform the following tasks:

  • Run queries

  • Modify tables

  • Retrieve MySQL HeatWave Metadata

  • Optimize workloads for OLAP and OLTP

  • Monitor MySQL HeatWave processes