ER_SQL_MODE_NO_EFFECT

Overview

'%s' mode no longer has any effect. Use STRICT_ALL_TABLES or STRICT_TRANS_TABLES instead.

See also: Error Codes for MariaDB Enterprise Server 10.6, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS

See also: Error Codes for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1 as error number 3027

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0 as error number 3027

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1 as error number 3027

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0 as error number 3027

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1 as error number 3027

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0 as error number 3027

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1 as error number 3027

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0 as error number 3027

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1 as error number 3027

10.2 Community

  • Added in MariaDB Community Server 10.2.3 as error number 3026

  • Error number changed in MariaDB Community Server 10.2.5 from 3026 to 3027

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1 as error number 3027

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1 as error number 3027

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1 as error number 3027

EXTERNAL REFERENCES