Re: query on MERGE table wrongly returns nothing
Unbelievable. I just did this:
mysql> select min(b) from t0;
+-----------------+
| min(b) |
+-----------------+
| 1147847058 |
+-----------------+
1 row in set (0.01 sec)
mysql> select min(b) from t0;
+-----------------+
| min(b) |
+-----------------+
| 0 |
+-----------------+
1 row in set (0.00 sec)
I ran those commands within seconds of each other. My merge table just zeroed out the entire b column:
mysql> select count(*) from t0;
+----------+
| count(*) |
+----------+
| 10638632 |
+----------+
1 row in set (0.00 sec)
mysql> select b from t0 limit 10;
+------------+
| b |
+------------+
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
+------------+
10 rows in set (0.00 sec)
Note that I know that b is NEVER equal to 0.
Subject
Views
Written By
Posted
6224
May 17, 2006 12:21AM
Re: query on MERGE table wrongly returns nothing
5335
May 17, 2006 12:30AM
4601
May 17, 2006 02:11AM
4553
May 17, 2006 02:22AM
4717
August 03, 2006 01:05PM
4747
August 03, 2006 03:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.