enterprise-support team mailing list archive

[Roel Van de Paar <806919@xxxxxxxxxxxxxxxxxx>]

I checked all other optimizer .yy grammars, and there are no other " AS
{few letters table name in uppercase}" occurrences. I did notice these:

AS { "SUBQUERY".$subquery_idx."_field1" }
AS { "CHILD_SUBQUERY".$child_subquery_idx."_field1" }
AS { "SQ".$subquery_idx."_field1" }
AS { "C_SQ".$child_subquery_idx."_alias".++$child_subquery_tables }

But that should be fine given the "_field1" addition and the fact that
it is so long.

Even if we were to change/fix the table matching regex (see bug
#792138), it is unlikely to match the above.

The only other one which may cause issues is virtual_columns.yy:

v1 field_type AS ( virtual_expr ) /*executor1 PERSISTENT */ /*executor2 VIRTUAL */ ,
v2 field_type AS ( virtual_expr ) /*executor1 PERSISTENT */ /*executor2 VIRTUAL */ ,
v3 field_type AS ( virtual_expr ) /*executor1 PERSISTENT */ /*executor2 VIRTUAL */ ,
v4 field_type AS ( virtual_expr ) /*executor1 PERSISTENT */ /*executor2 VIRTUAL */

virtual_expr leads to nested_expr which may lead to comparison_operator
which may leads to things like

       expr IS not boolean_value |
       expr IS not NULL |
       expr not BETWEEN ( expr ) AND ( expr ) |
       COALESCE( expr_list ) |
       GREATEST( expr , expr_list ) |
       expr not IN ( expr_list ) |
       ISNULL( expr ) |
       INTERVAL( expr , expr_list ) |
       LEAST( expr, expr_list ) ;

Not likely to be a problem, but if we're ever researching this... :)

Bug fixed.

** Changed in: randgen
       Status: In Progress => Fix Released

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/806919

Title:
  ConvertTablesToDerived transformer produces some queries with wrong
  syntax

To manage notifications about this bug go to:
https://bugs.launchpad.net/randgen/+bug/806919/+subscriptions