Package: mysqlcc
Version: 0.9.4-4
Severity: normal
I have a table called 'basic':
mysql> describe basic \G
*************************** 1. row ***************************
Field: class
Type: varchar(16)
Null:
Key:
Default:
Extra:
*************************** 2. row ***************************
Field: idx
Type: int(2)
Null:
Key:
Default: 0
Extra:
*************************** 3. row ***************************
Field: quantity
Type: enum('lon','lat','alt','vel','head','dist')
Null:
Key:
Default: lon
Extra:
*************************** 4. row ***************************
Field: factor
Type: double
Null: YES
Key:
Default: NULL
Extra:
*************************** 5. row ***************************
Field: object
Type: varchar(16)
Null: YES
Key:
Default: NULL
Extra:
*************************** 6. row ***************************
Field: objidx
Type: int(2)
Null: YES
Key:
Default: NULL
Extra:
*************************** 7. row ***************************
Field: lower_limit
Type: double
Null: YES
Key:
Default: NULL
Extra:
*************************** 8. row ***************************
Field: upper_limit
Type: double
Null: YES
Key:
Default: NULL
Extra:
*************************** 9. row ***************************
Field: resolution
Type: double
Null: YES
Key:
Default: NULL
Extra:
*************************** 10. row ***************************
Field: description
Type: varchar(32)
Null: YES
Key:
Default: NULL
Extra:
10 rows in set (0.00 sec)
mysql>
A tipical record looks like this:
mysql> select * from basic where class='foobar' and idx=1 \G
*************************** 1. row ***************************
class: foobar
idx: 1
quantity: lat
factor: 1
object: NULL
objidx: NULL
lower_limit: -90
upper_limit: 90
resolution: NULL
description: location
1 row in set (0.00 sec)
mysql>
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.
Gabor
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (101, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.10
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Versions of packages mysqlcc depends on:
ii libc6 2.3.2.ds1-20 GNU C Library: Shared libraries an
ii libgcc1 1:3.4.3-6 GCC support library
ii libmysqlclient12 4.0.23-7 mysql database client library
ii libstdc++5 1:3.3.5-8 The GNU Standard C++ Library v3
-- no debconf information
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
