Re: TRUNCATE problem ...

Rafal, - Original Message - From: "Rafal Kedziorski" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, July 28, 2003 6:52 PM Subject: TRUNCATE problem ... > hi, > > I have this table: > > CREATE TABLE `category_tree` ( >`categor

TRUNCATE problem ...

hi, I have this table: CREATE TABLE `category_tree` ( `category_tree_id` BIGINT NOT NULL AUTO_INCREMENT, `parent_id`BIGINT, `mandant_id` SMALLINT NOT NULL, `partner_id` SMALLINT NOT NULL, `class_id` VARCHAR ( 32) NOT NULL, `position`

Re: funny truncate "problem"

Hi Mihail Manolov wrote: > Hey guys, > > did you spot this problem? > > mysql> select truncate(199.20,2); > ++ > | truncate(199.20,2) | > ++ > | 199.19 | > ++ > 1 row in set (0.00 sec) > > Bug? No. Feature :) This is desc

funny truncate "problem"

Hey guys, did you spot this problem? mysql> select truncate(199.20,2); ++ | truncate(199.20,2) | ++ | 199.19 | ++ 1 row in set (0.00 sec) Bug? Mihail Manolov Government Liquidation, LLC 202 467 6868 x.227 [EMAIL PROTECTED