summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2004-02-09 13:59:41 +0100
committerunknown <monty@mysql.com>2004-02-09 13:59:41 +0100
commit74b81a801785058706b46a1e75b67b026c468d04 (patch)
tree8a4c27f40f9f6b198bd0c9b9b5a7bf3c49138f78 /mysql-test/t
parent1c810278bd5e1d69f8612b047784e46b4ba7cd46 (diff)
downloadmariadb-git-74b81a801785058706b46a1e75b67b026c468d04.tar.gz
Ensure that result from date_format() is binary
Removed warnings from test suite mysql-test/r/ctype_utf8.result: Update results after fix of return argument from date_format() mysql-test/r/date_formats.result: Remove unnecessary warnings mysql-test/r/type_decimal.result: Remove unnecessary warnings mysql-test/r/warnings.result: Remove unnecessary warnings mysql-test/t/ctype_utf8.test: Fixed test mysql-test/t/date_formats.test: Remove unnecessary warnings mysql-test/t/type_decimal.test: Remove unnecessary warnings mysql-test/t/warnings.test: Remove unnecessary warnings sql/field.cc: Optimize sql/item_timefunc.cc: Ensure that result from date_format() is binary strings/ctype-simple.c: Better names for arguments
Diffstat (limited to 'mysql-test/t')
-rw-r--r--mysql-test/t/ctype_utf8.test1
-rw-r--r--mysql-test/t/date_formats.test4
-rw-r--r--mysql-test/t/type_decimal.test4
-rw-r--r--mysql-test/t/warnings.test4
4 files changed, 7 insertions, 6 deletions
diff --git a/mysql-test/t/ctype_utf8.test b/mysql-test/t/ctype_utf8.test
index c2ea1ed20a4..9da7b32eb6d 100644
--- a/mysql-test/t/ctype_utf8.test
+++ b/mysql-test/t/ctype_utf8.test
@@ -60,3 +60,4 @@ set names koi8r;
create table t1 (s1 char(1) character set utf8);
insert into t1 values (_koi8r'ΑΒ');
select s1,hex(s1),char_length(s1),octet_length(s1) from t1;
+drop table t1;
diff --git a/mysql-test/t/date_formats.test b/mysql-test/t/date_formats.test
index 7b88c0ecf72..18af3dfb3db 100644
--- a/mysql-test/t/date_formats.test
+++ b/mysql-test/t/date_formats.test
@@ -2,9 +2,9 @@
# Test of date format functions
#
---disable-warnings
+--disable_warnings
drop table if exists t1;
---enable-warnings
+--enable_warnings
SHOW GLOBAL VARIABLES LIKE "%_format%";
SHOW SESSION VARIABLES LIKE "%_format%";
diff --git a/mysql-test/t/type_decimal.test b/mysql-test/t/type_decimal.test
index cddb0347b7e..3257002ae2c 100644
--- a/mysql-test/t/type_decimal.test
+++ b/mysql-test/t/type_decimal.test
@@ -248,7 +248,7 @@ CREATE TABLE t1 (a_dec DECIMAL(-1,1));
#
# Zero prepend overflow bug
#
---disable-warnings
+--disable_warnings
create table t1(a decimal(7,3));
insert into t1 values ('1'),('+1'),('-1'),('0000000001'),('+0000000001'),('-0000000001'),('10'),('+10'),('-10'),('0000000010'),('+0000000010'),('-0000000010'),('100'),('+100'),('-100'),('0000000100'),('+0000000100'),('-0000000100'),('1000'),('+1000'),('-1000'),('0000001000'),('+0000001000'),('-0000001000'),('10000'),('+10000'),('-10000'),('0000010000'),('+0000010000'),('-0000010000'),('100000'),('+100000'),('-100000'),('0000100000'),('+0000100000'),('-0000100000'),('1000000'),('+1000000'),('-1000000'),('0001000000'),('+0001000000'),('-0001000000'),('10000000'),('+10000000'),('-10000000'),('0010000000'),('+0010000000'),('-0010000000'),('100000000'),('+100000000'),('-100000000'),('0100000000'),('+0100000000'),('-0100000000'),('1000000000'),('+1000000000'),('-1000000000'),('1000000000'),('+1000000000'),('-1000000000');
select * from t1;
@@ -259,6 +259,6 @@ select * from t1;
drop table t1;
create table t1(a decimal(7,3) zerofill);
insert into t1 values ('1'),('+1'),('-1'),('0000000001'),('+0000000001'),('-0000000001'),('10'),('+10'),('-10'),('0000000010'),('+0000000010'),('-0000000010'),('100'),('+100'),('-100'),('0000000100'),('+0000000100'),('-0000000100'),('1000'),('+1000'),('-1000'),('0000001000'),('+0000001000'),('-0000001000'),('10000'),('+10000'),('-10000'),('0000010000'),('+0000010000'),('-0000010000'),('100000'),('+100000'),('-100000'),('0000100000'),('+0000100000'),('-0000100000'),('1000000'),('+1000000'),('-1000000'),('0001000000'),('+0001000000'),('-0001000000'),('10000000'),('+10000000'),('-10000000'),('0010000000'),('+0010000000'),('-0010000000'),('100000000'),('+100000000'),('-100000000'),('0100000000'),('+0100000000'),('-0100000000'),('1000000000'),('+1000000000'),('-1000000000'),('1000000000'),('+1000000000'),('-1000000000');
---enable-warnings
+--enable_warnings
select * from t1;
drop table t1;
diff --git a/mysql-test/t/warnings.test b/mysql-test/t/warnings.test
index 0456ca8c1fe..b6042df51f1 100644
--- a/mysql-test/t/warnings.test
+++ b/mysql-test/t/warnings.test
@@ -1,9 +1,9 @@
#
# Test some warnings
#
---disable-warnings
+--disable_warnings
drop table if exists t1, t2;
---enable-warnings
+--enable_warnings
SET SQL_WARNINGS=1;
create table t1 (a int);