EXTENDED_ALIASES

This page is part of MariaDB's Documentation.

The parent of this page is: SQL Modes

Topics on this page:

• Overview

• USAGE

• DETAILS

  • SYNONYMS

  • SCHEMA

  • PARAMETERS

  • SKYSQL

  • PRIVILEGES

• EXAMPLES

• ERROR HANDLING

• FEATURE INTERACTION

• RESPONSES

• DIAGNOSIS

• ISO 9075:2016

• CHANGE HISTORY

• RELATED TOPICS

• EXTERNAL REFERENCES

Overview

In 10.6 ES, 10.5 ES:

This mode allows aliases to work similar to aliases in Sybase SQL Anywhere. Aliases are resolved in the SELECT list and WHERE clause. Aliases can be used in the SELECT list before the alias is defined. If the same label is used for an alias and a column, the alias is used.