Carsten Hammer writes:
> Hi,
> I just experienced the following bug in tables created as berkeley
> tables:
>
> on bdb tables:
> mysql> SELECT
> jobs.number,jobs.status,jobs.filename,jobs.source_file,verarbeitung.name
> FROM verarbeitung right join jobs on (verarbeitung.verarbeitung =
> jobs.verarbeitung) order by jobs.number;
>
>+--------+--------+---------------------------+----------------------------------------------+------+
>
> | number | status | filename |
> source_file | name |
>
>+--------+--------+---------------------------+----------------------------------------------+------+
>
> | 1 | 1 | NULL |
> NULL | NULL |
> | 2 | 1 | /u/lpqueues/debis/data.40 |
> /etc/hosts | NULL |
> | 3 | 1 | /u/lpqueues/debis/data.41 |
> /etc/hosts | NULL |
> | 4 | 1 | /pfad/zum/datenfile |
> DEFSYSM.SAF0006.SAF00066.JOB07513.D0000103.? | NULL |
> | 5 | 1 | /pfad/zum/ogottogott |
> DEFSYSM.SAF0006.SAF00064.JOB07514.D0000103.? | NULL |
>
>+--------+--------+---------------------------+----------------------------------------------+------+
>
> 5 rows in set (0.15 sec)
>
Hi!
I have tested your report and it works just fine. I get the same
results that correspond to the your second result set.
I did not use ISAM, but MyISAM though, as this is a table handler that
is actively maintained.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
