Handle SQL statements without rows returned #191

Activity

1. jsalbr commented on Apr 22, 2021

   

   jsalbr

   on Apr 22, 2021

   Last edited by jsalbr

   More actions

   Hi, I got the same issue.

   The problem is really critical because not even a use mydb works.
   The error message is

   ResourceClosedError: This result object does not return rows. It has been closed automatically.
   

   The problem was introduced by sqlalchemy 1.4.

   A workaround is:

   !pip install "sqlalchemy<1.4"
   

   But it would be great if you could make ipython-sql compatible to sqlalchemy 1.4 again.

   Steps to reproduce:

   %load_ext sql
   
   %sql create table dummy(x int)
   

   I created a reproducable example including the workaround on colab:
   https://colab.research.google.com/gist/jsalbr/d4d280f1a68521071bf623427e9a1abd/ipython-sql_issue191.ipynb

   👍React with 👍1Reacted by Vicky Kumar
2. pmfischer

   added a commit that references this issue on Sep 8, 2023

   upgrades for prettytable (catherinedevlin#191)

   bed8b36