Versions Compared

Old Version 4

changes.mady.by.user Jana Volencová (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Jana Volencová (Deactivated)

Saved on

Key

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

...

Note

In Step 1 above: 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

In Step 3 above:Standard SQL behavior can be expected at this stage, everything in the user SELECT statement will be switched to lower case, unless it is quoted.

Note

In Step 4 above: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.

...