Gabor Kiss wrote: >Package: mysqlcc >Version: 0.9.4-4 >Severity: normal > >I have a table called 'basic': > ...
>This record cannot be deleted with mysqlcc because it creates >a sintactically bad SQL statement. >An entry from /var/log/mysql/mysql.log: > >050301 13:56:45 96 Query DELETE FROM `basic` >WHERE `class`='foobar' AND `idx`=1 AND `quantity`='lat' AND ABS(`factor` - 1) >< >1e-31 AND `object` IS NULL AND `objidx` IS NULL AND ABS(`lower_limit` - -90) >< > 1e-31 AND ABS(`upper_limit` - 90) < 1e-31 AND ABS(`resolution` - ) < 1e-31 > AND >`description`='location' >LIMIT 1 > >See expression "ABS(`resolution` - ) < 1e-31" >I think mysqlcc is confused by a numeric field that can be NULL. > > Unfortunately, MySQL CC is no longer under development and is now scheduled to be removed from Debian. The replacements for MySQL CC are mysql-admin and mysql-query-browser. Could you reproduce this bug in mysql-query-browser? Just select all records from the table, then edit the table (button at bottom of results), remove row, apply changes (query browser seems to be transaction oriented :). - Adam -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
