diff options
author | Michael Widenius <monty@askmonty.org> | 2010-05-13 14:00:53 +0300 |
---|---|---|
committer | Michael Widenius <monty@askmonty.org> | 2010-05-13 14:00:53 +0300 |
commit | 6659ad49fef7adf8fdf4db78403bbb45accc169b (patch) | |
tree | e4f9c37644dd4dd5e9755e703e2087406d367f02 /mysql-test/suite/binlog/r/binlog_stm_unsafe_warning.result | |
parent | 8b2abdcf41da724c3685be85611ace237f085374 (diff) | |
download | mariadb-git-6659ad49fef7adf8fdf4db78403bbb45accc169b.tar.gz |
Fixes after last merge of MySQL 5.1
- INSERT with RAND() doesn't require row based logging again
- Some bugs fixed in opt_range() where we table->key_read was wrongly used
.bzrignore:
Ignore new xtstat binary
mysql-test/r/index_merge_myisam.result:
Update results (old result was wrong)
mysql-test/suite/binlog/r/binlog_stm_binlog.result:
Added drop table first
mysql-test/suite/binlog/r/binlog_stm_unsafe_warning.result:
Added test for when RAND() requires row based logging
mysql-test/suite/binlog/t/binlog_stm_binlog.test:
Added drop table first
mysql-test/suite/binlog/t/binlog_stm_unsafe_warning.test:
Added test for when RAND() requires row based logging
scripts/make_binary_distribution.sh:
Removed type from last commit
sql/item_create.cc:
Don't require row based logging when using RAND() with INSERT
sql/opt_range.cc:
Revert wrong patch from Oracle:
- As QUICK_RANGE_SELECT uses it's own 'file' handler to the tables, one can't use 'table->key_read' as a flag to detect if index only read (keyread) is used or not
- Don't set keyread if keyread is already enabled
- Don't disable key read, if we didn't enable it ourselves
- Simplify code (and ensure that we do proper cleanup of index only read)
sql/opt_range.h:
Added flags to detect if the range optimizer enabled index only read (key read) or not
sql/opt_sum.cc:
Use our more optimized macros
sql/sql_lex.h:
Added 'readable' function to check if we are in a sub query function or not (not normal query or sub query in FROM clause)
sql/sql_select.cc:
Use our more optimized keyread macros
Added ASSERTS early
Simplify code on eliminate_item_equal()
Fixed that substitute_for_best_equal_field() doesn't core dump in case of out of memory conditions.
Removed not needed test for 'field->maybe_null()'
Replaced master_unit()->item with is_subquery_function() (More readable)
sql/sql_update.cc:
Use our more optimized keyread macros
sql/table.cc:
Use our more optimized keyread macros
sql/table.h:
Use separate functions to enable/disable Index only reads
- Safer, more readable, better logging and faster.
Diffstat (limited to 'mysql-test/suite/binlog/r/binlog_stm_unsafe_warning.result')
-rw-r--r-- | mysql-test/suite/binlog/r/binlog_stm_unsafe_warning.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_stm_unsafe_warning.result b/mysql-test/suite/binlog/r/binlog_stm_unsafe_warning.result index edbd878982b..eb056468f60 100644 --- a/mysql-test/suite/binlog/r/binlog_stm_unsafe_warning.result +++ b/mysql-test/suite/binlog/r/binlog_stm_unsafe_warning.result @@ -48,3 +48,16 @@ SET GLOBAL log_warnings = @old_log_warnings; # Count the number of times the "Unsafe" message was printed # to the error log. Occurrences: 1 +create table t1 (n1 int, n2 int, n3 int, +key (n1, n2, n3), +key (n2, n3, n1), +key (n3, n1, n2)); +insert into t1 values (1,1,1); +insert into t1 values (RAND()*1000+10, RAND()*1000+10, RAND()*1000+10); +update t1 set n1=rand() where n1=1; +Warnings: +Note 1592 Statement may not be safe to log in statement format. +delete from t1 where n2=1 + rand()*0; +Warnings: +Note 1592 Statement may not be safe to log in statement format. +drop table t1; |