title: MySQL 3.23 UNION fails with Error 1064
body: <p>I am trying to use a UNION statement in an old BugZilla MySQL DB running MySQL 3.23.  Here is a simplified version of what I am trying to do.  It's really nothing exotic but MySQL keeps saying that something is wrong.</p>
  
  <pre><code>(select bug_id,rep_platform from bugs where rep_platform='XX') 
   UNION 
  (select bug_id,rep_platform from bugs where rep_platform='YY');
  </code></pre>
  
  <p>The result I get is:</p>
  
  <pre><code>ERROR 1064 (HY000): You have an error in your SQL syntax near '(select bug_id,rep_platform from bugs where rep_platform='XX')
  UNION
  (select bu' at line 1
  </code></pre>
  
  <p>This is really about as simple of a union statement as you can get.  Any ideas?</p>
  
  <p>EDIT:  I ran a very similar query on a MySQL 5 DB and it worked just fine.  Is these some special UNION syntax on MySQL 3 that doesn't show up in documentation or Google searches?</p>