assertj / assertj-db

Assertions for database
https://assertj.github.io/doc/#assertj-db
Apache License 2.0
113 stars 19 forks source link

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

Open bhargavkumar-65 opened 1 year ago

bhargavkumar-65 commented 1 year ago

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">

VanRoy commented 3 days ago

Hi @bhargavkumar-65 Do you facing always to this issue ?