1. 17 Nov, 2006 1 commit
    • unknown's avatar
      Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR · 97608597
      unknown authored
      Fix tests for new behaviour: an error is thrown if a NON DETERMINISTIC
      stored function (SF) is called during statement-based replication (SBR).
      
      
      mysql-test/r/func_time.result:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/r/gis.result:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Mark function as DETERMINISTIC so it can be called with no error while
        doing statement-based replication (SBR).
      mysql-test/r/grant2.result:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/r/innodb_notembedded.result:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/r/ps.result:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Mark function as DETERMINISTIC so it can be called with no error while
        doing statement-based replication (SBR).
      mysql-test/r/query_cache.result:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/r/query_cache_notembedded.result:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/r/rpl_sp.result:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Move test for SF-calls in different replication modes to its own file, rpl_sf.
      mysql-test/r/rpl_sp_effects.result:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/r/sp.result:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Mark function as DETERMINISTIC so it can be called with no error while
        doing statement-based replication (SBR).
      mysql-test/r/timezone2.result:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/t/func_time.test:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/t/gis.test:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Mark function as DETERMINISTIC so it can be called with no error while
        doing statement-based replication (SBR).
      mysql-test/t/grant2.test:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/t/innodb_notembedded.test:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/t/ps.test:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/t/query_cache.test:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/t/query_cache_notembedded.test:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/t/rpl_sp.test:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/t/rpl_sp_effects.test:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      mysql-test/t/sp.test:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Mark function as DETERMINISTIC so it can be called with no error while
        doing statement-based replication (SBR).
      mysql-test/t/timezone2.test:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Modify test that contains non-deterministic functions so it can still be
        called with no error while doing statement-based replication (SBR).
      sql/item_func.cc:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        If 'log_bin_trust_function_creators' variable is set, don't throw an error
        on calling a non-deterministc function in statement-based replication (SBR).
      sql/sql_parse.cc:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Do not throw an error on calling a NON DETERMINISTIC stored procedure (SP)
        while doing statement-based replication (SBR), as the routine body is
        executed statement-by-statement.
      mysql-test/r/rpl_sf.result:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Test for stored function (SF) calls in different replication modes.
        NON DETERMINISTIC SFs are not allowed while doing
        statement-based replication (SBR).
      mysql-test/t/rpl_sf.test:
        Bug#16456 RBR: rpl_sp.test expects query to fail, but passes in RBR
        
        Test for stored function (SF) calls in different replication modes.
        NON DETERMINISTIC SFs are not allowed while doing
        statement-based replication (SBR).
      97608597
  2. 15 Nov, 2006 17 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.1-maint · 4587b47b
      unknown authored
      into  zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.1-maint
      
      
      sql/item_func.cc:
        Auto merged
      4587b47b
    • unknown's avatar
      Merge zippy.cornsilk.net:/home/cmiller/work/mysql/bug19955/my50-bug19955 · eb76d0dd
      unknown authored
      into  zippy.cornsilk.net:/home/cmiller/work/mysql/bug19955/my51-bug19955
      
      
      mysql-test/r/bigint.result:
        Auto merged
      sql/item_func.cc:
        Auto merged
      eb76d0dd
    • unknown's avatar
      Bug#19955: unsigned bigint used as signed with MOD function · 0d18a405
      unknown authored
      Problem:  When we have a really large number (between 2^63 and 2^64)
      as the left side of the mod operator, it gets improperly corerced
      into a signed value.
      
      Solution:  Added check to see if the "negative" number is really
      positive, and if so, cast it.
      
      
      mysql-test/r/bigint.result:
        Added test case result
      mysql-test/t/bigint.test:
        Added test case
      sql/item_func.cc:
        Added check to see if we have an unsigned number that looks like a
        signed number.
      0d18a405
    • unknown's avatar
      manual merge for 16456 · 482a4a81
      unknown authored
      
      mysql-test/r/rpl_sp.result:
        manual merge
      482a4a81
    • unknown's avatar
      Merge tnurnberg@bk-internal.mysql.com:/home/bk/mysql-5.1-maint · 14ae4425
      unknown authored
      into  salvation.intern.azundris.com:/home/tnurnberg/work/mysql-5.1-maint-16456
      
      14ae4425
    • unknown's avatar
      Merge zippy.cornsilk.net:/home/cmiller/work/mysql/bug17700/my51-bug17700 · afb5cc20
      unknown authored
      into  zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.1-maint
      
      afb5cc20
    • unknown's avatar
      Merge zippy.cornsilk.net:/home/cmiller/work/mysql/bug17700/my50-bug17700 · f16d28ac
      unknown authored
      into  zippy.cornsilk.net:/home/cmiller/work/mysql/bug17700/my51-bug17700
      
      
      scripts/mysql_fix_privilege_tables.sh:
        Auto merged
      f16d28ac
    • unknown's avatar
      Merge zippy.cornsilk.net:/home/cmiller/work/mysql/bug17700/my41-bug17700 · 5d7dcb80
      unknown authored
      into  zippy.cornsilk.net:/home/cmiller/work/mysql/bug17700/my50-bug17700
      
      
      scripts/mysql_fix_privilege_tables.sh:
        Auto merged
      5d7dcb80
    • unknown's avatar
      Bug#17700: mysql_fix_privilege_tables cannot handle a password \ · e4849218
      unknown authored
      	with embedded spaces
        
      Problem:  Original code written assuming password contains no spaces.
      Further, because of how sh interprets characters in variables, you
      cannot do the "simple solution".
        
      Solution:  Move the "was a password provided" check to the end. This
      allows us to correctly quote the password argument when passed to the
      mysql client program.  Addendum:  Put this check inside of a shell fn
      to simplify the code.
      
      
      scripts/mysql_fix_privilege_tables.sh:
        Moved password existence check to end to allow for passwords with
        with embedded spaces.
      e4849218
    • unknown's avatar
      Merge tnurnberg@bk-internal.mysql.com:/home/bk/mysql-5.1-maint · 4238f399
      unknown authored
      into  salvation.intern.azundris.com:/home/tnurnberg/work/mysql-5.1-maint-16456
      
      
      mysql-test/mysql-test-run.pl:
        Auto merged
      mysql-test/t/rpl_sp.test:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      mysql-test/r/rpl_sp.result:
        manual merge
      4238f399
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.1-new-maint · a79194a2
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.1-new-maint
      
      
      mysql-test/r/type_float.result:
        Auto merged
      a79194a2
    • unknown's avatar
      Update result file for mysql_upgrade as we have more tables that is checked in 5.1 · 143f180c
      unknown authored
      Fix merge errors
      
      
      mysql-test/r/mysql_upgrade.result:
        Update result file for mysql_upgrade
      mysql-test/r/mysqldump.result:
        Merge error
      mysql-test/r/rpl_drop_db.result:
        Merge error
      mysql-test/r/rpl_row_max_relay_size.result:
        Merge error
      mysql-test/t/rpl_drop_db.test:
        Merge error
      143f180c
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/mysql-5.0-maint · ba60c522
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.1-new-maint
      
      
      mysql-test/extra/rpl_tests/rpl_deadlock.test:
        Auto merged
      mysql-test/extra/rpl_tests/rpl_max_relay_size.test:
        Auto merged
      mysql-test/r/key_cache.result:
        Auto merged
      mysql-test/r/rpl_deadlock_innodb.result:
        Auto merged
      mysql-test/r/rpl_sp.result:
        Auto merged
      mysql-test/r/rpl_stm_max_relay_size.result:
        Auto merged
      mysql-test/r/rpl_timezone.result:
        Auto merged
      mysql-test/r/type_float.result:
        Auto merged
      mysql-test/r/view_grant.result:
        Auto merged
      mysql-test/t/init_connect.test:
        Auto merged
      mysql-test/t/mysqldump.test:
        Auto merged
      mysql-test/t/view_grant.test:
        Auto merged
      mysql-test/r/mysqldump.result:
        Manual merge
      mysql-test/r/rpl_drop_db.result:
        Manual merge
      mysql-test/r/rpl_variables.result:
        Manual merge
      mysql-test/t/rpl_drop_db.test:
        Manual merge
      mysql-test/t/rpl_sp.test:
        Manual merge
      mysql-test/t/rpl_timezone.test:
        Manual merge
      mysql-test/t/rpl_variables.test:
        Manual merge
      ba60c522
    • unknown's avatar
      Fix spelling error · a20458cd
      unknown authored
      a20458cd
    • unknown's avatar
      Cleanup after test cases · f4251720
      unknown authored
      
      mysql-test/r/init_connect.result:
        Restore global variable to the value it's set to when server is started
      mysql-test/r/key_cache.result:
        Restore global variable values to original
      mysql-test/r/mysqldump.result:
        Drop the user that was created. Specifying "drop user myDB_user" is equal to "drop user myDB_user@%"
      mysql-test/r/rpl_deadlock.result:
        Restore global variable values to original
      mysql-test/r/rpl_drop_db.result:
        Remove the conflicting file and drop database mysqltest1 before test exits
      mysql-test/r/rpl_ignore_revoke.result:
        As changes to mysql.* are ignored - explicitly delete the user on slave
      mysql-test/r/rpl_init_slave.result:
        Restore global variable values to original
      mysql-test/r/rpl_max_relay_size.result:
        Restore global variable values to original
      mysql-test/r/rpl_sp.result:
        Restore global variable values to original
      mysql-test/r/rpl_timezone.result:
        Restore global variable values to original
      mysql-test/r/rpl_variables.result:
        Restore global variable values to original
      mysql-test/r/view_grant.result:
        Use same user in all places in the same test "readonly" is equal to "readonly@%" not "readonly@localhost"
      mysql-test/t/init_connect.test:
        Restore global variable to the value it's set to when server is started
      mysql-test/t/key_cache.test:
        Restore global variable values to original
      mysql-test/t/mysqldump.test:
        Drop the user that was created. Specifying "drop user myDB_user" is equal to "drop user myDB_user@%"
      mysql-test/t/rpl_deadlock.test:
        Restore global variable values to original
      mysql-test/t/rpl_drop_db.test:
        Remove the conflicting file and drop database mysqltest1 before test exits
      mysql-test/t/rpl_ignore_revoke.test:
        As changes to mysql.* are ignored - explicitly delete the user on slave
      mysql-test/t/rpl_init_slave.test:
        Restore global variable values to original
      mysql-test/t/rpl_max_relay_size.test:
        Restore global variable values to original
      mysql-test/t/rpl_sp.test:
        Restore global variable values to original
      mysql-test/t/rpl_timezone.test:
        Restore global variable values to original
      mysql-test/t/rpl_variables.test:
        Restore global variable values to original
      mysql-test/t/view_grant.test:
        Use same user in all places in the same test "readonly" is equal to "readonly@%" not "readonly@localhost"
      f4251720
    • unknown's avatar
      Merge tnurnberg@bk-internal.mysql.com:/home/bk/mysql-5.1-maint · 129c87bc
      unknown authored
      into  salvation.intern.azundris.com:/home/tnurnberg/work/mysql-5.1-maint-16456
      
      
      mysql-test/r/func_time.result:
        Auto merged
      mysql-test/t/disabled.def:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      129c87bc
    • unknown's avatar
      Bug#16456 "RBR: rpl_sp.test expects query to fail, but passes in RBR" · 788e965c
      unknown authored
      calling (rather than defining) non-deterministic SP in SBR (as opposed
      to RBR or mixed) will throw an error now.
      
      require mixed mode for tests now. SBR will now fail when calling
      non-deter SPs and SFs (as it should), and RBR already failed by virtue of
      giving different results for "show binlog" than the results-file has.
      also test for 16456 now. lastly make amends because one of the tests
      fails with a new error # now as code was added to sql_trigger.cc while
      test was disabled.
      
      
      mysql-test/mysql-test-run.pl:
        Bug#16456 "RBR: rpl_sp.test expects query to fail, but passes in RBR"
        
        mtr falsely assumed that default rep mode is stmt i/o mixed?
      mysql-test/r/func_time.result:
        Bug#16456 "RBR: rpl_sp.test expects query to fail, but passes in RBR"
        
        rpl_sp.test was disabled for a while; update results where wording has
        changed and add results for #16456
      mysql-test/r/rpl_sp.result:
        Bug#16456 "RBR: rpl_sp.test expects query to fail, but passes in RBR"
        
        rpl_sp.test was disabled for a while; update results where wording has
        changed and add results for #16456
        ---
        Bug#16456 "RBR: rpl_sp.test expects query to fail, but passes in RBR"
        
        calling (rather than defining) non-deterministic SP or SF in SBR
        (as opposed to RBR or mixed) will throw an error now.
      mysql-test/t/disabled.def:
        Bug#16456 "RBR: rpl_sp.test expects query to fail, but passes in RBR"
        
        re-enable rpl_sp.test
      mysql-test/t/rpl_sp.test:
        Bug#16456 "RBR: rpl_sp.test expects query to fail, but passes in RBR"
        
        require mixed mode for tests now. SBR will now fail when calling
        non-deter SPs (as it should), and RBR already failed by virtue of
        giving different results for "show binlog" than the results-file has.
        also test for 16456 now. lastly make amends because one of the tests
        fails with a new error # now as code was added to sql_trigger.cc while
        test was disabled.
        ---
        Bug#16456 "RBR: rpl_sp.test expects query to fail, but passes in RBR"
        
        calling (rather than defining) non-deterministic SP or SF in SBR
        (as opposed to RBR or mixed) will throw an error now.
      sql/item_func.cc:
        Bug#16456 "RBR: rpl_sp.test expects query to fail, but passes in RBR"
        
        calling (rather than defining) non-deterministic SF in SBR
        (as opposed to RBR or mixed) will throw an error now.
      sql/sql_parse.cc:
        Bug#16456 "RBR: rpl_sp.test expects query to fail, but passes in RBR"
        
        calling (rather than defining) non-deterministic SP in SBR (as opposed
        to RBR or mixed) will throw an error now.
      788e965c
  3. 14 Nov, 2006 11 commits
  4. 13 Nov, 2006 11 commits