diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2003-09-12 19:17:30 +0300 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2003-09-12 19:17:30 +0300 |
| commit | a424ccee17b7f3fb10c261448f97b37e00461912 (patch) | |
| tree | d99b70e327f3202d97b4fd6adaa5ef6bea466062 /mysql-test/r/derived.result | |
| parent | 5e328057134ef81e4bf4f8896fd74a61e464f60c (diff) | |
| download | mariadb-git-a424ccee17b7f3fb10c261448f97b37e00461912.tar.gz | |
Fix for a bug #1231
Parse error caused global ORDER BY to be initialized although it should
not have been.
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 2 |
1 files changed, 2 insertions, 0 deletions
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 |