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
