[
https://issues.apache.org/jira/browse/DERBY-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15294841#comment-15294841
]
Danoja Dias commented on DERBY-3181:
------------------------------------
Hi Bryan,
I ran the test again after updating the repositary. Then no failures found.
Test result is like this.
junit-core:
[junit] Running org.apache.derbyTesting.junit.EnvTest
[junit] Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed:
0.314 sec
[junit] Running org.apache.derbyTesting.functionTests.tests.derbynet._Suite
[junit] Tests run: 339, Failures: 0, Errors: 0, Skipped: 0, Time elapsed:
565.378 sec
[junit] Running org.apache.derbyTesting.functionTests.tests.tools._Suite
[junit] Tests run: 127, Failures: 0, Errors: 0, Skipped: 0, Time elapsed:
202.549 sec
[junit] Running org.apache.derbyTesting.functionTests.tests.demo._Suite
[junit] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed:
28.831 sec
[junit] Running org.apache.derbyTesting.functionTests.tests.lang._Suite
[junit] Tests run: 3226, Failures: 0, Errors: 0, Skipped: 0, Time elapsed:
9,402.799 sec
[junit] Running org.apache.derbyTesting.functionTests.tests.jdbcapi._Suite
[junit] Tests run: 7881, Failures: 0, Errors: 0, Skipped: 0, Time elapsed:
3,496.768 sec
[junit] Running org.apache.derbyTesting.functionTests.tests.store._Suite
[junit] Tests run: 346, Failures: 0, Errors: 0, Skipped: 0, Time elapsed:
2,802.678 sec
[junit] Running org.apache.derbyTesting.functionTests.tests.engine._Suite
[junit] Tests run: 39, Failures: 0, Errors: 0, Skipped: 0, Time elapsed:
202.396 sec
[junit] Running
org.apache.derbyTesting.functionTests.tests.replicationTests.ReplicationSuite
[junit] Tests run: 23, Failures: 0, Errors: 0, Skipped: 0, Time elapsed:
1,391.063 sec
[junit] Running org.apache.derbyTesting.unitTests.junit._Suite
[junit] Tests run: 170, Failures: 0, Errors: 0, Skipped: 0, Time elapsed:
48.206 sec
[junit] Running
org.apache.derbyTesting.functionTests.tests.upgradeTests._Suite
[junit] Tests run: 6439, Failures: 0, Errors: 0, Skipped: 0, Time elapsed:
8,327.352 sec
[junit] Running org.apache.derbyTesting.functionTests.suites.EncryptionSuite
[junit] Tests run: 203, Failures: 0, Errors: 0, Skipped: 0, Time elapsed:
203.698 sec
Can we do the commits and change the status to resolved?
> isNullable on ResultSetMetaData from DatabaseMetaData.getBestRowIdentifier
> values are opposite when there is no rows in ResultSet vs. when there is a
> row.
> ----------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3181
> URL: https://issues.apache.org/jira/browse/DERBY-3181
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.4.1.3
> Reporter: Myrna van Lunteren
> Assignee: Danoja Dias
> Priority: Trivial
> Labels: derby_triage10_5_2
> Attachments: Derby-3181.diff, repro.java, testChange.diff
>
>
> With code like the following:
> DatabaseMetaData dmd = conn.getMetaData();
> ResultSet rs = dmd.getBestRowIdentifier(null,"APP","a",3,true);
> ResultSetMetaData rsmd = rs.getMetaData();
> int actualCols = rsmd.getColumnCount();
> for (int i = 0; i < actualCols; i++)
> {
> System.out.print("getColumnName: " + rsmd.getColumnName(i+1)
> + ", isNullable: ");
> System.out.println(rsmd.isNullable(i+1));
> }
> The printed values for isNullable returned are opposite of what they are when
> the getBestRowIdentifier call looks like this:
> ResultSet rs = dmd.getBestRowIdentifier(null,"APP","a",1,true);
> In the latter case, the values are:
> getColumnName: SCOPE, isNullable: 0
> getColumnName: COLUMN_NAME, isNullable: 1
> getColumnName: DATA_TYPE, isNullable: 0
> getColumnName: TYPE_NAME, isNullable: 1
> getColumnName: COLUMN_SIZE, isNullable: 0
> getColumnName: BUFFER_LENGTH, isNullable: 0
> getColumnName: DECIMAL_DIGITS, isNullable: 0
> getColumnName: PSEUDO_COLUMN, isNullable: 0
> In the first case, the values are:
> getColumnName: SCOPE, isNullable: 1
> getColumnName: COLUMN_NAME, isNullable: 0
> getColumnName: DATA_TYPE, isNullable: 1
> getColumnName: TYPE_NAME, isNullable: 1
> getColumnName: COLUMN_SIZE, isNullable: 1
> getColumnName: BUFFER_LENGTH, isNullable: 1
> getColumnName: DECIMAL_DIGITS, isNullable: 1
> getColumnName: PSEUDO_COLUMN, isNullable: 1
> The isNullable value should be stable.
> It's probably worthwhile verifying what the value *should* be in the first
> place.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
