1. 10 Oct, 2006 4 commits
    • andrey@example.com's avatar
      Merge ahristov@bk-internal.mysql.com:/home/bk/mysql-5.1-runtime · 1e339e3b
      andrey@example.com authored
      into  example.com:/work/mysql-5.1-runtime
      1e339e3b
    • andrey@example.com's avatar
      Remove direct mapping of enum interval_type to mysql.event.interval_field · 5fd8554a
      andrey@example.com authored
        This decoupling allows in further versions of MySQL enum interval_type to
        be reordered without this affecting any backward compatibility in the
        events code.
        This changeset doesn't change any exposed behavior but makes events' code
        more durable to changes outside of their code base.
        
        To the reviewer: There is no regression test included as it is impossible
        to construct one with the current infrastructure which can test it. To test
        the code one has create and event, then change the order of
        enum interval_type in my_time.h, update sql/time.cc, recompile the server
        and run it with scheduler running.
      5fd8554a
    • kroki/tomash@moonlight.intranet's avatar
      Merge moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.0-bug19111 · 588e8df5
      kroki/tomash@moonlight.intranet authored
      into  moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.1-bug19111
      588e8df5
    • kroki/tomash@moonlight.intranet's avatar
      Bug#19111: TRIGGERs selecting from a VIEW on the firing base table fail. · 4a28f8f1
      kroki/tomash@moonlight.intranet authored
      In a trigger or a function used in a statement it is possible to do
      SELECT from a table being modified by the statement.  However,
      encapsulation of such SELECT into a view and selecting from a view
      instead of direct SELECT was not possible.
      
      This happened because tables used by views (which in their turn
      were used from functions/triggers) were not excluded from checks
      in unique_table() routine as it happens for the rest of tables
      added to the statement table list for prelocking.
      
      With this fix we ignore all such tables in unique_table(), thus
      providing consistency: inside a trigger or a functions SELECT from
      a view may be used where plain SELECT is allowed.  Modification of
      the same table from function or trigger is still disallowed.  Also,
      this patch doesn't affect the case where SELECT from the table being
      modified is done outside of function of trigger, such SELECTs are
      still disallowed (this limitation and visibility problem when function
      select from a table being modified are subjects of bug 21326).  See
      also bug 22427.
      4a28f8f1
  2. 08 Oct, 2006 3 commits
  3. 06 Oct, 2006 12 commits
  4. 05 Oct, 2006 6 commits
  5. 03 Oct, 2006 15 commits