diff options
| author | unknown <monty@narttu.mysql.fi> | 2003-07-03 14:49:36 +0300 |
|---|---|---|
| committer | unknown <monty@narttu.mysql.fi> | 2003-07-03 14:49:36 +0300 |
| commit | 2d61b30415bad18a145fcee0c7c34d2aa59bc5b5 (patch) | |
| tree | c6d780e3da4145cc959c43df04187cccf89ec6c4 /mysql-test/t | |
| parent | 9f6614292b8061063e709147b1282dda84c7f018 (diff) | |
| parent | 3af862c7117a8c06db77709d289277a61fb79e9a (diff) | |
| download | mariadb-git-2d61b30415bad18a145fcee0c7c34d2aa59bc5b5.tar.gz | |
Merge bk-internal.mysql.com:/home/bk/mysql-4.1
into narttu.mysql.fi:/my/mysql-4.1
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/func_gconcat.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/func_gconcat.test b/mysql-test/t/func_gconcat.test index a5a7abe3b01..6409d8106c2 100644 --- a/mysql-test/t/func_gconcat.test +++ b/mysql-test/t/func_gconcat.test @@ -78,6 +78,8 @@ drop table if exists T_REQUEST; create table T_REQUEST ( REQ_ID int(11), URL_ID int(11)); insert into T_URL values (4,'www.host.com'), (5,'www.google.com'),(5,'www.help.com'); insert into T_REQUEST values (1,4), (5,4), (5,5); +# Make this order independent +--replace_result www.help.com X www.host.com X www.google.com X select REQ_ID, Group_Concat(URL) as URL from T_URL, T_REQUEST where T_REQUEST.URL_ID = T_URL.URL_ID group by REQ_ID; drop table T_URL; |