*** 4,21 ****
There are two pragmas which control how column names are chosen:
PRAGMA short_column_names;
! PRAGMA long_column_names;
Either pragma can be set to "true" or "false" or "on" or "off" or
"0" or "1". For example:
PRAGMA short_column_names=ON;
! PRAGMA long_column_names=OFF;
If you omit the "=VALUE" part then the pragma returns the current
setting. The column names generated depend on the value of both
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.
--- 4,21 ----
There are two pragmas which control how column names are chosen:
PRAGMA short_column_names;
! PRAGMA full_column_names;
Either pragma can be set to "true" or "false" or "on" or "off" or
"0" or "1". For example:
PRAGMA short_column_names=ON;
! PRAGMA full_column_names=OFF;
If you omit the "=VALUE" part then the pragma returns the current
setting. The column names generated depend on the value of both
pragmas at the time the query statement was prepared. The default
! settings for these pragmas are as shown above, short=ON and full=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.
***************
*** 27,33 ****
becomes the name of the column in the result set. The AS clause
overrides all other behavior. If an AS clause is present, it does
not matter what the settings of the short_column_name and
! long_column_name pragmas are - the name of the column is always the
string that follows the AS keyword.
*Case 2: Non-trivial result set expressions*
--- 27,33 ----
becomes the name of the column in the result set. The AS clause
overrides all other behavior. If an AS clause is present, it does
not matter what the settings of the short_column_name and
! full_column_name pragmas are - the name of the column is always the
string that follows the AS keyword.
*Case 2: Non-trivial result set expressions*
***************
*** 44,50 ****
*Case 3: short_column_names=ON*
If cases 1 and 2 do not apply and short_column_names=ON
! then long_column_names is ignored. The
name of the result set column is the name of the corresponding
table column as it appears in the original CREATE TABLE statement.
So, for example, if you have the following CREATE TABLE:
--- 44,50 ----
*Case 3: short_column_names=ON*
If cases 1 and 2 do not apply and short_column_names=ON
! then full_column_names is ignored. The
name of the result set column is the name of the corresponding
table column as it appears in the original CREATE TABLE statement.
So, for example, if you have the following CREATE TABLE:
***************
*** 63,69 ****
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*
For this case (which was the default prior to version 3.1.0) the
result is the same as for case 2 for simple queries and is the
--- 63,69 ----
in the CREATE TABLE statement are used, not the names in the
SELECT statement.
! *Case 4: short_column_names=OFF and full_column_names=OFF*
For this case (which was the default prior to version 3.1.0) the
result is the same as for case 2 for simple queries and is the
***************
*** 75,85 ****
the table and column from which the data comes, as defined in
the original CREATE TABLE statement.
! *Case 5: short_column_names=OFF and long_column_names=ON*
If cases 1 and 2 do not apply and short_column_names=OFF and
! long_column_names=ON then the names of result set columns are
! constructed by as "TABLE.COLUMN" where TABLE is the name of the
table from which the data is taken and COLUMN is the name of the
column within TABLE from which the data was taken. If the table
is aliased by the use of an AS clause in the FROM expression then
--- 75,85 ----
the table and column from which the data comes, as defined in
the original CREATE TABLE statement.
! *Case 5: short_column_names=OFF and full_column_names=ON*
If cases 1 and 2 do not apply and short_column_names=OFF and
! full_column_names=ON then the result set column name is
! constructed as "TABLE.COLUMN" where TABLE is the name of the
table from which the data is taken and COLUMN is the name of the
column within TABLE from which the data was taken. If the table
is aliased by the use of an AS clause in the FROM expression then
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|