<*>[Attachment(s) from Bob Syslo-Seel included below]
<<ToadSupportBundleToad for MySQL.zip>> 1. Create a table with multiple tinyint(1) columns. Make them null with NO default value. 2. Create a spreadsheet that has value of 1 for some rows for some of these columns 3. LEAVE REMAINING COLUMNS BLANK in EXCEL. 4. Use IMPORT tool to load spreadsheet to table. 5. Query resulting data. Its a mess, some values are "TRUE" but shown as checked box, some are represented as dark blue checkbox with no checkmark. 6. Go to column header in result set and try to display the list of values to filter by--BOOM you get error. 7. Interestingly, if you do an export to an Excel Instance, some of the values actually say "TRUE", and the rest are ones.
Solved the problem by revising the table definition to be tinyint(1) not null default 0. Loaded the data and got grey checkboxes in the result set, some of which were checked.
Bob Syslo-Seel Data Architect All Star Directories email@example.com