RE: Default 1 == Default 16777216?
* 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 posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Default 1 == Default 16777216?
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 == Default 16777216? 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 Sinisa Thanks for your bug report. Sinisa Now that you have cleared out that this is not happening with MyISAM, Sinisa it will be easier for us to fix it. I have now fixed this; It will be in MySQL 3.23.47 and 4.0.1. Thanks! Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216?
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/ * [EMAIL PROTECTED] Thanks for your bug report. Now that you have cleared out that this is not happening with MyISAM, it will be easier for us to fix it. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216?
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 Sinisa Thanks for your bug report. Sinisa Now that you have cleared out that this is not happening with MyISAM, Sinisa it will be easier for us to fix it. I have now fixed this; It will be in MySQL 3.23.47 and 4.0.1. Thanks! Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216 ?
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 have the same problem. I tried using 0x1, and the default is still set to 16777216 (and values get input with that value as well). Can anyone else verify that this is the case? I'm seeing it both with MyISAM tables and InnoDB tables, so I doubt it's a table handler. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] Hi! Can you make a test case so that we can test your bug ?? If there is our binary for your OS, please try that one first. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216?
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 | +-+-+--+-+--+---+ | testint | int(11) | | | 16777216 | | +-+-+--+-+--+---+ 1 row in set (0.00 sec) Why does my default not go in as '1'. I've tried it with and without quotes. This is vexing. Is there something obvious that I'm just not doing correctly? How-To-Repeat: Hi! As there is a binary for your SPARC Solaris 2.8, please try it out and see if you get the same result. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216?
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: : :+-+-+--+-+--+---+ :| Field | Type| Null | Key | Default | Extra | :+-+-+--+-+--+---+ :| testint | int(11) | | | 16777216 | | :+-+-+--+-+--+---+ :1 row in set (0.00 sec) : : Why does my default not go in as '1'. I've tried it with and : without quotes. This is vexing. Is there something obvious that : I'm just not doing correctly? : : How-To-Repeat: : : : Hi! : : As there is a binary for your SPARC Solaris 2.8, please try it out : and see if you get the same result. 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/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216 ?
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 tried using 0x1, and the default is still set to 16777216 (and values get input with that value as well). Can anyone else verify that this is the case? I'm seeing it both with MyISAM tables and InnoDB tables, so I doubt it's a table handler. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Default 1 == Default 16777216 ?
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 ? 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 tried using 0x1, and the default is still set to 16777216 (and values get input with that value as well). Can anyone else verify that this is the case? I'm seeing it both with MyISAM tables and InnoDB tables, so I doubt it's a table handler. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Default 1 == Default 16777216?
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 | +-+-+--+-+--+---+ | testint | int(11) | | | 16777216 | | +-+-+--+-+--+---+ 1 row in set (0.00 sec) Why does my default not go in as '1'. I've tried it with and without quotes. This is vexing. Is there something obvious that I'm just not doing 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 Category: mysql Class: sw-bug Release: mysql-3.23.46 (Source distribution) Environment: System: SunOS 5.8 Generic_108528-12 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' This build was compiled with the specs used on MySQL's web site for Solaris (SunOS, actually) builds. LIBC: -rw-r--r-- 1 root bin 1763908 Nov 16 16:42 /lib/libc.a lrwxrwxrwx 1 root root 11 Nov 20 13:29 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 16 16:42 /lib/libc.so.1 -rw-r--r-- 1 root bin 1763908 Nov 16 16:42 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Nov 20 13:29 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 16 16:42 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql-3.23.46 --with-low-memory --enable-assembler --enable-assembler --with-innodb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216?
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 endism problem. Dave Philip Molter wrote: 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 | +-+-+--+-+--+---+ | testint | int(11) | | | 16777216 | | +-+-+--+-+--+---+ 1 row in set (0.00 sec) Why does my default not go in as '1'. I've tried it with and without quotes. This is vexing. Is there something obvious that I'm just not doing 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 Category: mysql Class: sw-bug Release: mysql-3.23.46 (Source distribution) Environment: System: SunOS 5.8 Generic_108528-12 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' This build was compiled with the specs used on MySQL's web site for Solaris (SunOS, actually) builds. LIBC: -rw-r--r-- 1 root bin 1763908 Nov 16 16:42 /lib/libc.a lrwxrwxrwx 1 root root 11 Nov 20 13:29 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 16 16:42 /lib/libc.so.1 -rw-r--r-- 1 root bin 1763908 Nov 16 16:42 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Nov 20 13:29 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 16 16:42 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql-3.23.46 --with-low-memory --enable-assembler --enable-assembler --with-innodb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216?
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 endism problem. You are correct, sir. It's an endian issue. Hopefully, that can get fixed in either the next release or in my build process somewhere. MySQL, database, and other spam-detection words. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Default 1 == Default 16777216 ?
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 | +-+-+--+-+--+---+ | testint | int(11) | | | 16777216 | | +-+-+--+-+--+---+ 1 row in set (0.00 sec) Why does my default not go in as '1'. I've tried it with and without quotes. This is vexing. Is there something obvious that I'm just not doing correctly? * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216 ?
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 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 | +-+-+--+-+--+---+ | testint | int(11) | | | 16777216 | | +-+-+--+-+--+---+ 1 row in set (0.00 sec) Why does my default not go in as '1'. I've tried it with and without quotes. This is vexing. Is there something obvious that I'm just not doing correctly? * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216 ?
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 an : 'endism' problem. No, the client is on the same machine as the database. MySQL, database, and help Maybe that will get me by the spam-filter. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php