List:General Discussion« Previous MessageNext Message »
From:Mont McAdam Date:January 15 2008 4:34am
Subject:Did NOT condition on VARCHAR change with 5.0.45?
View as plain text  
Hi there,

I am having a problem with MySQL 5.0.45 returning what I consider to be
unexpected results.

Basically I am attempting the following query, and ALL records are being
returned.

" SELECT * FROM `jos_products_orders` WHERE NOT `method`  "

I have pasted table structure, and some sample  data below.

This worked fine up until a recent system update and seems to be ignored now.

Mont

-----------------------------------------------------------------------------
------
CREATE TABLE IF NOT EXISTS `jos_products_orders` (
  `id` int(11) NOT NULL auto_increment,
  `customer` int(11) NOT NULL,
  `ordered` datetime NOT NULL,
  `paid` int(11) NOT NULL default '0',
  `released_by` int(11) NOT NULL,
  `paid_at` datetime NOT NULL,
  `method` varchar(10) NOT NULL,
  `order` text NOT NULL,
  `amount` float NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=215 ;

--
-- Dumping data for table `jos_products_orders`
--

INSERT INTO `jos_products_orders` (`id`, `customer`, `ordered`, `paid`,
`released_by`, `paid_at`, `method`, `order`, `amount`) VALUES(126, 65,
'2007-11-21 20:10:52', 1, 0, '2007-11-21 20:17:25', 'CREDIT',
'6;1;2;14.3;Aviator - Silver with Black Lens\r\n13;1;1;14.3;Fastbacks - Black
with Black Lens\r\n19;4;1;14.3;Hotshot - Leopard with Amber
Lens\n4;2;2;14.3;Ice - Gunmetal with Black lens\r\n3;3;4;14.3;Razor -
Electric Blue with Black Lens\n1;1;3;14.3;Slider - Black with Black
Lens\r\n', 185.9);
INSERT INTO `jos_products_orders` (`id`, `customer`, `ordered`, `paid`,
`released_by`, `paid_at`, `method`, `order`, `amount`) VALUES(158, 790,
'2007-12-05 16:48:18', 1, 65, '2007-12-05 16:50:32', 'CASH',
'15;1;1;14.3;Bluefins - Black with Black Lens\r\n13;4;1;14.3;Fastbacks -
Brown with Amber Lens\r\n17;2;1;14.3;Microlite - Black with Black
Lens\r\n9;3;1;14.3;Radiator - Black with Black Lens\r\n3;1;1;14.3;Razor -
Black with Black Lens\r\n1;1;1;14.3;Slider - Black with Black
Lens\r\n8;1;1;14.3;Surfer - Silver with Black Lens\r\n8;3;1;14.3;Surfer -
Black with Black Lens\r\n10;3;1;14.3;Tropics - Silver with Black
Lens\r\n7;2;1;14.3;Wayfarer Style - Brown with Brown Lens\n', 143);
INSERT INTO `jos_products_orders` (`id`, `customer`, `ordered`, `paid`,
`released_by`, `paid_at`, `method`, `order`, `amount`) VALUES(157, 217,
'2007-11-30 16:27:53', 1, 0, '2007-11-30 16:33:35', 'CREDIT',
'6;1;1;14.3;Aviator - Silver with Black Lens\r\n4;1;1;14.3;Ice - Black with
Black Lens\r\n17;4;1;14.3;Microlite - Leopard with Amber
Lens\n5;2;1;14.3;Navigator - Silver with Black Lens\r\n3;1;2;14.3;Razor -
Black with Black Lens\r\n3;2;2;14.3;Razor - Leopard with Black
lens\r\n1;1;1;14.3;Slider - Black with Black Lens\r\n1;2;1;14.3;Slider -
Bronze with Black Lens\r\n1;3;1;14.3;Slider - Amber with Amber
Lens\n8;3;1;14.3;Surfer - Black with Black Lens\r\n10;2;1;14.3;Tropics -
Gunmetal with Black Lens\r\n10;4;1;14.3;Tropics - Black with Black
Lens\r\n7;2;1;14.3;Wayfarer Style - Brown with Brown Lens\n', 214.5);
Thread
Did NOT condition on VARCHAR change with 5.0.45?Mont McAdam15 Jan
  • Re: Did NOT condition on VARCHAR change with 5.0.45?Martijn Tonies15 Jan
    • Re: Did NOT condition on VARCHAR change with 5.0.45?Moon's Father16 Jan
Re: Did NOT condition on VARCHAR change with 5.0.45?Mont McAdam23 Jan
  • RE: Did NOT condition on VARCHAR change with 5.0.45?Jerry Schwartz23 Jan
  • Re: Did NOT condition on VARCHAR change with 5.0.45?Perrin Harkins23 Jan
    • executing query from the command line -- need help Charles Brown23 Jan
      • RE: executing query from the command line -- need help Jay Blanchard23 Jan
      • RE: executing query from the command line -- need help Jay Blanchard23 Jan
RE: executing query from the command line -- need help Jay Blanchard23 Jan
  • Re: executing query from the command line -- need helpobed24 Jan
    • RE: executing query from the command line -- need helpCharles Brown24 Jan