A DESCRIPTION OF THE REQUEST :
Currently "java.sql.Statement.executeQuery(String sql)" executes all sql including INSERT, UPDATE & DELETE queries apart from SELECT without any issues.



JUSTIFICATION :
When the api promises to return at least one ResultSet, how can it process for INSERT, UPDATE & DELETE queries which don't return any resultSet.

EXPECTED VERSUS ACTUAL BEHAVIOR :
EXPECTED -
According to me the api should process only SELECT query. For other types it should throw SQLException.
ACTUAL -
"java.sql.Statement.executeQuery(String sql)" executes all sql including INSERT, UPDATE & DELETE queries apart from SELECT without any issues.

---------- BEGIN SOURCE ----------
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
ResultSetMetaData rsmd = resultSet.getMetaData();
---------- END SOURCE ----------

CUSTOMER SUBMITTED WORKAROUND :
no workaround