MySQL Troubles & OOo Base - Solved UNSIGNED

In recent weeks I've posted a few things to this list try to get help 
for several issues I have with a MySQL db and OOo m110+.  I have now 
discovered the root of all my problems ... unsigned.

This simple little option has caused havoc for me testing m110+.  Here 
are a few symptoms:

*  A primary key was a simple counter, set to int(6) with unsigned.  
Select "MAX(Row)" would simply give back NULL.

*  One db has several fields set to int(1) and unsigned and are 
controlled by tick boxes on a form.  Changing the tick box and saving 
would fail and you'd get an error message saying your SQL was invalid.

*  Creating a new record from scratch with an unsigned field to be 
updated would fail (invalid message too).

The simple work around is to remove Unsigned from all these fields 
(ironically I only added Unsigned to them as in an early 1.1 release the 
tick boxes were setting the field to be either -1 or 0 which would give 
blank or a grey-ed out tick).

If anyone's interested the IZ number is 51846
http://qa.openoffice.org/issues/show_bug.cgi?id=51846


P h i l l