assertj / assertj/assertj-db

row(index).column("ABC") and row().row().row().column("ABC") always referring to row 0 itself

Open
#290 1 comment 0 reactions 0 assignees View on GitHub
question
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.