You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently I'm using fdb 1.6 and I still can't use BIGINT datatype using the connection.execute_immediate() method. I moved on and switched to use a cursor and call the cursor.execute() method, this way everything works fine.
Submitted by: Lele Gaifax (lelit)
Votes: 1
Is there a reason why the execute_immediate() method on the connection does not respect the connection's dialect?
Here is a simple test script:
import unittest
import fdb
class FDBTestCase(unittest.TestCase):
DB = '/tmp/fdb_test.fdb'
USER = 'lele'
PASSWORD = 'lele'
DIALECT = 3
class TestDialect(FDBTestCase):
def testDialect(self):
self.assertEqual(self.conn.monitor.db.sql_dialect, self.DIALECT)
class TestExecuteImmediate(FDBTestCase):
def testCreate(self):
self.conn.execute_immediate('recreate table t (d date)')
self.conn.commit()
class TestCursorExecute(FDBTestCase):
def testCreate(self):
cur = self.conn.cursor()
cur.execute('recreate table t (d date)')
self.conn.commit()
if __name__ == '__main__':
unittest.main()
The text was updated successfully, but these errors were encountered: