float to int conversion after using Data Wrangler addin

[DATA2PLAYvf]

1. What versions are you using?

Oracle Database version : 19.28.0.0.0

Python:
platform.platform: Windows-2022Server-10.0.20348-SP0
sys.maxsize > 2**32: True
platform.python_version: 3.12.10

oracledb client version : (19, 6, 0, 0, 0)
oracledb.version: 3.4.1

2. Is it an error or a hang or a crash?

error link to another component

3. What error(s) or behavior you are seeing?

I use Jupyter Notebook (inside VS code) to view data. I get oracle data via odf (connection.fetch_df_all())

When I use the plugin Data Wrangler to view data, there is an impact on the next execution of connection.fetch_df_all(). Float are converted to int !

4. Does your application call init_oracle_client()?
   yes

5. Include a runnable Python script that shows the problem.

import oracledb

conn = ...

odf = conn.fetch_df_all(statement='select 1.2 as VALUE from dual')

pdf = pyarrow.table(odf).to_pandas()

# first run : OK, result value : 1.2
# open the pandas dataframe via data wrangler plugin
# execute again the code (in the same python session) : KO, result value : 1.0

I think that a global constant/parameter used by oracledb is changed by data wrangler plugin, but I cannot see witch one.
If I use the pl.read_database() everything goes fine.

[anthony-tuininga]

What makes you think this is a bug in python-oracledb? Are you able to use thin mode to connect to your database and run the same scenario? If so, you can dump the packets that are sent/received by the client/database and send them to me via e-mail. I can see if there is something different between the two calls.

[DATA2PLAYvf]

Hello @anthony-tuininga ,
I put it into BUG section, but maybe it would be into "discussion", sorry.

I tried with the thin mode, it's the same behaviour.

I tried to get packets via DPI_DEBUG_LEVEL=16, but nothing... can you give me the good way to dump ?

import os
import oracledb
import pyarrow

# Paramètres de connexion
username = "user"
password = "password"
dsn = "host/service"

conn =  oracledb.connect(
    user=username,
    password=password,
    dsn=dsn
)

odf = conn.fetch_df_all(statement='select 1.2 as VALUE from dual')

pdf = pyarrow.table(odf).to_pandas()
print(f'{conn.thin=}')
print(f"DPI_DEBUG_LEVEL={os.getenv('DPI_DEBUG_LEVEL')}")

conn.close()

result:

conn.thin=True
DPI_DEBUG_LEVEL=16

[anthony-tuininga]

I'll change the tags for now until we have gotten to the bottom of the issue! When using thin mode, the environment variable DPI_DEBUG_LEVEL is not used. Instead, use the environment variable PYO_DEBUG_PACKETS and set it to any value. This will display all of the packet data sent to and received from the database.