INSERT INTO GROUND_STATION_ANTENNA VALUES (55,'Madrid','DSN') INSERT INTO GROUND_STATION_ANTENNA VALUES (54,'Madrid','DSN') INSERT INTO GROUND_STATION_ANTENNA VALUES (34,'Canberra','DSN') INSERT INTO GROUND_STATION_ANTENNA VALUES (26,'Goldstone','DSN') INSERT INTO GROUND_STATION_ANTENNA VALUES (25,'Goldstone','DSN') INSERT INTO GROUND_STATION_ANTENNA VALUES (24,'Goldstone','DSN') INSERT INTO GROUND_STATION_ANTENNA VALUES (0,'McMurdo','GN') Populate the Ground Station Antenna table The demonstrator for the repeatability has be extricated from a much larger and complicated system, though this is sufficient to demonstate the issue.ĭROP TABLE IF EXISTS GROUND_STATION_ANTENNA įOREIGN KEY (ANTENNAID) REFERENCES GROUND_STATION_ANTENNA( ANTENNAID ), The problem does not exist using a 4.0.20a database. I have used both MySQL 5.0.18 and the current 20a release to repeat the problem. NET 1.1, on a up-to-date patched Windows XP Pro box.

NET connector (1.0.7) to a MySQL 5 database, if the WHERE clause involves a DATETIME comparison operation, the query results in a 'There is already an open DataReader associated with this Connection which must be closed first.' exception.

Sql prompt where clause warning