search

apecloud / myduckserver

MySQL & Postgres Analytics, Reimagined
182 stars 8 forks source link

Compatibility with various programming languages #188

Open NoyException opened 19 hours ago

NoyException commented 19 hours ago

c (using libpq-fe): ok

Java (using postgresql JDBC): 

Exception in thread "main" java.lang.RuntimeException: org.postgresql.util.PSQLException: The server's standard_conforming_strings parameter was reported as postgres. The JDBC driver expected on or off.

Php (using php-pgsql): Numbers are garbled

   ...
   Running test: CREATE TABLE test.tb1 (id int, value float, c1 char(10), primary key(id))
   Returns 0 rows
   Running test: INSERT INTO test.tb1 VALUES (1, 1.1, 'a'), (2, 2.2, 'b')
   Returns 0 rows
   Running test: SELECT * FROM test.tb1
   Expected: 1, 1.1, a, got: 0, ?���, a

Python (using psycopg2): fixed

VWagen1989 commented 19 hours ago

I will try to fix the issue faced by psycopg2 now.

VWagen1989 commented 19 hours ago

@NoyException Which version of psycopg2 did you use for the test? I ran the test with psycopg2-2.9.10 and the connection was established as expected.

NoyException commented 17 hours ago

@NoyException Which version of psycopg2 did you use for the test? I ran the test with psycopg2-2.9.10 and the connection was established as expected.

This bug was found yesterday, and now I find it fixed in the newest version. Thank you for your attention.