MySQL Forums
Forum List  »  Federated Storage Engine

Wildcard and multiple tables with one of them on federated engine
Posted by: Stephan Schulz
Date: October 28, 2009 09:20AM

I set up a table with federated storage engine. The table 'channel' is the only one with federated engine, all others are MyIsam. On a specific query I get different results whether 'channel' is a remote table with federated or a lokal one using MyIsam.
I want do execute the following select-query:
SELECT channel.chanid FROM channel, cardinput WHERE channel.channum LIKE '2%' AND channel.sourceid = cardinput.sourceid;

with federated engine:
"Empty set (0,00 sec)"

without federated engine:
+--------+
| chanid |
+--------+
| 1002 |
+--------+

but here are the results of the seperated queries (with federated engine):

select sourceid from cardinput;
I get
+----------+
| sourceid |
+----------+
| 1 |
+----------+

next:
select chanid,sourceid,channum from channel WHERE channel.channum LIKE '2%';

+--------+----------+---------+
| chanid | sourceid | channum |
+--------+----------+---------+
| 1002 | 1 | 2 |
+--------+----------+---------+


But if I remove the wildcard all works as expected:
SELECT channel.chanid FROM channel, cardinput WHERE channel.channum LIKE '2' AND channel.sourceid = cardinput.sourceid;
+--------+
| chanid |
+--------+
| 1002 |
+--------+

So it looks like it has to be something to do with the combination of wildcard and AND
Am I missing something or could this be a bug?

Thank you in advance for any comments, Stephan

Options: ReplyQuote


Subject
Views
Written By
Posted
Wildcard and multiple tables with one of them on federated engine
8862
October 28, 2009 09:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.