Versions Compared

Old Version 1

changes.mady.by.user Igor Lebedev

Saved on

compared with

New Version 2

changes.mady.by.user Igor Lebedev

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

STEP 1: All the attributes in the result set from executing the statements here will be switched to lower case, even if:

  • the field names from the source tables had upper case letters,

  • the aliases for the fields in SELECT statement were quoted.

Note

STEP 3: Since all the input sources have all the attributes in lower case at this stepStandard SQL behavior can be expected at this stage, everything in the user SELECT statement will be switched to lowercase, unless it is quoted. Starting from here pay attention to what you quote.

Note

STEP 4:

  • More errors may appear at this step, because of the presence of attributes with different letter cases in user SELECT statement and in the result set from previous step.

  • The use of the * operator will preserve the attribute letter case from the input data.

  • The use of double quotes on an attribute will preserve its letter case, all the unquoted attributes will be switched to lower case to increase compatibility.

...