Drop keys does not stop indexes being created

[barrie.archer]

>Description
Following the instructions in section 5.2.8 to create a table using LOAD
DATA INFILE but without its indexes still causes the indexes to be
created at the end of the LOAD DATA INFILE statement
>How-To-Repeat:
The following shell script demonstrates the problem. There are two directory
listings, before and after the load. In the second one BestGuess.MYI should
be unchanged at 1024 bytes but it isn't because the indexes have been
created even though myisamchk -k 0 has been executed


MYSQLDIR=/usr/local/var

cat >/tmp/bgdata <<EOF
1|1|'Fordham'|'Emma'|344|'12'|'94'|'7ka3hn5qhtDRbPkJ1uWX/A'|''|1|3|'Lexdon &
Winstree'|'N'
2|1|'Fordham'|'Enoch'|625|'22'|'318'|'Daf1Dt+XH3aq47D8gigWDw'|''|1|3|'Wakefield'|'N'
3|1|'Fordham'|'George'|500|'12'|'164'|'i1L5pD8Q8gI+CFfqkkOWzQ'|''|1|3|'Saffron Walden'|'N'
4|1|'Fordham'|'Henry'|548|'14'|'144'|'Md3MtuwgcJtjGs5rKcU8pg'|''|1|3|'Saint Ives'|'N'
5|1|'Fordham'|'Henry'|209|'3'|'43'|'EpyvpR6wK4tXDCg0dUWThA'|''|1|3|'Edmonton'|'N'
6|1|'Fordham'|'John'|116|'14'|'7'|'SE1U6ewpSZkU0wA0WRe/pg'|''|1|3|'Cambridge'|'N'
7|1|'Fordham'|'Lewis'|348|'14'|'68'|'JeHwC7Jnhx6VNFabWRCwQA'|''|1|3|'Linton'|'N'
8|1|'Fordham'|'Stephen'|268|'6'|'359'|'LS/iLpTXxrfqwlfAVoJdyQ'|''|1|3|'Hatfield&
Welwyn'|'N'
9|1|'Fordham'|'female'|416|'14'|'89'|'s91dCImO+HeyIy6rXxldGA'|''|1|3|'Newmarket'|'N'
10|2|'FOTHERGILL'|'ROBERT'|206|'25'|'289'|'UIOL6Q5/8cMoeA/k/DmlZg'|''|1|3|'EastWard'|'N'
EOF


mysql -D test <<EOF
drop table BestGuess;
EOF

mysql -D test <<EOF
create table BestGuess
  (
  RecordNumber INT UNSIGNED NOT NULL AUTO_INCREMENT,
  ChunkNumber INT UNSIGNED NOT NULL,
  Confirmed VARCHAR( 1 ),
  Surname VARCHAR( 50 ) NOT NULL,
  GivenName VARCHAR( 50 ) NOT NULL,
  AgeAtDeath VARCHAR(50),
  DistrictNumber SMALLINT UNSIGNED NOT NULL,
  District VARCHAR( 50 ) NOT NULL,
  DistrictFlag TINYINT UNSIGNED NOT NULL,
  Volume VARCHAR( 50 ) NOT NULL,
  Page VARCHAR( 50 ) NOT NULL,
  Hash CHAR(22) NOT NULL,
  RecordTypeID TINYINT NOT NULL,
  QuarterNumber SMALLINT NOT NULL,
  PRIMARY KEY (RecordNumber),
  INDEX (ChunkNumber),
  INDEX (Surname(10),GivenName(10),QuarterNumber),
  INDEX (Surname(10),GivenName(10),DistrictNumber),
  INDEX (Surname(10),QuarterNumber),
  INDEX (Surname(10),DistrictNumber),
  INDEX (GivenName(10),QuarterNumber),
  INDEX (Volume,Page,QuarterNumber),
  INDEX (DistrictNumber,QuarterNumber)  
  );
EOF

ls -l $MYSQLDIR/test/BestGuess.M*

mysqladmin flush-tables
myisamchk -k 0 -rq $MYSQLDIR/test/BestGuess

mysql -D test <<EOF
LOAD DATA INFILE '/tmp/bgdata'
IGNORE
INTO TABLE BestGuess
FIELDS TERMINATED BY '|'
ENCLOSED BY "'"
(RecordNumber, ChunkNumber,Surname,GivenName,
DistrictNumber,Volume,Page,Hash,
AgeAtDeath,RecordTypeID,QuarterNumber,
District,Confirmed)
EOF

ls -l $MYSQLDIR/test/BestGuess.M*

>Fix:
Unknown

>Submitter-Id:	barrie
>Originator:	Barrie Archer
>Organization:  
FreeBMD (http://freebmd.rootsweb.com)
>MySQL support: none
>Synopsis:	drop keys does not inhibit creation of indexes on load
>Severity:	serious
>Priority:	medium
>Category:	mysql
>Class:		sw-bug
>Release:	mysql-3.23.51 (Source distribution)
>Server: /usr/local/bin/mysqladmin  Ver 8.23 Distrib 3.23.51, for unknown-freebsdelf4.2
> on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version		3.23.51
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/tmp/mysql.sock
Uptime:			5 days 6 hours 7 min 19 sec

Threads: 2  Questions: 2215677  Slow queries: 22  Opens: 300  Flush tables: 16  Open
tables: 1 Queries per second avg: 4.880
>Environment:
	
System: FreeBSD sump.inv.thebunker.net 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Wed Feb  7
18:04:50 GMT 2001     root@stripped:/usr/src/sys/compile/SUMP  i386


Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
-r--r--r--  1 root  wheel  1169076 Nov 20  2000 /usr/lib/libc.a
lrwxrwxrwx  1 root  wheel  9 Feb  6  2001 /usr/lib/libc.so -> libc.so.4
-r--r--r--  1 root  wheel  559196 Nov 20  2000 /usr/lib/libc.so.4
Configure command: ./configure --with-innodb