frbvianna opened a new issue, #3220:
URL: https://github.com/apache/arrow-adbc/issues/3220

   ### What happened?
   
   Hi, I'm seeing unexpected results when trying to retrieve object information 
with adbc.GetObjects.
   
   For instance, in the following call, the underscores and percent signs are 
always treated as wildcards:
   `cnxn.GetObjects(ctx, adbc.ObjectDepthTables, "DB%", 
"SCHEMA_WITH_UNDERSCORES", nil, nil, nil)`
   
   I expected to see that the identifiers would be treated literally. To my 
understanding, this is due to the usage of SQL 
[LIKE](https://docs.snowflake.com/en/sql-reference/functions/like#usage-notes). 
I have tried to escape these characters with `\\` (two blackslashes) before 
calling the function, but this does not seem to work.
   
   Besides, I have created the following schema to test the special characters:
   ```CREATE SCHEMA <DB-NAME>." 
SCHEMA_MiXeD_`~!@#$%^&*()-_=+[]{};:\'""."",<>?\| 元数æ�®ç¨æˆ·å¤šå—节 ";```
   
   While I'm able to create this schema, I cannot retrieve its contained tables 
at ObjectDepthTables (note that the double-quotes are de-duplicated in the 
created object):
   `cnxn.GetObjects(ctx, adbc.ObjectDepthTables, "<DB-NAME>", " 
SCHEMA_MiXeD_`~!@#$%^&*()-_=+[]{};:\'".",<>?\| 元数æ�®ç¨æˆ·å¤šå—节 ", nil, 
nil, nil)`
   
   Can the wildcards be handled literally? Can you help to understand why I 
cannot retrieve the objects contained in the schema above if I provide its name?
   
   
   ### Stack Trace
   
   _No response_
   
   ### How can we reproduce the bug?
   
   Create schemas with underscores `_`, percent signs `%`, or the following 
one, which cannot be inspected with GetObjects:
   ```CREATE SCHEMA <DB-NAME>." 
SCHEMA_MiXeD_`~!@#$%^&*()-_=+[]{};:\'""."",<>?\| 元数æ�®ç¨æˆ·å¤šå—节 ";```
   
   ### Environment/Setup
   
   github.com/apache/arrow-adbc/go/adbc v1.6.0
   macOS 15.5


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to