John,
are you sure that all indexes on all the tables merged are the same (same
fields, same order of indexes) ?
Benoit Grange
LibertySurf Telecom
10, rue Fructidor, 75834 Paris CEDEX 17
Tel: +33 (0) 1 41 66 77 88, Fax: +33 (0) 1 41 66 77 67
> -----Original Message-----
> From: John Hoffmann [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 21, 2001 1:25 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: select queries on merged tables?
>
>
> Just a quick question, maybe I'm missing the point of using
> merged tables, but why do I have to use like '%string' to
> find a match from a merged table instead of = 'string'?
>
> Example.
> mysql> select PARTNO,SUP,SUP_PARTNO,STOCK,PRICE,DESCR from
> combined_search where PARTNO = 'DSB-C300' order by PRICE,STOCK;
> ERROR 1030: Got error 124 from table handler
>
> mysql> select PARTNO,SUP,SUP_PARTNO,STOCK,PRICE,DESCR from
> combined_search where PARTNO like '%DSB-C300' order by PRICE,STOCK;
> | PARTNO | SUP | SUP_PARTNO | STOCK | PRICE | DESCR
> |
> | DSB-C300 | tec | 143224 | 0 | 95.32 | USB WEBCAM
> 32FPS DESKTOP 64M COLOR DIGITAL VIDCAM |
> | DSB-C300 | mer | 1621452 | 0 | 95.69 | USB WEB CAM,
> 300K PIXEL |
> | DSB-C300 | ing | 119607 | 22 | 97.00 | USB WEBCAM
> 32 FPS DESKTOP 64 MILLION COLOR DIGITAL VIDEO CAM |
> +----------+------+------------+-------+-------+--------------
> ------------------------------------------------+
> 3 rows in set (0.73 sec)
>
> --
> ---------------------------------------------------------------------
> / \ John Hoffmann Systems Engineer
> / . \ Professional Services VA LiNUX Systems Inc
> \ . / http://www.valinux.com [EMAIL PROTECTED]
> \_/ Linux Systems Work: (510) 687-6879 Cell: (613) 290-5217
> ---------------------------------------------------------------------
> This is Linux Country. On a quiet night, you can hear Windows reboot.
>
---------------------------------------------------------------------
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
