diff options
| author | unknown <jimw@mysql.com> | 2005-02-02 09:05:52 -0800 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-02-02 09:05:52 -0800 |
| commit | 8ecae2e65cd09568bdfcedd9b22b5fe41cf6144c (patch) | |
| tree | ccb5ba99d300dc642cd476e5dd16d1bba2b10cce /mysql-test/t/func_str.test | |
| parent | 33e74b1427c1e211acc1f06e0384e44bd1edac24 (diff) | |
| download | mariadb-git-8ecae2e65cd09568bdfcedd9b22b5fe41cf6144c.tar.gz | |
Fix merge of func_str tests (accidently duplicated a test).
mysql-test/t/func_str.test:
Remove duplicated test that crept in during merge
mysql-test/r/func_str.result:
Update results
Diffstat (limited to 'mysql-test/t/func_str.test')
| -rw-r--r-- | mysql-test/t/func_str.test | 7 |
1 files changed, 1 insertions, 6 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index 2bf130d1538..6d5974ca5ed 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -206,6 +206,7 @@ select quote(trim(concat(' ', 'a'))); CREATE TABLE t1 SELECT 1 UNION SELECT 2 UNION SELECT 3; SELECT QUOTE('A') FROM t1; DROP TABLE t1; + # Test collation and coercibility # @@ -440,12 +441,6 @@ create table t1 (a int not null primary key, b varchar(40), c datetime); insert into t1 (a,b,c) values (1,'Tom','2004-12-10 12:13:14'),(2,'ball games','2004-12-10 12:13:14'), (3,'Basil','2004-12-10 12:13:14'), (4,'Dean','2004-12-10 12:13:14'),(5,'Ellis','2004-12-10 12:13:14'), (6,'Serg','2004-12-10 12:13:14'), (7,'Sergei','2004-12-10 12:13:14'),(8,'Georg','2004-12-10 12:13:14'),(9,'Salle','2004-12-10 12:13:14'),(10,'Sinisa','2004-12-10 12:13:14'); select count(*) as total, left(c,10) as reg from t1 group by reg order by reg desc limit 0,12; drop table t1; -# crashing bug with QUOTE() and LTRIM() or TRIM() fixed -# Bug #7495 -# - -select quote(ltrim(concat(' ', 'a'))); -select quote(trim(concat(' ', 'a'))); # # Bug#7455 unexpected result: TRIM(<NULL> FROM <whatever>) gives NOT NULL |