- 26 Sep, 2010 2 commits
-
-
Igor Babaev authored
-
Igor Babaev authored
The condition over the outer tables now are extracted from the on condition of any outer join. This condition is saved in a special field of the JOIN_TAB structure for the first inner table of the outer join. The condition is checked before the first inner table is accessed. If it turns out to be false the table is not accessed at all and a null complemented row is generated immediately.
-
- 25 Sep, 2010 2 commits
-
-
Igor Babaev authored
-
Igor Babaev authored
the setting of optimizer switch for table elimination.
-
- 23 Sep, 2010 1 commit
-
-
Igor Babaev authored
-
- 21 Sep, 2010 1 commit
-
-
Igor Babaev authored
The implementation of the virtual method not_null_tables for the class Item_outer_ref must always return 0.
-
- 20 Sep, 2010 3 commits
-
-
Igor Babaev authored
-
Sergei Golubchik authored
-
Igor Babaev authored
Made sure that rr_quick is used to read the next record whenever a quick select is used to retrieve the table records.
-
- 18 Sep, 2010 1 commit
-
-
Sergei Golubchik authored
-
- 15 Sep, 2010 2 commits
-
-
Michael Widenius authored
-
Michael Widenius authored
Fixed crashing bug when doing ALTER TABLE RENAME with transactional tables. client/mysqltest.cc: Added errno to error message for system calls (delete, rename etc) Write error message for failures of system calls mysql-test/include/cleanup_fake_relay_log.inc: Disable warnings for remove_file mysql-test/include/diff_tables.inc: Disable warnings for remove_file mysql-test/include/maria_empty_logs.inc: Disable warnings for remove_file mysql-test/include/maria_make_snapshot.inc: Disable warnings for remove_file mysql-test/include/maria_make_snapshot_for_feeding_recovery.inc: Disable warnings for remove_file mysql-test/include/mysqlhotcopy.inc: Disable warnings for remove_file mysql-test/include/ndb_backup.inc: Disable warnings for remove_file mysql-test/include/ndb_backup_print.inc: Disable warnings for remove_file mysql-test/r/alter_table_trans.result: Test of crashing ALTER TABLE RENAME bug mysql-test/t/alter_table_trans.test: Test of crashing ALTER TABLE RENAME bug mysql-test/t/mysqltest.test: Disable warnings for remove_file and move_file mysys/my_copy.c: Fixed wrong error message sql/sql_table.cc: Fixed crashing bug when doing ALTER TABLE RENAME with transactional tables.
-
- 14 Sep, 2010 4 commits
-
-
unknown authored
-
Sergey Petrunya authored
-
Sergey Petrunya authored
-
Sergei Golubchik authored
libtool does not like it and fails the build.
-
- 13 Sep, 2010 5 commits
-
-
Sergei Golubchik authored
-
Igor Babaev authored
-
Michael Widenius authored
-
Michael Widenius authored
- When reopening table during recovery, don't set file length from file sizes as file is not flushed. New feature in Aria recovery: - Create database directory if missing. storage/maria/ma_recovery.c: Don't print Query: twice when running maria_read_log Create database directory if missing. (Needed when running maria_read_log on an empty database direcory during testing) More DBUG_print Fixed bug: When reopening table during recovery, don't set file length from file sizes as file is not flushed.
-
Igor Babaev authored
-
- 12 Sep, 2010 2 commits
-
-
Igor Babaev authored
-
Igor Babaev authored
-
- 11 Sep, 2010 2 commits
-
-
Igor Babaev authored
The problem could be demonstrated with an outer join of two single-row tables where the values of the join attributes were null. Any query with such a join could return a wrong result set if the where condition of the query was not empty. For queries with empty where conditions the result sets were correct. This was the consequence of two bugs in the code: - Item_equal objects for on conditions of outer joins were not built if the processed query had no where condition - the check for null values in the code that evaluated constant Item_equal objects was incorrect. Fixed both above problems. Added a test case for the bug and adjusted results for some other test cases.
-
Sergei Golubchik authored
-
- 10 Sep, 2010 2 commits
-
-
Michael Widenius authored
Fix for LP#634943 "marked as crashed", "zerofilling" and "wrong data in bitmap" when recovering Aria tables This was an interaction of several bugs: - Tables marked as opened was not properly unmarked on recovery if there was not changes since checkpoint - zerofill of tables put wrong data in bitmap if directory for page was full - Tables was thought as 'moved' during recovery if they had a create_lsn bigger than the lsn in the control file. storage/maria/ha_maria.cc: If table is moved and crashed, threat it as crashed. (Not a related to this bug, but still good to have fixed) storage/maria/ma_blockrec.c: Make enough_free_entries_on_page() global storage/maria/ma_blockrec.h: Make enough_free_entries_on_page() global storage/maria/ma_check.c: If directory is full, mark page full. Fixes bug in zerofill storage/maria/ma_open.c: Don't marke files as MOVED during recovery if create_trid > trnman_max_trid, as this fails for tables created after checkpoint. storage/maria/ma_recovery.c: Reset open_count in file that was open during crash and was part of checkpoint. Fixed wrong warning of 'open count' after recovery of files that was not touched since checkpoint. storage/maria/maria_chk.c: Changed not documented option --log-dir to --logdir Document more of the options. Clean up output for --help storage/maria/trnman.c: Added DBUG_PRINT
-
Igor Babaev authored
When not-exists optimization was applied to a table that happened to be an inner table of two outer joins, one embedded into another, then setting the match flag for the embedding outer join on could be skipped. This caused generation of extra null complemented rows. Made sure that the match flags are set correctly in all cases when not-exists optimization is used.
-
- 09 Sep, 2010 3 commits
-
-
Michael Widenius authored
Extend remove_function_from_trace.pl to work with many threads (patch from Sergei) dbug/remove_function_from_trace.pl: Extend remove_function_from_trace.pl to work with many threads (patch from Sergei) storage/maria/ma_bitmap.c: Added marker that table had changed since last checkpoint. This ensures that we will flush all bitmap pages from cache at checkpoint. This fixes bug LP#605798 "wrong data in bitmap" after recovery. storage/maria/ma_check.c: Cleaned up error output storage/maria/ma_recovery.c: Cleaned up error output storage/maria/maria_def.h: Added changed_not_flushed
-
Michael Widenius authored
Don't give warning about block_insert if table is crashed. scripts/mysql_install_db.sh: Added link to KB. storage/maria/ma_recovery.c: Don't give warning about block_insert if table is crashed.
-
Sergei Golubchik authored
double compilation
-
- 08 Sep, 2010 2 commits
-
-
Michael Widenius authored
-
Michael Widenius authored
Write message to stderr if recovery is not likely to succeed because we don't log records for batch inserts. Don't do UNDO or REDO on a crashed table. More DBUG_PRINT sql/sql_parse.cc: Remove display of 'packet' which is not useful storage/maria/ma_blockrec.c: More DBUG_PRINT() storage/maria/ma_key_recover.c: Write page number instead of page position storage/maria/ma_recovery.c: Write message to stderr if recovery is not likely to succeed because we don't log records for batch inserts. In normal cases this should never be an issue as we would recreate an empty table if MariaDB dies under batch insert. This warning will be given if you remove all tables and try to recreate them with maria_read_log, which can't be done as the log doesn't contain all data. Don't do UNDO or REDO on a crashed table. storage/maria/ma_write.c: Write page number instead of page position.
-
- 07 Sep, 2010 6 commits
-
-
Michael Widenius authored
Fixed typo that caused warnings from mysql-test-run mysql-test/mysql-test-run.pl: Fixed typo sql/mysqld.cc: Give a more precise warning why something fails.
-
Michael Widenius authored
-
Michael Widenius authored
mysql-test/mysql-test-run.pl: Added suppression mysql-test/t/upgrade.test: Added missing path
-
Michael Widenius authored
Fixed test failures in buildbot Don't write errors when failing to send ok packet mysql-test/suite/pbxt/r/range.result: Don't write number of rows as it varies. mysql-test/suite/pbxt/t/range.test: Don't write number of rows as it varies. sql/mysqld.cc: Don't write errors when failing to send ok packet storage/maria/ma_bitmap.c: Added DBUG_ASSERT to detect wrong bitmap pages storage/maria/ma_blockrec.c: Don't reset BLOCKUSED_USE_ORG_BITMAP flag. This fixed a bug where bitmap could be wrong after UNDO of row with blobs
-
Michael Widenius authored
storage/maria/ha_maria.cc: Don't use 'trn' variable to avoid warning about not used variable storage/maria/ma_delete.c: Added __attribute__((unused)) storage/maria/ma_key_recover.c: Added __attribute__((unused)) Fixed wrong placement of #endif storage/maria/ma_key_recover.h: Fixed typo
-
Michael Widenius authored
-
- 06 Sep, 2010 1 commit
-
-
unknown authored
(It is not legal C to do pointer arithmetics on void *).
-
- 05 Sep, 2010 1 commit
-
-
Michael Widenius authored
-