create table EAP (eapID int auto_increment primary key,
Name varchar(60),
Addr1 varchar(50),
Addr2 varchar(50),
City varchar(30),
State varchar(2), index state_ind(state),
Foreign key (State) references State(StateShort),
Zip varchar(5),
RevisionDate Date,
FundingSource varchar(15),
CEnumber varchar(10),
CompanyContact varchar(150),
Eligibility text,
ProbationaryPeriod text,
Sessions text,
Copay text,
InsuranceInfo text,
RequiredForms text,
Instructions text
) type = innodb;
create table ForCompany (ForCompanyID int auto_increment primary key,
eapID int, index eap_ind(eapID),
Foreign key (eapID) references EAP(eapID),
Name varchar(50)
) type = innodb;
These are the tables. It's table ForCompany that loses data. It doesn't
really matter what query I run, I've tried a few different. Examples:
1. Select * from ForCompany where eapID = $number;
2. Select * from ForComany;
The result differs from time to time. I have put 10 items in table ForCompany
and every second time I run query 2 only two items show up, or four, or none
at all.
I had the database on mySQL 3.23.36 and upgraded recently to 4.0.1-alpha-nt,
but nothing changed. I've tried to drop the database and create everything
from scratch, but that didn't help either.
I couldn't find anything like this in the bug report, and I find it highly
unlikly that it is a bug. Someone else should have encountered it long ago.
Is there some kind of property I don't know about? The other 4 database are
working fine. One of them is in production and I'd like to put the rest in
production to, but I don't dare do that until I've found out why this db is
misbehaving.
Anna
________________________________________________________________
This message was sent using SkyBURST Mail Center.
http://www.skyburst.net
---------------------------------------------------------------------
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
