apache / apache/beam

No Information of failed Query in JdbcIO

Open
#20,920 0 comments 0 reactions 0 assignees View on GitHub
improvement io java jdbc P3
Dominant language
Java
Stars
8.7k
Forks
4.7k
Avg merge
2d 2h
Merged PRs (30d)
205

Description

I've created a query and send it with JdbcIO to the database. 

There was a syntax error in this query. But I got no exception or something else. JdbcIO gets an empty resultset and ignores the syntax error. 

This could be improved. To find this error cost several days. 

Imported from Jira [BEAM-12443](https://issues.apache.org/jira/browse/BEAM-12443). Original Jira may contain additional context.
Reported by: dominic.warzok.

Contributor guide

Open the contributing guide

Research direction

Start by locating JdbcIO's query execution path and reproducing the reported syntax-error case against a database. Trace why the failure becomes an empty result set; done means the database error is surfaced to the caller with useful information, with a regression test covering the behavior.

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.