Skip to content

Conversation

@davidhcoe
Copy link
Contributor

When the user runs a query that does not return a record set, ie:

select * from (SELECT CAST(TRUE as BOOLEAN) as BOOLEANTYPE) as \"_\" where 0 = 1

the boolean column was being identified as a string column.

One example of this public issue:
https://www.reddit.com/r/PowerBI/comments/1kqhywe/comment/mttjia5/?context=3&share_id=Wr1PAx4F7KemsyQrCVnDK&utm_content=1&utm_medium=ios_app&utm_name=ioscss&utm_source=share&utm_term=1

@davidhcoe davidhcoe requested a review from zeroshade as a code owner May 23, 2025 13:11
@github-actions github-actions bot added this to the ADBC Libraries 19 milestone May 23, 2025
@lidavidm
Copy link
Member

Well, getting an issue reported via Reddit is a first for us.

Copy link
Member

@zeroshade zeroshade left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

well, I can't believe I forgot boolean in that handler! -_- oy. Nice catch, glad it was simple

@zeroshade zeroshade merged commit 9365ac8 into apache:main May 23, 2025
42 checks passed
@davidhcoe
Copy link
Contributor Author

well, I can't believe I forgot boolean in that handler! -_- oy. Nice catch, glad it was simple

The fix was simple. Figuring out what needed to be fixed was the hard part :).

@davidhcoe davidhcoe deleted the dev/snowflake-booleantype branch October 24, 2025 10:15
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants