Re: Strange optimizer behavior

2007-12-20 Thread Sharon
Baron Schwartz wrote: On Dec 20, 2007 7:16 AM, Sharon <[EMAIL PROTECTED]> wrote: Baron Schwartz wrote: Hi, On Dec 20, 2007 2:15 AM, Sharon <[EMAIL PROTECTED]> wrote: Hello all, Given this table: DROP TABLE IF EXISTS `maprimary`.`tbl_locales_ip2l`; CREATE TABLE `maprimary`.`tbl_locales_ip2l`

Re: Strange optimizer behavior

2007-12-20 Thread Baron Schwartz
On Dec 20, 2007 7:16 AM, Sharon <[EMAIL PROTECTED]> wrote: > > Baron Schwartz wrote: > > Hi, > > > > On Dec 20, 2007 2:15 AM, Sharon <[EMAIL PROTECTED]> wrote: > >> Hello all, > >> Given this table: > >> DROP TABLE IF EXISTS `maprimary`.`tbl_locales_ip2l`; > >> CREATE TABLE `maprimary`.`tbl_locale

Re: Strange optimizer behavior

2007-12-20 Thread Sharon
Baron Schwartz wrote: Hi, On Dec 20, 2007 2:15 AM, Sharon <[EMAIL PROTECTED]> wrote: Hello all, Given this table: DROP TABLE IF EXISTS `maprimary`.`tbl_locales_ip2l`; CREATE TABLE `maprimary`.`tbl_locales_ip2l` ( `ipStart` int(10) unsigned zerofill NOT NULL default '00', `ipEnd`

Re: Strange optimizer behavior

2007-12-20 Thread Baron Schwartz
Hi, On Dec 20, 2007 2:15 AM, Sharon <[EMAIL PROTECTED]> wrote: > Hello all, > Given this table: > DROP TABLE IF EXISTS `maprimary`.`tbl_locales_ip2l`; > CREATE TABLE `maprimary`.`tbl_locales_ip2l` ( >`ipStart` int(10) unsigned zerofill NOT NULL default '00', >`ipEnd` int(10) unsig

Strange optimizer behavior

2007-12-20 Thread Sharon
Hello all, Given this table: DROP TABLE IF EXISTS `maprimary`.`tbl_locales_ip2l`; CREATE TABLE `maprimary`.`tbl_locales_ip2l` ( `ipStart` int(10) unsigned zerofill NOT NULL default '00', `ipEnd` int(10) unsigned zerofill NOT NULL default '00', `countryCode` varchar(2) defaul