[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dbintegrator_public_public

Title:DB Integrator Public Conference
Notice:Database Integration - today! Kit/Doc info see note 36
Moderator:BROKE::ABUGOV
Created:Mon Sep 21 1992
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1171
Total number of notes:5187

1095.0. "No unavailable warning in a partitioned view!" by NLVMS3::VVISSER (Vincent Visser, Oracle Rdb Support, The Netherlands) Mon Sep 09 1996 10:17

    Hello,
    
    One of our customers is evaluating DBI (Distributed option). They
    couldn't find a way to detect that the result of the following query on
    a partitioned view is incomplete: SELECT COUNT(*) FROM tablename;
    
    It doesn't give a %DBI-W-HAHPV_UNAVAILABLE warning when one or more
    partitions are unavailable.
    With a select that returns one or more data records it is no problem.
    
    Is this a bug and should I create a bugreport or is this intended
    behaviour and is it documented somewhere as a restriction?
    
    Regards,
    Vincent
T.RTitleUserPersonal
Name		DateLines
1095.1Looks like a bug to me...BROKE::ABUGOVMon Sep 09 1996 18:478
    
    Hi Vincent,
    
    This is indeed a bug.  We are looking at it now.
    
    Thanks,
    
    Dan
1095.2BROKE::RAMSHAWThu Sep 12 1996 10:544
Yes, this was a bug, it has now been fixed. The next field test kit
(FT3) contains the fix. Aggregate (statistical) functions should behave
like selects in that they process whatever data can be found along with
appropriate messages about unavailable partitions.