summaryrefslogtreecommitdiff
path: root/mysql-test/r/warnings.result
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2003-08-19 00:08:08 +0300
committerunknown <monty@mashka.mysql.fi>2003-08-19 00:08:08 +0300
commit2901c3b8fa7d4095445c6ca2070367d2f61af2d1 (patch)
treedf4f8c8cf4d399e322333c5516d5c19507b1fda8 /mysql-test/r/warnings.result
parent034b44cb9ff914ceb6d32706a3a284eda00891b3 (diff)
downloadmariadb-git-2901c3b8fa7d4095445c6ca2070367d2f61af2d1.tar.gz
After merge fixes
Use server character set if --default-character-set is not used Added convert_string() for more efficient alloc+character-set convert of strings BitKeeper/deleted/.del-convert.result~a3b56e1db6f498e9: Delete: mysql-test/r/convert.result BitKeeper/deleted/.del-convert.test~f4ceb743194dfe72: Delete: mysql-test/t/convert.test BitKeeper/deleted/.del-make_win_src_distribution.old~5c9ebdc4a852b43b: Delete: scripts/make_win_src_distribution.old client/mysql.cc: Use server character set if --default-character-set is not used client/mysqltest.c: Code cleanup (merge identical code) More debug messages heap/hp_create.c: After merge fix include/m_ctype.h: After merge fix include/my_global.h: Remove size_str (we already have size_s) include/mysql_com.h: After merge fix libmysql/libmysql.c: After merge fix libmysqld/Makefile.am: After merge fix mysql-test/r/auto_increment.result: After merge fix mysql-test/r/create.result: After merge fix mysql-test/r/ctype_latin1_de.result: After merge fix mysql-test/r/distinct.result: After merge fix mysql-test/r/drop.result: After merge fix mysql-test/r/fulltext.result: After merge fix mysql-test/r/func_gconcat.result: After merge fix mysql-test/r/func_str.result: After merge fix mysql-test/r/func_test.result: After merge fix mysql-test/r/grant.result: After merge fix mysql-test/r/group_by.result: After merge fix mysql-test/r/handler.result: After merge fix mysql-test/r/heap.result: After merge fix mysql-test/r/heap_btree.result: After merge fix mysql-test/r/heap_hash.result: After merge fix mysql-test/r/innodb.result: After merge fix mysql-test/r/insert.result: After merge fix mysql-test/r/insert_select.result: After merge fix mysql-test/r/join_outer.result: After merge fix mysql-test/r/key.result: After merge fix mysql-test/r/key_cache.result: After merge fix mysql-test/r/loaddata.result: After merge fix mysql-test/r/myisam.result: After merge fix mysql-test/r/null.result: After merge fix mysql-test/r/null_key.result: After merge fix mysql-test/r/order_by.result: After merge fix mysql-test/r/rpl_do_grant.result: After merge fix mysql-test/r/rpl_error_ignored_table.result: After merge fix mysql-test/r/rpl_ignore_grant.result: After merge fix mysql-test/r/rpl_loaddata.result: After merge fix mysql-test/r/rpl_log.result: After merge fix mysql-test/r/rpl_log_pos.result: After merge fix mysql-test/r/rpl_max_relay_size.result: After merge fix mysql-test/r/rpl_replicate_do.result: After merge fix mysql-test/r/rpl_reset_slave.result: After merge fix mysql-test/r/rpl_rotate_logs.result: After merge fix mysql-test/r/rpl_user_variables.result: After merge fix mysql-test/r/select.result: After merge fix mysql-test/r/select_safe.result: After merge fix mysql-test/r/subselect.result: After merge fix mysql-test/r/type_blob.result: After merge fix mysql-test/r/type_decimal.result: After merge fix mysql-test/r/type_float.result: After merge fix mysql-test/r/type_ranges.result: After merge fix mysql-test/r/type_time.result: After merge fix mysql-test/r/type_uint.result: After merge fix mysql-test/r/union.result: After merge fix mysql-test/r/warnings.result: After merge fix mysql-test/t/auto_increment.test: After merge fix mysql-test/t/case.test: After merge fix mysql-test/t/ctype_collate.test: After merge fix mysql-test/t/ctype_latin1_de.test: After merge fix mysql-test/t/drop.test: After merge fix mysql-test/t/func_in.test: After merge fix mysql-test/t/func_set.test: After merge fix mysql-test/t/func_str.test: After merge fix mysql-test/t/func_test.test: After merge fix mysql-test/t/grant.test: After merge fix mysql-test/t/group_by.test: After merge fix mysql-test/t/handler.test: After merge fix mysql-test/t/heap.test: After merge fix mysql-test/t/heap_btree.test: After merge fix mysql-test/t/heap_hash.test: After merge fix mysql-test/t/innodb.test: After merge fix mysql-test/t/insert_select.test: After merge fix mysql-test/t/key.test: After merge fix mysql-test/t/key_cache.test: After merge fix mysql-test/t/lock_tables_lost_commit-master.opt: After merge fix mysql-test/t/lock_tables_lost_commit.test: After merge fix mysql-test/t/myisam.test: After merge fix mysql-test/t/row.test: After merge fix mysql-test/t/subselect.test: After merge fix mysql-test/t/type_decimal.test: After merge fix mysql-test/t/type_ranges.test: After merge fix mysql-test/t/type_uint.test: After merge fix mysql-test/t/variables.test: After merge fix mysql-test/t/warnings.test: After merge fix scripts/make_win_src_distribution.sh: after merge fixes sql-common/client.c: After merge fix Change my_connect() to use poll() If character set is not given, use servers character set. sql/field.cc: After merge fix Don't give warnings when storing data in fields in optimizer. sql/ha_myisammrg.h: After merge fix sql/log.cc: After merge fix sql/log_event.cc: After merge fix sql/mysqld.cc: After merge fix sql/opt_range.cc: After merge fix sql/set_var.cc: Code cleanup Fixed wrong usage of base_names (like medium.key_buffer) that caused core dumps sql/set_var.h: Fixed wrong usage of base_names (like medium.key_buffer) that caused core dumps sql/slave.cc: After merge fix sql/sql_acl.cc: After merge fix Code cleanup sql/sql_class.cc: Added convert_string() for more efficient alloc+character-set convert of strings Add cached flags to avoid calling mysql_charset_same() during parsing. sql/sql_class.h: Added convert_string() for more efficient alloc+character-set convert of strings Add cached flags to avoid calling mysql_charset_same() during parsing. sql/sql_handler.cc: After merge fix sql/sql_lex.h: After merge fix sql/sql_parse.cc: Optimize and fix memory reference errors reported by valgrind sql/sql_repl.cc: After merge fix sql/sql_yacc.yy: After merge fix Avoid calling mysql_charset_same() when parsing identifiers strings/ctype-latin1.c: Port latin_de conversion code from 4.0
Diffstat (limited to 'mysql-test/r/warnings.result')
-rw-r--r--mysql-test/r/warnings.result91
1 files changed, 46 insertions, 45 deletions
diff --git a/mysql-test/r/warnings.result b/mysql-test/r/warnings.result
index 0ad165a861a..9d4710ff729 100644
--- a/mysql-test/r/warnings.result
+++ b/mysql-test/r/warnings.result
@@ -2,23 +2,24 @@ drop table if exists t1, t2;
Warnings:
Note 1051 Unknown table 't1'
Note 1051 Unknown table 't2'
+SET SQL_WARNINGS=1;
create table t1 (a int);
insert into t1 values (1);
insert into t1 values ("hej");
Warnings:
-Warning 1263 Data truncated for column 'a' at row 1
+Warning 1264 Data truncated for column 'a' at row 1
insert into t1 values ("hej"),("då");
Warnings:
-Warning 1263 Data truncated for column 'a' at row 1
-Warning 1263 Data truncated for column 'a' at row 2
+Warning 1264 Data truncated for column 'a' at row 1
+Warning 1264 Data truncated for column 'a' at row 2
set SQL_WARNINGS=1;
insert into t1 values ("hej");
Warnings:
-Warning 1263 Data truncated for column 'a' at row 1
+Warning 1264 Data truncated for column 'a' at row 1
insert into t1 values ("hej"),("då");
Warnings:
-Warning 1263 Data truncated for column 'a' at row 1
-Warning 1263 Data truncated for column 'a' at row 2
+Warning 1264 Data truncated for column 'a' at row 1
+Warning 1264 Data truncated for column 'a' at row 2
drop table t1;
set SQL_WARNINGS=0;
drop temporary table if exists not_exists;
@@ -45,13 +46,13 @@ drop table t1;
create table t1(a tinyint, b int not null, c date, d char(5));
load data infile '../../std_data/warnings_loaddata.dat' into table t1 fields terminated by ',';
Warnings:
-Warning 1261 Data truncated, NULL supplied to NOT NULL column 'b' at row 2
-Warning 1263 Data truncated for column 'd' at row 3
-Warning 1263 Data truncated for column 'c' at row 4
-Warning 1259 Record count is fewer than the column count at row 5
-Warning 1263 Data truncated for column 'b' at row 6
-Warning 1260 Record count is more than the column count at row 7
-Warning 1262 Data truncated, out of range for column 'a' at row 8
+Warning 1262 Data truncated, NULL supplied to NOT NULL column 'b' at row 2
+Warning 1264 Data truncated for column 'd' at row 3
+Warning 1264 Data truncated for column 'c' at row 4
+Warning 1260 Record count is fewer than the column count at row 5
+Warning 1264 Data truncated for column 'b' at row 6
+Warning 1261 Record count is more than the column count at row 7
+Warning 1263 Data truncated, out of range for column 'a' at row 8
select @@warning_count;
@@warning_count
7
@@ -59,42 +60,42 @@ drop table t1;
create table t1(a tinyint NOT NULL, b tinyint unsigned, c char(5));
insert into t1 values(NULL,100,'mysql'),(10,-1,'mysql ab'),(500,256,'open source'),(20,NULL,'test');
Warnings:
-Warning 1261 Data truncated, NULL supplied to NOT NULL column 'a' at row 1
-Warning 1262 Data truncated, out of range for column 'b' at row 2
-Warning 1263 Data truncated for column 'c' at row 2
-Warning 1262 Data truncated, out of range for column 'a' at row 3
-Warning 1262 Data truncated, out of range for column 'b' at row 3
-Warning 1263 Data truncated for column 'c' at row 3
+Warning 1262 Data truncated, NULL supplied to NOT NULL column 'a' at row 1
+Warning 1263 Data truncated, out of range for column 'b' at row 2
+Warning 1264 Data truncated for column 'c' at row 2
+Warning 1263 Data truncated, out of range for column 'a' at row 3
+Warning 1263 Data truncated, out of range for column 'b' at row 3
+Warning 1264 Data truncated for column 'c' at row 3
alter table t1 modify c char(4);
Warnings:
-Warning 1263 Data truncated for column 'c' at row 1
-Warning 1263 Data truncated for column 'c' at row 2
+Warning 1264 Data truncated for column 'c' at row 1
+Warning 1264 Data truncated for column 'c' at row 2
alter table t1 add d char(2);
update t1 set a=NULL where a=10;
Warnings:
-Warning 1261 Data truncated, NULL supplied to NOT NULL column 'a' at row 2
+Warning 1262 Data truncated, NULL supplied to NOT NULL column 'a' at row 2
update t1 set c='mysql ab' where c='test';
Warnings:
-Warning 1263 Data truncated for column 'c' at row 4
+Warning 1264 Data truncated for column 'c' at row 4
update t1 set d=c;
Warnings:
-Warning 1263 Data truncated for column 'd' at row 1
-Warning 1263 Data truncated for column 'd' at row 2
-Warning 1263 Data truncated for column 'd' at row 3
-Warning 1263 Data truncated for column 'd' at row 4
+Warning 1264 Data truncated for column 'd' at row 1
+Warning 1264 Data truncated for column 'd' at row 2
+Warning 1264 Data truncated for column 'd' at row 3
+Warning 1264 Data truncated for column 'd' at row 4
create table t2(a tinyint NOT NULL, b char(3));
insert into t2 select b,c from t1;
Warnings:
-Warning 1263 Data truncated for column 'b' at row 1
-Warning 1263 Data truncated for column 'b' at row 2
-Warning 1263 Data truncated for column 'b' at row 3
-Warning 1261 Data truncated, NULL supplied to NOT NULL column 'a' at row 4
-Warning 1263 Data truncated for column 'b' at row 4
+Warning 1264 Data truncated for column 'b' at row 1
+Warning 1264 Data truncated for column 'b' at row 2
+Warning 1264 Data truncated for column 'b' at row 3
+Warning 1262 Data truncated, NULL supplied to NOT NULL column 'a' at row 4
+Warning 1264 Data truncated for column 'b' at row 4
insert into t2(b) values('mysqlab');
set sql_warnings=1;
insert into t2(b) values('mysqlab');
Warnings:
-Warning 1263 Data truncated for column 'b' at row 1
+Warning 1264 Data truncated for column 'b' at row 1
set sql_warnings=0;
drop table t1, t2;
create table t1(a char(10));
@@ -102,24 +103,24 @@ alter table t1 add b char;
set max_error_count=10;
update t1 set b=a;
Warnings:
-Warning 1263 Data truncated for column 'b' at row 1
-Warning 1263 Data truncated for column 'b' at row 2
-Warning 1263 Data truncated for column 'b' at row 3
-Warning 1263 Data truncated for column 'b' at row 4
-Warning 1263 Data truncated for column 'b' at row 5
-Warning 1263 Data truncated for column 'b' at row 6
-Warning 1263 Data truncated for column 'b' at row 7
-Warning 1263 Data truncated for column 'b' at row 8
-Warning 1263 Data truncated for column 'b' at row 9
-Warning 1263 Data truncated for column 'b' at row 10
+Warning 1264 Data truncated for column 'b' at row 1
+Warning 1264 Data truncated for column 'b' at row 2
+Warning 1264 Data truncated for column 'b' at row 3
+Warning 1264 Data truncated for column 'b' at row 4
+Warning 1264 Data truncated for column 'b' at row 5
+Warning 1264 Data truncated for column 'b' at row 6
+Warning 1264 Data truncated for column 'b' at row 7
+Warning 1264 Data truncated for column 'b' at row 8
+Warning 1264 Data truncated for column 'b' at row 9
+Warning 1264 Data truncated for column 'b' at row 10
select @@warning_count;
@@warning_count
50
drop table t1;
create table t1 (id int) type=isam;
Warnings:
-Warning 1264 Using storage engine MYISAM for table 't1'
+Warning 1265 Using storage engine MYISAM for table 't1'
alter table t1 type=isam;
Warnings:
-Warning 1264 Using storage engine MYISAM for table 't1'
+Warning 1265 Using storage engine MYISAM for table 't1'
drop table t1;