Using Sybase as the main transactional DB and SQLite as the in memory DB for Integration tests. Issue I am facing is conflicting behavior of the two implementations.
I need to execute a query similar to
select dbo.get_name(id), id from some_table
This runs perfectly fine in sybase (I understand the importance of schema prefix for user defined functions). However SQL lite throws error saying SQLite.Operational error near "("
Tried to add dbo as schema while creating SQLite connections but no luck.
Using Python for all the implementation.
from How to configure function in SQLite with dbo. prefix
No comments:
Post a Comment