• unknown's avatar
    This is a large push. Included are : · 71ce58a3
    unknown authored
    * multi-table updates
    * new paid feature for limiting number of queries per hour for users
    * optional syntax for multi-table deletes
    * optimization for SQL_CALC_FOUND_ROWS
    * a small addition for CREATE .. SELECT that will be of future use
    
    I know that all this will require many additions to documentation, 
    which I have not done, but I am at Arjen's disposal to help him document
    all this.
    
    
    
    libmysqld/lib_sql.cc:
      This is a small change required due to new paid feature of limiting 
      number of queries per hour for each user.
    mysql-test/r/multi_update.result:
      Change of the result to accomodate multi-table updates
    mysql-test/t/multi_update.test:
      Change in multi-table tests to accomodate multi-table updates
    BitKeeper/etc/ignore:
      Added 50 sql/new.cc to the ignore list
    scripts/mysql_install_db.sh:
      This is a small change required due to new paid feature of limiting 
      number of queries per hour for each user.
    sql/item_timefunc.h:
      This is a small feature that will be of use later in the proper 
      creation of the tables out of CREATE ... SELECT...
      
      Further changes will come after this resolve/push/test passes ..
    sql/lex.h:
      This is a small change required due to new paid feature of limiting 
      number of queries per hour for each user.
    sql/mysql_priv.h:
      This is a small change required due to new paid feature of limiting 
      number of queries per hour for each user.
    sql/mysqld.cc:
      This is a small change required due to new paid feature of limiting 
      number of queries per hour for each user.
    sql/sql_acl.cc:
      This is a small change required due to new paid feature of limiting 
      number of queries per hour for each user.
    sql/sql_acl.h:
      This is a small change required due to new paid feature of limiting 
      number of queries per hour for each user.
    sql/sql_class.h:
      These are changes required for multi-table updates.
    sql/sql_lex.h:
      Changes required for both multi-table updates and limiting number of 
      queries per hour (paid feature).
    sql/sql_parse.cc:
      Ha ! So many changes. 
      
      * multi-table updates
      * limiting number of queries per hour for users
    sql/sql_select.cc:
      Optimisation for SQL_CALC_FOUND_ROWS, when a query involves a single
      table, without WHERE or GROUP clause
    sql/sql_update.cc:
      multi-table updates
    sql/sql_yacc.yy:
      Many things :
      * multi-table updates
      * limiting number of queries per hour for users
      * new optional syntax for multi-table deletes. This one is different 
        from the one demanded by user. USING clause MUST include ALL tables, 
        not just the ones that are used and not deleted from.
    71ce58a3
multi_update.result 1.17 KB