Skip to content

Queries with comments in PostgreSQL are executed incorrectly #499

Closed
@zaleslaw

Description

@zaleslaw

SELECT users.username, posts.content FROM users JOIN posts ON users.id = posts.user_id; -- 5. Select usernames along with their posted content

returns

Multiple ResultSets were returned by the query. org.postgresql.util.PSQLException: Multiple ResultSets were returned by the query. at org.postgresql.jdbc.PgStatement.getSingleResultSet(PgStatement.java:251) at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:243) at org.jetbrains.kotlinx.dataframe.io.ReadJdbcKt.readSqlQuery(readJdbc.kt:191) at org.jetbrains.kotlinx.dataframe.io.ReadJdbcKt.readSqlQuery(readJdbc.kt:140)

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions