Permalink
Commits on Nov 8, 2017
  1. fix #issue 15 : mysql#15

    zhouxiao
    zhouxiao committed Nov 8, 2017
  2. mysqldiff: make the result sql more readable

    zhouxiao
    zhouxiao committed Nov 8, 2017
  3. allow generate create/drop sql when db objects does not exist, rather…

    zhouxiao
    zhouxiao committed Nov 8, 2017
    … than throw exception
    
    1. compatiable with old version
    2. --include-create option to allow generating create sql if not exist in target db. This option is allow only when difftype=sql
    3. --include-drop option to allow generating drop sql if ONLY exist in source db. This option works only when --include-create given
    4. support comparing all objects in db. Usage:  db1.* or db1.*:db2.*  (mysqldiff only check objects exist or when using db1:db2 )
  4. mysqldiff:add --skip-opt-autoinc

    zhouxiao
    zhouxiao committed Nov 8, 2017
    add --skip-opt-autoinc to only skip AUTO_INCREMENT when comparing and generating diffs.  mysqldiff skip all table options(engine,charset,comment,autoinc) when using --skip-table-options
  5. mysqldiff: fix two bugs

    zhouxiao
    zhouxiao committed Nov 8, 2017
    1. in sql_transform.py:_get_index_sql_clauses(), rows parameter must be ordered by index seq_no, since index filelds have order. But when using get_common_lists() to get add/drop index, index fileds are disordered (set() operation)
    This leads to the wrong index clauses: idx1(f1,f2) is constructed to idx1(f2,f1) probably.
    
    2. using get_common_lists() to get add/drop index, will missing some index filelds:
    table1: idx1(f1,f2)
    table2: idx1(f1)
    idx1(f2) will be constructed, that's too bad.
Commits on Dec 22, 2016
  1. Update with changes to internal.

    Chuck Bell
    Chuck Bell committed Dec 22, 2016
  2. Update with changes to internal

    Chuck Bell
    Chuck Bell committed Dec 22, 2016
Commits on Dec 21, 2016
  1. Updates for internal code.

    Chuck Bell
    Chuck Bell committed Dec 21, 2016
Commits on Dec 15, 2016
  1. Update Utilities-internal release-1.6.5

    Chuck Bell
    Chuck Bell committed Dec 15, 2016
  2. Fixed another issue with the same code for user.py and unittests.

    Chuck Bell
    Chuck Bell committed Dec 15, 2016
    Got it this time, I think.
    
    CAB
  3. Fix unittest failure.

    Chuck Bell
    Chuck Bell committed Dec 15, 2016
    CAB
Commits on Dec 14, 2016
  1. Fix minor test issues for MySQL 5.6

    Chuck Bell
    Chuck Bell committed Dec 14, 2016
    CAB
Commits on Dec 13, 2016
  1. Fixed minor test issues running MySQL 5.5.

    Chuck Bell
    Chuck Bell committed Dec 13, 2016
    CAB
  2. Updated CHANGES.txt with release-1.6.5 manifest.

    Chuck Bell
    Chuck Bell committed Dec 13, 2016
    CAB
  3. Merge branch 'release/1.6.5' of myrepo.no.oracle.com:mysql-utilities …

    Chuck Bell
    Chuck Bell committed Dec 13, 2016
    …into release/1.6.5
  4. BUG#20524886 : mysqlfailover doesn't clean up failover_console table …

    Chuck Bell
    Chuck Bell committed Dec 13, 2016
    …(drop) in daemon mode
    
    When running the mysqlfailover utility in daemon mode, the utility does not cleanup
    properly when exited. In this case, it does not remove the mysql.failover_console row
    or delete the table.
    
    This patch corrects the behavior so that the table is deleted on exit.
    
    CAB v1
Commits on Dec 12, 2016
  1. BUG#25030151: mysqlfailover (v:1.6) was stopped silently when using a…

    Chuck Bell
    Chuck Bell committed Dec 12, 2016
    … '--exec-before' script
    
    External scripts executed with failover or switchover that fail are not
    detected. In fact, the error is ignored. If the error is severe, the
    utility can halt unexpectedly without error or messages of any kind.
    
    This patch corrects the anomoly by capturing the error in an exception
    and logging the error to the log. This keeps the original premise that
    the external script should not halt the utility.
    
    Also, this patch corrects a defect found in the failover test whereby
    there was no coordination of the key phrases searched in the log for
    detecting successful test cases. While unconfirmed, this may fix the
    long-standing random failure seen on some platforms.
    
    Finally, the patch introduces the ability to search for multiple key
    phrases in the log for detecting successful test case execution for
    failover tests.
    
    CAB v2
  2. BUG#24742356 : typos in mysqlfailover messages

    Chuck Bell
    Chuck Bell committed Dec 12, 2016
    There are a number of typographical errors in some of the messages
    for mysqlfailover. This patch corrects those found in the code for
    mysqlfailover including rpl_admin.py.
    
    CAB v2
  3. BUG#24624716: ISSUE WITH 'MYSQLREPLICATE' 1.6.4 UTILITY

    Chuck Bell
    Chuck Bell committed Dec 12, 2016
    When connecting to a master and/or slave with the same user account as
    the replication user and there exists another account with an anonymous
    host, for example 'rpl'@'localhost' and 'rpl'@'%', where the anonymous
    user account has full privileges, the mysqlreplicate utility can fail.
    
    The failure is due to the way the code checks for privileges. Currently,
    the code is designed to include the anonymous host user grants, but it
    should not do so. The replication user account must use the more
    restrictive user@host rather than an anonymous host.
    
    Thus, this code has changed the way privileges are checked for the
    replication user. It no longer uses the anonymous host and instead
    checks only for the user@host as specified in the connection parameters.
    
    This eliminates the reliance on anonymous host accounts as well as makes
    the utility work correctly should a user desire to use the same account
    for connecting to the master and the replication user.
    
    CAB v2
  4. BUG#24613794 : mysqlfrm unable to parse some .frm files

    Chuck Bell
    Chuck Bell committed Dec 12, 2016
    This patch corrects a problem found during diagnostic mode where .frm
    files have indexes that exceed one page in the old page format. In this
    case, the offset for the column headings must take into account the
    size of the index keys in calculating the offset. This patch includes
    the change along with additional test files and tests to verify the
    changes.
    
    CAB v4
  5. BUG#22738248: mysqlfailover fails with --master=my.cnf[entry] style o…

    Chuck Bell
    Chuck Bell committed Dec 12, 2016
    …ption and python 2.6
    
    The code to read values from a configuration file fails to read unicode strings
    properly when used with Python 2.6.
    
    This patch adds logic to ensure the values read are converted to strings when
    run with Python 2.6. It does not affect other versions of Python.
    
    CAB v1
  6. BUG#22155217 : mysqldbimport --skip does not work

    Chuck Bell
    Chuck Bell committed Dec 12, 2016
    The --skip option does not work with --dry-run.
    
    This patch permits the use of the --skip option with the
    --dry-run option in mysqldbimport.
    
    CAB v2
  7. BUG#21764003 : convenience notation not permitted

    Chuck Bell
    Chuck Bell committed Dec 12, 2016
    The mysqldiff utility permits the use of a single database when
    comparing data on two servers, but the code does not work.
    
    This patch corrects the behaviour by examining the database argument
    looking for the colon (:) separator. If not found, it duplicates
    the database name so that the code works properly.
    
    CAB v3
  8. BUG#20857151 : MYSQLDIFF DROPS AND RECREATES PK AND INDEXES WHEN IT I…

    Chuck Bell
    Chuck Bell committed Dec 12, 2016
    …S NOT NEEDED
    
    This defect is subtle but nonetheless critical. The comparison of index metadata
    includes a column for cardinality. This value is updated is sublte ways by the
    server and can differ from one machine to another depending on how the data was
    entered. The problem also creates a case where the compare_db and diff tests can fail
    randomly producing (or not) differences with index drop and recreate.
    
    The solution is to ignore cardinality when comparing index metadata. Once corrected,
    the code no longer produces unnecessary index drop and recreate and makes the tests
    stable. Cool.
    
    CAB v1
  9. BUG#20807296 : remove use password() function (deprecated as of mysql…

    Chuck Bell
    Chuck Bell committed Dec 12, 2016
    … 5.7.6)
    
    The code currently uses the password() function, which was deprecated
    in version 5.7.6. This must be remove or else the utilities will
    crash when used with newer servers.
    
    This patch removes the use of the password() function when run with
    server version 5.7.6 or later.
    
    CAB v3
  10. BUG#18763591 : using grid format header difference should be ignored …

    Chuck Bell
    Chuck Bell committed Dec 12, 2016
    …for mysqldbcompare
    
    Currently, when using the GRID format for mysqldbcompare and there
    are differences among the rows, the code duplicates the header when
    the column sizes differ. This makes the output seem strange and
    confusing and seems to identify the column names themselves as being
    different.
    
    This patch adds code to calculate the maximum column widths for
    each table of the rows that differ using the maximum column values
    in the formatted rows thereby removing the difference with the
    column headers and extraneous print lines.
    
    CAB v2
  11. BUG#18733683 : mysqldbexport table names in the output are not consis…

    Chuck Bell
    Chuck Bell committed Dec 12, 2016
    …tent
    
    Currently, the output of mysqldbexport may show some object names with tickmarks
    and other object names without. The output should be made uniform.
    
    This patch makes the output of mysqldbexport conform to use tickmarks for all
    object names in the output stream.
    
    CAB v3
Commits on Nov 29, 2016
Commits on Nov 28, 2016
  1. Update Utilities-internal update

    Chuck Bell
    Chuck Bell committed Nov 28, 2016
Commits on Nov 22, 2016
  1. Update wix version to v3.10

    bkandasa committed Nov 22, 2016
Commits on Nov 21, 2016
  1. Set version for PB, test builds.

    Chuck Bell
    Chuck Bell committed Nov 21, 2016
Commits on Nov 7, 2016
  1. Fix for ssl test that used dbcompare after --quiet changes.

    Chuck Bell
    Chuck Bell committed Nov 7, 2016
    CAB
  2. BUG#22093453 : mysqldbcompare --quiet does not work

    Chuck Bell
    Chuck Bell committed Nov 7, 2016
    Fixed diff_sql tests failing as a result of changing --quiet
    behavior.
    
    CAB v1
Commits on Nov 4, 2016
  1. BUG#22093453 : mysqldbcompare --quiet does not work

    Chuck Bell
    Chuck Bell committed Nov 4, 2016
    Currently, using --quiet in mysqldbcompare does not completely
    silence all messages.
    
    This patch improves the --quiet option for mysqldbcompare to
    silence all informational messages.
    
    CAB v2