Versions Compared

Old Version 2

changes.mady.by.user Igor Lebedev

Saved on

compared with

New Version 3

changes.mady.by.user Igor Lebedev

Saved on

Key

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

...

Note

STEP 3: Standard SQL behavior can be expected at this stage, everything in the user SELECT statement will be switched to lowercase, unless it is quoted.

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

Standard SQL behavior can be expected at this stage as well.

  • 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.

  • 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.

Study the example to make sure that you understand this concept . There you can see which attributes will be switched to lower case, and for which the case will be preserved.

...