>Description:
CREATE TABLE creates ZEROFILL fields
even if they are not specified as such.
>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))
) TYPE=MyISAM;
mysql> describe article; >article.log
+-----------+------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------------------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| up | int(11) | | | 0 | |
| topic | int(11) | | MUL | 0 | |
| title | varchar(255) | | | | |
| abstract | longtext | | | | |
| content | longtext | | | | |
| author | int(11) | | | 0 | |
| created | datetime | | | 0000-00-00 00:00:00 | |
| url | varchar(255) | | | | |
| calstart | date | YES | | NULL | |
| caldays | int(11) | | | 0 | |
| icon | int(11) | | | 0 | |
| view | int(11) | | | 0 | |
| print | int(11) | | | 0 | |
| extra1 | varchar(255) | | | | |
| extra2 | varchar(255) | | | | |
| extra3 | varchar(255) | | | | |
| name | varchar(255) | | MUL | | |
| creator | int(11) zerofill | | | 00000000000 | |
| revisor | int(11) zerofill | | | 00000000000 | |
| revision | int(11) zerofill | | | 00000000000 |
>Fix:
Don't know.
>Submitter-Id: <submitter ID>
>Originator: [EMAIL PROTECTED]
>Organization: Martin Brulisauer
>MySQL support: none
>Synopsis: ZEROFILL
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.47 (Source distribution)
>Environment:
System: Linux alps 2.4.4 #13 Fri Dec 21 14:35:31 CET 2001 alpha EV5
Architecture: alpha
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.3/specs
Configured with: ./configure --prefix=/usr --host=alphaev5-bruli-linux
Thread model: single
gcc version 3.0.3
Compilation info: CC='gcc' CFLAGS='-O3 -DDBUG_OFF -O3 -mcpu=ev5 -Wa,-mev5,-m21164
-fomit-frame-pointer ' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jan 11 15:49 /lib/libc.so.6.1 ->
libc-2.2.4.so
-rwxr-xr-x 1 root root 1629008 Jan 11 15:52 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 6814422 Jan 11 15:43 /usr/lib/libc.a
-rw-r--r-- 1 root root 180 Jan 11 15:43 /usr/lib/libc.so
-rw-r--r-- 1 root root 1750904 Jul 26 14:34 /usr/lib/libc-client.a
lrwxrwxrwx 1 root root 19 Dec 21 10:11 /usr/lib/libc-client.so ->
libc-client.so.2000
-rwxr-xr-x 1 root root 964200 Jul 26 14:34 /usr/lib/libc-client.so.2000
Configure command: ./configure --host=alphaev5-bruli-linux-gnu --prefix=/usr
--sysconfdir=/etc --localstatedir=/var --enable-shared --enable-static
--enable-thread-safe-client --with-unix-socket-path=/var/mysql/mysql.sock
--with-mysqld-user=mysql --without-debug --with-berkeley-db
---------------------------------------------------------------------
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
