row(index).column("ABC") and row().row().row().column("ABC") always referring to row 0 itself
- Dominant language
- Java
- Stars
- 130
- Forks
- 21
- PR merge metrics
- No merged PRs in 30d
Description
Hi,
I am trying to read the value at ROW index 3 and column ABC, when i execute below code, getting below error message.
Source source = new Source("jdbc:sqlserver://localhost;database=KMSupportShipping_Office;encrypt=true;trustServerCertificate=true;integratedSecurity=True","","");
String Query1 = " select * from bu_customer where id='I15910'";
Table TABLE_BU_Customer = new Table(source, "bu_customer");
assertThat(TABLE_BU_Customer)
.row(3)
.column(7)
.value().isEqualTo("700");
Error:
java.lang.AssertionError: [Value at **index 0** of Column at index 7 (column name : AMOUNT) of bu_customer table]
Expecting:
<"100000.0000">
to be equal to:
<"700">
Contributor guide
Research direction
No source file or test is named. Reproduce the issue with Table, row(3), and column(7) using the provided query, then trace how row selection is handled and verify that the assertion reports index 3 rather than index 0 when the requested row is found.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100