tags 442884 pending
thanks
--- Begin Message ---
The following issue has been CLOSED
======================================================================
http://bugs.bacula.org/view.php?id=992
======================================================================
Reported By: jgoerzen
Assigned To:
======================================================================
Project: bacula
Issue ID: 992
Category: Director
Reproducibility: always
Severity: minor
Priority: normal
Status: closed
Resolution: fixed
Fixed in Version:
======================================================================
Date Submitted: 10-18-2007 12:35 EDT
Last Modified: 10-19-2007 08:01 EDT
======================================================================
Summary: Default MySQL table format contains a redundant
index
Description:
Received at http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=442884
Original submitter: Jukka Merinen <[EMAIL PROTECTED]>
In the MySQL src/cats/make_mysql_tables.in, the clause for the File table
creates these indices:
INDEX (JobId),
INDEX (JobId, PathId, FilenameId)
The first index is redundant since the last one could already be used for
this task.
-- John
======================================================================
----------------------------------------------------------------------
kern - 10-19-07 08:01
----------------------------------------------------------------------
The index referenced above does not exist in the currently released Bacula
version 2.2.5, and since the version info is not in the bug report, I'm not
sure where this comes up.
However, I did notice that it is in the SVN. Most likely it is there
because PostgreSQL will not use a multiple index for doing a single index
as MySQL will providing it is the first one. Anyway, I removed the INDEX
(JobId) from the File table in the trunk SVN (development code).
Issue History
Date Modified Username Field Change
======================================================================
10-18-07 12:35 jgoerzen New Issue
10-19-07 08:01 kern Note Added: 0002885
10-19-07 08:01 kern Status new => closed
10-19-07 08:01 kern Resolution open => fixed
======================================================================
--- End Message ---
