> First: please reply to the list, not directly to me.
> Then:
>
> I need a repeatable test case. That is
>
> CREATE TABLE ...
> INSERT INTO ... VALUSE (...),(...)...
> SELECT * FROM ... WHERE ... <= it works
> SELECT * FROM ... WHERE ... ORDER BY ... <= it does not
THIS QUERY WORKS:
SELECT * FROM products WHERE (MATCH
(title,short_desc,long_desc,spec_desc,item_no) AGAINST ('rubber'))
THIS QUERY DOES NOT WORK -- RETURNS NOTHING:
SELECT * FROM products WHERE (MATCH
(title,short_desc,long_desc,spec_desc,item_no) AGAINST ('rubber')) order by
item_no
HERE IS A TEST DATABASE:
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,'','');
Can you duplicate my problem?
Thanks!
-Mark
---------------------------------------------------------------------
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
