An error occurred fetching the project authors.
  1. 30 Mar, 2004 2 commits
  2. 26 Mar, 2004 1 commit
    • unknown's avatar
      1. New data types, from the user point of view: · d98ff080
      unknown authored
         BINARY(N) and VARBIBARY(N)
      2. More 4.0 compatibility and more BINARY keyword consistency:
      2a. CREATE TABLE a (a CHAR(N) BINARY) 
          is now synonym for
          CREATE TABLE a (a CHAR(N) COLLATE xxxx_bin)
      2b. SELECT BINARY x
          is still synonin for
          SELECT x COLLATE xxxxx_bin.
      
      d98ff080
  3. 25 Mar, 2004 1 commit
    • unknown's avatar
      Fixed BUG#3117: LAST_INSERT_ID() works incorrectly inside stored procedure. · addb7842
      unknown authored
      This turned out to be a problem for prepared statements as well; the id was
      evaluated once, at parse time.
      
      
      mysql-test/r/auto_increment.result:
        Updated results after bugfix in last_insert_id().
      mysql-test/r/query_cache.result:
        Updated results after bugfix in last_insert_id().
      mysql-test/r/variables.result:
        Updated results after bugfix in last_insert_id().
      sql/item_func.cc:
        Fixed bug in last_insert_id(); get id at each evaluation (and not in the parser).
        Renamed the class Item_func_set_last_insert_id too, since it's not only for setting.
      sql/item_func.h:
        Fixed bug in last_insert_id(); get id at each evaluation (and not in the parser).
        Renamed the class Item_func_set_last_insert_id too, since it's not only for setting.
      sql/sql_yacc.yy:
        Fixed bug in last_insert_id(); get id at each evaluation (and not in the parser).
        Renamed the class Item_func_set_last_insert_id too, since it's not only for setting.
      tests/client_test.c:
        Test case for last_insert_id() in prepared statements.
      addb7842
  4. 24 Mar, 2004 1 commit
  5. 23 Mar, 2004 1 commit
  6. 20 Mar, 2004 1 commit
    • unknown's avatar
      after review changes · 042b46fc
      unknown authored
      sql/item.cc:
        removed double_fix & already_fixed in Item_field
      sql/item.h:
        added quick_fix_field() for cases when we are sure that no need full fix_field processing
        fixed neg() method for numeric constants to have the same logic as constant parser
        Item_null, Item_real, ... are constant which are fixed by creation
      sql/item_cmpfunc.h:
        right fix_fields in and_conds call
      sql/item_func.cc:
        changed Item_field constructor call
        fix_field emulation call
      sql/item_strfunc.cc:
        correct layout
      sql/item_subselect.cc:
        correct layout
        changed Item_field constructor call
      sql/item_sum.cc:
        changed Item_field constructor call
      sql/item_sum.h:
        changed Item_field constructor call
      sql/sql_base.cc:
        fixed layout
        right fix_fields calls
      sql/sql_help.cc:
        changed Item_field constructor call
      sql/sql_load.cc:
        changed Item_field constructor call
      sql/sql_parse.cc:
        constant changed
      sql/sql_select.cc:
        fixed layout
        fix_field emulation insted of real fix_fields call
      sql/sql_show.cc:
        changed Item_field constructor call
      sql/sql_union.cc:
        changed Item_field constructor call
        double_fix removed
      sql/sql_update.cc:
        renamed variable, fixed layout
      sql/sql_yacc.yy:
        typo fixed
        fix_fields emulation calls
        hegation of numbers fixed
      042b46fc
  7. 18 Mar, 2004 2 commits
    • unknown's avatar
      fixed signed numeric literal parsing · adc4aa5a
      unknown authored
      sql/item.h:
        added negation methods for numeric Items
      sql/sql_yacc.yy:
        fixed numeric literal
      adc4aa5a
    • unknown's avatar
      DBUG_ASSERT(fixed == 1); added to val* · ad2c3773
      unknown authored
      small optimisation in signed_literal
      
      
      sql/field.cc:
        layout fixed
      sql/item.cc:
        DBUG_ASSERT(fixed == 1); added to val*
        layout fixed
        fixed= 1; added where it was forgoten in fix_fields
        Item_string can be used without fix_fields
      sql/item.h:
        DBUG_ASSERT(fixed == 1); added to val*
        Item_string can be used without fix_fields
      sql/item_cmpfunc.cc:
        DBUG_ASSERT(fixed == 1); added to val*
      sql/item_cmpfunc.h:
        fixed layout and getting Item statistic
      sql/item_func.cc:
        DBUG_ASSERT(fixed == 1); added to val*
      sql/item_func.h:
        DBUG_ASSERT(fixed == 1); added to val*
      sql/item_geofunc.cc:
        DBUG_ASSERT(fixed == 1); added to val*
      sql/item_strfunc.cc:
        DBUG_ASSERT(fixed == 1); added to val*
        layout fixed
      sql/item_strfunc.h:
        DBUG_ASSERT(fixed == 1); added to val*
      sql/item_subselect.cc:
        DBUG_ASSERT(fixed == 1); added to val*
      sql/item_sum.cc:
        DBUG_ASSERT(fixed == 1); added to val*
      sql/item_sum.h:
        DBUG_ASSERT(fixed == 1); added to val*
      sql/item_timefunc.cc:
        DBUG_ASSERT(fixed == 1); added to val*
      sql/item_timefunc.h:
        DBUG_ASSERT(fixed == 1); added to val*
      sql/item_uniq.h:
        DBUG_ASSERT(fixed == 1); added to val*
      sql/sql_base.cc:
        Item creation revised
      sql/sql_help.cc:
        Item creation revised
      sql/sql_load.cc:
        Item creation revised
      sql/sql_parse.cc:
        fix_field call added
      sql/sql_select.cc:
        Item creation revised
      sql/sql_show.cc:
        Item creation revised
      sql/sql_union.cc:
        Item creation revised
      sql/sql_update.cc:
        Item creation revised
      sql/sql_yacc.yy:
        Item creation revised
        small optimisation in signed_literal
      ad2c3773
  8. 16 Mar, 2004 2 commits
  9. 12 Mar, 2004 1 commit
    • unknown's avatar
      Spatial code changed to get rid of inconsistent this->* operation · 97af7fae
      unknown authored
      Now we use virtual calls instead and redirect VMT pointer of the
      geometry object with 'new' operation
      
      
      sql/field.cc:
        Usage of the Geometry class changed
      sql/item_geofunc.cc:
        Usage of the Geometry class changed
      sql/spatial.cc:
        Now we rewrite the real VMT of the object with new operation
      sql/spatial.h:
        No need for the VMT-like structure and pointers to it
      sql/sql_yacc.yy:
        enum items was renamed accordingly to coding standards
      97af7fae
  10. 10 Mar, 2004 1 commit
    • unknown's avatar
      Fixed memory leak in DROP DATABASE when using RAID tables (Bug #2882) · 98cd9f93
      unknown authored
      BUILD/compile-pentium-debug-max:
        Added --with-raid
      configure.in:
        Removed -DFN_NO_CASE_SENCE for Mac OS X as this is not always true
      mysql-test/install_test_db.sh:
        Added --skip-warnings
      mysql-test/mysql-test-run.sh:
        Fixes to get --gdb and --ddd to work
      mysql-test/r/lowercase_table2.result:
        Test for lower_case_table_names=2 and temporary tables
      mysql-test/r/lowercase_table3.result:
        Fixed error message
      mysql-test/r/multi_update.result:
        Test of behaviour of multi-table-delete and alias
      mysql-test/t/lowercase_table2.test:
        Test for lower_case_table_names=2 and temporary tables
      mysql-test/t/lowercase_table3.test:
        Fixed error
      mysql-test/t/multi_update.test:
        Test of behaviour of multi-table-delete and alias (Bug #2940)
      mysys/mf_iocache.c:
        Renamed _flush_io_cache to my_b_flush_io_cache
      sql/ha_myisam.cc:
        Added comment
      sql/lock.cc:
        Extra debugging
      sql/log.cc:
        New parameter to flush_relay_log_info
      sql/log_event.cc:
        New parameter to flush_relay_log_info
      sql/mf_iocache.cc:
        Removed not used header files
      sql/mysqld.cc:
        More debugging info
        Less warnings when run with --skip-warnings
      sql/opt_range.cc:
        More debug information
      sql/repl_failsafe.cc:
        New parameter to flush_relay_log_info
      sql/slave.cc:
        First start SQL thread, then start IO thread. This fixed a raze condition in SLAVE START (Bug #2921)
        Ensure that we have a lock on the IO thread before flushing a relay log file that. The original code could core dump when a relay log rotated.
      sql/slave.h:
        New parameter to flush_relay_log_info
      sql/sql_base.cc:
        Added warning
      sql/sql_handler.cc:
        Indentation fix
      sql/sql_repl.cc:
        New parameter to flush_relay_log_info
      sql/sql_select.cc:
        Fixed problem with deleting temporary tables when using lower_case_table_names=2. (Bug #2858)
      sql/sql_table.cc:
        Fixed comment
      sql/sql_yacc.yy:
        Removed compiler warning
      include/my_sys.h:
        Fixed usage of unpack_filename
      mysys/mf_pack.c:
        Changed unpack_filename() to return length of result string.
      mysys/test_fn.c:
        Fixed usage of unpack_filename
      sql/sql_db.cc:
        Fixed memory leak with raid tables
      sql/table.cc:
        Fixed usage of unpack_filename
      98cd9f93
  11. 05 Mar, 2004 1 commit
    • unknown's avatar
      Portability fixes · 84a38930
      unknown authored
      mysql-test/r/show_check.result:
        Updated results
      mysql-test/t/show_check.test:
        Portability fix (for 64 bit platforms)
      mysys/hash.c:
        Portablity fix
      sql/gen_lex_hash.cc:
        Don't include mysql_priv.h;  Causes build errors on a lot of platforms
      sql/lex_symbol.h:
        Moved symbols here from mysql_priv.h to avoid including mysql_priv.h in gen_lex_hash.cc
      sql/mysql_priv.h:
        Move symbols and struct to lex_symbol.h
      sql/sql_db.cc:
        Don't use sql_alloc/sql_free methods in sql_string.h
      sql/sql_help.cc:
        Don't use sql_alloc/sql_free methods in sql_string.h
      sql/sql_string.h:
        Don't use sql_alloc/sql_free methods in sql_string.h
        This makes the code faster and more portable
      sql/sql_yacc.yy:
        Don't use sql_alloc/sql_free methods in sql_string.h
      84a38930
  12. 02 Mar, 2004 1 commit
    • unknown's avatar
      Desperate attempt to push part of prepared statements cleanup which was · dba4dce2
      unknown authored
      reviewed in Saint-Petersbourg (including post-review fixes).
      
      
      include/my_sys.h:
        Added clear_alloc_root (reset alloc root without freeing its memory)
      sql/item.h:
        - rename setup_param -> set_parap (function assigns parameter value to item)
      sql/mysql_priv.h:
        - all return values are void, because return value is never checked in
            dispatch_command
        - removed unused declaration of setup_param_functions
      sql/protocol.h:
        - unused declarations of setup_params_data* removed
      sql/sql_class.cc:
        Cleanup:
          - bzero(mem_root) replaced with clear_alloc_root
          - query_id and command members moved back to THD from Statement
        Assignment of mem_root, free_list, query_id and command optimized
        away from set_statement().
      sql/sql_class.h:
        - query_id and command moved back to THD from Statement
      sql/sql_lex.h:
        - better type for param_list
        - param_count is the same thing as param_list.elements
      sql/sql_parse.cc:
        - comments for dispatch_command
      sql/sql_prepare.cc:
        Cleanup:
        - added comments to many functions and removed trailing spaces in many 
          lines, some stale comments removed.
        - it's faster to iterate using pointers, than classes
        - Renames: error_in_prepare renamed to get_longdata_error (because it is set
          when there is an error in mysql_send_longdata, rather than in
          mysql_prepare), embedded versions of placeholder assignement functions
          now have prefix emb_, setup_ functions renamed to set_, because they
          perform assignment, not installation, setup_params_data now doesn't
          call insert_params and was renamed to setup_set_param_functions,
        - find_prepared_statement should not send error if called from no-reply
          calls, like mysql_stmt_reset
        - error reporting is checked up, to always report errors and not report
          errors twice. send_prep_stmt can be done mostly in send_prepare_result, 
          rather than in test_* functions.
        - now we don't need to reinit THD->mem_root/free_list in mysql_stmt_execute,
          because it's not reset there.
      tests/client_test.c:
        - removed second call to test_subqueries
      dba4dce2
  13. 22 Feb, 2004 1 commit
    • unknown's avatar
      Cleanups · 1052b612
      unknown authored
      acinclude.m4:
        Remove innobase/libodbc
      innobase/Makefile.am:
        Remove innobase/libodbc
      sql/sql_delete.cc:
        Indentation cleanup
      sql/sql_yacc.yy:
        Fixed wrong merge
      1052b612
  14. 21 Feb, 2004 2 commits
  15. 16 Feb, 2004 2 commits
    • unknown's avatar
      6b9072f7
    • unknown's avatar
      After merge fixes · a8983f07
      unknown authored
      Added more DBUG statements
      Ensure that we are comparing end space with BINARY strings
      Use 'any_db' instead of '' to mean any database. (For HANDLER command)
      Only strip ' ' when comparing CHAR, not other space-like characters (like \t)
      
      
      BitKeeper/deleted/.del-ctype_tis620.result-old~3578ceb0b8284685:
        Delete: mysql-test/r/ctype_tis620.result-old
      BitKeeper/deleted/.del-ctype_tis620.test-old~ffb1bbd2935d1aba:
        Delete: mysql-test/t/ctype_tis620.test-old
      client/mysqlbinlog.cc:
        Added DBUG statements
        Added call of my_end() to free all used memory on exit
      heap/hp_info.c:
        After merge fixes
      heap/hp_open.c:
        After merge fixes
      include/heap.h:
        After merge fixes
      include/m_ctype.h:
        Use pchar instead of 'int' for character parameters.
        Added 'my_binary_compare()'
      include/m_string.h:
        Fixed wrong define
      innobase/ibuf/ibuf0ibuf.c:
        After merge fixes
      innobase/srv/srv0start.c:
        After merge fixes
      mysql-test/r/alter_table.result:
        Fixed results after merge
      mysql-test/r/auto_increment.result:
        Fixed results after merge
      mysql-test/r/bdb.result:
        Fixed results after merge
      mysql-test/r/binary.result:
        Fixed results after merge
      mysql-test/r/create.result:
        Fixed results after merge
      mysql-test/r/ctype_mb.result:
        Fixed results after merge
      mysql-test/r/ctype_tis620.result:
        Fixed results after merge
      mysql-test/r/ctype_utf8.result:
        Fixed results after merge
      mysql-test/r/delete.result:
        Fixed results after merge
      mysql-test/r/func_compress.result:
        Fixed results after merge
      mysql-test/r/func_gconcat.result:
        Fixed results after merge
      mysql-test/r/func_group.result:
        Fixed results after merge
      mysql-test/r/func_str.result:
        Fixed results after merge
      mysql-test/r/innodb.result:
        Fixed results after merge
      mysql-test/r/insert.result:
        Fixed results after merge
      mysql-test/r/insert_select.result:
        Fixed results after merge
      mysql-test/r/key.result:
        Fixed results after merge
      mysql-test/r/loaddata.result:
        Fixed results after merge
      mysql-test/r/lock.result:
        Fixed results after merge
      mysql-test/r/myisam.result:
        Fixed results after merge
      mysql-test/r/null.result:
        Fixed results after merge
      mysql-test/r/null_key.result:
        Fixed results after merge
      mysql-test/r/order_by.result:
        Fixed results after merge
      mysql-test/r/query_cache.result:
        Fixed results after merge
      mysql-test/r/range.result:
        Fixed results after merge
      mysql-test/r/rpl_multi_delete.result:
        Fixed results after merge
      mysql-test/r/rpl_until.result:
        Fixed results after merge
      mysql-test/r/subselect.result:
        Fixed results after merge
      mysql-test/r/subselect_innodb.result:
        Fixed results after merge
      mysql-test/r/type_blob.result:
        Fixed results after merge
      mysql-test/r/type_datetime.result:
        Fixed results after merge
      mysql-test/r/type_decimal.result:
        Fixed results after merge
      mysql-test/r/type_enum.result:
        Fixed results after merge
      mysql-test/r/type_float.result:
        Fixed results after merge
      mysql-test/r/type_ranges.result:
        Fixed results after merge
      mysql-test/r/type_time.result:
        Fixed results after merge
      mysql-test/r/type_timestamp.result:
        Fixed results after merge
      mysql-test/r/type_uint.result:
        Fixed results after merge
      mysql-test/r/type_year.result:
        Fixed results after merge
      mysql-test/r/variables.result:
        Fixed results after merge
      mysql-test/r/warnings.result:
        Fixed results after merge
      mysql-test/t/case.test:
        Fixed shifted error messages
      mysql-test/t/create.test:
        Fixed shifted error messages
      mysql-test/t/ctype_collate.test:
        Fixed shifted error messages
      mysql-test/t/ctype_tis620.test:
        Merge with 4.0 ctype_tis620 test
      mysql-test/t/delete.test:
        Fixed shifted error messages
      mysql-test/t/derived.test:
        Fixed shifted error messages
      mysql-test/t/fulltext.test:
        Fixed shifted error messages
      mysql-test/t/func_in.test:
        Fixed shifted error messages
      mysql-test/t/func_str.test:
        Fixed shifted error messages
      mysql-test/t/func_test.test:
        Fixed shifted error messages
      mysql-test/t/grant.test:
        Fixed shifted error messages
      mysql-test/t/innodb.test:
        Change to 4.1 syntax
      mysql-test/t/key_cache.test:
        Fixed shifted error messages
      mysql-test/t/myisam.test:
        New test of blob and end space
      mysql-test/t/row.test:
        Fixed shifted error messages
      mysql-test/t/rpl_until.test:
        Fixed shifted error messages
      mysql-test/t/subselect.test:
        Fixed shifted error messages
      mysql-test/t/subselect_innodb.test:
        Fix test to take into account foreign key constraints
      mysql-test/t/union.test:
        Fixed shifted error messages
      mysql-test/t/user_var.test:
        Fixed shifted error messages
      mysql-test/t/variables.test:
        Fixed shifted error messages
      mysys/my_handler.c:
        Merge with 4.0 code
      sql/ha_heap.cc:
        After merge fixes
      sql/handler.cc:
        After merge fixes
      sql/item.cc:
        After merge fixes
      sql/item_cmpfunc.cc:
        Ensure that we are comparing end space with BINARY strings
      sql/item_cmpfunc.h:
        Ensure that we are comparing end space with BINARY strings
      sql/log_event.cc:
        More DBUG statements
        Ensure that we use all options to LOAD DATA in replication
      sql/opt_range.cc:
        After merge fixes
      sql/sql_db.cc:
        After merge fixes
      sql/sql_handler.cc:
        After merge fixes
        Use 'any_db' instead of '' to mean 'no database comparison'
      sql/sql_parse.cc:
        After merge fixes
      sql/sql_select.cc:
        After merge fixes
        Added function comment for setup_group()
      sql/sql_string.cc:
        Added stringcmp() for binary comparison.
        Added function comments for sortcmp() and stringcmp()
      sql/sql_string.h:
        Added stringcmp()
      sql/sql_table.cc:
        After merge fixes
      sql/sql_update.cc:
        After merge fixes
      sql/sql_yacc.yy:
        Use 'any_db' instead of '' to mean any database. Using "" causes a 'wrong db name' error.
      strings/ctype-big5.c:
        Strip only end space, not other space characters.
      strings/ctype-bin.c:
        Removed some not needed functions.
        Added function comments
        Don't remove end space in comparisons
        Change my_wildcmp_bin() to be 'identical' with other similar code
      strings/ctype-czech.c:
        Strip only end space, not other space characters.
      strings/ctype-gbk.c:
        Strip only end space, not other space characters.
      strings/ctype-latin1.c:
        Strip only end space, not other space characters.
      strings/ctype-mb.c:
        Strip only end space, not other space characters.
      strings/ctype-simple.c:
        Strip only end space, not other space characters.
      strings/ctype-sjis.c:
        Strip only end space, not other space characters.
      strings/ctype-tis620.c:
        Added usage of my_instr_simple. This needs to be cleaned up!
      strings/ctype-utf8.c:
        Strip only end space, not other space characters.
      strings/ctype-win1250ch.c:
        Strip only end space, not other space characters.
        Fixed indentation
      strings/strto.c:
        Code cleanup
      a8983f07
  16. 15 Feb, 2004 1 commit
  17. 12 Feb, 2004 1 commit
  18. 11 Feb, 2004 1 commit
  19. 09 Feb, 2004 1 commit
    • unknown's avatar
      Added --compact to mysqlbinlog · de0fbb06
      unknown authored
      Fixed output from mysqlbinlog when using --skip-comments
      Fixed warnings from valgrind
      Fixed ref_length when used with HEAP tables
      More efficent need_conversion()
      Fixed error handling in UPDATE with not updateable tables
      Fixed bug in null handling in CAST to signed/unsigned
      
      
      
      client/client_priv.h:
        cleanup & added OPT_COMPACT
      client/mysqldump.c:
        Added option --compact to get a compact readable dump.
        Ensure that SET CHARACTER_SET_CLIENT is not done if we have not remembered the old character set
        Print optimization comments even if --skip-comments are given as these are not true comments. (Before these where only printed at end, which was a bug)
      mysql-test/r/cast.result:
        More cast tests
      mysql-test/r/derived.result:
        Removed warnings
      mysql-test/r/mysqldump.result:
        Update results after fixing mysqlbinlog
      mysql-test/r/query_cache.result:
        Make test usable with --extern
        more tests
      mysql-test/r/rpl_until.result:
        Make test repeatable under valgrind
      mysql-test/r/sql_mode.result:
        Fix test result
      mysql-test/r/subselect.result:
        Make test smaller. Update wrong results
      mysql-test/t/cast.test:
        More cast tests
      mysql-test/t/derived.test:
        Removed warnings
      mysql-test/t/query_cache.test:
        Make test usable with --extern
        more tests
      mysql-test/t/rpl_until.test:
        fix for valgrind.  Becasue of unknown reason one got 'Slave_SQL_Running=yes' in this setup
      mysql-test/t/subselect.test:
        Make test case smaller
      sql/field.cc:
        Updated need_conversion() to use new arguments
      sql/ha_heap.cc:
        Moved initialization of ref_length to right place. This fixed problem that we had a ref_length of 8 for heap tables, which was not efficent.
      sql/item_func.cc:
        Cleanup
      sql/item_func.h:
        Fixed bug in null_handling for cast to signed/unsigned
      sql/item_strfunc.cc:
        Optimized/cleaned up Item_func_conv_charset3
      sql/item_sum.cc:
        Cleanup.
        Ensure that some flag variables are cleared in cleanup()
      sql/item_sum.h:
        Fixed references to uninitialized memory
      sql/opt_range.cc:
        Fixed spelling error
      sql/sql_class.cc:
        Fixed wrong return code, which could case protocol problems
      sql/sql_class.h:
        After merge fix
      sql/sql_prepare.cc:
        Added comments
      sql/sql_show.cc:
        Cleanup
      sql/sql_string.cc:
        Optimzed usage of need_conversion().
        - Removed not used argument
        - Save diff lenght in 'offset' to not have to recalculate length several times.
        Cleaned up comment
        Optimized copy_aligned() based on the knowledge that it's only called when you have wrong data
      sql/sql_string.h:
        Updated need_conversion() and copy_aligned() to use new arguments
      sql/sql_update.cc:
        Fixed error handling with non-updateable tables
      sql/sql_yacc.yy:
        Ensure that lex->lock_options are set correctly (to get rid of warnings from valgrind)
        Ensure that cast_type sets lex->charset and lex->length. Without these CONVERT() didn't work properly
      de0fbb06
  20. 04 Feb, 2004 1 commit
    • unknown's avatar
      correct assignment of default limit (BUG#2600) · 3af341d2
      unknown authored
      mysql-test/r/subselect.result:
        test of global limit and subqueries
      mysql-test/t/subselect.test:
        test of global limit and subqueries
      sql/sql_lex.cc:
        correct detection of non-default limits
      sql/sql_parse.cc:
        correct assignment of default limit
      sql/sql_yacc.yy:
        correct assignment of default limit
      3af341d2
  21. 02 Feb, 2004 2 commits
    • unknown's avatar
      fixed parsing mode for derived tables (BUG#2421) · 2cb1467f
      unknown authored
      mysql-test/r/derived.result:
        test of BUG#2421
      mysql-test/t/derived.test:
        test of BUG#2421
      sql/sql_yacc.yy:
        fixed parsing mode for derived tables
      2cb1467f
    • unknown's avatar
      preload.result, key_cache.result, preload.test, key_cache.test, sql_yacc.yy: · d2517310
      unknown authored
        Fixed bug #2602 in CACHE INDEX, LOAD INDEX
      
      
      sql/sql_yacc.yy:
        Fixed bug #2602 in CACHE INDEX, LOAD INDEX
      mysql-test/t/key_cache.test:
        Fixed bug #2602 in CACHE INDEX, LOAD INDEX
      mysql-test/t/preload.test:
        Fixed bug #2602 in CACHE INDEX, LOAD INDEX
      mysql-test/r/key_cache.result:
        Fixed bug #2602 in CACHE INDEX, LOAD INDEX
      mysql-test/r/preload.result:
        Fixed bug #2602 in CACHE INDEX, LOAD INDEX
      d2517310
  22. 28 Jan, 2004 1 commit
  23. 26 Jan, 2004 2 commits
  24. 23 Jan, 2004 1 commit
    • unknown's avatar
      SCRUM · 1c8de850
      unknown authored
      wl #1163 (Make spatial code optional)
      Patch I cleaned with Serg & Monty's suggestions
      
      
      sql/gen_lex_hash.cc:
        mysql_priv.h was included for SYM_GROUP declaration
      sql/lex.h:
        sym_group_xxx made global so we can use texts from them
        throughout the code
      sql/lex_symbol.h:
        SYM_GROUP declaration moved to mysql_priv.h
      sql/mysql_priv.h:
        declarations about SYM_GROUP
      sql/sql_table.cc:
        sym_group_xxx objects used instead of text constants
        a couple of HAVE_SPATIAL removed
      sql/sql_yacc.yy:
        sym_group_xxx used instead of text constants
        some duplicated code restructured
        MYF(0) parameters removed from net_printf calls
      1c8de850
  25. 22 Jan, 2004 1 commit
  26. 18 Jan, 2004 1 commit
  27. 15 Jan, 2004 1 commit
    • unknown's avatar
      SCRUM: · 975a611b
      unknown authored
      WL#1163 (Making spatial code optional)
      Pack of changes to do in sql/ code.
      
      
      sql/field.cc:
        Spatial code #ifdef-ed
      sql/field.h:
        Spatial code #ifdef-ed
      sql/item_create.cc:
        Spatial code #ifdef-ed
      sql/item_create.h:
        Spatial code #ifdef-ed
      sql/item_geofunc.cc:
        Spatial code #ifdef-ed
      sql/item_geofunc.h:
        Spatial code #ifdef-ed
        GEOM_NEW implementation
      sql/lex.h:
        Code was significally modified to support optional group
        of functions
      sql/lex_symbol.h:
        SYM_GROUP structure presented
      sql/sql_table.cc:
        Spatial code #ifdef-ed
      sql/sql_yacc.yy:
        Several modifications to make spatial code optional
      sql/table.cc:
        Spatial code #ifdef-ed
      sql/unireg.cc:
        Spatial code #ifdef-ed
      975a611b
  28. 13 Jan, 2004 1 commit
  29. 04 Jan, 2004 1 commit
    • unknown's avatar
      allow UPDATE and DELETE stetements with tables derived from subquery if they... · d2b540a7
      unknown authored
      allow UPDATE and DELETE stetements with tables derived from subquery if they are not updated (BUG#2117)
      allow delete table by alias in multi-delete statement
      
      
      
      include/mysqld_error.h:
        new error message about non-updateable table
      mysql-test/r/derived.result:
        test of multi-update and multi-delete
      mysql-test/t/derived.test:
        test of multi-update and multi-delete
      sql/share/czech/errmsg.txt:
        new error message about non-updateable table
      sql/share/danish/errmsg.txt:
        new error message about non-updateable table
      sql/share/dutch/errmsg.txt:
        new error message about non-updateable table
      sql/share/english/errmsg.txt:
        new error message about non-updateable table
      sql/share/estonian/errmsg.txt:
        new error message about non-updateable table
      sql/share/french/errmsg.txt:
        new error message about non-updateable table
      sql/share/german/errmsg.txt:
        new error message about non-updateable table
      sql/share/greek/errmsg.txt:
        new error message about non-updateable table
      sql/share/hungarian/errmsg.txt:
        new error message about non-updateable table
      sql/share/italian/errmsg.txt:
        new error message about non-updateable table
      sql/share/japanese/errmsg.txt:
        new error message about non-updateable table
      sql/share/korean/errmsg.txt:
        new error message about non-updateable table
      sql/share/norwegian-ny/errmsg.txt:
        new error message about non-updateable table
      sql/share/norwegian/errmsg.txt:
        new error message about non-updateable table
      sql/share/polish/errmsg.txt:
        new error message about non-updateable table
      sql/share/portuguese/errmsg.txt:
        new error message about non-updateable table
      sql/share/romanian/errmsg.txt:
        new error message about non-updateable table
      sql/share/russian/errmsg.txt:
        new error message about non-updateable table
      sql/share/serbian/errmsg.txt:
        new error message about non-updateable table
      sql/share/slovak/errmsg.txt:
        new error message about non-updateable table
      sql/share/spanish/errmsg.txt:
        new error message about non-updateable table
      sql/share/swedish/errmsg.txt:
        new error message about non-updateable table
      sql/share/ukrainian/errmsg.txt:
        new error message about non-updateable table
      sql/sql_parse.cc:
        allow delete table by alias
        separate error message for try to delete derived table
      sql/sql_update.cc:
        test "is updated table derived?"
      sql/sql_yacc.yy:
        error message in case of try to update derived table
      d2b540a7
  30. 30 Dec, 2003 1 commit
    • unknown's avatar
      Fix for prepared statements · c3b49a4e
      unknown authored
      Here i added Item_*::cleanup() functions,
      removed a lot of ~Item_*'s,
      added code to restore order_list and group_list
      
      
      sql/item.cc:
        cleanups methods implemented
        Item_ref constructors changed
      sql/item.h:
        cleanups declared
        Item_ref constructors changed
        some ~Item_* deleted
      sql/item_cmpfunc.cc:
        new Item_ref format
      sql/item_cmpfunc.h:
        saving/restoring of the original arguments added to
        eq and equal functions
      sql/item_func.cc:
        New Item_ref format
      sql/item_func.h:
        destructors removed/changed to 'cleanup()'
      sql/item_row.cc:
        New Item_ref format
      sql/item_row.h:
        ~Item_row -> cleanup()
      sql/item_strfunc.cc:
        new Item_ref format
      sql/item_strfunc.h:
        destructors removed
      sql/item_subselect.cc:
        Item_subselect implementation,
        new Item_ref() format
      sql/item_subselect.h:
        cleanups for subselects declared
      sql/item_sum.cc:
        cleanups implementations
      sql/item_sum.h:
        cleanups declarations
        destructors removed
      sql/mysql_priv.h:
        free_items, cleanup_items exported
      sql/sql_prepare.cc:
        cleanup_items, free_items calls added
        stmt->query_id= thd->query_id restored
        cleanup procedures for group_list and order_list added
      sql/sql_yacc.yy:
        New Item_ref() format
      c3b49a4e
  31. 19 Dec, 2003 2 commits
    • unknown's avatar
      THD::lex now points to THD::main_lex like in 5.0 · 0b098472
      unknown authored
      All tests pass (client_test included)
      
      
      libmysqld/lib_sql.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/filesort.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/ha_innodb.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/ha_myisam.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/item.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/item_cmpfunc.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/item_create.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/item_func.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/item_subselect.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/item_sum.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/mysql_priv.h:
        THD::lex now points to THD::main_lex like in 5.0
      sql/mysqld.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/protocol.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/repl_failsafe.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/slave.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_acl.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_base.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_cache.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_class.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_class.h:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_delete.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_error.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_insert.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_lex.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_lex.h:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_parse.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_prepare.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_repl.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_select.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_table.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_union.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_update.cc:
        THD::lex now points to THD::main_lex like in 5.0
      sql/sql_yacc.yy:
        THD::lex now points to THD::main_lex like in 5.0
      0b098472
    • unknown's avatar
      Fixes after merge with 4.0 · c9f5145a
      unknown authored
      Cleaned up embedded library access and query cache handling
      Changed min stack size to 128K (to allow longer MyISAM keys)
      Fixed wrong priority for XOR (should be less than NEG to get -1^1 to work)
      
      
      client/mysqldump.c:
        Fixed bugs found after merge
      include/mysql_embed.h:
        Disable query cache when using embedded version
      myisam/mi_check.c:
        Removed not used variable
      mysql-test/r/auto_increment.result:
        Fixed bugs found after merge
      mysql-test/r/bdb.result:
        Fixed bugs found after merge
      mysql-test/r/func_group.result:
        Fixed bugs found after merge
      mysql-test/r/func_str.result:
        Fixed bugs found after merge
      mysql-test/r/func_time.result:
        Fixed bugs found after merge
      mysql-test/r/group_by.result:
        Fixed bugs found after merge
      mysql-test/r/innodb.result:
        Fixed bugs found after merge
      mysql-test/r/insert.result:
        Fixed bugs found after merge
      mysql-test/r/join_outer.result:
        Fixed bugs found after merge
      mysql-test/r/loaddata.result:
        Fixed bugs found after merge
      mysql-test/r/multi_update.result:
        Fixed bugs found after merge
      mysql-test/r/mysqldump.result:
        Update results
      mysql-test/r/rpl_EE_error.result:
        Fixed bugs found after merge
      mysql-test/r/rpl_multi_update.result:
        Fixed bugs found after merge
      mysql-test/r/symlink.result:
        Update results
      mysql-test/r/type_blob.result:
        Update results
      mysql-test/r/type_datetime.result:
        Update results
      mysql-test/r/type_decimal.result:
        Update results
      mysql-test/r/type_enum.result:
        Fixed bugs found after merge
      mysql-test/r/type_timestamp.result:
        Update results
      mysql-test/r/union.result:
        Update results
      mysql-test/r/warnings.result:
        Update results
      mysql-test/t/bdb.test:
        Fix test for 4.1
      mysql-test/t/innodb.test:
        Fix test for 4.1
      mysql-test/t/multi_update.test:
        Fix test for 4.1
      mysql-test/t/mysqldump.test:
        Fix test for 4.1
      mysql-test/t/rpl_EE_error.test:
        Fix test for 4.1
      mysql-test/t/rpl_multi_update.test:
        Fix test for 4.1
      mysql-test/t/union.test:
        Cleanup
      mysys/charset.c:
        Check results from my_once_alloc()
      mysys/my_handler.c:
        part of 4.0 merge
      sql-common/client.c:
        Part of 4.0 merge
      sql/field.cc:
        After merge fixes
      sql/field.h:
        After merge fixes
      sql/ha_innodb.cc:
        Remove duplicate include files
      sql/item.cc:
        Changed automatic int conversion to be of type binary
      sql/item.h:
        After merge fixes
      sql/item_func.cc:
        Changed automatic int conversion to be of type binary
      sql/item_func.h:
        After merge fixes
      sql/item_strfunc.cc:
        Added comments
      sql/item_subselect.cc:
        Indentation fixes
      sql/item_sum.cc:
        Changed automatic int conversion to be of type binary
      sql/item_sum.h:
        After merge fixes
      sql/mysql_priv.h:
        Cleanup embedded library access checks
      sql/mysqld.cc:
        Changed min stack size to 128K (to allow longer MyISAM keys)
      sql/set_var.cc:
        Fixed compiler warnings
      sql/share/czech/errmsg.txt:
        Better error message
      sql/share/danish/errmsg.txt:
        Better error message
      sql/share/dutch/errmsg.txt:
        Better error message
      sql/share/english/errmsg.txt:
        Better error message
      sql/share/estonian/errmsg.txt:
        Better error message
      sql/share/french/errmsg.txt:
        Better error message
      sql/share/greek/errmsg.txt:
        Better error message
      sql/share/hungarian/errmsg.txt:
        Better error message
      sql/share/italian/errmsg.txt:
        Better error message
      sql/share/japanese/errmsg.txt:
        Better error message
      sql/share/korean/errmsg.txt:
        Better error message
      sql/share/norwegian-ny/errmsg.txt:
        Better error message
      sql/share/norwegian/errmsg.txt:
        Better error message
      sql/share/polish/errmsg.txt:
        Better error message
      sql/share/romanian/errmsg.txt:
        Better error message
      sql/share/russian/errmsg.txt:
        Better error message
      sql/share/serbian/errmsg.txt:
        Better error message
      sql/share/slovak/errmsg.txt:
        Better error message
      sql/share/spanish/errmsg.txt:
        Better error message
      sql/share/swedish/errmsg.txt:
        Better error message
      sql/share/ukrainian/errmsg.txt:
        Better error message
      sql/sql_acl.h:
        Cleaned up embedded library acccess checks
      sql/sql_base.cc:
        After merge fixes
      sql/sql_client.cc:
        After merge fixes
      sql/sql_parse.cc:
        After merge fixes
        Changed access check code for embedded library (needed to make code shorter and ensure that check_table_access() is called)
        Recoded create-table handling for CREATE TABLE ... SELECT to make code shorter and faster
      sql/sql_prepare.cc:
        Add missing arguments
      sql/sql_select.cc:
        After merge fixes
      sql/sql_update.cc:
        After merge fixes
      sql/sql_yacc.yy:
        Fixed wrong priority for XOR (should be less than NEG to get -1^1 to work)
      sql/table.cc:
        After merge fixes
      c9f5145a
  32. 17 Dec, 2003 1 commit
    • unknown's avatar
      WorkLog #1323 (part 2) · fcbb2f07
      unknown authored
      New Statement: SHOW [STORAGE] ENGINES
      New System Variable: storage_engine
      New mysqld Argument: --default-storage-engine=
      
      
      include/mysqld_error.h:
        We now call handlers STORAGE ENGINEs
      include/sql_state.h:
        We now call handlers STORAGE ENGINEs
      mysql-test/r/create.result:
        table_type system variable becomes storage_engine
      mysql-test/r/key_cache.result:
        table_type system variable becomes storage_engine
      mysql-test/r/variables.result:
        table_type system variable becomes storage_engine
      mysql-test/r/warnings.result:
        Test for deprecated table_type system variable
      mysql-test/t/create.test:
        table_type system variable becomes storage_engine
      mysql-test/t/key_cache.test:
        table_type system variable becomes storage_engine
      mysql-test/t/variables.test:
        table_type system variable becomes storage_engine
      mysql-test/t/warnings.test:
        Test for deprecated table_type system variable
      sql/handler.cc:
        change name for consistency
      sql/handler.h:
        change name for consistency
      sql/lex.h:
        New keywords - ENGINES and STORAGE
      sql/mysql_priv.h:
        change name for consistency
      sql/mysqld.cc:
        New command like argument for default-storage-engine
      sql/set_var.cc:
        New system variable for storage_engine
      sql/set_var.h:
        New system variable for storage_engine
      sql/sql_lex.h:
        Change for consistancy
      sql/sql_parse.cc:
        Change for consistancy
      sql/sql_show.cc:
        Change for consistancy
      sql/sql_table.cc:
        Change for consistancy
      sql/sql_yacc.yy:
        New keywords: STORAGE and ENGINES
        Change table_types to storage_engines
        New statement: SHOW [STORAGE] ENGINES
      fcbb2f07