• Fixes the connection issue in Database Snaps by detecting and closing open connections after the Snap execution ends.

4.21 (snapsmrc542)

• No updates made.

4.20 Patch db/mysql8815

• Fixes the MySQL Stored Procedure Snap to resolve compatibility issues with the Amazon Aurora database.

4.20 Patch db/mysql8786

• Fixes the MySQL - Bulk Load Snap to use the UTF-8 character set for writing temporary files in order to successfully handle special characters, irrespective of the value specified in the Character set field in the Snap settings.  

4.20 (snapsmrc535)

• No updates made.

4.19 Patch db/mysql8638

• Fixes the MySQL Database Account where the associated Snaps produce a huge count of open file descriptors when the Configure SSH Tunnel property is enabled.

4.19 Patch db/mysql8635

• Fixes the MySQL - Execute Snap where the retry option fails to establish a connection with the MySQL database, after an interrupted transmission.

4.19 Patch db/mysql8407

• Fixes an issue with the MySQL - Update Snap wherein the Snap is unable to perform operations when:
  • An expression is used in the Update condition property.
  • Input data contain the character '?'.

4.19 Patch db/mysql8390

• Fixes an issue wherein the MySQL Snaps are unable to reconnect to the MySQL database after the breakdown of a connection.

4.19 Patch db/mysql8340

• Fixes an issue with the MySQL Bulk Load Snap wherein the Snap is unable to execute the bulk load feature with MySQL 8.0 and higher versions.

4.19 (snapsmrc528)

• No updates made.

4.18 Patch db/mysql7846

• Fixed an issue with the MySQL Snaps wherein the Snaps exhibit degraded performance with snapsmrc523.

4.18 (snapsmrc523)

• Reverted a 4.17-patch (db/mysql7395) update regarding how BIT and BOOLEAN column data type values are displayed. They now display as true or false (4.17GA behavior in snapsmrc515) rather than converting to 0 or 1 values (4.17-patch behavior).

4.17 Patch ALL7402

• Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17 Patch db/mysql7395

• Fixed an issue wherein bit data types in the MySQL - Select table convert to true or false instead of 0 or 1.

4.17 Patch db/mysql7357

• Fixed an issue with the MySQL Execute snap wherein the Retry property for connection fails after the database connection is severed.

4.17 (snapsmrc515)

• Fixed an issue with the MySQL Execute Snap wherein the Snap would send the input document to the output view even if the Pass through field is not selected in the Snap configuration. With this fix, the Snap sends the input document to the output view, under the key original, only if you select the Pass through field.
• Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

4.16 Patch MULTIPLE7123

• Added two new properties, Number of retries and Retry interval, to Delete, Insert, Select, Execute, Merge, Update, and MutliExecute Snaps that enables you to handle retry attempts during a connection failure.

4.16 Patch db/mysql6823

• Fixed an issue with the Lookup Snap passing data simultaneously to output and error views when some values contained spaces at the end.

4.16 (snapsmrc508)

• No updates made. Automatic rebuild with a platform release.

4.15 Patch MULTIPLE6413

• Added 2 new properties, JDBC Driver Class and JDBC JARs. The new properties enable uploading JDBC JARs that help connect to MYSQL8.

4.15 Patch db/mysql6332

• Replaced Max idle time and Idle connection test period properties with Max life time and Idle Timeout properties respectively, in the Account configuration. The new properties fix the connection release issues that were occurring due to default/restricted DB Account settings.

4.15 (snapsmrc500)

• No updates made. Automatic rebuild with a platform release.

4.14 (snapsmrc490)

• Added support for Amazon Aurora and Azure SQL DB.

4.13 (snapsmrc486)

• No updates made. Automatic rebuild with a platform release.

4.12 Patch db/mysql4924

• Fixed the MySQL Bulk Load Snap so that it doesn't produce an output document if there are no input documents.

4.12 (snapsmrc480)

• No updates made. Automatic rebuild with a platform release. 

4.11 (snapsmrc465)

• New! MySQL Stored Procedure Snap added to call/execute MySQL Stored Procedure.
• SSH Tunnelling related properties added at the Account level for both MySQL Dynamic Account and MySQL Database Account.

4.10 Patch mysql3988

• SSH Tunnelling related properties added at the Account level for both MySQL Dynamic Account and MySQL Database Account.

4.10 (snapsmrc414)

• Added Auto commit property to the Select and Execute Snaps at the Snap level to support overriding of the Auto commit property at the Account level.

4.9.0 Patch mysql3070

• Fixed an issue regarding connection not closed after login failure; Expose autocommit for "Select into" statement in PostgreSQL Execute Snap and Redshift Execute Snap

4.9 (snapsmrc405)

• No updates made. Automatic rebuild with a platform release.

4.8.0 Patch mysql2755

• Potential fix for JDBC deadlock issue.
  

4.8.0 Patch mysql2695

• Addresses an issue where some changes made in the platform patch MRC294 to improve perfomance caused Snaps in the listed Snap Packs to fail. 

4.8 (snapsmrc398)

• Info tab added to accounts.
• Database accounts now invalidate connection pools if account properties are modified and login attempts fail.

4.7.0 Patch mysql2189

• Fixed an issue for database Select Snaps regarding Limit rows not supporting an empty string from a pipeline parameter.

4.7.0 Patch mysql2280

• MySQL Merge will now route documents to the output and error views correctly

4.7 (snapsmrc382)

• Added a new Snap, MySQL Bulk Load.

4.6 (snapsmrc362)

• Enhanced MySQL Execute Snap to fully support SQL statements with/without expressions & SQL bind variables.
• Extended support for MySQL Dynamic accounts.
• Resolved an issue in MySQL Select Snap that caused failures in the second output view when retrieving outputs from a table with a dot (.) character.
• Resolved an issue in MySQL Execute Snap that caused failures when passing expression ($variable_name) for stored procedures.
• Resolved an issue in MySQL Execute Snap that caused failures when an SQL statement had an inline comment.
• Resolved an issue in MySQL Execute Snap that ignored all statements after "–".

4.5.1 (mysql1582)

• Fixed an error in a tooltip for MySQL - Select Snap.

4.5 (snapsmrc344)

• Resolved an issue in MySQL Insert Snap to ensure an error is reported when table column is set to NOT NULL.

4.3.2

• NEW! MySQL Lookup Snap
• Improved performance of the MySQL Execute Snap.

4.3.0

• Table List Snap: A new option, Compute table graph, now lets you determine whether or not to generate dependents data into the output.

4.2.2

• Ignore empty result added to Execute and Select Snaps. The option will not write any document to the output view for select statements producing no results.
• Resolved a Java exception in MySQL Merge Snap.

August 7, 2015 (2015.25/4.2.1)

• Resolved an error in MySQL Merge Snap while trying to load Images.
• Resolved an error when MySQL Execute Snap was placed after a ForEach Snap.
• Output fields table property added to Select Snap.
• Resolved an issue in Execute and Select Snaps where the output document was the same as the input document if the query produces no data. When there is no result from the SELECT query, the input document will be passed through to the output view as a value to the 'original' key. The new property Pass through with true default.

June 6, 2015 (2015.20)

• MySQL Insert: resolved issue with the Snap not handling out of range value properly
• Dynamic DB queries now supported in the Execute Snap.
• The SQL statement property now can be set as an expression property. When it is an expression, it will be evaluated with each input document and one SQL statement per each input document will be executed.
• Known issue: When the SQL statement property is an expression, the pipeline parameters are shown in the suggest, but not the input schema.
• With the SQL statement property set as an expression, the Snap can be exposed to SQL injection. Please use this feature with caution.
• Migration Impacts: There is a change in behavior in the MySQL Insert and Merge Snaps that is not backwards compatible. When a string value is inserted or merged into an integer type field of MySQL and the string value is not a numeric string or is larger than the maximum integer value (2147483647), the Snap will throw an error or route an error to the error view. The previous behavior was that if the string value was not a numeric string, it was converted to zero, and if the string value was larger than the maximum integer value, it was converted to the maximum integer value.

March 2015

• MySQL Select: Resolved an issue with using a where clause with a column name having a special character.

January 2015

• MySQL Account: The settings Acquire increment and Retry Attempts were removed.

December 20, 2014

• Updates

October 18, 2014

• MySQL Snap Pack: MySQL Multi Execute Snap (Beta) added.
• Addressed the following issues:
  • Mysql Merge fails with data type tinyint.error: "SQL operation failed" reason: "Column 'column1' cannot be null"
    
  • MySQL batch insert - misleading error
    

Initial Release (June 2013)

• Initial release of this Snap Pack. Read/Write support for MySQL.