apache / apache/hop

[Bug]: depending on the source, even after converting fields to Booleans they are displayed differently in Write to log

Open
#5,958 6 comments 0 reactions 0 assignees View on GitHub
awaiting triage Hop Gui P3 Transforms
Dominant language
Java
Stars
1.5k
Forks
476
Avg merge
19h
Merged PRs (30d)
227

Description

### Apache Hop version?

2.15

### Java version?

OpenJDK 17

### Operating system

Windows

### What happened?

A boolean value is read from a JSON file via JSON input transform.
A 'true'/'false' string is read from a database.
Both fields are converted to "Boolean" via "Select values" transform in the same way.
Still the "Write to log" transform displays them differently.

Image

More details on the setup:

Image

and

Image

The metadata information of the fields that goes into "Write to log" looks like this:

Image

When setting the "Length" to 1 in the "Select values" transforms explicitly, the format is the same for both fields: "Y".

I believe that the expected behaviour is that having to set "Length" explicitly in "Select values" should NOT be necessary.

### Issue Priority

Priority: 3

### Issue Component

Component: Hop Gui, Component: Transforms

Contributor guide

Open the contributing guide

Research direction

Reproduce the pipeline described in the issue: read one boolean from JSON input and one from a database, convert both with Select values, then inspect their output in Write to log. Compare the resulting field metadata with and without Length set to 1; done means both Boolean fields display consistently without requiring that explicit setting.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
data-engineering
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.