RE: Default 1 == Default 16777216?

2001-12-15 Thread Roger Baklund
* Quentin Bennett For those that silently follow these more unusual threads, what was the cause? It was a bug, and it is fixed: * Monty: I have now fixed this; It will be in MySQL 3.23.47 and 4.0.1. -- Roger - Before

RE: Default 1 == Default 16777216?

2001-12-14 Thread Quentin Bennett
For those that silently follow these more unusual threads, what was the cause? Quentin -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 December 2001 8:07 a.m. To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Default 1

Re: Default 1 == Default 16777216?

2001-12-13 Thread Sinisa Milivojevic
Philip Molter writes: Yeah, let me amend this. It's not happening with MyISAM tables, only with InnoDB tables, and it is happening with the pre-compiled binaries from the web site. It's definitely an endian issue. * Philip Molter * Texas.net Internet * http://www.texas.net/ *

Re: Default 1 == Default 16777216?

2001-12-13 Thread Michael Widenius
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Philip Molter writes: Yeah, let me amend this. It's not happening with MyISAM tables, only with InnoDB tables, and it is happening with the pre-compiled binaries from the web site. It's definitely an endian issue. cut

Re: Default 1 == Default 16777216 ?

2001-12-12 Thread Sinisa Milivojevic
Philip Molter writes: On Mon, Dec 10, 2001 at 02:55:04PM -0700, Nathan wrote: : Dave Burgess had a good suggestion; I suppose you could specify the default in hex... : (default = 0x1) - as long as this is NOT in quotes it will input the hex value 1. I compiled a 3.23.46 last night and I

Re: Default 1 == Default 16777216?

2001-12-12 Thread Sinisa Milivojevic
Philip Molter writes: Description: When I do this: mysqlcreate table test_default ( testint int not null default 1 ); mysqldesc test_default; I get: +-+-+--+-+--+---+ | Field | Type| Null | Key | Default | Extra |

Re: Default 1 == Default 16777216?

2001-12-12 Thread Philip Molter
On Wed, Dec 12, 2001 at 02:35:15PM +0200, Sinisa Milivojevic wrote: : Philip Molter writes: : Description: : : When I do this: : :mysqlcreate table test_default ( testint int not null default 1 ); :mysqldesc test_default; : : I get: : :

Re: Default 1 == Default 16777216 ?

2001-12-11 Thread Philip Molter
On Mon, Dec 10, 2001 at 02:55:04PM -0700, Nathan wrote: : Dave Burgess had a good suggestion; I suppose you could specify the default in :hex... : (default = 0x1) - as long as this is NOT in quotes it will input the hex value 1. I compiled a 3.23.46 last night and I have the same problem. I

RE: Default 1 == Default 16777216 ?

2001-12-11 Thread Quentin Bennett
Hi, The output of mysqlbug might be useful, so we can see what platform etc you are on. Quentin -Original Message- From: Philip Molter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 12 December 2001 9:08 a.m. To: Nathan Cc: [EMAIL PROTECTED] Subject: Re: Default 1 == Default 16777216

Default 1 == Default 16777216?

2001-12-11 Thread Philip Molter
correctly? How-To-Repeat: See above Fix: Don't know. I'm looking for verification that the problem exists. Submitter-Id: submitter ID Originator: Philip Molter Organization: Texas.Net MySQL support: none Synopsis: Default 1 == Default 16777216 Severity: serious Priority: medium

Re: Default 1 == Default 16777216?

2001-12-11 Thread Dave Burgess
: See above Fix: Don't know. I'm looking for verification that the problem exists. Submitter-Id: submitter ID Originator: Philip Molter Organization: Texas.Net MySQL support: none Synopsis: Default 1 == Default 16777216 Severity: serious Priority: medium Category

Re: Default 1 == Default 16777216?

2001-12-11 Thread Philip Molter
On Tue, Dec 11, 2001 at 04:24:40PM -0600, Dave Burgess wrote: : Obvious stupid question: : : What happens when you specify the value as 16777216? Since you : are running on a SPARC, I'm sure you will end up with : the correct value (1) in the space. If that works, there is : definitely an

Default 1 == Default 16777216 ?

2001-12-10 Thread Philip Molter
I have a 3.23.45 database running with InnoDB tables. When I do this: create table test_default ( testint int not null default 1 ); desc test_default; I get: +-+-+--+-+--+---+ | Field | Type| Null | Key | Default | Extra |

Re: Default 1 == Default 16777216 ?

2001-12-10 Thread Dave Burgess
You wouldn't happen to be crossing an architecture boundary, would you? Say from a Macintosh client to a PC server, or a PC client to a Sun Server? 16777216 Decimal = 100 Hex which would make perfect sense if there was an 'endism' problem. Philip Molter wrote: I have a 3.23.45 database

Re: Default 1 == Default 16777216 ?

2001-12-10 Thread Philip Molter
On Mon, Dec 10, 2001 at 03:49:34PM -0600, Dave Burgess wrote: : You wouldn't happen to be crossing an architecture boundary, would you? : : Say from a Macintosh client to a PC server, or a PC client to a Sun Server? : : 16777216 Decimal = 100 Hex which would make perfect sense if there was