I am currently experiencing a strange problem that I have not seen
prior today. It appeared on an existing database without any changes
in the DB version or the system (win2000).
The problems describes as 'loss of the content of a column when
selecting from two tables'.
eg:
I have two tables activation and theaters where 'theact' refers
to 'actval'.
+--------------+ +-------------------------------------------+
activation theaters
+--------------+ +-------------------------------------------+
actid actval theid theact thenam theadr thezip
1 0 1 1 aaa aas aaaa
2 1 2 0 bbb bbsd sdf
+--------------+ 3 1 ccc dsdf sdf
+-------------------------------------------+
The problem now is that as soon I do a joint query such as:
SELECT * FROM theaters,activation WHERE theact=actval
I am spontaneously loosing the content of one of the theater columns.
+----------------------------------------------------------+
actid actval theid theact thenam theadr thezip
+----------------------------------------------------------+
2 1 1 1 aaa aaaa
1 0 2 0 bbb sdf
2 1 1 1 ccc sdf
+----------------------------------------------------------+
????
Selecting one of the tables individually works fine, but as soon
as they are merged, one of the columns completely looses its content.
I have never seen this before an I cannot imagine where the problem
comes from. It appreas as well on PHP/Apache as on the mysql shell
with raw sql statements.
The column that looses it's content is alway the same one in the same
query, but it might show up fine in a query that joins the column in
question with a third table.
I managed to get rid of one of the cases by setting the flag for the
buggy column to 'NOT NULL' and then back to 'NULL' and tought the
NULL setting could have something to do with it. But I keep spotting
the problem now and I have to triple-check all my queries again...
Has anyone seen somthing similar? I'm using 3.23.29a-gamma on win2000
any help or pointer is appreciated.
patrick./
---------------------------------------------------------------------
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
