Monday, 1 March 2021

How to configure function in SQLite with dbo. prefix

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