Hi!

Sorry for delay :-(

On Dec 05, Mark J. Degallier wrote:
> >
> > I need a repeatable test case.
> 
> CREATE TABLE products (
>   id mediumint(6) default NULL auto_increment,
>   numOfFileUploads tinyint(2) NOT NULL default '2',
>   category_id text NOT NULL,
>   item_no varchar(30) NOT NULL default ' ',
>   title varchar(50) NOT NULL default ' ',
>   short_desc text NOT NULL,
>   long_desc text NOT NULL,
>   spec_desc text NOT NULL,
>   p_weight float(6,2) NOT NULL default '0.00',
>   p_width float(6,2) NOT NULL default '0.00',
>   p_height float(6,2) NOT NULL default '0.00',
>   p_depth float(6,2) NOT NULL default '0.00',
>   retail_price float(7,2) NOT NULL default '0.00',
>   wholesale_price float(7,2) NOT NULL default '0.00',
>   taxable_list text NOT NULL,
>   special_expiration date NOT NULL default '0000-00-00',
>   special_retail_price float(7,2) NOT NULL default '0.00',
>   special_wholesale_price float(7,2) NOT NULL default '0.00',
>   quantity_breaks text NOT NULL,
>   within_category tinyint(1) NOT NULL default '0',
>   min_order float(7,2) NOT NULL default '0.00',
>   max_order float(7,2) NOT NULL default '0.00',
>   inventory mediumint(7) NOT NULL default '0',
>   inventory_flag_amount smallint(6) NOT NULL default '0',
>   inventory_allow_order tinyint(1) NOT NULL default '0',
>   inventory_decrease mediumint(6) NOT NULL default '1',
>   inventory_comment varchar(100) NOT NULL default ' ',
>   shipping_comment varchar(50) NOT NULL default ' ',
>   PRIMARY KEY (id),
>   FULLTEXT KEY text_search(item_no,title,short_desc,long_desc,spec_desc)
> ) TYPE=MyISAM;
> 
> INSERT INTO products VALUES (13,1,'::1::5::4::','102a','Scent Clip 2-Pack','From 
>bows to firearms any big game hunting can be enhanced by the Scent Clip™. 
>Molded in tough polypropylene the Scent Clip is inexpensive, easy to use, and the 
>special Buna N O-Ring seal prevents leaks.  ','Use multiple Scent Clips for cover 
>scents, attractants, or curiosity scents. Transport them on arrow shafts or bow 
>limbs. When removed, the cap conveniently fits into the bottom keeping the cap and 
>housing together.  Simply clip it to a limb, corn stalk, etc. to catch the wind more 
>effectively. Leave the woods without leaving any scent trace behind.  
>\r\n\r\n<B><FONT COLOR=#FF000>Very effective with rut scents!</FONT></B> Patent 
>Pending.\r\n\r\nTwo (2) Scent Clips (1 brown & 1 green) with seals installed. (1) 
>Little Shiner (reflective tape strip), & unscented cotton balls. \r\n\r\n-Poly 
>bagged.\r\n-Punched header card. \r\n-UPC code.','4-3/4" x 
>6"','0.00','0.00','0.00','0.00','4.99','0.00','::','0000-00-00','0.00','0.00','','','0.00','0.00',100,10,1,1,'','');
> INSERT INTO products VALUES (11,1,'::3::','101','The Hunters Log ©','Provide insight 
>into big game movement with the Hunter\'s Log©. Record date and time, wind direction, 
>temperature, phase of the moon, location, and details of each hunt. \r\n\r\nThe 
>pocket size Hunter\'s Log is also ideal when hunting out of state, for sketching maps 
>of landmarks, roads, compass bearings or making field notes for reference on future 
>hunts.  \r\n\r\nEntries in the Hunter\'s Log will provide a legacy of hunting 
>experiences for generations to come.\r\n','-Poly bagged\r\n-Punched header 
>card\r\n-UPC coded.','4-3/4" x 
>7-1/2"','0.00','0.00','0.00','0.00','2.49','0.00','::','0000-00-00','0.00','0.00','','','0.00','0.00',30,10,'',10,'','');
> INSERT INTO products VALUES (21,1,'::5::','110','Predator Camo Slip On Camo Caps 
>set','(1) Green\r\n(1) Fall Gray','long 
>description','','0.00','0.00','0.00','0.00','7.99','0.00','::','0000-00-00', 
>'0.00','0.00','','','0.00','0.00',100,10,'',1,'','boo');
> INSERT INTO products VALUES (24,1,'::5::','113','Service/Replacement Rubber Kit / 
>Std. Rubber parts','short desc','long 
>desc','','0.00','0.00','0.00','0.00','4.99','0.00','','0000-00-00','0.00','0.00','','','0.00','0.00',100,10,'',1,'','');
> 
> SELECT * FROM products WHERE (MATCH (title,short_desc,long_desc,spec_desc,item_no) 
>AGAINST ('rubber'));
> 
> SELECT * FROM products WHERE (MATCH (title,short_desc,long_desc,spec_desc,item_no) 
>AGAINST ('rubber')) order by item_no;
> 
> Can you duplicate my problem?

Thank you for a test case - it was exactly what I asked for!

But both these queries produce identical one-row results for me.
I've tried both 3.23 and 4.0 versions.
Isn't your MySQL version too old ?

Regards,
Sergei

-- 
MySQL Development Team
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to