An error occurred fetching the project authors.
  1. 30 Nov, 2007 3 commits
    • davi@endora.local's avatar
      Merge mysql.com:/Users/davi/mysql/bugs/22312-5.1 · 7bdb3219
      davi@endora.local authored
      into  mysql.com:/Users/davi/mysql/mysql-5.1-runtime
      7bdb3219
    • davi@mysql.com/endora.local's avatar
      Bug#22312 Syntax error in expression with INTERVAL() · ee9bafc1
      davi@mysql.com/endora.local authored
      Parser rejects valid INTERVAL() expressions when associated with
      arithmetic operators. The problem is the way in which the expression
      and interval grammar rules were organized caused shift/reduce conflicts.
      
      The solution is to tweak the interval rules to avoid shift/reduce
      conflicts by removing the broken interval_expr rule and explicitly
      specify it's content where necessary.
      
      Original fix by Davi Arnaut, revised and improved rules by Marc Alff
      ee9bafc1
    • anozdrin/alik@ibm.'s avatar
      A test case for BUG#26676: VIEW using old table schema in a session. · a1666e06
      anozdrin/alik@ibm. authored
      The following clarification should be made in The Manual:
      
      Standard SQL is quite clear that, if new columns are added
      to a table after a view on that table is created with
      "select *", the new columns will not become part of the view.
      In all cases, the view definition (view structure) is frozen
      at CREATE time, so changes to the underlying tables do not
      affect the view structure.
      a1666e06
  2. 29 Nov, 2007 1 commit
    • davi@mysql.com/endora.local's avatar
      Bug#23713 LOCK TABLES + CREATE TRIGGER + FLUSH TABLES WITH READ LOCK = deadlock · d179bb64
      davi@mysql.com/endora.local authored
      This bug is actually two bugs in one, one of which is CREATE TRIGGER under
      LOCK TABLES and the other is CREATE TRIGGER under LOCK TABLES simultaneous
      to a FLUSH TABLES WITH READ LOCK (global read lock). Both situations could
      lead to a server crash or deadlock.
      
      The first problem arises from the fact that when under LOCK TABLES, if the
      table is in the set of locked tables, the table is already open and it doesn't
      need to be reopened (not a placeholder). Also in this case, if the table is
      not write locked, a exclusive lock can't be acquired because of a possible
      deadlock with another thread also holding a (read) lock on the table. The
      second issue arises from the fact that one should never wait for a global
      read lock if it's holding any locked tables, because the global read lock
      is waiting for these tables and this leads to a circular wait deadlock.
      
      The solution for the first case is to check if the table is write locked
      and upgraded the write lock to a exclusive lock and fail otherwise for non
      write locked tables. Grabbin the exclusive lock in this case also means
      to ensure that the table is opened only by the calling thread. The second
      issue is partly fixed by not waiting for the global read lock if the thread
      is holding any locked tables.
      
      The second issue is only partly addressed in this patch because it turned
      out to be much wider and also affects other DDL statements. Reported as
      Bug#32395
      d179bb64
  3. 28 Nov, 2007 13 commits
  4. 27 Nov, 2007 16 commits
  5. 26 Nov, 2007 7 commits