>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