Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.6.1
-
None
Description
org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet#getMetadata always returns a MariaDbResultSetMetaData which is not updatable, which results in isReadOnly(int column) to always return true
JDBC state that https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/ResultSetMetaData.html#isReadOnly(int) Indicates whether the designated column is definitely not writable. Driver indicate that resultset not an updatable resultset and all its columns are readOnly.
Instead only effectively readOnly-columns should return true
PS: discussion leading to this Issue https://lists.launchpad.net/maria-discuss/msg05864.html
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
JDBC state that https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/ResultSetMetaData.html#isReadOnly(int) Indicates whether the designated column is definitely not writable. Driver indicate that resultset not an updatable resultset and all its columns are readOnly.
Instead only effectively readOnly-Columns should return true PS: discussion leading to this Issue https://lists.launchpad.net/maria-discuss/msg05864.html |
org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet#getMetadata always returns a MariaDbResultSetMetaData which is not updatable, which results in isReadOnly(int column) to always return true
JDBC state that https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/ResultSetMetaData.html#isReadOnly(int) Indicates whether the designated column is definitely not writable. Driver indicate that resultset not an updatable resultset and all its columns are readOnly. Instead only effectively readOnly-columns should return true PS: discussion leading to this Issue https://lists.launchpad.net/maria-discuss/msg05864.html |
| Summary | sReadOnly(int) always resturns true in org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet | SelectResultSet's (ResultSet)MetaData indicates all columns to be readonly |
| Summary | SelectResultSet's (ResultSet)MetaData indicates all columns to be readonly | SelectResultSet's (ResultSet)MetaData always indicates all columns to be readonly |
| Fix Version/s | 2.6.2 [ 24601 ] |
| issue.field.resolutiondate | 2020-07-22 16:26:22.0 | 2020-07-22 16:26:22.264 |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 111550 ] | MariaDB v4 [ 135181 ] |
this is due to https://jira.mariadb.org/browse/CONJ-788 introduced in last version, but writable value has been set incorrectly, based on column is updatable with an updatable resultset, not on the fact that column is read only.