Hi,
in pervious version of Elsa there was no query on ModelType columns which exist in Bookmark and some other table and the problem is that it uses text datatype if postgres or nvarchar(max) in sql which would be NCLOB in oracle ,
in oracle NCLOB field can't be searched and also it doesn't make sense to search within a column with huge amount of data.
I don't know which sort of data is inside this column but if it is big why it is being searched and if it is not then datatype of this coulum is wrong I fixed this issue with a pull request in new table but now I am seeing this problem in Bookmark table as well
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
Hi, in pervious version of Elsa there was no query on ModelType columns which exist in Bookmark and some other table and the problem is that it uses text datatype if postgres or nvarchar(max) in sql which would be NCLOB in oracle , in oracle NCLOB field can't be searched and also it doesn't make sense to search within a column with huge amount of data. I don't know which sort of data is inside this column but if it is big why it is being searched and if it is not then datatype of this coulum is wrong I fixed this issue with a pull request in new table but now I am seeing this problem in Bookmark table as well