Menu

#470 [ADO.NET]CUBRIDSchemaProvider .GetViews can't be got.

open
nobody
None
5
2013-03-23
2013-03-23
Jira Trac
No

In source file(CUBRIDSchemaProvider.cs) it use this sql to find view:
select class_name from db_class where is_system_class='NO' and [class_type='VCLASS'] and class_name LIKE 'view';
but
1.in system tale:class_name, it use '1' to means that it's type is view not use 'VCLASS', So the view can't be found out. So when select view the sql should has ['class_type=1']
2.system table has no table db_class but _db_class.
3.is_system_class's datatype is integer.

Discussion

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.