added empty result set testing

1 files changed, 20 insertions, 0 deletions

diff --git a/src/interfaces/jdbc/org/postgresql/test/jdbc2/ResultSetTest.java b/src/interfaces/jdbc/org/postgresql/test/jdbc2/ResultSetTest.java
index 2c556bfb2d0..49af9e5ce9f 100644
--- a/src/interfaces/jdbc/org/postgresql/test/jdbc2/ResultSetTest.java
+++ b/src/interfaces/jdbc/org/postgresql/test/jdbc2/ResultSetTest.java
@@ -63,4 +63,24 @@ public class ResultSetTest extends TestCase
 
 		stmt.close();
 	}
+  public void testEmptyResult()
+  {
+    try
+    {
+      Statement stmt = con.createStatement();
+      ResultSet rs = stmt.executeQuery("SELECT * FROM testrs where id=100");
+      rs.beforeFirst();
+      rs.afterLast();
+      assertTrue(!rs.first());
+      assertTrue(!rs.last());
+      assertTrue(!rs.next());
+
+
+    }
+    catch ( Exception ex )
+    {
+      fail( ex.getMessage() );
+    }
+
+  }
 }