db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: Simple unary operand "is [not] null" bug with VTIs
Date Tue, 17 May 2011 17:38:37 GMT
On 5/17/11 9:10 AM, drv wrote:
> select * from new com.ibm.db2j.GaianTable('LT0') T where misc is not null
Hi David,

You may want to change Gaian to use Table Functions instead of VTIs. 
Table Functions are the supported ANSI/ISO analog of VTIs. I do not see 
this error when I select from a Table Function instead of a VTI. Table 
Functions do not rely on the special backdoor which was put into Derby 
to support VTIs from the com.ibm.db2j package. I do not know if anyone 
is supporting that backdoor these days.

Regards,
-Rick

Mime
View raw message