Prepared Statement failing for SELECT COUNT(*) AS test1_count FROM default

SELECT COUNT AS test1_count FROM default

Lead to the following error

Caused by: java.sql.SQLException: Unable to decode prepared statement - cause: Unrecognizable prepared statement - cause: unable to convert to prepared statment.

Test case

@Test
public void testExecuteQuery() throws Exception
{
try (PreparedStatement preparedStatement = con.prepareStatement("INSERT INTO default (KEY, VALUE) VALUES ( ?, ?)"))
{
assertNotNull(preparedStatement);

for (int i = 0; i++< 100

{ preparedStatement.setString(1, "K"+i); preparedStatement.setInt(2,i); int inserted = preparedStatement.executeUpdate(); assertEquals(1, inserted); }

}

try( PreparedStatement preparedStatement = con.prepareStatement("SELECT COUNT AS test1_count FROM default")) <------ FAILS HERE

{ assertNotNull(preparedStatement); ResultSet rs = preparedStatement.executeQuery(); assertTrue(rs.next()); assertEquals( 100, rs.getInt(1) ); }

try ( PreparedStatement preparedStatement = con.prepareStatement( "SELECT default FROM default WHERE default >= ? order by default"))
{
assertNotNull(preparedStatement);
preparedStatement.setInt(1,50);
ResultSet rs = preparedStatement.executeQuery();
for (int i=0; i< 50;i++)

{ assertTrue(rs.next()); assertEquals(50+i, rs.getInt(1)); }

}

}

mvn test -Dtest=com.couchbase.PreparedStatementTest#testExecuteQuery