title: Create or replace view error #1222
body: <p>the code</p>
  
  <pre><code>CREATE OR REPLACE VIEW `posts` AS  
      (SELECT '11' AS blog_id
          , 'blog1.domain.net' AS domain
          , '/' AS path
          , posts11.*
      FROM wp_11_posts posts11
      WHERE posts11.post_type = 'post'
          AND posts11.post_status = 'publish')
    UNION
      (SELECT '20' AS blog_id
          , 'blog2.domain.net' AS domain
          , '/' AS path
          , posts20.*
      FROM wp_20_posts posts20
      WHERE posts20.post_type = 'post'
          AND posts20.post_status = 'publish')
  </code></pre>
  
  <p>works with no error, this one</p>
  
  <pre><code>CREATE OR REPLACE VIEW `posts` AS  
      (SELECT '11' AS blog_id
          , 'blog1.domain.net' AS domain
          , '/' AS path, posts11.*
      FROM wp_11_posts posts11
      WHERE posts11.post_type = 'post'
          AND posts11.post_status = 'publish')
    UNION
      (SELECT '2' AS blog_id
          , 'blog2.domain.net' AS domain
          , '/' AS path, posts2.*
      FROM wp_2_posts posts2
      WHERE posts2.post_type = 'post'
          AND posts2.post_status = 'publish')
  </code></pre>
  
  <p>gives me the error</p>
  
  <pre><code>#1222 - The used SELECT statements have a different number of columns
  </code></pre>
  
  <p>the difference is only the id of the table, and all the tables or rows exits,
  thanks for your help</p>