An error occurred fetching the project authors.
  1. 08 Dec, 2003 1 commit
    • unknown's avatar
      WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions · 417354ea
      unknown authored
      Syntax for TIMESTAMPADD:
      
      TIMESTAMPADD(interval, integer_expression, datetime_expression)
      
      interval:= FRAC_SECOND | SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | 
      QUARTER | YEAR
      
      Supported SQL_TSI_  prefix  (like SQL_TSI_SECOND)
      
      Syntax for TIMESTAMPDIFF:
      
      TIMESTAMPDIFF(interval, datetime_expression1, datetime_expression2)
      
      interval:= FRAC_SECOND | SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | 
      QUARTER | YEAR
      
      Supported SQL_TSI_  prefix  (like SQL_TSI_SECOND)
      
      
      mysql-test/r/func_sapdb.result:
        Additional tests for timediff
      mysql-test/r/func_time.result:
        Tests for timestampadd, timestampdiff functions
      mysql-test/r/keywords.result:
        Test for new keywords
      mysql-test/t/func_sapdb.test:
        Additional tests for timediff
      mysql-test/t/func_time.test:
        Tests for timestampadd, timestampdiff functions
      mysql-test/t/keywords.test:
        Test for new keywords
      sql/item_create.cc:
        WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
      sql/item_create.h:
        WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
      sql/item_timefunc.cc:
        WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
      sql/item_timefunc.h:
        WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
      sql/lex.h:
        WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
      sql/sql_yacc.yy:
        WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functions
      417354ea
  2. 17 Nov, 2003 1 commit
    • unknown's avatar
      WL#1253: LAST_DAY · ac584b24
      unknown authored
      mysql-test/r/func_time.result:
        Test for WL#1253: LAST_DAY
      mysql-test/t/func_time.test:
        Test for WL#1253: LAST_DAY
      ac584b24
  3. 30 Oct, 2003 1 commit
    • unknown's avatar
      added code covarage for functions convert(), nullif(), crc32(),... · 87e6c2ba
      unknown authored
      added code covarage for functions convert(), nullif(), crc32(), is_used_lock(), char_lengtrh(), bit_xor()
      added string length for more speed
      made code covarage for print() method of Item
      fixed printability of some items (SCRUM) (WL#1274)
      
      
      mysql-test/r/auto_increment.result:
        print() code coverage
      mysql-test/r/bench_count_distinct.result:
        print() code coverage
      mysql-test/r/case.result:
        print() code coverage
      mysql-test/r/cast.result:
        print() code coverage
      mysql-test/r/ctype_collate.result:
        print() code coverage
      mysql-test/r/ctype_many.result:
        convert with 3 arguments code covarage
        print() code coverage
      mysql-test/r/ctype_utf8.result:
        char_length code coverage
      mysql-test/r/date_formats.result:
        print() code coverage
      mysql-test/r/fulltext.result:
        print() code coverage
      mysql-test/r/func_compress.result:
        print() code coverage
      mysql-test/r/func_gconcat.result:
        print() code coverage
      mysql-test/r/func_group.result:
        bit_xor() code coverage
        print() code coverage
      mysql-test/r/func_if.result:
        nullif() code coverage
        print() code coverage
      mysql-test/r/func_in.result:
        print() code coverage
      mysql-test/r/func_math.result:
        print() code coverage
      mysql-test/r/func_op.result:
        print() code coverage
      mysql-test/r/func_regexp.result:
        print() code coverage
      mysql-test/r/func_set.result:
        print() code coverage
      mysql-test/r/func_str.result:
        crc32() code coverage
        print() code coverage
      mysql-test/r/func_system.result:
        print() code coverage
      mysql-test/r/func_test.result:
        print() code coverage
      mysql-test/r/func_time.result:
        print() code coverage
      mysql-test/r/group_by.result:
        print() code coverage
      mysql-test/r/having.result:
        print() code coverage
      mysql-test/r/insert_update.result:
        print() code coverage
      mysql-test/r/null.result:
        print() code coverage
      mysql-test/r/olap.result:
        print() code coverage
      mysql-test/r/query_cache.result:
        print() code coverage
      mysql-test/r/row.result:
        print() code coverage
      mysql-test/r/rpl000001.result:
        print() code coverage
      mysql-test/r/rpl_get_lock.result:
        print() code coverage
      mysql-test/r/rpl_master_pos_wait.result:
        print() code coverage
      mysql-test/r/select.result:
        print() code coverage
      mysql-test/r/subselect.result:
        print() code coverage
      mysql-test/r/type_blob.result:
        print() code coverage
      mysql-test/r/varbinary.result:
        print() code coverage
      mysql-test/r/variables.result:
        print() code coverage
      mysql-test/t/auto_increment.test:
        print() code coverage
      mysql-test/t/bench_count_distinct.test:
        print() code coverage
      mysql-test/t/case.test:
        print() code coverage
      mysql-test/t/cast.test:
        print() code coverage
      mysql-test/t/ctype_collate.test:
        print() code coverage
      mysql-test/t/ctype_many.test:
        convert with 3 arguments code covarage
        print() code coverage
      mysql-test/t/ctype_utf8.test:
        char_length code coverage
      mysql-test/t/date_formats.test:
        print() code coverage
      mysql-test/t/fulltext.test:
        print() code coverage
      mysql-test/t/func_compress.test:
        print() code coverage
      mysql-test/t/func_gconcat.test:
        print() code coverage
      mysql-test/t/func_group.test:
        bit_xor() code coverage
        print() code coverage
      mysql-test/t/func_if.test:
        nullif() code coverage
        print() code coverage
      mysql-test/t/func_in.test:
        print() code coverage
      mysql-test/t/func_math.test:
        print() code coverage
      mysql-test/t/func_op.test:
        print() code coverage
      mysql-test/t/func_regexp.test:
        print() code coverage
      mysql-test/t/func_set.test:
        print() code coverage
      mysql-test/t/func_str.test:
        crc32() code covarage
        print() code coverage
      mysql-test/t/func_system.test:
        print() code coverage
      mysql-test/t/func_test.test:
        print() code coverage
      mysql-test/t/func_time.test:
        print() code coverage
      mysql-test/t/group_by.test:
        print() code coverage
      mysql-test/t/having.test:
        print() code coverage
      mysql-test/t/insert_update.test:
        print() code coverage
      mysql-test/t/null.test:
        print() code coverage
      mysql-test/t/olap.test:
        print() code coverage
      mysql-test/t/query_cache.test:
        print() code coverage
      mysql-test/t/row.test:
        print() code coverage
      mysql-test/t/rpl000001.test:
        print() code coverage
      mysql-test/t/rpl_get_lock.test:
        print() code coverage
      mysql-test/t/rpl_master_pos_wait.test:
        print() code coverage
      mysql-test/t/select.test:
        print() code coverage
      mysql-test/t/type_blob.test:
        print() code coverage
      mysql-test/t/varbinary.test:
        print() code coverage
      mysql-test/t/variables.test:
        print() code coverage
      sql/item.cc:
        added string length for more speed
        layout fix
        fixed string printability
      sql/item.h:
        added string length for more speed
      sql/item_cmpfunc.cc:
        added string length for more speed
      sql/item_cmpfunc.h:
        fixed printability
      sql/item_create.cc:
        fixed printability
      sql/item_func.cc:
        fixed printability
        added string length for more speed
      sql/item_func.h:
        fixed printability
      sql/item_strfunc.cc:
        fixed printability
        added string length for more speed
      sql/item_strfunc.h:
        fixed printability
      sql/item_subselect.cc:
        added string length for more speed
      sql/item_sum.cc:
        added string length for more speed
      sql/item_timefunc.cc:
        added string length for more speed
      sql/item_timefunc.h:
        fixed printability
      sql/item_uniq.h:
        added string length for more speed
      sql/key.cc:
        added string length for more speed
      sql/sql_lex.cc:
        added string length for more speed
      sql/sql_parse.cc:
        after merge fix
      sql/sql_repl.cc:
        string changed with character for more speed
      sql/sql_select.cc:
        added string length for more speed
      sql/sql_show.cc:
        added string length for more speed
      87e6c2ba
  4. 11 Aug, 2003 1 commit
    • unknown's avatar
      Implemented UTC_TIME, UTC_DATE and UTC_TIMESTAMP functions (WL#345) · 2ad06dc6
      unknown authored
      configure.in:
        ./configure now tests if gmtime_r is present
      include/config-os2.h:
        Supposing that OS/2 have gmtime_r
      include/my_pthread.h:
        Use our imeplementation of gmtime_r if system lacks one
      mysql-test/r/func_time.result:
        Added UTC_* functions to test
      mysql-test/t/func_time.test:
        Added UTC_* functions to test
      mysys/my_pthread.c:
        Our implementation of gmtime_r
      mysys/my_thr_init.c:
        Now we also need LOCK_locktime_r if gmtime_r is absent
      sql/item_timefunc.cc:
        Generalized classes for CURDATE, CURTIME and NOW, abstracted them from
        timezone. Added new children classes for implementing these and UTC_*
        functions.
      sql/item_timefunc.h:
        Generalized classes for CURDATE, CURTIME and NOW, abstracted them from
        timezone. Added new children classes for implementing these and UTC_*
        functions.
      sql/lex.h:
        Added tokens for UTC_TIME, UTC_DATE and UTC_TIMESTAMP
      sql/sql_yacc.yy:
        Added UTC_* functions to grammar. Current functions are using 
        classes now.
      2ad06dc6
  5. 19 Jun, 2003 1 commit
    • unknown's avatar
      SCRUM · 85d2282e
      unknown authored
      Task ID 894:
      Backport default_week_format variable to 4.0
      
      
      mysql-test/r/func_time.result:
        Backport default_week_format variable to 4.0
      mysql-test/t/func_time.test:
        Backport default_week_format variable to 4.0
      sql/mysqld.cc:
        Backport default_week_format variable to 4.0
      sql/set_var.cc:
        Backport default_week_format variable to 4.0
      sql/sql_class.h:
        Backport default_week_format variable to 4.0
      sql/sql_yacc.yy:
        Backport default_week_format variable to 4.0
      85d2282e
  6. 11 Jun, 2003 1 commit
    • unknown's avatar
      test case for bug #614 · 4885c3ff
      unknown authored
      mysql-test/r/func_time.result:
        result's checking added
      mysql-test/t/func_time.test:
        testcase added
      4885c3ff
  7. 19 Feb, 2003 1 commit
    • unknown's avatar
      add option default-week-format and variable default_week_format · bcd22f2a
      unknown authored
      (SCRUM)
      
      
      mysql-test/r/func_time.result:
        result of test default_week_format
      mysql-test/t/func_time.test:
        test of default_week_format
      sql/mysqld.cc:
        add option default-week-format
      sql/set_var.cc:
        add system variable default_week_format
      sql/sql_class.h:
        add default_week_format into structure system_variables
      sql/sql_yacc.yy:
        change lex of week() with one parameter
      bcd22f2a
  8. 14 Dec, 2002 1 commit
    • unknown's avatar
      Fixes for binary protocol (complement to last push) · f935c6a2
      unknown authored
      Changed timestamp to return string in YYYY-MM-DD HH:MM:SS format.
      DATE_ADD() and related functions now returns correct DATE/DATETIME type depending on argument types.
      Now all tests passes, still some work left to remove warnings in log files from mysql-test-run
      
      
      mysql-test/r/cast.result:
        New result for time
      mysql-test/r/delayed.result:
        Timestamp update
      mysql-test/r/derived.result:
        Fix after bulk insert change
      mysql-test/r/explain.result:
        Fix after bulk insert change
      mysql-test/r/func_date_add.result:
        Timestamp change
      mysql-test/r/func_str.result:
        Timestamp change
      mysql-test/r/func_time.result:
        Timestamp change
      mysql-test/r/innodb.result:
        Timestamp change
      mysql-test/r/join_outer.result:
        Fix after bulk insert change
      mysql-test/r/key_primary.result:
        Fix after bulk insert change
      mysql-test/r/keywords.result:
        Timestamp change
      mysql-test/r/merge.result:
        Removed warning
      mysql-test/r/odbc.result:
        Fix after bulk insert change
      mysql-test/r/range.result:
        Fix after bulk insert change
      mysql-test/r/select.result:
        Fix after bulk insert change
      mysql-test/r/subselect.result:
        Fixed EXPLAIN output
      mysql-test/r/type_datetime.result:
        Timestamp update
      mysql-test/r/type_ranges.result:
        Timestamp update
      mysql-test/r/type_timestamp.result:
        Timestamp update
      mysql-test/r/union.result:
        EXPLAIN UPDATE
      mysql-test/t/func_str.test:
        Timestamp update
      mysql-test/t/func_time.test:
        New test for interval type result
      mysql-test/t/merge.test:
        Remove warnings of wrong drop table
      mysql-test/t/type_datetime.test:
        Timestamp change
      mysql-test/t/type_timestamp.test:
        Timestamp change
      sql/field.cc:
        Changed timestamp to return string in YYYY-MM-DD HH:MM:SS format
      sql/field.h:
        Changed timestamp to return string in YYYY-MM-DD HH:MM:SS format
      sql/item.cc:
        Binary protocol update
      sql/item.h:
        Binary protocol update
      sql/item_func.cc:
        Added comment
      sql/item_func.h:
        @variables are always returned to the client as strings
      sql/item_timefunc.cc:
        Changed INTERVAL to return correct type
      sql/item_timefunc.h:
        Changed INTERVAL to return correct type
      sql/mysqld.cc:
        Changed default pthread_attr_setstacksize to 129K
      sql/protocol.cc:
        More type checking
      sql/set_var.cc:
        Fixed that @convert works ok with new protocol
      sql/sql_analyse.cc:
        Fixed bug in analyze
      sql/sql_class.cc:
        Fixed bug from last push in LIMIT
      sql/sql_error.cc:
        More optimal types
      sql/sql_repl.cc:
        Binary protocol changes
      sql/sql_select.cc:
        Fixed bug in multi-table-update
        Changed EXPLAIN to return NULL instead of empty strings
      sql/sql_show.cc:
        Binary protocol
      f935c6a2
  9. 24 Nov, 2002 1 commit
    • unknown's avatar
      Added new ANSI functions LOCALTIME, LOCALTIMESTAMP and CURRENT_USER · 72da2e4c
      unknown authored
      Added CEIL as an alias for CEILING
      Cleaned up CHECK constraint handling.
      (We don't anymore require braces after CHECK)
      Added casting to CHAR.
      
      
      mysql-test/r/bigint.result:
        Moved casting test to cast.test
      mysql-test/r/func_time.result:
        Test of new functions
      mysql-test/t/bigint.test:
        Moved casting test to cast.test
      mysql-test/t/func_time.test:
        Test of new functions
      sql/item_create.cc:
        Added casting to CHAR
      sql/item_func.h:
        Added casting to CHAR
      sql/item_timefunc.h:
        Added casting to CHAR
      sql/lex.h:
        Added new ANSI functions LOCALTIME, LOCALTIMESTAMP and CURRENT_USER
        Added CEIL as an alias for CEILING
      sql/sql_yacc.yy:
        Cleaned up CHECK constraint handling.
      72da2e4c
  10. 22 Nov, 2002 1 commit
  11. 12 Nov, 2002 1 commit
    • unknown's avatar
      Extended WEEK() to be able to handle ISO weeks. · e1c1abd0
      unknown authored
      unlink socket file if mysqld dies on startup
      Some optimization of AND expressions
      
      
      mysql-test/r/func_time.result:
        Update for new week() handling
      mysql-test/t/func_time.test:
        Update for new week() handling
      sql/item_cmpfunc.cc:
        Optimization of IF( and-expression,,)
      sql/item_cmpfunc.h:
        Optimization of AND expressions
      sql/item_timefunc.cc:
        Extended WEEK() to be able to handle ISO weeks.
      sql/mysqld.cc:
        unlink socket file if mysqld dies on startup
      sql/sql_base.cc:
        Fixed problem with SIGHUP and INSERT DELAYED
      tests/Makefile.am:
        Added missing myisam-big-rows.tst file to source distribution
      e1c1abd0
  12. 06 Nov, 2002 1 commit
    • unknown's avatar
      BETWEEN fixed · c5d40413
      unknown authored
      myisam/ft_nlq_search.c:
        cleanup
      mysql-test/r/func_time.result:
        updated
      c5d40413
  13. 05 Nov, 2002 1 commit
    • unknown's avatar
      Removed wrong patch to fix DATE BETWEEN TIMESTAMP1 AND TIMESTAMP2 · 841fa6f6
      unknown authored
      Some simple optimizations
      
      
      Docs/manual.texi:
        Updted how binary log works
      mysql-test/mysql-test-run.sh:
        Added usage of --port to mysqltest
      mysql-test/r/func_test.result:
        Moved test of datetime comparison to func_time
      mysql-test/r/func_time.result:
        New test
      mysql-test/t/func_test.test:
        Moved test of datetime comparison to func_time
      mysql-test/t/func_time.test:
        Test of DATE BETWEEN TIMESTAMPS
      sql/field.h:
        Removed wrong patch
      sql/item_cmpfunc.cc:
        Removed wrong patch
        (Need to be fixed by taking into account all arguments to between)
      sql/lock.cc:
        Removed call to current_thd
      sql/set_var.cc:
        Don't show 'socket' variable if sockets are not used
      sql/sql_base.cc:
        Simple optimisation
      841fa6f6
  14. 04 Nov, 2001 2 commits
    • unknown's avatar
      Fixes up things after merge from 3.23.44 · d18a6cc3
      unknown authored
      Portability fixes.
      Don't delete temporary tables on FLUSH tables.
      
      
      client/client_priv.h:
        Fix after merge
      client/mysqldump.c:
        Fix after merge
      include/my_global.h:
        Change CMP -> CMP_NUM because CMP was used in other places
      include/violite.h:
        Added missing prototype
      myisam/ft_boolean_search.c:
        Removed warnings
      myisam/ft_nlq_search.c:
        Removed warnings
      myisam/mi_search.c:
        CMP -> CMP_NUM
      mysql-test/mysql-test-run.sh:
        Write all logs to log directory
      mysql-test/r/func_time.result:
        Fix test results after merge
      mysql-test/r/having.result:
        Fix test results after merge
      mysql-test/r/join.result:
        Fix test results after merge
      mysql-test/r/rpl000012.result:
        Fix test results after merge
      mysys/mf_iocache.c:
        Allow multiple call to end_iocache.
      sql/ha_innobase.cc:
        Removed possible problem with using uninitialized variable
      sql/log_event.cc:
        Don't delete temporary tables on FLUSH tables.
        (Needs to be fixed properly)
      d18a6cc3
    • unknown's avatar
      use local version when doing merge with 3.23.44 · cec36f0f
      unknown authored
      cec36f0f
  15. 03 Nov, 2001 1 commit
    • unknown's avatar
      Fix that mysqladmin shutdown can be interrupted with ^C · b2cec26d
      unknown authored
      Fixed bug with BLOB keys in BDB tables
      Fixed problem with MERGE tables on OS with 32 bit files
      Fixed that TIME_TO_SEC() works with negative times
      
      
      Docs/manual.texi:
        Changelog
      client/mysqladmin.c:
        Fix that mysqladmin shutdown can be interrupted with ^C
      include/mysqld_error.h:
        Fixed typo
      mysql-test/r/func_time.result:
        Added test case for negative times
      mysql-test/t/func_time.test:
        Added test case for negative times
      mysql-test/t/rpl000015-slave.sh:
        Removed warnings
      mysql-test/t/rpl000016-slave.sh:
        Removed warnings
      sql/field.cc:
        Fixed bug with BLOB keys in BDB tables
      sql/field.h:
        Fixed bug with BLOB keys in BDB tables
      sql/ha_berkeley.cc:
        Fixed bug with BLOB keys in BDB tables
      sql/ha_myisammrg.cc:
        Fixed problem with MERGE tables on OS with 32 bit files
      sql/item_timefunc.cc:
        Fixed that TIME_TO_SEC() works with negative times.
      sql/share/swedish/errmsg.txt:
        Merge with 4.0
      sql/sql_acl.cc:
        Fixed typo
      b2cec26d
  16. 31 Oct, 2001 1 commit
    • unknown's avatar
      Portability fixes · 03f6fdd5
      unknown authored
      Fix for consistent 0000-00-00 date handling
      Close + open binary logs on flush tables
      Fix for AVG() in HAVING.
      
      
      BUILD/SETUP.sh:
        Compile MySQL with -O0 to make debugging easier.
      Docs/manual.texi:
        Changelog
      configure.in:
        Version change
      innobase/buf/buf0lru.c:
        Fix for windows
      mysql-test/r/func_time.result:
        Updated tests
      mysql-test/r/having.result:
        Updated tests
      mysql-test/t/func_time.test:
        Updated tests
      mysql-test/t/having.test:
        Updated tests
      mysys/mf_casecnv.c:
        Portability fix
      mysys/mf_qsort.c:
        Portability fix
      mysys/my_compress.c:
        Portability fix
      mysys/my_tempnam.c:
        More comments
      sql/field.cc:
        Fix for consistent 0000-00-00 date handling
      sql/item.h:
        Fix for AVG() in HAVING
      sql/log.cc:
        Close + open update logs on flush tables
      sql/sql_select.cc:
        More debugging info
      sql/time.cc:
        Fix for consistent 0000-00-00 date handling
      strings/ctype.c:
        Portability fix
      strings/strto.c:
        Portability fix
      03f6fdd5
  17. 28 Sep, 2001 1 commit
    • unknown's avatar
      client/mysqlmanagerc.c · 29f148bd
      unknown authored
          added support for quiet
          increased line buffer size
      client/mysqltest.c
          fixed memory leak
          added query logging to result file
          added error message logging to result file
          added enable_query_log/disable_query_log
      mysql-test/mysql-test-run.sh
          converted tests to use mysqlmanager
      
      Updated test results
      
      
      BitKeeper/etc/ignore:
        added *.reject
      client/mysqlmanagerc.c:
        added support for quiet
        increased line buffer size
      client/mysqltest.c:
        fixed memory leak
        added query logging to result file
        added error message logging to result file
        added enable_query_log/disable_query_log
      mysql-test/mysql-test-run.sh:
        converted tests to use mysqlmanager
      mysql-test/r/alias.result:
        log queries
      mysql-test/r/alter_table.result:
        log queries
      mysql-test/r/analyse.result:
        log queries
      mysql-test/r/auto_increment.result:
        log queries
      mysql-test/r/backup.result:
        log queries
      mysql-test/r/bdb-crash.result:
        log queries
      mysql-test/r/bench_count_distinct.result:
        log queries
      mysql-test/r/bigint.result:
        log queries
      mysql-test/r/binary.result:
        log queries
      mysql-test/r/bulk_replace.result:
        log queries
      mysql-test/r/case.result:
        log queries
      mysql-test/r/check.result:
        log queries
      mysql-test/r/comments.result:
        log queries
      mysql-test/r/compare.result:
        log queries
      mysql-test/r/count_distinct.result:
        log queries
      mysql-test/r/count_distinct2.result:
        log queries
      mysql-test/r/create.result:
        log queries
      mysql-test/r/ctype_latin1_de.result:
        log queries
      mysql-test/r/delayed.result:
        log queries
      mysql-test/r/dirty-close.result:
        log queries
      mysql-test/r/distinct.result:
        log queries
      mysql-test/r/drop.result:
        log queries
      mysql-test/r/empty_table.result:
        log queries
      mysql-test/r/explain.result:
        log queries
      mysql-test/r/flush.result:
        log queries
      mysql-test/r/fulltext.result:
        log queries
      mysql-test/r/fulltext_cache.result:
        log queries
      mysql-test/r/fulltext_distinct.result:
        log queries
      mysql-test/r/fulltext_left_join.result:
        log queries
      mysql-test/r/fulltext_multi.result:
        log queries
      mysql-test/r/fulltext_order_by.result:
        log queries
      mysql-test/r/fulltext_update.result:
        log queries
      mysql-test/r/fulltext_var.result:
        log queries
      mysql-test/r/func_crypt.result:
        log queries
      mysql-test/r/func_date_add.result:
        log queries
      mysql-test/r/func_equal.result:
        log queries
      mysql-test/r/func_group.result:
        log queries
      mysql-test/r/func_in.result:
        log queries
      mysql-test/r/func_like.result:
        log queries
      mysql-test/r/func_math.result:
        log queries
      mysql-test/r/func_misc.result:
        log queries
      mysql-test/r/func_op.result:
        log queries
      mysql-test/r/func_regexp.result:
        log queries
      mysql-test/r/func_set.result:
        log queries
      mysql-test/r/func_str.result:
        log queries
      mysql-test/r/func_system.result:
        log queries
      mysql-test/r/func_test.result:
        log queries
      mysql-test/r/func_time.result:
        log queries
      mysql-test/r/func_timestamp.result:
        log queries
      mysql-test/r/group_by.result:
        log queries
      mysql-test/r/handler.result:
        log queries
      mysql-test/r/having.result:
        log queries
      mysql-test/r/heap.result:
        log queries
      mysql-test/r/identity.result:
        log queries
      mysql-test/r/ins000001.result:
        log queries
      mysql-test/r/insert.result:
        log queries
      mysql-test/r/insert_select.result:
        log queries
      mysql-test/r/isam.result:
        log queries
      mysql-test/r/join.result:
        log queries
      mysql-test/r/join_crash.result:
        log queries
      mysql-test/r/join_outer.result:
        log queries
      mysql-test/r/key.result:
        log queries
      mysql-test/r/key_diff.result:
        log queries
      mysql-test/r/key_primary.result:
        log queries
      mysql-test/r/keywords.result:
        log queries
      mysql-test/r/kill.result:
        log queries
      mysql-test/r/limit.result:
        log queries
      mysql-test/r/lock.result:
        log queries
      mysql-test/r/merge.result:
        log queries
      mysql-test/r/multi_update.result:
        log queries
      mysql-test/r/myisam.result:
        log queries
      mysql-test/r/null.result:
        log queries
      mysql-test/r/null_key.result:
        log queries
      mysql-test/r/odbc.result:
        log queries
      mysql-test/r/openssl_1.result:
        log queries
      mysql-test/r/openssl_2.result:
        log queries
      mysql-test/r/order_by.result:
        log queries
      mysql-test/r/order_fill_sortbuf.result:
        log queries
      mysql-test/r/raid.result:
        log queries
      mysql-test/r/range.result:
        log queries
      mysql-test/r/rename.result:
        log queries
      mysql-test/r/replace.result:
        log queries
      mysql-test/r/rollback.result:
        log queries
      mysql-test/r/rpl000001.result:
        log queries
      mysql-test/r/rpl000002.result:
        log queries
      mysql-test/r/rpl000003.result:
        log queries
      mysql-test/r/rpl000004.result:
        log queries
      mysql-test/r/rpl000005.result:
        log queries
      mysql-test/r/rpl000006.result:
        log queries
      mysql-test/r/rpl000007.result:
        log queries
      mysql-test/r/rpl000008.result:
        log queries
      mysql-test/r/rpl000009.result:
        log queries
      mysql-test/r/rpl000010.result:
        log queries
      mysql-test/r/rpl000011.result:
        log queries
      mysql-test/r/rpl000012.result:
        log queries
      mysql-test/r/rpl000013.result:
        log queries
      mysql-test/r/rpl000014.result:
        log queries
      mysql-test/r/rpl000015.result:
        log queries
      mysql-test/r/rpl000016.result:
        log queries
      mysql-test/r/rpl000017.result:
        log queries
      mysql-test/r/rpl000018.result:
        log queries
      mysql-test/r/rpl_get_lock.result:
        log queries
      mysql-test/r/rpl_log.result:
        log queries
      mysql-test/r/rpl_magic.result:
        log queries
      mysql-test/r/rpl_mystery22.result:
        log queries
      mysql-test/r/rpl_sporadic_master.result:
        log queries
      mysql-test/r/sel000001.result:
        log queries
      mysql-test/r/sel000002.result:
        log queries
      mysql-test/r/sel000003.result:
        log queries
      mysql-test/r/sel000031.result:
        log queries
      mysql-test/r/sel000032.result:
        log queries
      mysql-test/r/sel000033.result:
        log queries
      mysql-test/r/sel000100.result:
        log queries
      mysql-test/r/select.result:
        log queries
      mysql-test/r/select_found.result:
        log queries
      mysql-test/r/select_safe.result:
        log queries
      mysql-test/r/show_check.result:
        log queries
      mysql-test/r/slave-running.result:
        log queries
      mysql-test/r/slave-stopped.result:
        log queries
      mysql-test/r/status.result:
        log queries
      mysql-test/r/symlink.result:
        log queries
      mysql-test/r/tablelock.result:
        log queries
      mysql-test/r/temp_table.result:
        log queries
      mysql-test/r/truncate.result:
        log queries
      mysql-test/r/type_blob.result:
        log queries
      mysql-test/r/type_date.result:
        log queries
      mysql-test/r/type_datetime.result:
        log queries
      mysql-test/r/type_decimal.result:
        log queries
      mysql-test/r/type_enum.result:
        log queries
      mysql-test/r/type_float.result:
        log queries
      mysql-test/r/type_ranges.result:
        log queries
      mysql-test/r/type_time.result:
        log queries
      mysql-test/r/type_timestamp.result:
        log queries
      mysql-test/r/type_uint.result:
        log queries
      mysql-test/r/type_year.result:
        log queries
      mysql-test/r/union.result:
        log queries
      mysql-test/r/update.result:
        log queries
      mysql-test/r/user_var.result:
        log queries
      mysql-test/r/varbinary.result:
        log queries
      mysql-test/r/variables.result:
        log queries
      mysql-test/t/bench_count_distinct.test:
        log queries
      mysql-test/t/check.test:
        log queries
      mysql-test/t/count_distinct2.test:
        log queries
      mysql-test/t/flush.test:
        log queries
      mysql-test/t/isam.test:
        log queries
      mysql-test/t/multi_update.test:
        log queries
      mysql-test/t/myisam.test:
        log queries
      mysql-test/t/order_fill_sortbuf.test:
        log queries
      mysql-test/t/rpl000016.test:
        log queries
      tools/managertest1.nc:
        test for def_exec overwrite
      tools/mysqlmanager.c:
        support def_exec overwrite and queries on running server
      29f148bd
  18. 21 Aug, 2001 1 commit
    • unknown's avatar
      Remove usage of my_dup(), as this casued error 127 when reading MyISAM tables · 023cbef0
      unknown authored
      New definition of WEEK().
      
      
      Docs/manual.texi:
        Changelog
      myisam/mi_cache.c:
        Better logging on error
      myisam/mi_open.c:
        Remove usage of my_dup(), as this casued error 127 when reading tables
      mysql-test/r/func_time.result:
        More tests for the WEEK/YEARWEEK function
      mysql-test/t/func_time.test:
        More tests for the WEEK/YEARWEEK function
      sql/time.cc:
        New definition of WEEK
      023cbef0
  19. 16 Aug, 2001 1 commit
    • unknown's avatar
      fixed bug in Item_func_div::val_int() that broke all functions that · 6ca8d50c
      unknown authored
      do val_int() on their arguments before starting the computation. 
      Similar fixes are need for +-* and probably several other but I want
      to make sure Monty is fine with my fix approach before changing a lot
      of code. 
      
      Amazingly,
      this bug is not as critical as you would expect since very few functions do val_int()
      on their arguments ( from_unixtime(), sec_to_time()), and those not
      very frequently perform a computation on their floating point arguments.
      which is probably why no one has yet reported this bug. Another 
      possibility is that the result is usually wrong by no more than 5%,
      which makes it hard to catch it. I found it when trying to compute mile
      splits for 30:47 10K - it told me 5:07, and I knew it was wrong because
      5:00 mile gives you 31:08. However, if I had not run as many 10K races,
      I would have easily believed that 30:47 10K is a 5:07 mile pace and 
      would not have noticed the bug.
      
      
      mysql-test/r/func_time.result:
        another test for sec_to_time that exposes a long outstanding bug
      mysql-test/t/func_time.test:
        another test for sec_to_time that exposes a long outstanding bug
      sql/item_func.cc:
        fixed bug in Item_func_div::val_int()
      6ca8d50c
  20. 22 May, 2001 1 commit
    • unknown's avatar
      Remove wrong access check for locks. · 41dd2aa2
      unknown authored
      Fixed problem with fuzzy dates.
      
      
      mysql-test/r/func_time.result:
        Added test of fuzzy dates
      mysql-test/t/func_time.test:
        Added test of fuzzy dates
      sql/item.cc:
        Fixed bug with fuzzy dates
      sql/sql_parse.cc:
        Remove wrong access check for locks.
        (This has to be delayed for 4.0 because there is currently now way
        to check for "any of the following privileges"
      Docs/manual.texi:
        Changelog
      41dd2aa2
  21. 09 Apr, 2001 1 commit
    • unknown's avatar
      Fixed INSERT DELAYED with Innobase · c7105d80
      unknown authored
      Fix for shutdown on NT
      Fixed bug when using wrong dates from blob field.
      
      
      BitKeeper/deleted/.del-df_crash.result~4a3dbee64843953d:
        Delete: mysql-test/r/df_crash.result
      BitKeeper/deleted/.del-df_crash.test~4c365178fe437f6:
        Delete: mysql-test/t/df_crash.test
      Docs/manual.texi:
        Changelog
      innobase/ib_config.h.in:
        automatic changed file
      innobase/ib_config.h:
        automatic changed file
      mysql-test/r/func_time.result:
        Test case for bug in time functions
      mysql-test/r/innobase.result:
        Test for INSERT DELAYED
      mysql-test/t/func_time.test:
        Test case for bug in time functions
      mysql-test/t/innobase.test:
        Test for INSERT DELAYED
      scripts/mysql_convert_table_format.sh:
        Added --socket and --port
      sql/ha_innobase.cc:
        Fix bug when compiling with SAFE_MUTEX
        Cleaner comment when using SHOW TABLE STATUS
      sql/mysqld.cc:
        Fix for shutdown on NT
      sql/sql_insert.cc:
        Fixed problem with Innobase and INSERT DELAYED
      sql/sql_udf.cc:
        Support for UDF on windows
      sql/time.cc:
        Fixed bug when using wrong dates from blob field.
      strings/ctype-tis620.c:
        Removed not used variable
      support-files/mysql-max.spec.sh:
        Removed old not used section
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      c7105d80
  22. 31 Jan, 2001 1 commit
    • unknown's avatar
      New myisamchk option --sort-recover · 495231ea
      unknown authored
      Allow delete of crashed MyISAM tables
      Fixed bug when BLOB was first part of key
      Fixed bug when using result from CASE in GROUP BY
      Fixed core-dump bug in monthname()
      Optimized calling of check_db_name()
      
      
      Docs/manual.texi:
        Added more information about myisamchk
      client/mysqladmin.c:
        Added error message for CREATE database and fixed possible overflow bug
      include/myisam.h:
        New myisamchk option --sort-recover
      libmysql/libmysql.c:
        Removed commented code
        Don't define getpwuid (breaks on SCO 3.2)
      myisam/mi_check.c:
        Fixed (new) bug when using --recover --optimize
      myisam/mi_delete_table.c:
        Allow delete of crashed tables
      myisam/mi_key.c:
        Fixed bug when BLOB was first part of key
      myisam/myisamchk.c:
        New myisamchk option --sort-recover
      mysql-test/r/case.result:
        New test cases to check for reported bugs
      mysql-test/r/func_time.result:
        New test cases to check for reported bugs
      mysql-test/r/type_blob.result:
        New test cases to check for reported bugs
      mysql-test/r/type_datetime.result:
        New test cases to check for reported bugs
      mysql-test/t/case.test:
        New test cases to check for reported bugs
      mysql-test/t/func_time.test:
        New test cases to check for reported bugs
      mysql-test/t/type_blob.test:
        New test cases to check for reported bugs
      mysql-test/t/type_datetime.test:
        New test cases to check for reported bugs
      mysys/my_bitmap.c:
        Optimize
      sql-bench/limits/ms-sql.cfg:
        Updated limits
      sql/item_cmpfunc.cc:
        Fixed bug when using result from CASE in GROUP BY
      sql/item_cmpfunc.h:
        Fixed bug when using result from CASE in GROUP BY
      sql/item_timefunc.cc:
        Fixed core-dump bug in monthname()
      sql/sql_db.cc:
        Optimized calling of check_db_name()
      sql/sql_parse.cc:
        Optimized calling of check_db_name()
      sql/table.cc:
        Fixed typo
      495231ea
  23. 15 Jan, 2001 1 commit
  24. 28 Dec, 2000 1 commit
    • unknown's avatar
      Added support for hex strings to mysqlimport · f537319d
      unknown authored
      A lot of new tests to mysqltest
      Fixed bug with BDB tables and autocommit
      
      
      BitKeeper/deleted/.del-delete.test~389410e29f2cebe5:
        Delete: mysql-test/t/delete.test
      BitKeeper/deleted/.del-delete.result~e866a6678e29f186:
        Delete: mysql-test/r/delete.result
      BitKeeper/deleted/.del-sel000014.test~74cb8c70f1d73fcc:
        Delete: mysql-test/t/sel000014.test
      BitKeeper/deleted/.del-sel000015.test~7442bf9cbc96fe07:
        Delete: mysql-test/t/sel000015.test
      BitKeeper/deleted/.del-sel000016.test~f495235f14c47ec:
        Delete: mysql-test/t/sel000016.test
      BitKeeper/deleted/.del-sel000017.test~7c39f2b45a6aa780:
        Delete: mysql-test/t/sel000017.test
      BitKeeper/deleted/.del-sel000018.test~16207f3ad74de75e:
        Delete: mysql-test/t/sel000018.test
      BitKeeper/deleted/.del-sel000014.result~fc8de0ec89d9e35:
        Delete: mysql-test/r/sel000014.result
      BitKeeper/deleted/.del-sel000015.result~cadbc52051d47bac:
        Delete: mysql-test/r/sel000015.result
      BitKeeper/deleted/.del-sel000016.result~6177851869bd5b07:
        Delete: mysql-test/r/sel000016.result
      BitKeeper/deleted/.del-sel000017.result~84ebf147850ff31c:
        Delete: mysql-test/r/sel000017.result
      BitKeeper/deleted/.del-sel000018.result~562ac9094cf53aba:
        Delete: mysql-test/r/sel000018.result
      BitKeeper/deleted/.del-sel000005.test~982fde89a4d6d886:
        Delete: mysql-test/t/sel000005.test
      BitKeeper/deleted/.del-sel000006.test~291cc6c8d85e51df:
        Delete: mysql-test/t/sel000006.test
      BitKeeper/deleted/.del-sel000005.result~d5410bb765199cc5:
        Delete: mysql-test/r/sel000005.result
      BitKeeper/deleted/.del-sel000006.result~d38004d1acfc11a5:
        Delete: mysql-test/r/sel000006.result
      BitKeeper/deleted/.del-sel000004.test~daf9ad4a1a31cd3c:
        Delete: mysql-test/t/sel000004.test
      BitKeeper/deleted/.del-sel000007.test~f431e4f4739a24c3:
        Delete: mysql-test/t/sel000007.test
      BitKeeper/deleted/.del-sel000008.test~b338ef585cadf7ae:
        Delete: mysql-test/t/sel000008.test
      BitKeeper/deleted/.del-sel000009.test~a455c38f5c942cd1:
        Delete: mysql-test/t/sel000009.test
      BitKeeper/deleted/.del-sel000010.test~ca07085ae92255f1:
        Delete: mysql-test/t/sel000010.test
      BitKeeper/deleted/.del-sel000011.test~c2a971726c9d18d6:
        Delete: mysql-test/t/sel000011.test
      BitKeeper/deleted/.del-sel000012.test~ae64bff363c42e92:
        Delete: mysql-test/t/sel000012.test
      BitKeeper/deleted/.del-sel000013.test~ce8aa504ba4f74ba:
        Delete: mysql-test/t/sel000013.test
      BitKeeper/deleted/.del-sel000019.test~8fd63c8dc6be8dbc:
        Delete: mysql-test/t/sel000019.test
      BitKeeper/deleted/.del-sel000020.test~c5758ad18a6dff1e:
        Delete: mysql-test/t/sel000020.test
      BitKeeper/deleted/.del-sel000021.test~94dd47de2872264a:
        Delete: mysql-test/t/sel000021.test
      BitKeeper/deleted/.del-sel000022.test~6e3e5435e66875e9:
        Delete: mysql-test/t/sel000022.test
      BitKeeper/deleted/.del-sel000023.test~7bdfcfaa278f837d:
        Delete: mysql-test/t/sel000023.test
      BitKeeper/deleted/.del-sel000024.test~849f47e6cbdc4fe3:
        Delete: mysql-test/t/sel000024.test
      BitKeeper/deleted/.del-sel000025.test~65b32b4b67e4c77:
        Delete: mysql-test/t/sel000025.test
      BitKeeper/deleted/.del-sel000026.test~d8aa2d614f23b1:
        Delete: mysql-test/t/sel000026.test
      BitKeeper/deleted/.del-sel000027.test~ab44bb57a580de9:
        Delete: mysql-test/t/sel000027.test
      BitKeeper/deleted/.del-sel000028.test~db9bfc0a808fb629:
        Delete: mysql-test/t/sel000028.test
      BitKeeper/deleted/.del-sel000029.test~6aae34dbb3ee86d9:
        Delete: mysql-test/t/sel000029.test
      BitKeeper/deleted/.del-sel000030.test~a29683eac3e7b706:
        Delete: mysql-test/t/sel000030.test
      BitKeeper/deleted/.del-sel000004.result~1f8d1265be521c17:
        Delete: mysql-test/r/sel000004.result
      BitKeeper/deleted/.del-sel000007.result~df455e49f9727c4f:
        Delete: mysql-test/r/sel000007.result
      BitKeeper/deleted/.del-sel000008.result~67a459ff62c84d6a:
        Delete: mysql-test/r/sel000008.result
      BitKeeper/deleted/.del-sel000009.result~e042b35ab131fb3:
        Delete: mysql-test/r/sel000009.result
      BitKeeper/deleted/.del-sel000010.result~eee5b9631a1e0066:
        Delete: mysql-test/r/sel000010.result
      BitKeeper/deleted/.del-sel000011.result~6907fe356973ed25:
        Delete: mysql-test/r/sel000011.result
      BitKeeper/deleted/.del-sel000012.result~be18991fc28954c2:
        Delete: mysql-test/r/sel000012.result
      BitKeeper/deleted/.del-sel000013.result~513389e06c96af73:
        Delete: mysql-test/r/sel000013.result
      BitKeeper/deleted/.del-sel000019.result~2870fe1c4998d929:
        Delete: mysql-test/r/sel000019.result
      BitKeeper/deleted/.del-sel000020.result~faa670294ef5fa91:
        Delete: mysql-test/r/sel000020.result
      BitKeeper/deleted/.del-sel000021.result~8f0ce4ec26e0c21d:
        Delete: mysql-test/r/sel000021.result
      BitKeeper/deleted/.del-sel000022.result~34828a43753ee767:
        Delete: mysql-test/r/sel000022.result
      BitKeeper/deleted/.del-sel000023.result~13e112d77573bf17:
        Delete: mysql-test/r/sel000023.result
      BitKeeper/deleted/.del-sel000024.result~b10d449624f48d07:
        Delete: mysql-test/r/sel000024.result
      BitKeeper/deleted/.del-sel000025.result~f31e08fcca805f35:
        Delete: mysql-test/r/sel000025.result
      BitKeeper/deleted/.del-sel000026.result~854fa951666b7982:
        Delete: mysql-test/r/sel000026.result
      BitKeeper/deleted/.del-sel000027.result~cfd73fe738f27da:
        Delete: mysql-test/r/sel000027.result
      BitKeeper/deleted/.del-sel000028.result~13ff5add6ac24908:
        Delete: mysql-test/r/sel000028.result
      BitKeeper/deleted/.del-sel000029.result~c6d071781808aa26:
        Delete: mysql-test/r/sel000029.result
      BitKeeper/deleted/.del-sel000030.result~98d496948e15064d:
        Delete: mysql-test/r/sel000030.result
      BitKeeper/deleted/.del-alt000001.test~633aed61c4bad94c:
        Delete: mysql-test/t/alt000001.test
      BitKeeper/deleted/.del-alt000001.result~393103dbf15f35c9:
        Delete: mysql-test/r/alt000001.result
      BitKeeper/deleted/.del-mrg000001.dummy.result~bf7e6d609f22b897:
        Delete: mysql-test/r/mrg000001.dummy.result
      BitKeeper/deleted/.del-mrg000001.result~db2ef2e717ab8332:
        Delete: mysql-test/r/mrg000001.result
      BitKeeper/deleted/.del-mrg000002.result~745be0854aaaaf5e:
        Delete: mysql-test/r/mrg000002.result
      BitKeeper/deleted/.del-mrg000001.test~e0327f9d1e6cb4e:
        Delete: mysql-test/t/mrg000001.test
      BitKeeper/deleted/.del-mrg000002.test~16b3a176adc0f311:
        Delete: mysql-test/t/mrg000002.test
      Docs/manual.texi:
        Changelog
      client/mysqlimport.c:
        Added support for hex strings
      client/mysqltest.c:
        Added linenumbers in output
        Only allow '{' first on a row (Conflicts with ODBC {} syntax).
        Handle bigger queries.
        Handle double ''
        Truncate result files.
      mysql-test/mysql-test-run.sh:
        Added --verbose
        cleanup
      mysql-test/r/bdb.result:
        Updating of test
      mysql-test/r/func_crypt.result:
        Updating of test
      mysql-test/r/func_equal.result:
        Updating of test
      mysql-test/r/func_str.result:
        Updating of test
      mysql-test/r/ins000001.result:
        Updating of test
      mysql-test/t/bdb.test:
        Updating of test
      mysql-test/t/err000001.test:
        Updating of test
      mysql-test/t/func_crypt.test:
        Updating of test
      mysql-test/t/func_equal.test:
        Updating of test
      mysql-test/t/func_str.test:
        Updating of test
      mysql-test/t/ins000001.test:
        Updating of test
      sql/gen_lex_hash.cc:
        Smaller table
      sql/handler.cc:
        Fixed bug in auto_commit
      f537319d