confluentinc / confluentinc/ksql
Support for the star wildcard (*) on STRUCT types not working
- Dominant language
- Java
- Stars
- 315
- Forks
- 1k
- Avg merge
- 1d 7h
- Merged PRs (30d)
- 36
Description
**Describe the bug**
Using wildcard (*) on Struct not being recognised in the query.
**To Reproduce**
Version of KSQL: 0.27.1 and above (when feature was introduced)
SQL statements ran:
I wasn't sure if it was an issue with my SQL queries but I started up a local docker image in interactive mode and ran the SQL statements used in the tests from this PR https://github.com/confluentinc/ksql/pull/9120/files#diff-859d7164544672dd0a30979e56b201e0a5704352d0a5bd4b9967018b27a739ddR61
**Expected behavior**
Expected the stream to create and the fields `a` and `b` from the struct `k1` to be returned.
**Actual behaviour**
See error message in screenshot above.
**Additional context**
Contributor guide
Research direction
Reproduce the reported SQL statements in a local Docker image, then compare the failure with the STRUCT wildcard tests linked from PR #9120. The issue is done when the stream is created and fields a and b from struct k1 are returned for the supported KSQL versions.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- docker, java, sql
- Domain
- databases, stream-processing
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100