| Commit message (Collapse) | Author | Age | Files | Lines |
|
|
|
|
|
|
| |
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)
|
|\ |
|
| | |
|
| |
| |
| |
| |
| |
| | |
Allow always DROPping of a table which is only referenced by FOREIGN KEY constraints from the same table
Many files:
Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
|
| |
| |
| |
| |
| | |
alter table rename a bit more efficient in case of
lower_case_table_names.
|
| |
| |
| |
| | |
If AUTOCOMMIT=1, then we do not need to make a plain SELECT set shared locks even on the SERIALIZABLE isolation level, because we know the transaction is read-only: a read-only transaction can always be performed on the REPEATABLE READ level, and that does not endanger the serializability
|
| |\
| | |
| | |
| | | |
into mysql.com:/home/kostja/mysql/mysql-4.0-merge
|
| | | |
|
| | | |
|
| |\ \
| | |/
| |/| |
|
| | | |
|
| | | |
|
| | |
| | |
| | |
| | | |
by fixing optimizer bug with help of 'volatile' keyword
|
| | |
| | |
| | |
| | | |
(fixed #bug 2012)
|
| |\ \
| | | |
| | | |
| | | | |
into eagle.mysql.r18.ru:/home/vva/work/BUG_2526/mysql-4.0
|
| | |\ \
| | | | |
| | | | |
| | | | | |
into eagle.mysql.r18.ru:/home/vva/work/BUG_2526/mysql-4.0
|
| | | | | |
|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | | |
(fixed bug #2526 "--init-file crashes MySQL if contains large select")
Such checking usually works in send_ok, send_eof, but in this case large
result causes interim flushing.
|
| |/ / /
| | | |
| | | |
| | | |
| | | |
| | | | |
DROP DATABASE now assumes RAID directories are in hex. (Bug #2627)
Don't increment 'select_full_range' and similar statistics for EXPLAIN queries. (Bug #2506)
Test in configure if pthread_key_delete() exists (to fix compile problem on SCO) (Bug #2461)
|
| | | | |
|
| |\ \ \
| | | | |
| | | | |
| | | | | |
into mysql.com:/home/my/mysql-4.0
|
| | | | |
| | | | |
| | | | |
| | | | | |
from command line did not work.
|
| | | | | |
|
| |\ \ \ \
| | |/ / /
| |/| | |
| | | | | |
into mysql.com:/home/my/mysql-4.0
|
| | | | | |
|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | | |
Now one need only SELECT privilege for tables that are only read in
UPDATE statements with many tables. (Bug #2377).
|
| | | | |
| | | | |
| | | | |
| | | | | |
message when doing LOCK TABLES t1 WRITE; INSERT TABLE t1 SELECT * from t1 (Bug #2296)
|
| |\ \ \ \
| | | | | |
| | | | | |
| | | | | | |
into serg.mylan:/usr/home/serg/Abk/mysql-4.0
|
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | | |
Marked --bdb-no-sync as deprecated
Added --sync-bdb-logs / --disable-sync-bdb-logs as a synonym / alternative.
|
| | | | | |
| | | | | |
| | | | | |
| | | | | | |
"system variable query_prealloc_size can be only global"
|
| |/ / / /
| | | | |
| | | | |
| | | | |
| | | | |
| | | | | |
the thread to be created on some systems)
bug#2599
|
| | | | |
| | | | |
| | | | |
| | | | | |
s/expection/exception
|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | | |
Remove redundant code; parse both the database name and the table name in a FOREIGN KEY constraint with quotes in mind
row0mysql.c, ha_innodb.cc, sql_table.cc:
Return error message Cannot delete or update a parent row... if we try to drop a table which is referenced by a FOREIGN KEY constraint, and the user has not set foreign_key_checks=0
|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | | |
Moved all range checks for TIMESTAMP value to my_gmt_sec().
Also fixed check of upper boundary of TIMESTAMP range (which
also now will catch datetime values which are too small for
TIMESTAMP in case if time_t is unsigned).
|
| |\ \ \ \
| | |/ / /
| |/| | |
| | | | | |
into mysql.com:/home/dlenev/src/mysql-4.0-bg2464
|
| | |/ /
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | | |
values for TIMESTAMP columns. The solution is not perfect since
we just silently ignoring default value for first TIMESTAMP
column and properly reflecting this fact in SHOW CREATE TABLE.
We can't give a warning or simply support standard syntax
(niladic functions as legal value for default) for first field
since it is 4.0 tree.
|
| |\ \ \
| | | | |
| | | | |
| | | | | |
into mysql.com:/home/my/mysql-4.0
|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | | |
handle quoted identifiers and identifiers with space. (Bug #1725)
Fix optimizer tuning bug when first used key part was a constant. (Bug #1679)
|
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
| | | | | |
when we open the HEAP table for the first time since server restart,
in hp_open(), we set a flag to propagate this info to the handler level
which then writes a DELETE FROM this_heap_table to the binlog.
It is not a perfect solution for the bug, because between the server start and
the first open of the table, the slave still had old data in his table so
a SELECT on the slave may show wrong content. But if there is a --init-file
to populate the HEAP table on master as startup, then this is a safe fix
(I'll put a note about init-file in the HEAP section of the manual).
|
| |/ / /
| | | |
| | | |
| | | |
| | | |
| | | |
| | | | |
replicate-wild-do-table"
(as long as replicate-*-table rules were defined, multi-table DELETE was never
replicated by the slave).
|
| |\ \ \
| | | | |
| | | | |
| | | | | |
into mysql.com:/home/my/mysql-4.0
|
| | | | |
| | | | |
| | | | |
| | | | | |
This fixed problem with index reads on character fields with BDB tables. (Bug #2509)
|
| |/ / /
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | | |
INFILE fail":
reset errors (in thd) before executing the event. Otherwise if an event is ignored
because of replicate-*-table rules (error ER_SLAVE_IGNORED_TABLE) this error code
may remain in thd->net and the next event may pick it.
|
| |\ \ \
| | | | |
| | | | |
| | | | | |
into gw.mysql.r18.ru:/usr/home/ram/work/4.0.b2298
|
| | |\ \ \
| | | |/ /
| | |/| |
| | | | | |
into eagle.mysql.r18.ru:/home/vva/work/BUG_2290/mysql-4.0
|
| | | | | |
|
| | | | | |
|
| | |\ \ \
| | | | | |
| | | | | |
| | | | | | |
into mysql.com:/home/mysql_src/mysql-4.0
|
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | | |
do not write the Execute_load_log_event if there was no Create_file_log_event
(empty file).
|
| | | | | | |
|