An error occurred fetching the project authors.
- 01 Dec, 2005 1 commit
-
-
evgen@moonbone.local authored
depending on table order multi_update::send_data() was counting updates, not updated rows. Thus if one record have several updates it will be counted several times in 'rows matched' but updated only once. multi_update::send_data() now counts only unique rows.
-
- 27 Oct, 2005 1 commit
-
-
evgen@moonbone.local authored
Date field was declared as not null, thus expression 'datefield is null' was always false. For SELECT special handling of such cases is used. There 'datefield is null' converted to 'datefield eq "0000-00-00"'. In mysql_update() before creation of select added remove_eq_conds() call. It makes some optimization of conds and in particular performs conversion from 'is null' to 'eq'. Also remove_eq_conds() makes some evaluation of conds and if it founds that conds is always false then update statement is not processed further. All this allows to perform some update statements process faster due to optimized conds, and not wasting resources if conds known to be false.
-
- 24 Oct, 2005 1 commit
-
-
monty@mysql.com authored
-
- 13 Oct, 2005 1 commit
-
-
bell@sanja.is.com.ua authored
- fixed test
-
- 10 Oct, 2005 1 commit
-
-
lars@mysql.com authored
-
- 30 Sep, 2005 1 commit
-
-
sergefp@mysql.com authored
optimization: now can use index to find records to update/delete when there is no WHERE clause.
-
- 25 Sep, 2005 1 commit
-
-
monty@mysql.com authored
-
- 15 Feb, 2005 1 commit
-
-
mats@mysql.com authored
reading tables in "complex" SQL statements. If inserts happen in a table being read, the statements have no serialization order and the change can therefore not be reproduced on the slave.
-
- 02 Feb, 2005 2 commits
-
-
monty@mysql.com authored
-
serg@serg.mylan authored
don't define UNIV_DEBUG in CFLAGS/CXXFLAGS anymore sql/mysqld.cc hide from the user options that do nothing sql/sql_update.cc better fix for uninitialized used_index
-
- 30 Jan, 2005 1 commit
-
-
acurtis@pcgem.rdg.cyberkinetica.com authored
Fix replication for multi-update new test - rpl_multi_update2
-
- 24 Jan, 2005 1 commit
-
-
serg@serg.mylan authored
-
- 31 Dec, 2004 1 commit
-
-
monty@mysql.com authored
This allows use to use INSERT IGNORE ... ON DUPLICATE ...
-
- 18 Dec, 2004 2 commits
-
-
-
Add in missing privilege checks. Tests for the privileges.
-
- 09 Dec, 2004 1 commit
-
-
dlenev@brandersnatch.localdomain authored
tables requires privileges for them if some table or column level grants present" (with after-review fixes). We should set SELECT_ACL for implicitly opened tables in my_tz_check_n_skip_implicit_tables() to be able to bypass privilege checking in check_grant(). Also we should exclude those tables from privilege checking in multi-update.
-
- 06 Dec, 2004 1 commit
-
-
mskold@mysql.com authored
-
- 03 Dec, 2004 1 commit
-
-
mats@mysql.com authored
CREATE DATABASE statement used the current database instead of the database created when checking conditions for replication. CREATE/DROP/ALTER DATABASE statements are now replicated based on the manipulated database.
-
- 28 Nov, 2004 1 commit
-
-
mskold@mysql.com authored
-
- 07 Oct, 2004 1 commit
-
-
monty@mysql.com authored
Some bigger code changes was necessary becasue of the multi-table-update and the new HANDLER code
-
- 05 Oct, 2004 1 commit
-
-
monty@mysql.com authored
Cleaned up patch for checking locks for multi-table updates
-
- 02 Oct, 2004 1 commit
-
-
Ensures that WRITE lock is not obtained on all tables referenced.
-
- 01 Oct, 2004 1 commit
-
-
dlenev@brandersnatch.localdomain authored
column types TIMESTAMP is NOT NULL by default, so in order to have TIMESTAMP column holding NULL valaues you have to specify NULL as one of its attributes (this needed for backward compatibility). Main changes: Replaced TABLE::timestamp_default_now/on_update_now members with TABLE::timestamp_auto_set_type flag which is used everywhere for determining if we should auto-set value of TIMESTAMP field during this operation or not. We are also use Field_timestamp::set_time() instead of handler::update_timestamp() in handlers.
-
- 17 Sep, 2004 1 commit
-
-
We don't want the update to abort when IGNORE is specified
-
- 08 Sep, 2004 1 commit
-
-
bell@sanja.is.com.ua authored
-
- 08 Jul, 2004 1 commit
-
-
monty@mysql.com authored
New handler::index_flags() definition to make it easy to check the full used key and a specific key part. Added key part to optimize_range() to fix problems when using fields in key parts.
-
- 23 Jun, 2004 1 commit
-
-
serg@serg.mylan authored
more logical table/index_flags return HA_ERR_WRONG_COMMAND instead of abstract methods where appropriate max_keys and other limits renamed to max_supported_keys/etc max_keys/etc are now wrappers to max_supported_keys/etc ha_index_init/ha_rnd_init/ha_index_end/ha_rnd_end are now wrappers to real {index,rnd}_{init,end} to enforce strict pairing
-
- 09 Jun, 2004 1 commit
-
-
guilhem@mysql.com authored
binlog even if they changed nothing, and a test for this. This is useful when users use these commands to clean up their master and slave by issuing one command on master (assume master and slave have slightly different data for some reason and you want to clean up both). Note that I have not changed multi-table DELETE and multi-table UPDATE because their error-reporting mechanism is more complicated.
-
- 05 May, 2004 1 commit
-
-
bell@sanja.is.com.ua authored
SQL_SELECT_LIMIT as default will be applied only for SELECT statement if there was not explicit LIMIT clause correct table list passed to class constructor of select_update
-
- 04 May, 2004 2 commits
-
-
Sinisa@sinisa.nasamreza.org authored
but used in a nested query.
-
monty@mysql.com authored
Fixed security problem that password was temporarly reset when someone changed GRANT for a user. (Bug #3404) Fixed problem with PROCEDURE analyse() and impossible WHERE (Bug #2238) Don't auto-repair tables in mysqlcheck if table type doesn't support 'check' command.
-
- 09 Apr, 2004 1 commit
-
-
bell@sanja.is.com.ua authored
-
- 07 Apr, 2004 1 commit
-
-
bell@sanja.is.com.ua authored
fixed IN subselect with basic constant left expression SQLCOM_CREATE_TABLE, SQLCOM_UPDATE_MULTI, SQLCOM_REPLACE_SELECT, SQLCOM_INSERT_SELECT, QLCOM_DELETE_MULTI fixed to be compatible with PS (BUG#3398, BUG#3406) fixed multiupdate privelege check (BUG#3408) fixed multiupdate tables check (BUG#3411) unchecked commands now is rejected by PS protocol to avoid serever crash fixed cleunup procedure to be compatible sith DO/SET (BUG#3393)
-
- 02 Apr, 2004 1 commit
-
-
dlenev@jabberwock.localdomain authored
Final version of patch. Adds support for specifying of DEFAULT NOW() and/or ON UPDATE NOW() clauses for TIMESTAMP field definition. Current implementation allows only one such field per table and uses several unireg types for storing info about this properties of field. It should be replaced with better implementation when new .frm format is introduced.
-
- 20 Mar, 2004 1 commit
-
-
bell@sanja.is.com.ua authored
-
- 18 Mar, 2004 1 commit
-
-
bell@sanja.is.com.ua authored
small optimisation in signed_literal
-
- 11 Mar, 2004 1 commit
-
-
monty@mysql.com authored
Ensure that install_test_db.sh script works with both 'make install' and 'make_binary_distribution' layouts Abort if we can't allocate memory for table cache Fix bug with multi-update-tables and BDB tables.
-
- 04 Mar, 2004 1 commit
-
-
monty@mysql.com authored
nsure that rows in a multi-row INSERT DELAYED are inserted atomicly
-
- 16 Feb, 2004 2 commits
-
-
bell@sanja.is.com.ua authored
-
monty@mysql.com authored
Added more DBUG statements Ensure that we are comparing end space with BINARY strings Use 'any_db' instead of '' to mean any database. (For HANDLER command) Only strip ' ' when comparing CHAR, not other space-like characters (like \t)
-