Automation error Row size too large, importing data in Local Storage (4270393)

Automation error Row size too large, importing data in Local Storage

In using MySQL (InnoDB) for the Local Storage, MySQL imposes a row-size limit.  In this SR, theses tables had a much larger row count than supported my MySQL. When trying to use Toad Automation to import the data to Local storage it failed.

 *   Although InnoDB supports row sizes larger than 65,535 bytes internally, MySQL itself imposes a row-size limit of 65,535 for the combined size of all columns:
·
·         mysql> CREATE TABLE t (a VARCHAR(8000), b VARCHAR(10000),
·             -> c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000),
·             -> f VARCHAR(10000), g VARCHAR(10000)) ENGINE=InnoDB;
·         ERROR 1118 (42000): Row size too large. The maximum row size for the
·         used table type, not counting BLOBs, is 65535. You have to change some
·         columns to TEXT or BLOBs

A  suggestion would be to revisit the SQL engine that Toad Data Point is  using to store data and or come up with some error trapping to test tables structures during the Automation process and warn users prior to execution of the script.

WORKAROUND:
None 

STATUS:
Enhancement request has been submitted to the Toad Data Point Idea Pond. Vote on this enhancement for consideration in a future release of Toad Data Point.