ibis-project / ibis

the portable Python dataframe library
https://ibis-project.org
Apache License 2.0
5.25k stars 592 forks source link

bug: DatabaseError: ORA-00923 when attempting to fetch table schema using Ibis Oracle backend #10403

Open xuefliang opened 1 day ago

xuefliang commented 1 day ago

What happened?

Here's an English description of the issue suitable for a GitHub submission:

Title: DatabaseError: ORA-00923 when attempting to fetch table schema using Ibis Oracle backend

Description: I'm encountering an error when trying to connect to an Oracle database using the Ibis Oracle backend. The error occurs specifically when attempting to fetch the schema for a table.

Steps to reproduce:

Establish a connection to the Oracle database:

con = ibis.oracle.connect( user='user', password='password', host='88888', port=1521, service_name='**' ) List databases and tables: dbs = con.list_databases() tables = con.list_tables() Attempt to fetch a specific table: t = con.table("CONFIG_YMXX") ### What version of ibis are you using? 9.5.0 ### What backend(s) are you using, if any? Oracle ### Relevant log output ```sh DatabaseError: ORA-00923: FROM keyword not found where expected Help: https://docs.oracle.com/error-help/db/ora-00923/ ``` ### Code of Conduct - [X] I agree to follow this project's Code of Conduct
gforsyth commented 23 hours ago

Hi @xuefliang -- what version of Oracle are you trying to connect to? We currently only support Oracle >= 23 because that's when they finally added a Boolean dtype