summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_str.test
diff options
context:
space:
mode:
authorunknown <monty@donna.mysql.com>2001-01-01 14:17:10 +0200
committerunknown <monty@donna.mysql.com>2001-01-01 14:17:10 +0200
commitdcd25bc9f4db6313b0fa0e75f03888f52970ef77 (patch)
tree290e7b9ca68fdbcc58714c71951a1a399601dec6 /mysql-test/t/func_str.test
parent4fbd7817aee31466cf81b5dfcd154eeffd840f67 (diff)
downloadmariadb-git-dcd25bc9f4db6313b0fa0e75f03888f52970ef77.tar.gz
Fixed gethostname_r tests to be more portable
BUILD/FINISH.sh: Moved symbolic files to tmp Docs/manual.texi: Updated mysql-test/r/func_str.result: Removed time functions mysql-test/t/func_str.test: Removed time functions mysql-test/t/order_by.test: Fixed sort problem sql/sql_parse.cc: End transactions before LOCK TABLES
Diffstat (limited to 'mysql-test/t/func_str.test')
-rw-r--r--mysql-test/t/func_str.test9
1 files changed, 0 insertions, 9 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test
index e5ca1bd1d74..51af2766dae 100644
--- a/mysql-test/t/func_str.test
+++ b/mysql-test/t/func_str.test
@@ -64,15 +64,6 @@ select length(repeat("a",1000000)),length(concat(repeat("a",32000),repeat("a",32
# Problem med concat
#
-drop table if exists t1;
-create table t1 (Zeit time, Tag tinyint not null, Monat tinyint not null, Jahr smallint not null, index(Tag), index(Monat), index(Jahr) );
-insert into t1 values ("09:26:00",16,9,1998);
-insert into t1 values ("09:26:00",16,9,1998);
-SELECT CONCAT(Jahr,'-',Monat,'-',Tag,' ',Zeit) AS Date,
- UNIX_TIMESTAMP(CONCAT(Jahr,'-',Monat,'-',Tag,' ',Zeit)) AS Unix
-FROM t1;
-drop table t1;
-
create table t1 ( domain char(50) );
insert into t1 VALUES ("hello.de" ), ("test.de" );
select domain from t1 where concat('@', trim(leading '.' from concat('.', domain))) = '@hello.de';