cancel
Showing results for 
Search instead for 
Did you mean: 

Can't filter by VIEW_TYPE = 'CALC' from SYS.VIEWS in rev. 23

Former Member
0 Kudos

Hi all!

Trying to select:

select * from views where view_type='CALC'

Getting the following error:

Could not execute 'select * from views where view_type='CALC''

SAP DBTech JDBC: [2]: general error: case(Boolean, BigInt, Boolean, NLocator)

Candidates:

Alphanum case(Boolean(&)([]), Alphanum(&)([]))

Double case(Boolean(&)([]), Double(&)([]))

Real case(Boolean(&)([]), Real(&)([]))

Decimal case(Boolean(&)([]), Decimal(&)([]))

SmallDecimal case(Boolean(&)([]), SmallDecimal(&)([]))

BigInt case(Boolean(&)([]), BigInt(&)([]))

Integer case(Boolean(&)([]), Integer(&)([]))

SmallInt case(Boolean(&)([]), SmallInt(&)([]))

TinyInt case(Boolean(&)([]), TinyInt(&)([]))

String case(Boolean(&)([]), String(&)([]))

NString case(Boolean(&)([]), NString(&)([]))

BinaryString case(Boolean(&)([]), BinaryString(&)([]))

Binary case(Boolean(&)([]), Binary(&)([]))

Locator& case(Boolean(&)([]), Locator(&)([]))

NLocator& case(Boolean(&)([]), NLocator(&)([]))

Longdate case(Boolean(&)([]), Longdate(&)([]))

Seconddate case(Boolean(&)([]), Seconddate(&)([]))

Daydate case(Boolean(&)([]), Daydate(&)([]))

Secondtime case(Boolean(&)([]), Secondtime(&)([]))

Timestamp case(Boolean(&)([]), Timestamp(&)([]))

Date case(Boolean(&)([]), Date(&)([]))

Time case(Boolean(&)([]), Time(&)([]))

The same is with select * from views where view_type like '%CALC%'

But the statement: select * from views where view_type='ROW' works, which is strange.

It happens on Hana rev.23. Can You please check, is this bug still remains in further revisions?

BR, Dmitry

Accepted Solutions (0)

Answers (1)

Answers (1)

hai_murali_here
Advisor
Advisor
0 Kudos

Hi,

The following works fine with Revision 25

SELECT TOP 1000 * FROM "SYS"."VIEWS" where VIEW_TYPE='CALC'

SELECT TOP 1000 * FROM "SYS"."VIEWS" where VIEW_TYPE='JOIN'

SELECT TOP 1000 * FROM "SYS"."VIEWS" where VIEW_TYPE='OLAP'

SELECT TOP 1000 * FROM "SYS"."VIEWS" where VIEW_TYPE='ROW'

Rgds,

Murali

Former Member
0 Kudos

Thanks, then it seems to be fixed.