apache / apache/arrow-adbc

csharp/src/Drivers/BigQuery: Make GetObjects API case insensitive for patterns

Open
#1,321 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
627
Forks
217
Avg merge
22h 22m
Merged PRs (30d)
64

Description

BigQuery driver uses `LIKE` throughout in its implementation in the `GetObjects` API for patterns: https://github.com/apache/arrow-adbc/blob/cc0c4e9c01b1feb7c175b22f7cc1b0d019751745/csharp/src/Drivers/BigQuery/BigQueryConnection.cs#L364

However, as per discussion here: https://github.com/apache/arrow-adbc/issues/1314, the search with patterns should be case insensitive and use `ILIKE` instead of `LIKE`

Contributor guide

Open the contributing guide

Research direction

Start in csharp/src/Drivers/BigQuery/BigQueryConnection.cs at the GetObjects implementation around line 364, and review the related discussion in issue 1314. Update the pattern searches so they use case-insensitive matching with ILIKE, then verify that GetObjects pattern searches behave case-insensitively.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
databases
Issue type
Bug
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
56/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.