Skip to content

Join condition gets rendered wrongly if column has an alias [DATAJDBC-353] #575

@spring-projects-issues

Description

@spring-projects-issues

Jens Schauder opened DATAJDBC-353 and commented

This test when added to SelectRendererUnitTest fails because the columns in the join condition get rendered with table-alias.column AS column-alias.
 

@Test public void shouldRenderJoinWithAliases() { Table a = SQL.table("a").as("a_alias"); Column aColumn = a.column("a_col").as("a_col_alias"); Table b = SQL.table("b").as("b_alias"); Column bColumn = b.column("a_col").as("a_col_alias"); Select select = Select.builder().select(aColumn, bColumn) //  .from(a) //  .join(b).on(aColumn).equals(bColumn) //  .build(); assertThat(SqlRenderer.toString(select)) //  .isEqualTo( "SELECT a_alias.a_col AS a_col_alias, b_alias.b_col AS b_col_alias " //  + "FROM a AS a_alias " // + "JOIN b AS b_alias ON a_alias.a_col = b_alias.b_col " //  ); }

Referenced from: pull request #246

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions