An error occurred fetching the project authors.
  1. 18 Oct, 2013 1 commit
  2. 18 May, 2011 1 commit
    • unknown's avatar
      Rewritten patch of percona - switching query cache on and off, removing comments. · 1177bea2
      unknown authored
      client/mysqltest.cc:
        Column names.
      mysql-test/r/grant_cache_no_prot.result:
        fix of text.
      mysql-test/r/grant_cache_ps_prot.result:
        Fix of test.
      mysql-test/r/query_cache.result:
        Switching on and off query cache.
      mysql-test/t/query_cache.test:
        Switching on and off query cache.
      mysys/charset.c:
        Fix of parser.
      sql/handler.cc:
        thd added to parameters.
      sql/log_event.cc:
        thd added to parameters.
      sql/log_event_old.cc:
        thd added to parameters.
      sql/mysql_priv.h:
        Fixed functions definitions.
      sql/mysqld.cc:
        Comments stripping.
      sql/set_var.cc:
        Switching on and off query cache.
      sql/set_var.h:
        Switching on and off query cache.
      sql/share/errmsg.txt:
        New errors.
      sql/sql_cache.cc:
        Switching query cache on and off, removing comments.
      sql/sql_cache.h:
        thd added to parameters.
      sql/sql_class.h:
        Comments stripping.
      sql/sql_db.cc:
        thd added to parameters.
      sql/sql_lex.cc:
        lex fixed.
      sql/sql_parse.cc:
        thd added to parameters.
      1177bea2
  3. 09 Aug, 2010 1 commit
  4. 15 May, 2009 1 commit
    • Matthias Leich's avatar
      Fix for Bug#42308 Several server tests do not pass MTR's --check option · 21f878e7
      Matthias Leich authored
      Details:
      Most tests mentioned within the bug report were already fixed.
      The test modified here failed in stability (high parallel load) tests.
      
      Details:
      1. Take care that disconnects are finished before the test terminates.
      2. Correct wrong handling of send/reap in events_stress which caused
         random garbled output
      3. Minor beautifying of script code
      21f878e7
  5. 03 Sep, 2008 1 commit
    • Martin Hansson's avatar
      Bug#36086: SELECT * from views don't check column grants · 3bad2119
      Martin Hansson authored
      This patch also fixes bugs 36963 and 35600.
                            
      - In many places a view was confused with an anonymous derived
        table, i.e. access checking was skipped. Fixed by introducing a
        predicate to tell the difference between named and anonymous
        derived tables.
                            
      - When inserting fields for "SELECT * ", there was no 
        distinction between base tables and views, where one should be
        made. View privileges are checked elsewhere.
      
      mysql-test/include/grant_cache.inc:
        Bug#36086: Changed test case.
      mysql-test/r/grant2.result:
        Bug#36086: Changed test result.
      mysql-test/r/grant_cache_no_prot.result:
        Bug#36086: Changed test result.
      mysql-test/r/grant_cache_ps_prot.result:
        Bug#36086: Changed test result.
      mysql-test/r/view_grant.result:
        Bug#36086: Test result.
      mysql-test/t/grant2.test:
        Bug#36086: Changed test case.
      mysql-test/t/view_grant.test:
        Bug#36086: Test case.
      sql/item.cc:
        Bug#36086: Replaced conditional with new methods.
      sql/sql_acl.cc:
        Bug no 35600: 
        In mysql_table_grant:
          Replaced conditional with the new accessor method.
        
        In check_grant:
         - Changed the requirement table->derived != null to 
           checking all anonymous derived tables.
         - Use of the accessor methods for getting object and database 
           names.
            
        Bug#36086: In check_grant_all_columns:
          - Updated comment. This function is now called for views
            as well.
          - The error message should not disclose any column names 
            unless the user has privilege to see all column names.
          - Changed names of Field_iterator_table_ref methods.
      sql/sql_base.cc:
        Bug no 36963: In insert_fields()
          - Commented.
          - We should call check_grant_all_columns() for views in  
            this case.        
          - Changed names of Field_iterator_table_ref methods.
          - We should not disclose column names in the error message
            when the user has no approprate privilege.
      sql/sql_cache.cc:
        Bug#36086: Replaced test with new predicate method.
      sql/sql_derived.cc:
        Bug#36086: commenting only. Updated and doxygenated
        comment for mysql_derived_prepare().
      sql/sql_parse.cc:
        Bug no 35600: 
        - In check_single_table_access:
          Due to the bug, check_grant would raise an error for a
          SHOW CREATE TABLE command for a TEMPTABLE view. It should in
          fact not be be invoked in this case. This table privilege
          is checked already.
          There is a test case for this in information_schema_db.test.
            
        - In check_access: replaced table->derived
      sql/table.cc:
        Bug#36086: 
        
        - In TABLE_LIST::set_underlying_merge(): 
          Commenting only. Doxygenated, corrected spelling,
          added.
        
        - Renamed table_name() and db_name() methods of 
          Field_iterator_table_ref in order to be consistent
          with new methods in TABLE_LIST.
      sql/table.h:
        Bug#36086: 
          - Commented GRANT_INFO.
          - Added a predicate is_anonymous_derived_table() to    
            TABLE_LIST.
          - Added get_table_name() and get_db_name() to   
            TABLE_LIST in order to hide the disparate   
            representation of these properties.
      3bad2119
  6. 24 May, 2007 1 commit
    • unknown's avatar
      This changeset belongs to the fix of Bug#735 Prepared Statements: there is no... · bcb1ff7f
      unknown authored
      This changeset belongs to the fix of Bug#735 Prepared Statements: there is no support for Query Cache
        
      - Create "--ps-protocol" and no "--<whatever>-protocol" variants of the former tests
        t/grant_cache.test and t/query_cache_sql_prepare.test.
      - Some additional subtest and fixes of bugs
      - Minor improvements 
      
      
      mysql-test/include/grant_cache.inc:
        - Rename mysql-test/t/grant_cache.test to include/grant_cache.inc
        - Toplevel scripts running variants of this test are
             t/grant_cache_ps_prot.test (runs only with "--ps-protocol")
             t/grant_cache_no_prot.test (skipped if any protocol is assigned)
        - Modifications to include/grant_cache.inc:
          - Minor improvements like replace --error <number> by --error <name>
          - enable that some subtests are run with "--ps-protocol"
      mysql-test/include/query_cache_sql_prepare.inc:
        - Rename t/query_cache_sql_prepare.test to include/query_cache_sql_prepare.inc
        - Toplevel scripts running variants of this test are
             query_cache_ps_ps_prot.test (skipped if other protocol than --ps-protocol is used.)
             query_cache_ps_no_prot.test (skipped if --<whatever>-protocol is used)   
        - Modifications to include/query_cache_sql_prepare.inc:
        - Minor improvements like add drop table
        - Add tests checking that 
          - another connection gets the same amount of QC hits
          - statements running via ps-protocol do not hit QC results of preceding sql EXECUTEs
      mysql-test/r/grant_cache_no_prot.result:
        Updated result
      mysql-test/r/query_cache_ps_no_prot.result:
        Updated result
      tests/mysql_client_test.c:
        - correct wrong sized "for" loop
        - add some missing tests of query cache hit numbers
      mysql-test/r/grant_cache_ps_prot.result:
        New BitKeeper file ``mysql-test/r/grant_cache_ps_prot.result''
      mysql-test/r/query_cache_ps_ps_prot.result:
        New BitKeeper file ``mysql-test/r/query_cache_ps_ps_prot.result''
      mysql-test/t/grant_cache_no_prot.test:
        Variant of the test grant_cache to be run without any "--<whatever>-protocol"
      mysql-test/t/grant_cache_ps_prot.test:
        Variant of the test grant_cache to be run with "--ps-protocol" only
      mysql-test/t/query_cache_ps_no_prot.test:
        Variant of the test query_cache_sql_prepare to be run without any "--<whatever>-protocol"
      mysql-test/t/query_cache_ps_ps_prot.test:
        Variant of the test query_cache_sql_prepare to be run with "--ps-protocol" only
      bcb1ff7f
  7. 20 Jun, 2006 1 commit
    • unknown's avatar
      SHOW STATUS does not anymore change local status variables (except... · f3a56a17
      unknown authored
      SHOW STATUS does not anymore change local status variables (except com_show_status). Global status variables are still updated.
      SHOW STATUS are not anymore put in slow query log because of no index usage.
      
      Implemntation done by removing orig_sql_command and moving logic of SHOW STATUS to mysql_excute_command()
      This simplifies code and allows us to remove some if statements all over the code.
      
      Upgraded uc_update_queries[] to sql_command_flags and added more bitmaps to better categorize commands.
      This allowed some overall simplifaction when testing sql_command.
      
      Fixes bugs:
      Bug#10210: running SHOW STATUS increments counters it shouldn't
      Bug#19764: SHOW commands end up in the slow log as table scans
      
      
      mysql-test/r/grant_cache.result:
        Fixed results after SHOW STATUS doesn't anymore affect status variables
      mysql-test/r/information_schema.result:
        Added extra test to cover more code
      mysql-test/r/query_cache.result:
        Remove resuts from previous tests
      mysql-test/r/status.result:
        Added more tests for testing of last_query_cost and how SHOW STATUS affects status variables.
        (Bug#10210)
      mysql-test/r/temp_table.result:
        Fixed results after SHOW STATUS doesn't anymore affect status variables
      mysql-test/r/union.result:
        Fixed results after SHOW STATUS is not logged to slow query log
        (Bug#19764)
      mysql-test/t/events_microsec.test:
        Disable warnings at init
      mysql-test/t/information_schema.test:
        Added extra test to cover more code
      mysql-test/t/query_cache.test:
        Remove resuts from previous tests
      mysql-test/t/status.test:
        Added more tests for testing of last_query_cost and how SHOW STATUS affects status variables.
        (Bug #10210)
      sql/mysql_priv.h:
        Added 'sql_command_flags'
      sql/sql_class.cc:
        New function add_diff_to_status(), used to update global status variables when using SHOW STATUS
      sql/sql_class.h:
        New function 'fill_information_schema_tables()'
        (One could not anymore use fill_derived_tables() for this as only_view_structures() is not relevant for information schema tables)
        Added defines for bit flags in sql_command_flags[]
      sql/sql_lex.cc:
        Remove orig_sql_command
      sql/sql_lex.h:
        Remove orig_sql_command
      sql/sql_parse.cc:
        Rename uc_update_queries -> sql_command_flags.
        Enhanced 'sql_command_flags' to better classify SQL commands
        uc_update_queries[] != 0 is changed to (sql_command_flags[] & CF_CHANGES_DATA)
        lex->orig_sql_command == SQLCOM_END is changed to (sql_command_flags[lex->sql_command] & CF_STATUS_COMMAND) == 0)
        
        Simplify incrementing of thd->status_var.com_stat[] as we don't have to do special handling for SHOW commands.
        
        Split SQLCOM_SELECT handling in mysql_execute_command() to a separate function.
        Added special handling of SHOW STATUS commands in mysql_execute_command() and call common SQLCOM_SELECT handling.
        These changes allows us to easily fix that we save and restore status variables during execution of a SHOW STATUS command.
        Don't log SHOW STATUS commands to slow query log.
        
        This fixes Bug#10210 and Bug#19764 without adding additional 'if' code.
        (The new code is faster than the original as we now have fewer if's than before)
      sql/sql_prepare.cc:
        Clean up prepare-check handling of SQLCOM commands by using sql_command_flags[]
        This simplifes code and ensures that code works even if someone forgets to put a new status commands into the switch statement.
      sql/sql_select.cc:
        Remove special handling of SHOW STATUS.
        (This is now done in SQLCOM_SHOW_STATUS part in mysql_execute_command())
      sql/sql_show.cc:
        Remove orig_sql_command
        Only change sql_command during 'open_normal_and_derived_tables()' (for views) and not for the full duration of generating data.
        Changed 'show status' to use thd->initial_status_var to ensure that the current statement is not affecting the to-be-used values.
        Use thd->fill_information_schema_tables() instead of 'thd->fill_derived_tables()' as the later wrongly checks the value of sql_command.
      sql/sql_yacc.yy:
        Remove usage of orig_sql_command.
        One side effect of this is that we need to test for cursors if the current command is a SELECT or a SHOW command.
      sql/structs.h:
        Updated comment
      f3a56a17
  8. 18 May, 2005 1 commit
    • unknown's avatar
      reduced 1 server reloding during test · 8c4e2860
      unknown authored
      BitKeeper/deleted/.del-grant_cache-master.opt~1b04b4b1116a7a2:
        Delete: mysql-test/t/grant_cache-master.opt
      mysql-test/r/grant_cache.result:
        query cache management moved inside test
      mysql-test/t/grant_cache.test:
        query cache management moved inside test to privent server reloading during test
      8c4e2860
  9. 31 Dec, 2004 1 commit
    • unknown's avatar
      post-merge · 5eaf65ab
      unknown authored
      mysql-test/r/grant2.result:
        new test case
      mysql-test/r/variables.result:
        don't fail w/o innodb
      mysql-test/t/grant2.test:
        new test case
      mysql-test/t/multi_update.test:
        don't fail w/o innodb
      mysql-test/t/variables.test:
        don't fail w/o innodb
      sql/sql_acl.cc:
        cleanup
      5eaf65ab
  10. 30 Dec, 2004 2 commits
    • unknown's avatar
    • unknown's avatar
      wl#1629 SHOW with WHERE(final part, after review) · 525242d3
      unknown authored
        added syntax:
        'show variables where', 'show status where', 'show open tables where'
      
      
      mysql-test/r/grant_cache.result:
        wl#1629 SHOW with WHERE(final part,after review)
      mysql-test/r/information_schema.result:
        wl#1629 SHOW with WHERE(final part,after review)
      mysql-test/r/query_cache.result:
        wl#1629 SHOW with WHERE(final part,after review)
      mysql-test/r/temp_table.result:
        wl#1629 SHOW with WHERE(final part,after review)
      mysql-test/r/union.result:
        wl#1629 SHOW with WHERE(final part,after review)
      mysql-test/t/information_schema.test:
        wl#1629 SHOW with WHERE(final part,after review)
      mysql-test/t/query_cache.test:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/item.cc:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/mysql_priv.h:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/sql_parse.cc:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/sql_select.cc:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/sql_show.cc:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/sql_yacc.yy:
        wl#1629 SHOW with WHERE(final part,after review)
      sql/table.h:
        wl#1629 SHOW with WHERE(final part,after review)
      525242d3
  11. 08 Jul, 2004 1 commit
  12. 16 Jun, 2004 1 commit
  13. 15 Jun, 2004 1 commit
  14. 05 Apr, 2004 1 commit
    • unknown's avatar
      WL1368: SHOW GRANTS FOR CURRENT USER · 8c06c8c0
      unknown authored
        'SHOW GRANTS' syntax is added 
        'SHOW GRANTS FOR CURRENT_USER' syntax is added
        'SHOW GRANTS FOR CURRENT_USER()' syntax is added
       CURRENT_USER without parens in expressions(SELECT CURRENT_USER;) 
      
      
      mysql-test/r/grant2.result:
        WL1368: SHOW GRANTS FOR CURRENT USER
      mysql-test/r/grant_cache.result:
        WL1368: SHOW GRANTS FOR CURRENT USER
      mysql-test/t/grant2.test:
        WL1368: SHOW GRANTS FOR CURRENT USER
      mysql-test/t/grant_cache.test:
        WL1368: SHOW GRANTS FOR CURRENT USER
      sql/lex.h:
        WL1368: SHOW GRANTS FOR CURRENT USER
      sql/sql_yacc.yy:
        WL1368: SHOW GRANTS FOR CURRENT USER
      8c06c8c0
  15. 21 Mar, 2004 1 commit
    • unknown's avatar
      fixed BUG in query cahe statistic counting · 91bac76e
      unknown authored
      mysql-test/r/grant_cache.result:
        right results in query cache
      mysql-test/t/grant_cache.test:
        proving new results
      sql/sql_cache.cc:
        fixed statistic calculating in query cahe
      91bac76e
  16. 24 Jul, 2003 1 commit
    • unknown's avatar
      Print accounts in error messages as 'user'@'host' rather than 'user@host'. · 3a8d1c3c
      unknown authored
      The latter is misleading because differs from the syntax used for GRANT/REVOKE.
      
      Fix up test result affected by error message edits.
      
      
      mysql-test/r/grant_cache.result:
        Fix up test result to match error message edit.
      sql/share/czech/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/danish/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/dutch/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/english/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/estonian/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/french/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/german/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/greek/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/hungarian/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/italian/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/japanese/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/korean/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/norwegian-ny/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/norwegian/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/polish/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/portuguese/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/romanian/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/russian/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/serbian/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/slovak/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/spanish/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/swedish/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      sql/share/ukrainian/errmsg.txt:
        Print user@host in syntax actually used for GRANT/REVOKE.
      3a8d1c3c
  17. 03 Jul, 2003 1 commit
    • unknown's avatar
      Cleaner implementation if INSERT ... SELECT with same tables · 2373397e
      unknown authored
      Tests cleanup (put drop database first in tests)
      
      
      client/mysql.cc:
        Cleanup of code in last pull
      include/config-win.h:
        Remove HAVE_CHSIZE on windows as it's not 64 bit clean
      include/my_global.h:
        Portability fix
      mysql-test/r/drop.result:
        Clean up results
      mysql-test/r/flush.result:
        Clean up results
      mysql-test/r/grant_cache.result:
        Clean up results
      mysql-test/r/innodb.result:
        Clean up results
      mysql-test/r/insert_select.result:
        Clean up results
      mysql-test/r/merge.result:
        Clean up results
      mysql-test/r/query_cache.result:
        Clean up results
      mysql-test/t/drop.test:
        Clean up tests
      mysql-test/t/flush.test:
        Clean up tests
      mysql-test/t/grant_cache.test:
        Clean up tests
      mysql-test/t/innodb.test:
        Clean up tests
      mysql-test/t/insert_select.test:
        Added more tests
      mysql-test/t/merge.test:
        Test of bug 515
      mysql-test/t/query_cache.test:
        Clean up tests
      mysql-test/t/symlink.test:
        Clean up tests
      sql/mysql_priv.h:
        Cleaner implementation if INSERT ... SELECT with same tables
      sql/sql_lex.h:
        Cleaner implementation if INSERT ... SELECT with same tables
      sql/sql_list.h:
        Indentation cleanup
      sql/sql_parse.cc:
        Cleaner implementation if INSERT ... SELECT with same tables
      sql/sql_yacc.yy:
        Cleaner implementation if INSERT ... SELECT with same tables
      2373397e
  18. 01 Jul, 2003 2 commits
  19. 04 Jun, 2003 1 commit
    • unknown's avatar
      Added SQLSTATE to client/server protocol · b388eb00
      unknown authored
      bmove_allign -> bmove_align
      Added OLAP function ROLLUP
      Split mysql_fix_privilege_tables to a script and a .sql data file
      Added new (MEMROOT*) functions to avoid calling current_thd() when creating some common objects.
      Added table_alias_charset, for easier --lower-case-table-name handling
      Better SQL_MODE handling (Setting complex options also sets sub options)
      New (faster) assembler string functions for x86
      
      
      BitKeeper/etc/ignore:
        added libmysqld/sql_state.c
      client/mysql.cc:
        Added SQLSTATE to error messages
        Added new function put_error() to be able to clean up some old code.
      client/mysqltest.c:
        Write ERROR SQLSTATE for all errors
      dbug/dbug.c:
        Portability fixes
      include/m_string.h:
        Rename bmove_allign as bmove_align
      include/mysql.h:
        Added SQLSTATE (for embedded version)
      include/mysql_com.h:
        Send correct SQLSTATE for the error to the client
      libmysql/libmysql.c:
        Changed default error state to HY000
        Applied code cleanup patch
      libmysqld/Makefile.am:
        Added sql_state.cc
      libmysqld/libmysqld.c:
        Added sqlstate
      mysql-test/r/analyse.result:
        Updated results
      mysql-test/r/ansi.result:
        Updated results
      mysql-test/r/auto_increment.result:
        Updated results
      mysql-test/r/bdb-deadlock.result:
        Updated results
      mysql-test/r/bdb.result:
        Updated results
      mysql-test/r/comments.result:
        Updated results
      mysql-test/r/create.result:
        Updated results
      mysql-test/r/ctype_collate.result:
        Updated results
      mysql-test/r/delayed.result:
        Updated results
      mysql-test/r/delete.result:
        Updated results
      mysql-test/r/derived.result:
        Updated results
      mysql-test/r/distinct.result:
        Updated results
      mysql-test/r/drop.result:
        Updated results
      mysql-test/r/err000001.result:
        Updated results
      mysql-test/r/explain.result:
        Updated results
      mysql-test/r/flush.result:
        Updated results
      mysql-test/r/fulltext.result:
        Updated results
      mysql-test/r/func_gconcat.result:
        Updated results
      mysql-test/r/func_system.result:
        Updated results
      mysql-test/r/grant_cache.result:
        Updated results
      mysql-test/r/group_by.result:
        Updated results
      mysql-test/r/handler.result:
        Updated results
      mysql-test/r/heap.result:
        Updated results
      mysql-test/r/heap_btree.result:
        Updated results
      mysql-test/r/heap_hash.result:
        Updated results
      mysql-test/r/innodb.result:
        Updated results
      mysql-test/r/innodb_handler.result:
        Updated results
      mysql-test/r/insert_select.result:
        Updated results
      mysql-test/r/insert_update.result:
        Updated results
      mysql-test/r/join.result:
        Updated results
      mysql-test/r/join_outer.result:
        Updated results
      mysql-test/r/key.result:
        Updated results
      mysql-test/r/lock.result:
        Updated results
      mysql-test/r/lock_multi.result:
        Updated results
      mysql-test/r/merge.result:
        Updated results
      mysql-test/r/multi_update.result:
        Updated results
      mysql-test/r/myisam.result:
        Updated results
      mysql-test/r/null.result:
        Updated results
      mysql-test/r/olap.result:
        Updated results
      mysql-test/r/order_by.result:
        Updated results
      mysql-test/r/packet.result:
        Updated results
      mysql-test/r/query_cache.result:
        Updated results
      mysql-test/r/row.result:
        Updated results
      mysql-test/r/rpl000001.result:
        Updated results
      mysql-test/r/rpl000009.result:
        Updated results
      mysql-test/r/rpl_empty_master_crash.result:
        Updated results
      mysql-test/r/rpl_log.result:
        Updated results
      mysql-test/r/rpl_replicate_do.result:
        Updated results
      mysql-test/r/rpl_rotate_logs.result:
        Updated results
      mysql-test/r/select.result:
        Updated results
      mysql-test/r/select_safe.result:
        Updated results
      mysql-test/r/show_check.result:
        Updated results
      mysql-test/r/sql_mode.result:
        Updated results
      mysql-test/r/subselect.result:
        Updated results
      mysql-test/r/temp_table.result:
        Updated results
      mysql-test/r/truncate.result:
        Updated results
      mysql-test/r/type_blob.result:
        Updated results
      mysql-test/r/type_decimal.result:
        Updated results
      mysql-test/r/type_float.result:
        Updated results
      mysql-test/r/type_ranges.result:
        Updated results
      mysql-test/r/union.result:
        Updated results
      mysql-test/r/update.result:
        Updated results
      mysql-test/r/user_var.result:
        Updated results
      mysql-test/r/varbinary.result:
        Updated results
      mysql-test/r/variables.result:
        Updated results
      mysql-test/t/ansi.test:
        Test of sql_mode
      mysql-test/t/derived.test:
        Updated results
      mysql-test/t/func_system.test:
        Make this independen of the MySQL server name
      mysql-test/t/lowercase_table.test:
        Cleanup
      mysql-test/t/olap.test:
        A lot of new tests
      mysql-test/t/sql_mode.test:
        More test for sql_mode
      mysql-test/t/subselect.test:
        Added a few new tests (to find a bug in the item_ref code)
      scripts/Makefile.am:
        Added mysql_fix_privilege_tables.sql
      scripts/mysql_fix_privilege_tables.sh:
        Totally new script.  This bascily just pipes mysql_fix_privilege_tables.sql through 'mysql' to 'mysqld'
      sql/Makefile.am:
        Added sql_state.cc
      sql/item.cc:
        Extended Item_field::eq() to be able to better match GROUP BY fields on the command line.
        Needed for ROLLUP
      sql/item.h:
        Added function to be able to avoid calling current_thd() when doing new Item.
      sql/item_sum.cc:
        Moved copy_or_same() and some reset() functions from item_sum.h
        Needed to be able to access thd->mem_root.
      sql/item_sum.h:
        Moved some functions to item_sum.cc
        Added make_unique() for ROLLUP
      sql/item_uniq.h:
        Fixed return value
      sql/mysql_priv.h:
        Updated MODE flags
      sql/mysqld.cc:
        Added ANSI as it's own mode
        Moved charset_info variables here
        Cleaned up handler_count handling (for NT)
        Added table_alias_charset, for easier --lower-case-table-name handling
      sql/net_serv.cc:
        New comment
      sql/protocol.cc:
        Send SQLSTATE to client
      sql/set_var.cc:
        Better SQL_MODE handling (Setting complex options also sets sub options)
      sql/set_var.h:
        Better SQL_MODE handling
      sql/sql_base.cc:
        Make alias depend on --lower-case-table-names
        Make find_item_in_list also check database name
      sql/sql_cache.cc:
        Indentation cleanup
      sql/sql_list.h:
        Added safety assert
        Addes support of alloc without current_thd()
      sql/sql_prepare.cc:
        Update after prototype change
      sql/sql_select.cc:
        Added ROLLUP
      sql/sql_select.h:
        structures for rollup
      sql/sql_show.cc:
        Easier SQL_MODE handling
      sql/sql_string.cc:
        Move CHARSET_INFO to mysqld (to be together with all other global variables)
      sql/sql_string.h:
        Added function to be able to avoid calling current_thd() when doing new Item.
      sql/sql_table.cc:
        Simpler --lower-case-table-name handling
      sql/sql_union.cc:
        Update after prototype change
      sql/sql_yacc.yy:
        ROLLUP
      sql/unireg.h:
        bmove_allign ->bmove_align
      strings/Makefile.am:
        Fix to be able to compile str_test.c
      strings/ctype.c:
        Removed empty lines
      strings/str_test.c:
        Added test of bmove_align
      strings/strings-x86.s:
        Faster bmove_align, bmove_upp and strmake
      strings/strings.asm:
        move_allg
      b388eb00
  20. 12 Jun, 2002 1 commit
    • unknown's avatar
      Added the following new privleges: · 0724f98e
      unknown authored
      SHOW DATABASES
      CREATE TEMPORARY TABLE
      LOCK TABLES
      REPLICATION SLAVE & REPLICATION CLIENT
      SUPER
      EXECUTE
      
      All scripts & documentation is updated for this change.
      Added better error messages for global privileges 
      
      
      BitKeeper/deleted/.del-mysql_new_fix_privilege_tables.sh~b1664b401375eece:
        Delete: scripts/mysql_new_fix_privilege_tables.sh
      Docs/manual.texi:
        Updated manual for privilege changes.
      include/mysqld_error.h:
        new error messages
      mysql-test/install_test_db.sh:
        Updated to use new privileges
      mysql-test/r/grant_cache.result:
        Updated to use new privileges
      mysql-test/r/rpl000017.result:
        Updated to use new privileges
      mysql-test/t/rpl000017.test:
        Updated to use new privileges
      mysys/safemalloc.c:
        Cleanup
      scripts/mysql_fix_privilege_tables.sh:
        Updated to use new privileges
      scripts/mysql_install_db.sh:
        Updated to use new privileges
      sql/field.h:
        Cleanup
      sql/item_strfunc.cc:
        Updated to use new privileges
      sql/lex.h:
        Updated to use new privileges
      sql/log.cc:
        Updated to use new privileges
      sql/mysql_priv.h:
        Updated to use new privileges
      sql/mysqld.cc:
        Updated to use new privileges
      sql/repl_failsafe.cc:
        Updated to use new privileges
      sql/share/czech/errmsg.txt:
        new error messages
      sql/share/danish/errmsg.txt:
        new error messages
      sql/share/dutch/errmsg.txt:
        new error messages
      sql/share/english/errmsg.txt:
        new error messages
      sql/share/estonian/errmsg.txt:
        new error messages
      sql/share/french/errmsg.txt:
        new error messages
      sql/share/german/errmsg.txt:
        new error messages
      sql/share/greek/errmsg.txt:
        new error messages
      sql/share/hungarian/errmsg.txt:
        new error messages
      sql/share/italian/errmsg.txt:
        new error messages
      sql/share/japanese/errmsg.txt:
        new error messages
      sql/share/korean/errmsg.txt:
        new error messages
      sql/share/norwegian-ny/errmsg.txt:
        new error messages
      sql/share/norwegian/errmsg.txt:
        new error messages
      sql/share/polish/errmsg.txt:
        new error messages
      sql/share/portuguese/errmsg.txt:
        new error messages
      sql/share/romanian/errmsg.txt:
        new error messages
      sql/share/russian/errmsg.txt:
        new error messages
      sql/share/slovak/errmsg.txt:
        new error messages
      sql/share/spanish/errmsg.txt:
        new error messages
      sql/share/swedish/errmsg.txt:
        new error messages
      sql/share/ukrainian/errmsg.txt:
        new error messages
      sql/slave.cc:
        Portability cleanup
      sql/sql_acl.cc:
        Updated to use new privileges
      sql/sql_acl.h:
        Updated to use new privileges
      sql/sql_base.cc:
        Remove not used include file
      sql/sql_class.cc:
        Comment cleanup
      sql/sql_class.h:
        Updated to use new privileges
        Comment cleanups
      sql/sql_insert.cc:
        Updated to use new privileges
      sql/sql_lex.h:
        Indentation cleanup
      sql/sql_parse.cc:
        Updated to use new privileges
      sql/sql_repl.cc:
        Updated to use new privileges
        Comment cleanup
      sql/sql_show.cc:
        Updated to use new privileges
      sql/sql_yacc.yy:
        Updated to use new privileges
        Sorted some tockens for easer merge to 4.1 in the future.
      sql/table.h:
        Updated to use new privileges
      tests/grant.pl:
        Updated to use new privileges
      tests/grant.res:
        Updated to use new privileges
      0724f98e
  21. 22 Dec, 2001 1 commit
    • unknown's avatar
      Fixed access privilege bug in query cache. · 9625a39d
      unknown authored
      Change tests to use database 'mysqltest' instead of 'foo'
      Add option to not print access denied messages to check_table_access()
      
      
      Docs/manual.texi:
        Updated query cache information.
      client/mysqltest.c:
        When connection to the database '*NO-ONE*, connect without specify a database.
      include/raid.h:
        Portability fix
      mysql-test/r/drop.result:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/r/flush.result:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/r/innodb.result:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/r/query_cache.result:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/t/drop.test:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/t/flush.test:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/t/innodb.test:
        Change test to use database 'mysqltest' instead of 'foo'
      mysql-test/t/query_cache.test:
        Change test to use database 'mysqltest' instead of 'foo'
      sql/mysql_priv.h:
        Add option to not print access denied messages
      sql/net_pkg.cc:
        Fix for query cache
      sql/net_serv.cc:
        Speed improvment
      sql/sql_cache.cc:
        Fixed access privilege bug in query cache
      sql/sql_cache.h:
        Always compiled with integrity check function prototypes.
      sql/sql_do.cc:
        Removed warning
      sql/sql_parse.cc:
        Add option to not print access denied messages
      9625a39d