>Description:
I am porting MySQL to Linux/Alpha. On some occasions
the CREATE TABLE statement adds ZEROFILL for int(11)
fields. If you don't know this problem, let me know
so I can try to fix it. If you know the problem please
let me know what to do (I don't want to re-invent the
wheel).
>How-To-Repeat:
CREATE TABLE article (
id int(11) NOT NULL auto_increment,
up int(11) NOT NULL default '0',
topic int(11) NOT NULL default '0',
title varchar(255) NOT NULL default '',
abstract longtext NOT NULL,
content longtext NOT NULL,
author int(11) NOT NULL default '0',
created datetime NOT NULL default '0000-00-00 00:00:00',
url varchar(255) NOT NULL default '',
calstart date default NULL,
caldays int(11) NOT NULL default '0',
icon int(11) NOT NULL default '0',
view int(11) NOT NULL default '0',
print int(11) NOT NULL default '0',
extra1 varchar(255) NOT NULL default '',
extra2 varchar(255) NOT NULL default '',
extra3 varchar(255) NOT NULL default '',
name varchar(255) NOT NULL default '',
creator int(11) NOT NULL default '0',
revisor int(11) NOT NULL default '0',
revision int(11) NOT NULL default '0',
approver int(11) NOT NULL default '0',
revised datetime NOT NULL default '0000-00-00 00:00:00',
approved datetime NOT NULL default '0000-00-00 00:00:00',
score int(11) NOT NULL default '0',
type int(11) NOT NULL default '0',
locked datetime NOT NULL default '0000-00-00 00:00:00',
locker int(11) NOT NULL default '0',
sitegroup int(11) NOT NULL default '0',
PRIMARY KEY (id),
KEY topic(topic,title(14)),
KEY article_sitegroup_idx(sitegroup),
KEY article_name_idx(name(10))
);
results in:
-- MySQL dump 8.22
--
-- Host: localhost Database: midgard
---------------------------------------------------------
-- Server version 3.23.52-log
--
-- Table structure for table 'article'
--
CREATE TABLE article (
id int(11) zerofill NOT NULL auto_increment,
up int(11) zerofill NOT NULL default '00000000000',
topic int(11) NOT NULL default '0',
title varchar(255) NOT NULL default '',
abstract longtext NOT NULL,
content longtext NOT NULL,
author int(11) NOT NULL default '0',
created datetime NOT NULL default '0000-00-00 00:00:00',
url varchar(255) NOT NULL default '',
calstart date default NULL,
caldays int(11) NOT NULL default '0',
icon int(11) NOT NULL default '0',
view int(11) NOT NULL default '0',
print int(11) NOT NULL default '0',
extra1 varchar(255) NOT NULL default '',
extra2 varchar(255) NOT NULL default '',
extra3 varchar(255) NOT NULL default '',
name varchar(255) NOT NULL default '',
creator int(11) NOT NULL default '0',
revisor int(11) NOT NULL default '0',
revision int(11) NOT NULL default '0',
approver int(11) NOT NULL default '0',
revised datetime NOT NULL default '0000-00-00 00:00:00',
approved datetime NOT NULL default '0000-00-00 00:00:00',
score int(11) NOT NULL default '0',
type int(11) NOT NULL default '0',
locked datetime NOT NULL default '0000-00-00 00:00:00',
locker int(11) NOT NULL default '0',
sitegroup int(11) NOT NULL default '0',
PRIMARY KEY (id),
KEY topic (topic,title(14)),
KEY article_sitegroup_idx (sitegroup),
KEY article_name_idx (name(10))
) TYPE=MyISAM;
>Fix:
I did not examine the problem yet. Do you know it or
do I have to investigate it myself?
>Submitter-Id: Martin Brulisauer
>Originator: [EMAIL PROTECTED]
>Organization:
Martin Brulisauer, Switzerland
>MySQL support: none
>Synopsis: CREATE TABLE adds zerofill on int(11) fields
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.52 (Source distribution)
>Environment:
System: Linux alps 2.4.19 #1 Wed Aug 28 17:24:26 MEST 2002 alpha EV5
Architecture: alpha EV5
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/alphaev5-bruli-linux/3.0.4/specs
Configured with: ./configure --prefix=/usr --exec-prefix=/usr
--host=alphaev5-bruli-linux --enable-threads=posix --enable-shared --disable-static
Thread model: posix
gcc version 3.0.4
Compilation info: CC='gcc' CFLAGS='-O3 -mcpu=ev5 -Wa,-mev5,-m21164
-fomit-frame-pointer' CXX='g++' CXXFLAGS='-O4 -mcpu=ev5 -Wa,-mev5,-m21164
-fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 2486187 Apr 24 2001 /lib/libc.so.6.1
-rw-r--r-- 1 root root 6564480 Apr 24 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 180 Apr 24 2001 /usr/lib/libc.so
Configure command: ./configure --build=alphaev5-bruli-linux-gnu
--host=alphaev5-bruli-linux-gnu --prefix=/usr --sysconfdir=/etc --localstatedir=/var
--enable-shared --disable-static --enable-thread-safe-client
--with-unix-socket-path=/var/mysql/mysql.sock --with-mysqld-user=mysql --without-debug
--with-berkeley-db --enable-shared --with-innodb CC=gcc 'CFLAGS=-O3 -mcpu=ev5
-Wa,-mev5,-m21164 -fomit-frame-pointer' 'CXXFLAGS=-O4 -mcpu=ev5 -Wa,-mev5,-m21164
-fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
build_alias=alphaev5-bruli-linux-gnu host_alias=alphaev5-bruli-linux-gnu
---------------------------------------------------------------------
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
