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

Conference orarep::nomahs::sql

Title:SQL notes
Moderator:NOVA::SMITHI
Created:Wed Aug 27 1986
Last Modified:Thu Jun 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:3895
Total number of notes:17726

3720.0. "SQL$$BLR_XPR + B8, 6.0-13 Alpha" by M5::LWILCOX (Buns of Cinnamon) Thu Feb 01 1996 11:59

T.RTitleUserPersonal
Name
DateLines
3720.1NOVA::SMITHIDon't understate or underestimate Rdb!Thu Feb 01 1996 12:2313
3720.2Thanks, Ian!M5::LWILCOXBuns of CinnamonThu Feb 01 1996 15:5911
3720.3NOVA::SMITHIDon't understate or underestimate Rdb!Thu Feb 01 1996 16:324
3720.4count(f.anyfield)NOVA::STONEThu Feb 01 1996 20:4111
3720.5NOVA::SMITHIDon't understate or underestimate Rdb!Thu Feb 01 1996 20:4821
3720.6M5::LWILCOXBuns of CinnamonFri Feb 02 1996 11:497
3720.7also on VAX, 6.1-1 . Fixed in Rdb 7.08292::PJACOBPatrick JACOB-pjacob@fr.oracle.comFri Apr 11 1997 12:2016
    
    Same problem on VAX Rdb 6.1-1:
    	SQL> select count(x.*) from employees x ;
    	%SQL-I-BUGCHKDMP, generating bugcheck dump file
    	FRVMSS$DKA200:[USER.PJACOB]SQLBUGCHK.DMP;
    	%SQL-F-BUGCHK, There has been a fatal error. Please submit a software
    	performance report. SQL$BLRXPR - 12
    	SQL>
    
    A better error message is displayed in Rdb V7.0:
    	SQL> select count(x.*) from employees x ;
    	%SQL-F-INVSELSTAR, * is not allowed in this context
    	SQL>
    
    Patrick
    
3720.8NOVA::SMITHIDon't understate or underestimate Rdb!Fri Apr 11 1997 13:316
"Better" is a relative.  The error reported is quite wrong.  It is the
correlation name which is not valid in this context, the * is fine.

Please submit a BUG report asking for the message to be corrected.

Ian