An error occurred fetching the project authors.
  1. 14 Aug, 2013 1 commit
  2. 16 Dec, 2011 1 commit
  3. 28 Mar, 2011 1 commit
  4. 12 Feb, 2011 1 commit
  5. 08 Dec, 2010 1 commit
    • Michael Widenius's avatar
      Fixed test results for windows builds · eb70e64c
      Michael Widenius authored
      Fixed compiler warning
      
      mysql-test/r/named_pipe.result:
        Fixed test results for windows builds
      mysql-test/r/shm.result:
        Fixed test results for windows builds
      sql/item_cmpfunc.cc:
        Fixed compiler warning about uninitialized "first"
      eb70e64c
  6. 20 Feb, 2010 1 commit
  7. 26 Mar, 2009 1 commit
    • Davi Arnaut's avatar
      Bug#33899: Deadlock in mysql_real_query with shared memory connections · 96e02e57
      Davi Arnaut authored
      The problem is that the read and write methods of the shared
      memory transport (protocol) didn't react to asynchronous close
      events, which could lead to a lock up as the client would wait
      (until time out) for a server response that will never come.
      
      The solution is to also wait for close events while waiting
      for I/O from or to the server.
      
      mysql-test/r/shm.result:
        Add test case result for Bug#33899
      mysql-test/t/shm.test:
        Add test case for Bug#33899
      vio/viosocket.c:
        Also wait for close events.
      96e02e57
  8. 13 Feb, 2008 1 commit
  9. 24 Oct, 2007 1 commit
  10. 26 Sep, 2007 1 commit
    • unknown's avatar
      Update result file(s) for 5.1 · 573f3a00
      unknown authored
      mysql-test/r/named_pipe.result:
        Update result file for 5.1
      mysql-test/r/shm.result:
        Update result file for 5.1
      573f3a00
  11. 24 Sep, 2007 1 commit
    • unknown's avatar
      Add test for named pipes on windows · 562deff3
      unknown authored
      Improve test for  shm on windows
      
      
      mysql-test/include/windows.inc:
        improve "skip message" and don't require a result file
      mysql-test/r/shm.result:
        Update result after adding more tests
      mysql-test/t/shm-master.opt:
        Add $MTR_BUILD_THREAD to get a unique shared memory base name
      mysql-test/t/shm.test:
        Run a bunch of more test to check shm
      mysql-test/r/named_pipe.result:
        New BitKeeper file ``mysql-test/r/named_pipe.result''
      mysql-test/t/named_pipe-master.opt:
        New BitKeeper file ``mysql-test/t/named_pipe-master.opt''
      mysql-test/t/named_pipe.test:
        New BitKeeper file ``mysql-test/t/named_pipe.test''
      562deff3
  12. 29 May, 2007 1 commit
    • unknown's avatar
      Bug #27531: 5.1 part of the fix · aff34a8c
      unknown authored
      - Renamed "Using join cache" to "Using join buffer".
      - "Using join buffer" is now printed on the last
        table that "reads" from the join buffer cache.
      
      
      mysql-test/r/archive_gis.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/compress.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ctype_utf8.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/derived.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/distinct.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/func_group.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/func_group_innodb.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/gis.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/greedy_optimizer.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/group_by.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/group_min_max.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/index_merge_myisam.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/information_schema.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/innodb_gis.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/innodb_mysql.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/join.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/join_nested.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/key_diff.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/myisam.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ndb_condition_pushdown.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ndb_gis.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/range.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/row.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/select.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ssl.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/ssl_compress.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/subselect.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/subselect3.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/union.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      mysql-test/r/view.result:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      sql/sql_select.cc:
        Bug #27531: renamed "Using join cache" to "Using join buffer"
        and moved to the last table in the batch.
      aff34a8c
  13. 15 May, 2007 1 commit
  14. 04 May, 2007 1 commit
    • unknown's avatar
      bug #27531: 5.1 part of the fix: · 0c835da8
      unknown authored
       - added join cache indication in EXPLAIN (Extra column).
       - prefer filesort over full scan over 
         index for ORDER BY (because it's faster).
       - when switching from REF to RANGE because
         RANGE uses longer key turn off sort on
         the head table only as the resulting 
         RANGE access is a candidate for join cache
         and we don't want to disable it by sorting
         on the first table only. 
      
      
      mysql-test/r/archive_gis.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/compress.result:
        bug #27531:
         - join cache in EXPLAIN. 
         - prefer filesort over full scan over index for ORDER BY.
      mysql-test/r/ctype_utf8.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/derived.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/distinct.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/func_group.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/func_group_innodb.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/gis.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/greedy_optimizer.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/group_by.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/group_min_max.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/index_merge_myisam.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/information_schema.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/innodb_gis.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/innodb_mysql.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/join.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/join_nested.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/key_diff.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/myisam.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/ndb_condition_pushdown.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/ndb_gis.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/range.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/row.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/select.result:
        bug #27531:
         - join cache in EXPLAIN.
         - prefer filesort over full scan over index for ORDER BY.
      mysql-test/r/ssl.result:
        bug #27531:
         - join cache in EXPLAIN.
         - prefer filesort over full scan over index for ORDER BY.
      mysql-test/r/ssl_compress.result:
        bug #27531:
         - join cache in EXPLAIN.
         - prefer filesort over full scan over index for ORDER BY.
      mysql-test/r/subselect.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/subselect3.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/union.result:
        bug #27531: join cache in EXPLAIN
      mysql-test/r/view.result:
        bug #27531: join cache in EXPLAIN
      sql/sql_select.cc:
        bug #27531:
         - join cache in EXPLAIN.
         - prefer filesort over full scan over
           index for ORDER BY.
         - disable sorting on the first table only
           when switching from REF to RANGE.
      0c835da8
  15. 03 Apr, 2007 1 commit
    • unknown's avatar
      Bug#27327 information_schema status views, variable_value conversion · 6e5ca12b
      unknown authored
      Type of 'Slave_running' status variable is changed to bool
      
      
      mysql-test/r/compress.result:
        test result
      mysql-test/r/rpl_packet.result:
        test result
      mysql-test/t/compress.test:
        test case
      mysql-test/t/rpl_packet.test:
        test case
      sql/mysqld.cc:
        Type of 'Slave_running' status variable is changed to bool
      6e5ca12b
  16. 28 Jul, 2006 1 commit
    • unknown's avatar
      BUG#14940 "MySQL choose wrong index", v.2 · ef452e19
      unknown authored
      - Make the range-et-al optimizer produce E(#table records after table 
                                                 condition is applied),
      - Make the join optimizer use this value,
      - Add "filtered" column to EXPLAIN EXTENDED to show 
        fraction of records left after table condition is applied
      - Adjust test results, add comments
      
      
      mysql-test/r/archive_gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/auto_increment.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/bdb_gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/bench_count_distinct.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/binlog_stm_blackhole.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/case.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/cast.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/compress.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ctype_collate.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ctype_cp1250_ch.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/date_formats.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/distinct.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/fulltext.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_compress.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_crypt.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_default.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_encrypt.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_gconcat.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_group.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_if.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_in.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_like.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_math.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_op.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_regexp.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_set.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_str.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_system.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_test.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/func_time.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/group_by.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/group_min_max.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/having.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/heap.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/heap_hash.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/index_merge.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/index_merge_innodb.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/index_merge_ror.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/innodb_gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/insert_update.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/join.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/join_nested.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/key_diff.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/myisam.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ndb_gis.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/negation_elimination.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/null.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/olap.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/partition_pruning.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/query_cache.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/row.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/rpl_get_lock.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/rpl_master_pos_wait.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/select.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ssl.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/ssl_compress.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/subselect.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/type_blob.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/union.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/varbinary.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/variables.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/r/view.result:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/ctype_cp1250_ch.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/func_like.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/group_min_max.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/index_merge_ror.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/index_merge_ror_cpk.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/join.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      mysql-test/t/partition_pruning.test:
        BUG#14940: Adjust the test results: EXPLAIN EXTENDED now has extra "filtered" column
      sql/opt_range.cc:
        BUG#14940: Make range/index_merge/group-min-max optimizer produce TABLE::quick_condition_rows -
          estimate of #records that will match the table condition.
      sql/sql_class.cc:
        BUG#14940: Add "filtered" column to output of EXPLAIN EXTENDED
      sql/sql_select.cc:
        BUG#14940: 
        - Make the join optimizer to use TABLE::quick_condition_rows=
          = E(#table records after filtering with table condition) 
        - Add "filtered" column to output of EXPLAIN EXTENDED
      sql/sql_select.h:
        BUG#14940: Added comments
      sql/table.h:
        BUG#14940: Added comments
      ef452e19
  17. 09 Jun, 2006 1 commit
  18. 06 Jun, 2006 1 commit
    • unknown's avatar
      Added --pipe option for faster compile · 7f19b1cc
      unknown authored
      Changed error to be more descriptive when you are refering to a not existing key
      Fixed core dump in view test and changed to better error message
      
      
      BUILD/compile-pentium64-debug-max:
        Added --pipe option for faster compile
        (This changset was missing in the tree I used to rebuild a new 5.1 tree)
      BUILD/compile-pentium64-debug:
        Added --pipe option for faster compile
        (This changset was missing in the tree I used to rebuild a new 5.1 tree)
      mysql-test/include/common-tests.inc:
        Changed error to be more descriptive
      mysql-test/r/compress.result:
        Changed error to be more descriptive
      mysql-test/r/explain.result:
        Changed error to be more descriptive
      mysql-test/r/key_cache.result:
        Changed error to be more descriptive
      mysql-test/r/preload.result:
        Changed error to be more descriptive
      mysql-test/r/select.result:
        Changed error to be more descriptive
      mysql-test/r/ssl.result:
        Changed error to be more descriptive
      mysql-test/r/ssl_compress.result:
        Changed error to be more descriptive
      mysql-test/r/view.result:
        Changed error to be more descriptive
      mysql-test/t/disabled.def:
        Disable im_instance_conf and im_options  until Bug#20294 (Instance manager test im_instance_conf fails randomly) is fixed
      mysql-test/t/explain.test:
        Changed error to be more descriptive
      mysql-test/t/select.test:
        Changed error to be more descriptive
      mysql-test/t/view.test:
        Changed error to be more descriptive
      sql/share/errmsg.txt:
        Fix that ER_KEY_DOES_NOT_EXISTS has same SQLSTATE as ER_KEY_COLUMN_DOES_NOT_EXISTS
      sql/sql_base.cc:
        Fixed core dump in view test
        Changed to correct error message that also shows the name of the faulty table
      BUILD/compile-pentium64:
        New BitKeeper file ``BUILD/compile-pentium64''
      7f19b1cc
  19. 01 Jun, 2006 1 commit
  20. 13 Oct, 2005 1 commit
    • unknown's avatar
      Updated after testing · c7ff3bdb
      unknown authored
      mysql-test/mysql-test-run.pl:
        Improved printouts
      mysql-test/r/compress.result:
        Updated test result
      mysql-test/r/ssl.result:
        Updated test result
      mysql-test/r/ssl_compress.result:
        Updated test result
      mysql-test/t/compress.test:
        Use new connection
        Use common include file 
        Test feature is turned on both before and after tests
      mysql-test/t/ssl.test:
        Use new connection
        Use common include file 
        Test feature is turned on both before and after tests
      mysql-test/t/ssl_compress.test:
        Use new connection
        Use common include file 
        Test feature is turned on both before and after tests
      c7ff3bdb
  21. 04 Oct, 2005 1 commit
    • unknown's avatar
      Improved testing of ssl and compression · 20fdedb7
      unknown authored
       - Added show status variable "compression" for checking that compression is turned on.
       - Updated show status variable "have_openssl" to be set to DISABLED if server supports ssl but it's not turned on to accept incoming ssl connections.  
       - Setup server to accept ssl connections from clients ig that is supported by server
       - New tests 
         - ssl - Run with ssl turned on
         - ssl_compress - Run with ssl and compression turned on
         - compress - Run with compression turned in 
       - Updated test 
         - openssl_1, rpl_openssl1 - Changed to run if server supports ssl
      
      
      BitKeeper/deleted/.del-have_openssl_1.inc~55590efedeec9ee0:
        Delete: mysql-test/include/have_openssl_1.inc
      BitKeeper/deleted/.del-have_openssl_1.require~e8cdeb0adba99ac5:
        Delete: mysql-test/r/have_openssl_1.require
      client/mysqltest.c:
        Add commands to enable/disable ssl for the follwing connect's
        Add commands to enable/disable compression for the  following connect's
      mysql-test/mysql-test-run.pl:
        Test if ssl is supported by the server
        If ssl is supported by the server, start server with ability to accept ssl connections from clients
        Cleanup check of supported features check_ssl_support, check_ndbcluster_support
        Flags and helptext for mysl-test-run.pl updated 
          --ssl, turn on ssl encryption between server and client
          --skip-ssl, don'r turn on ssl or setup ssl even if it's supported
          --with-openssl, deprecated, synonym with --ssl
      mysql-test/r/openssl_1.result:
        Update test results
      mysql-test/t/openssl_1.test:
        Run this if server reports it has support for ssl
        Enable ssl before connecting
        Check that ssl encryption has been turned on
      mysql-test/t/rpl_openssl.test:
        Run this if server reports it supports ssl
      sql-common/client.c:
        Add DBUG_PRINT's
      sql/mysqld.cc:
        If server can't accept ssl connection set have_openssl to SHOW_OPTION_DISABLED
        Add status variable to show if connection with server is using compressed protocol
      sql/sql_show.cc:
        Add status variable to show if connection with server is using compressed protocol
      sql/structs.h:
        Add status variable to show if connection with server is using compressed protocol
      mysql-test/r/compress.result:
        New BitKeeper file ``mysql-test/r/compress.result''
      mysql-test/r/ssl.result:
        New BitKeeper file ``mysql-test/r/ssl.result''
      mysql-test/r/ssl_compress.result:
        New BitKeeper file ``mysql-test/r/ssl_compress.result''
      mysql-test/t/compress.test:
        New BitKeeper file ``mysql-test/t/compress.test''
      mysql-test/t/ssl.test:
        New BitKeeper file ``mysql-test/t/ssl.test''
      mysql-test/t/ssl_compress.test:
        New BitKeeper file ``mysql-test/t/ssl_compress.test''
      20fdedb7
  22. 03 Oct, 2005 1 commit
    • unknown's avatar
      Fix bug#13535 Incorrect result from SELECT statement after SHOW TABLE STATUS · 78e8833f
      unknown authored
      After SHOW TABLE STATUS last_insert_id wasn't cleaned, and next select
      erroneously rewrites WHERE condition and returs a row;
      5.0 isn't affected because of different SHOW TABLE STATUS handling.
      
      last_insert_id cleanup added to mysqld_extend_show_tables().
      
      
      sql/sql_show.cc:
        Fix bug #13535 Incorrect result from SELECT statement after SHOW TABLE STATUS
        Added last_insert_id cleanup after SHOW TABLE STATUS command.
      mysql-test/t/select.test:
        Test case for bug #13535 Incorrect result from SELECT statement after SHOW TABLE STATUS
      mysql-test/r/select.result:
        Test case for bug #13535 Incorrect result from SELECT statement after SHOW TABLE STATUS
      78e8833f
  23. 30 Sep, 2005 1 commit
    • unknown's avatar
      Fix for BUG#13597 - columns in ON condition not resolved if references a table... · 68a91293
      unknown authored
      Fix for BUG#13597 - columns in ON condition not resolved if references a table in a nested right join.
      
      The problem was in that when finding the last table reference in a nested join tree,
      the procedure doing the iteration over the right-most branches of a join tree
      was testing for RIGHT JOINs the table reference that represents the join, and not
      the second operand of the JOIN. Currently the information whether a join is LEFT/RIGHT
      is stored not on the join object itself, but on one of its operands.
      
      
      mysql-test/r/select.result:
        Added test for BUG#13597
      mysql-test/t/select.test:
        Added test for BUG#13597
      sql/table.cc:
        - test whether a table reference is a right join by testing the
          rigth join operand (first in the list of operands), and not
          the table reference that represents the join itself.
        - clearer comments
      68a91293
  24. 28 Sep, 2005 1 commit
    • unknown's avatar
      select.result, item.cc: · 0fda286a
      unknown authored
        After merge fix for bug#13356
      
      
      sql/item.cc:
        After merge fix for bug#13356
      mysql-test/r/select.result:
        After merge fix for bug#13356
      0fda286a
  25. 27 Sep, 2005 1 commit
    • unknown's avatar
      Fix bug#13356 resolve_const_item() wasn't able to handle Item_row items. · a17b3dcb
      unknown authored
      resolve_const_item() assumed to be not called for Item_row items. For
      ensuring that DBUG_ASSERT(0) was set there.
      
      This patch adds section for Item_row items. If it can it recursively calls
      resolve_const_item() for each item the Item_row contains. If any of the
      contained items is null then whole Item_row substitued by Item_null. Otherwise
      it just returns.
      
      
      sql/item.cc:
        Fix bug#13356 resolve_const_item() wasn't able to handle Item_row items.
        
        Added section to resolve_const_item() for Item_row items. If it can it
        recursively calls resolve_const_item() for each item the Item_row contains. If
        any of the contained items is null then Item_row is substituted by Item_null.
        Otherwise it just returns.
        Comment moved closer to function it belongs to.
      mysql-test/t/select.test:
        Test case for bug#13356 resolve_const_item() wasn't able to handle Item_row items.
      mysql-test/r/select.result:
        Test case for bug#13356 resolve_const_item() wasn't able to handle Item_row items.
      a17b3dcb
  26. 20 Sep, 2005 1 commit
    • unknown's avatar
      Fix for BUG#13127. · 5f81fbb3
      unknown authored
      The problem was in the way table references are pre-filtered when
      resolving a qualified field. When resolving qualified table references
      we search recursively in the operands of the join. If there is
      natural/using join with a merge view, the first call to find_field_in_table_ref
      makes a recursive call to itself with the view as the new table reference
      to search for the column. However the view has both nested_join and
      join_columns != NULL so it skipped the test whether the view name matches
      the field qualifier. As a result the field was found in the view since the
      view already has a field with the same name. Thus the field was incorrectly
      resolved as the view field.
      
      
      mysql-test/r/select.result:
        Test for BUG#13127.
      mysql-test/t/select.test:
        Test for BUG#13127.
      sql/sql_base.cc:
        The patch contains two independent changes:
        
        - When searching for qualified fields, include merge views and information schema tables
        used with SHOW (both using TABLE_LIST::field_translation to represent result fields) in
        the test that compares the qualifying table with the name of the table reference being
        searched. This change fixes the bug.
        
        - Do not search the materialized list of columns of a NATURAL/USING join if 'table_list'
        is a stored table or merge view. Instead search directly in the table or view as if it
        is not under a natural join. This is a performance improvement since if 'table_list'
        is a stored table, then the search can utilize the name hash for table names.
      5f81fbb3
  27. 15 Sep, 2005 1 commit
    • unknown's avatar
      Fix bug #12291 Table wasn't reinited for index scan after sequential scan · 28028b5f
      unknown authored
      Optimizer did choose "Range checked for each record" for one of the tables.
      For first few loops over that table it choose sequential access, on later
      stage it choose to use index. Because table was previously initialized for 
      sequential access, it skips intitialization for index access, and when
      server tries to retrieve data error occurs.
      
      QUICK_RANGE_SELECT::init() changes so if file already initialized for
      sequential access, it calls ha_rnd_end() and initializes file for index
      access.
      
      
      sql/opt_range.cc:
        Fix bug #12291 Table wasn't reinited for index scan after sequential scan
      mysql-test/t/select.test:
        Test case for bug #12291 Table wasn't reinited for index scan after sequential scan
      mysql-test/r/select.result:
        Test case for bug #12291 Table wasn't reinited for index scan after sequential scan
      28028b5f
  28. 12 Sep, 2005 2 commits
  29. 10 Sep, 2005 1 commit
    • unknown's avatar
      Fix for BUG#12943. · 0dec682f
      unknown authored
      The problem was that in the first production in rule 'join_table', that
      processes simple cross joins, the parser was processing the second join operand
      before the first one due to unspecified priorities of JOINs. As a result in the
      case of cross joins the parser constructed a tree with incorrect nesting:
      the expression "t1 join t2 join t3 on some_cond" was interpreted as
      "t1 join (t2 join t3 on some_cond)" instead of
      "(t1 join t2) join t3 on some_cond".
      Because of this incorrect nesting the method make_join_on_context picked an
      incorrect table as the first table of the name resolution context.
      
      The solution assignes correct priorities to the related production.
      
      
      mysql-test/r/select.result:
        Added test for BUG#12943.
      mysql-test/t/select.test:
        Added test for BUG#12943.
      sql/sql_parse.cc:
        Fixed typo.
      sql/sql_yacc.yy:
        Provide explicit priorities of the JOIN operator and the 'table_ref' rule,
        to enforce left-associativity of [INNER | CROSS] JOIN.
      0dec682f
  30. 08 Sep, 2005 1 commit
    • unknown's avatar
      Fix for BUG#12977. · 9adffe29
      unknown authored
      mysql-test/r/select.result:
        Test for BUG#12977.
      mysql-test/t/select.test:
        Test for BUG#12977.
      sql/sql_base.cc:
        - Compare table qualifier of qualified fields only with tables that
          are not natural joins or their operands.
        - For qualified fields perform recursive search in all operands of
          natural joins that are nested joins.
        - Symmetrically detect ambiguous columns for both operands of
          NATURAL/USING joins.
      9adffe29
  31. 29 Aug, 2005 1 commit
    • unknown's avatar
      fix for bug #12841 · c38e297b
      unknown authored
      (Server crash on DO IFNULL(NULL,NULL)
      (fixes also "SELECT CAST(IFNULL(NULL,NULL) as DECIMAL)" unreported
       crash)
      (new revampled fix with suggestions from Igor)
      
      
      mysql-test/r/select.result:
        result of test for bug 12841
      mysql-test/t/select.test:
        test for bug #12841
        (Server crash on DO IFNULL(NULL,NULL)
      sql/item_func.cc:
        don't use the return value of ::str_op() without checking it
        whether checking it for NULL. (fixes bug #12841 as well as
        another not reported bug, but existing one - test case added).
        All other places where ::str_op() is used are safe.
      c38e297b
  32. 23 Aug, 2005 5 commits
    • unknown's avatar
      Test for BUG#6495. · 96f884c0
      unknown authored
      The bug itself is fixed by WL#2486.
      
      
      mysql-test/r/select.result:
        Test for BUG#6495.
      mysql-test/t/select.test:
        Test for BUG#6495.
      96f884c0
    • unknown's avatar
      Test for BUG#4889 - inconsistent resilts of more than 2-way natural join · 4bf5c7c5
      unknown authored
      due to incorrect transformation to JOIN ... ON.
      
      The bug itself is fixed by WL#2486.
      
      
      mysql-test/r/select.result:
        Test for BUG#4889.
      mysql-test/t/select.test:
        Test for BUG#4889.
      4bf5c7c5
    • unknown's avatar
      Fix for BUG#6276. · b4e830c3
      unknown authored
      mysql-test/r/select.result:
        Test for BUG#6276.
      mysql-test/t/select.test:
        Test for BUG#6276.
      sql/sql_base.cc:
        Add a true ON condition for outer joins without common columns.
      b4e830c3
    • unknown's avatar
      Test case for BUG#10972 - Natural join of view and underlying table gives wrong result. · 142f6583
      unknown authored
      The bug itself is fixed by WL#2486.
      
      
      mysql-test/r/select.result:
        Test case for BUG#10972.
      mysql-test/t/select.test:
        Test case for BUG#10972.
      142f6583
    • unknown's avatar
      WL#2486 - natural and using join according to SQL:2003 · fe24add7
      unknown authored
      * Provide backwards compatibility extension to name resolution of
        coalesced columns. The patch allows such columns to be qualified
        with a table (and db) name, as it is in 4.1.
        Based on a patch from Monty.
      
      * Adjusted tests accordingly to test both backwards compatible name
        resolution of qualified columns, and ANSI-style resolution of
        non-qualified columns.
        For this, each affected test has two versions - one with qualified
        columns, and one without. 
      
      
      mysql-test/include/ps_query.inc:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/bdb.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/innodb.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/join.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/join_nested.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/join_outer.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/null_key.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/order_by.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/ps_2myisam.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/ps_3innodb.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/ps_4heap.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/ps_5merge.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/ps_6bdb.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/ps_7ndb.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/select.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/subselect.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/r/type_ranges.result:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/bdb.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/innodb.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/join.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/join_nested.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/join_outer.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/null_key.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/order_by.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/select.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/subselect.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      mysql-test/t/type_ranges.test:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      sql/sql_base.cc:
        * Applied Monty's patch for backwards compatible name resolution
          of qualified columns. The idea is:
          - When a column is qualified, search for the column in all
            tables/views underlying each natural join. In this case
            natural joins are *not* considered leaves.
          - If a column is not qualified, then consider natural joins
            as leaves, thus directly search the result columns of
            natural joins.
        * Simplified 'find_field_in_tables()' - unified two similar
          loops into one.
      sql/table.cc:
        - Removed method & members not needed after Monty's patch.
      sql/table.h:
        - Removed method & members not needed after Monty's patch.
      tests/mysql_client_test.c:
        Put back old tests to test that coalesced columns of natural joins can be qualified.
      fe24add7
  33. 22 Aug, 2005 2 commits
    • unknown's avatar
      Test case for BUG#10646 · 9f70b175
      unknown authored
      The bug itself is fixed by WL #2486.
      
      
      mysql-test/r/select.result:
        Test for BUG#10646
      mysql-test/t/select.test:
        Test for BUG#10646
      9f70b175
    • unknown's avatar
      Test case for BUG#6558 - Views: create fails with JOIN ... USING · aebf2e49
      unknown authored
      The bug is non-view specific, and it resulted from incorrect
      name resolution of natural join result columns. The bug is
      fixed by WL#2486.
      
      
      mysql-test/r/select.result:
        Added test case for BUG#6558
      mysql-test/t/select.test:
        Added test case for BUG#6558
      aebf2e49
  34. 18 Aug, 2005 1 commit