MySQL Bugs: #21835: Data rows fetch problem from asp.net application

Bug #21835	Data rows fetch problem from asp.net application
Submitted:	25 Aug 2006 13:27	Modified:	25 Sep 2006 13:52
Reporter:	Karan Saini	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0	OS:	Windows (Windows 2003)
Assigned to:		CPU Architecture:	Any

Description:
MySql Administrator:- 1.1.9
MYSQL:- 5.0
ASP.NET 2.0 with VB.NET
DB Engine:- MYISAM

I am also getting quite the same kind of problem. It is not showing the exact number of rowcount on the asp.net application. The rowcount always differ by one row.
In the query analyser, it is showing one more record and on the webpage it is showing one less record. I'm reckon its a bug on the db connectivity side!

###############################################################
SQL Statement:-
SELECT DISTINCT title,url,abstract FROM enwiki WHERE TITLE like "BBC%"
###############################################################

This is a straight sql statement and i never expected to face problems like that.
Now for search results with one row, i'm getting problems because it shows nothing.
Also the db table is holding around 1 million rows with 4 columns of varchar type. Also i want to know how many rows can a table holds? Although no db error has occurred so far. 
Please give your suggestions.
Any help would be appreciated.

How to repeat:
I also posted a reply at the following link.

http://forums.mysql.com/read.php?34,53006,112326#msg-112326

The db table size is around 250 MB.

Screenshot of the database

Attachment: Screenshot1.JPG (image/jpeg, text), 94.55 KiB.

Screenshot of the table data in query browser.

Attachment: Screenshot2.JPG (image/jpeg, text), 74.91 KiB.

Thank you for the bug report. Looks like the same issue of bug:

http://bugs.mysql.com/bug.php?id=21818

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 5.0.25-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table tbx (col char(20));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into tbx values ('aaa'),('bbb'),('ccc'),('aaa');
Query OK, 4 rows affected (0.01 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select distinct col from tbx where col = 'aaa';
+------+
| col  |
+------+
| aaa  | 
+------+
1 row in set (0.00 sec)

mysql> select row_count();
+-------------+
| row_count() |
+-------------+
|          -1 | 
+-------------+
1 row in set (0.00 sec)

mysql>

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".