*** 17,23 ****
pragmas at the time the query statement was prepared. The default
settings for these pragmas are as shown above, short=ON and long=OFF.
If you want to change these settings, you will have to do so separately
! for each database connection. The changes are not persistent but
revert to their default value with each new connection.
*Case 1: Result set expressions contain an "AS" clause*
--- 17,23 ----
pragmas at the time the query statement was prepared. The default
settings for these pragmas are as shown above, short=ON and long=OFF.
If you want to change these settings, you will have to do so separately
! for each database connection. The changes are not persistent. They
revert to their default value with each new connection.
*Case 1: Result set expressions contain an "AS" clause*
***************
*** 39,45 ****
that is enclosed in parentheses is still considered trivial.
The name of any non-trivial result set expression is a copy of the
! complete text for that expression.
*Case 3: short_column_names=ON*
--- 39,45 ----
that is enclosed in parentheses is still considered trivial.
The name of any non-trivial result set expression is a copy of the
! text of that expression as it appeared in the SELECT statement.
*Case 3: short_column_names=ON*
***************
*** 59,66 ****
SELECT rowid, xyz FROM example1;
The names of your result set columns will be "abc" and "Xyz",
! not "rowid" and "xyz". The names of the columns as they appear
! in the CREATE TABLE statement are used, not as the appear in the
SELECT statement.
*Case 4: short_column_names=OFF and long_column_names=OFF*
--- 59,66 ----
SELECT rowid, xyz FROM example1;
The names of your result set columns will be "abc" and "Xyz",
! not "rowid" and "xyz". The names of the columns
! in the CREATE TABLE statement are used, not the names in the
SELECT statement.
*Case 4: short_column_names=OFF and long_column_names=OFF*
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|