From a424ccee17b7f3fb10c261448f97b37e00461912 Mon Sep 17 00:00:00 2001
From: "Sinisa@sinisa.nasamreza.org" <>
Date: Fri, 12 Sep 2003 19:17:30 +0300
Subject: Fix for a bug #1231

Parse error caused global ORDER BY to be initialized although it should
not have been.
---
 mysql-test/r/derived.result | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'mysql-test/r/derived.result')

diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result
index 944253bd527..6932e0d5476 100644
--- a/mysql-test/r/derived.result
+++ b/mysql-test/r/derived.result
@@ -204,3 +204,5 @@ select 2 as a from (select * from a1) b;
 a
 2
 drop table a1;
+select mail_id,  if(folder.f_description!='', folder.f_description, folder.f_name) as folder_name,  date, address_id, phrase, address,  subject from folder, (select  mail.mail_id as mail_id,  date_format(mail.h_date, '%b %e, %Y %h:%i') as date,  mail.folder_id,  sender.address_id as address_id,  sender.phrase as phrase, sender.address as address,    mail.h_subject as subject from    mail left join mxa as mxa_sender on mail.mail_id=mxa_sender.mail_id and mxa_sender.type='from' left join address as sender on mxa_sender.address_id=sender.address_id  mxa as mxa_recipient,   address as recipient, where 1     and mail.mail_id=mxa_recipient.mail_id   and mxa_recipient.address_id=recipient.address_id   and mxa_recipient.type='to'  and  match(sender.phrase, sender.address, sender.comment) against ('jeremy' in boolean mode)   and  match(recipient.phrase, recipient.address, recipient.comment) against ('monty' in boolean mode) order by mail.h_date desc limit 0, 25 ) as query where query.folder_id=folder.folder_id;
+ERROR 42000: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mxa as mxa_recipient,   address as recipient, where 1     and mail.mail_id=mxa_r' at line 1
-- 
cgit v1.2.1