Quoting all database identifiers breaks queries to tables in custom schema [DATAJDBC-491]

[spring-projects-issues]

Veli-Pekka Muli opened DATAJDBC-491 and commented

This is the exception I get:

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT "EXAMPLE.USER"."ID" AS "ID", ...

...

Caused by: org.postgresql.util.PSQLException: ERROR: relation "EXAMPLE.USER" does not exist

I have configured the schema like this:

@Configuration
public class DatabaseConfiguration {
    @Bean
    public NamingStrategy namingStrategy() {
        return new NamingStrategy() {
            @Override
            public String getSchema() {
                return "example";
            }
        };
    }
}

---

Affects: 2.0 M3 (Neumann)

Referenced from: pull request #194

[spring-projects-issues]

Mark Paluch commented

Thanks for report. That is an oversight on our end. We're currently building the table name by concatenating the schema and the table name into a single string instead of representing the name as composite SqlIdentifier