diff options
| author | unknown <heikki@hundin.mysql.fi> | 2004-03-17 19:37:48 +0200 |
|---|---|---|
| committer | unknown <heikki@hundin.mysql.fi> | 2004-03-17 19:37:48 +0200 |
| commit | 68273f0f84597c92a8b727f415564df87bcdb0a5 (patch) | |
| tree | c5d75fedad7590ad42c86f32a245754a2a6e548e /include/my_base.h | |
| parent | 8bdbfee96b876e48387cdc14d6b44a18d82a1043 (diff) | |
| download | mariadb-git-68273f0f84597c92a8b727f415564df87bcdb0a5.tar.gz | |
Many files:
Fix Bug #1942: do not retrieve all columns in a table if we only need the 'ref' of the row (usually, the PRIMARY KEY) to calculate an ORDER BY
innobase/dict/dict0dict.c:
Fix Bug #1942: do not retrieve all columns in a table if we only need the 'ref' of the row (usually, the PRIMARY KEY) to calculate an ORDER BY
innobase/include/dict0dict.h:
Fix Bug #1942: do not retrieve all columns in a table if we only need the 'ref' of the row (usually, the PRIMARY KEY) to calculate an ORDER BY
innobase/include/row0mysql.h:
Fix Bug #1942: do not retrieve all columns in a table if we only need the 'ref' of the row (usually, the PRIMARY KEY) to calculate an ORDER BY
sql/ha_innodb.cc:
Fix Bug #1942: do not retrieve all columns in a table if we only need the 'ref' of the row (usually, the PRIMARY KEY) to calculate an ORDER BY
sql/sql_select.cc:
Fix Bug #1942: do not retrieve all columns in a table if we only need the 'ref' of the row (usually, the PRIMARY KEY) to calculate an ORDER BY
include/my_base.h:
Fix Bug #1942: do not retrieve all columns in a table if we only need the 'ref' of the row (usually, the PRIMARY KEY) to calculate an ORDER BY
Diffstat (limited to 'include/my_base.h')
| -rw-r--r-- | include/my_base.h | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/include/my_base.h b/include/my_base.h index e2b6d010d69..cfdab6a49ba 100644 --- a/include/my_base.h +++ b/include/my_base.h @@ -131,10 +131,14 @@ enum ha_extra_function { HA_EXTRA_IGNORE_DUP_KEY, /* Dup keys don't rollback everything*/ HA_EXTRA_NO_IGNORE_DUP_KEY, /* - Instructs InnoDB to retrieve all columns, not just those where - field->query_id is the same as the current query id + Instructs InnoDB to retrieve all columns (except in key read), not just + those where field->query_id is the same as the current query id */ HA_EXTRA_RETRIEVE_ALL_COLS, + /* + Instructs InnoDB to retrieve at least all the primary key columns + */ + HA_EXTRA_RETRIEVE_PRIMARY_KEY, HA_EXTRA_PREPARE_FOR_DELETE, HA_EXTRA_PREPARE_FOR_UPDATE, /* Remove read cache if problems */ HA_EXTRA_PRELOAD_BUFFER_SIZE /* Set buffer size for preloading */ |