[GitHub] [shardingsphere] carlors opened a new issue, #21622: Can't exeute DDL statement with python module that interfaces to a PostgreSQL database

[GitBox]

carlors opened a new issue, #21622:
URL: https://github.com/apache/shardingsphere/issues/21622

   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   5.1.2
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   DDL statement was executed successfully with python module that interfaces 
to a PostgreSQL database.
   
   ### Actual behavior
   Got an error saying:
   OperationalError: ERROR:  
org.apache.shardingsphere.proxy.backend.exception.TableModifyInTransactionException
   
   ### Reason analyze (If you can)
   ShardingSphere-Proxy is not compatible with python module  that interfaces 
to a PostgreSQL database, since I executed the same DDL statement successfully 
according the ShardingSphere-Proxy.
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule 
configuration, when exception occur etc.
   First. start ShardingSphere-Proxy successfully with two data source 
configured.
   Second, use the python PostgreSQL database interfaces  connect the 
ShardingSphere-Proxy and execute the DDL statement
   
   ### Example codes for reproduce this issue (such as a github link).
   ```
   #!/usr/bin/python3
   import pgdb
   conn=pgdb.connect( host='localhost', port=3307, user='root', 
password='root', dbname='test')
   cur=conn.cursor()
   cur.execute("create table test(id serial);")
   print (cur)
   conn.commit()
   cur.close()
   conn.close()
   ```


-- 
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: 
notifications-unsubscr...@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org