Re: query returning odd result

Oh sorry, I'm using MySQL 5.0 on Windows Server 2003.

Joelle Tegwen wrote:
> I have a table:
> CREATE TABLE  `youthhood`.`link` (
>  `linkID` int(10) unsigned NOT NULL default '0',
>  `url` varchar(255) NOT NULL default '',
>  `sectionID` int(10) unsigned NOT NULL default '0',
>  `title` varchar(255) default NULL,
>  `description` longtext,
>  `organization` varchar(255) default NULL,
>  `locationID` int(10) unsigned NOT NULL default '0',
>  `isActive` tinyint(1) unsigned NOT NULL default '1',
>  `ordinal` int(10) unsigned NOT NULL default '0',
>  `dateUpdated` datetime NOT NULL default '0000-00-00 00:00:00',
>  `dateCreated` datetime NOT NULL default '0000-00-00 00:00:00',
>  `changeDescription` longtext,
>  PRIMARY KEY  (`linkID`),
>  KEY `url` (`url`),
>  KEY `locationID` (`locationID`)
> ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='connectionString';
>
> If I run this query:
> SELECT url, sectionID, title, description, organization FROM link 
> WHERE sectionID=16 AND isActive = true AND locationID= 0
> I get three rows:
> 'http://www.highschoolace.com/ace/ace.cfm', 16, 'High School Ace', 
> 'Homework help, online learning quizzes, college prep resources, and 
> more!', ''
> 'http://school.discovery.com/students/', 16, 'Discovery's Homework 
> Help', 'Study tools, fun and games, and cool learning adventures.', 
> 'Discovery Education'
> 'http://www.multcolib.org/homework/', 16, 'Homework Center', 'Youth 
> can chat with an online tutor through this site for homework 
> assistance on a variety of topics from 2p.m. - 10p.m.
>
> ', 'Multnomah County Library'
>
>
> If I run this query:
> SELECT url, sectionID, title, description, organization FROM link 
> WHERE sectionID=16 AND isActive = true AND locationID= 0 ORDER BY Ordinal
> I get three different (but the same) rows
> 'http://www.doitnow.org/pages/180.html', 83, 'Ceasefire: What We Can 
> Do to Stop Violence in our Schools', 'Thoughts about school shootings 
> and how to stop them.', 'Do It Now Foundation'
> 'http://www.doitnow.org/pages/180.html', 83, 'Ceasefire: What We Can 
> Do to Stop Violence in our Schools', 'Thoughts about school shootings 
> and how to stop them.', 'Do It Now Foundation'
> 'http://www.doitnow.org/pages/180.html', 83, 'Ceasefire: What We Can 
> Do to Stop Violence in our Schools', 'Thoughts about school shootings 
> and how to stop them.', 'Do It Now Foundation'
>
> If I run
> SELECT * FROM (SELECT url, sectionID, title, description, 
> organization, ordinal FROM link WHERE sectionID=16 AND isActive = true 
> AND locationID= 0 ) as l ORDER BY Ordinal
> I get the correct results
>
> If I run the same query on the host server I get the desired results. 
> Permissions for the federated table login are SELECT only, restricted 
> to only certain tables.
>
> Is this a bug in the federated table engine?
>
> Thanks
> Joelle
>
>


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]