added empty result set testing

Dave Cramer · Dave Cramer · commit fd8b1539123f · 2002-06-14T14:01:36.000Z
diff --git 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 void testAbsolute() throws Exception
 
 		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() );
+    }
+
+  }
 }
