Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 56419
Status: resolved
Priority: 0/
Queue: SQL-Translator
People
Owner: Nobody in particular
Requestors: lamoz [...] adriver.ru
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Fri Apr 09 04:28:14 2010 lamoz [...] adriver.ru - Ticket created
Subject: Mysql producer fails on views with unions
I have no success on producing CREATE VIEW on views defined with unions like so: SELECT id FROM User UNION SELECT id FROM Object The generated statement is: VIEW `my_view` ( `id` ) AS ( SELECT id FROM User UNION SELECT id FROM Object ) The parentheses added by producer around united selects confuse MySQL due to the bug http://bugs.mysql.com/bug.php?id=9198 which is "won't fix". Are they necessary at all?
  Thu Jun 03 04:52:47 2010 ribasushi [...] leporine.io - Correspondence added
Fixed in 0.11006. Thanks!
  Thu Jun 03 04:52:47 2010 The RT System itself - Status changed from 'new' to 'open'
  Thu Jun 03 04:52:47 2010 ribasushi [...] leporine.io - Status changed from 'open' to 'resolved'