[Bug]: Inconsistent meta type handling results into casting exceptions when using SQLite and Database join

### Apache Hop version?

2.7.0 (2023-11-17 12.19.09)

### Java version?

openjdk version "17.0.3" 2022-04-19

### Operating system

Windows

### What happened?

I execute the attached example with a database join accessing an SQLite source. When checking the preview of the join step, the lookup columns are displayed as null and an error message indicates inconsistent meta type of those fields.
[mini-example-issue-2312.zip](https://github.com/apache/hop/files/14310290/mini-example-issue-2312.zip)

I discovered this in the context of #2312 and have already come across such issue in three different cases. Anyhow I will track them separately until either separate or a common solution is found.

### Issue Priority

Priority: 2

### Issue Component

Component: Transforms