Re: query on MERGE table wrongly returns nothing

[Nathan Cheng]

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.