Annotation of 43BSD/ingres/doc/other/v710v81diff.nr, revision 1.1.1.1

1.1       root        1: .ds HE 'Version 8.1 Changes'INGRES'Page %'
                      2: .so nmacs
                      3: Version 8.1 of INGRES is functionaly upward compatible
                      4: with version 7.10 of INGRES.
                      5: .sh 1
                      6: Monitor
                      7: .dn
                      8: Escaped characters.
                      9: .PS
                     10: The INGRES monitor used to interpret \\g as meaning "go", no matter
                     11: how it was escaped. You can now send a \\g as part of a string.
                     12: For example:
                     13: .nf
                     14: 
                     15: replace e (string ="quel statment\\\\g") where e.number = 4
                     16: 
                     17: .fi
                     18: .sh
                     19: Nested includes
                     20: .PS
                     21: A bug in the monitor which caused a "longjmp botch" if there were a
                     22: recursive include followed by a user interrupt has been fixed.
                     23: 
                     24: .sh 1
                     25: Equel
                     26: .dn
                     27: Error Messages
                     28: .PS
                     29: The EQUEL precompiler now produces error messages that the
                     30: UNIX utility "error(1)" can understand.
                     31: 
                     32: .sh
                     33: Exit Value
                     34: .PS
                     35: The EQUEL precompiler now exits with a non-zero status if it finds any
                     36: errors.
                     37: 
                     38: .sh
                     39: Param Commands
                     40: .PS
                     41: A bug in the param command which caused the last request to be
                     42: lost has been fixed.
                     43: .sh 1
                     44: Parser
                     45: .dn
                     46: Implicit Range Variables
                     47: .PS
                     48: The INGRES system now supports implicit range variables. If you issue
                     49: a query with an undefined range variable, the system will check to see
                     50: if there is a relation with the same name as the variable. If there is,
                     51: it will create a range variable over that relation with the name of the
                     52: relation.
                     53: For example:
                     54: .nf
                     55: 
                     56: retrieve ( relation.all ) where relation.relid = "attribute"
                     57: 
                     58: .fi
                     59: .sh
                     60: Qualification Clauses With And Or Nodes.
                     61: .PS
                     62: A bug which caused statements with a qualification clause of the form:
                     63: .nf
                     64: 
                     65: retrieve ( e.all ) where e.a = f.a of (e.b = f.b and e.c = f.c)
                     66: 
                     67: .fi
                     68: to core dump has been fixed.
                     69: .sh
                     70: Block Copy of Tids
                     71: .PS
                     72: You can now use the copy(QUEL) command to block copy tids out of
                     73: a relation. You can NOT use the copy command to block copy them in.
                     74: For example:
                     75: .nf
                     76: 
                     77: copy emp(tid=i4,name=c0,comma=d1,sal=c0,nl=d1) 
                     78:        into "/mnt/you/yourfile"
                     79: 
                     80: .fi
                     81: .sh
                     82: New String Manipulation Routines
                     83: .PS
                     84: There are now a number of complex string manipulation routines
                     85: that are available, see quel(QUEL) for details.
                     86: .sh
                     87: New Storage Structure
                     88: .PS
                     89: There is now a new storage structure "ordered". This structure
                     90: will guarantee the retrieval order of a relation, see ordered(QUEL)
                     91: for details.
                     92: .sh 1
                     93: Qrymod
                     94: .dn
                     95: Range Variables in Views.
                     96: .PS
                     97: A bug that caused range variables to disapear after executing a view
                     98: multiple times has been removed.
                     99: .sh
                    100: Protection.
                    101: .PS
                    102: A bug which kept some protection definitions from being inserted into
                    103: the system has been fixed.
                    104: .sh
                    105: Integrity.
                    106: .PS
                    107: A bug which caused some integrities to be incorrectly stored has been fixed.
                    108: .sh
                    109: View Updates.
                    110: .PS
                    111: A decision to disallow updates to attributes which define a view has been
                    112: reversed. That is this now works:
                    113: .nf
                    114: 
                    115: range of e is emp
                    116: range of d is dept
                    117: 
                    118: define view viewdef (name = e.emname,deptname = d.dept, deptno = d.deptno) 
                    119:        where d.deptno = e.deptno
                    120: 
                    121: range of v is viewdef
                    122: 
                    123: replace v (v.deptno = 5) where v.deptno = 4
                    124: .fi
                    125: 
                    126: .sh 1
                    127: Support
                    128: .dn
                    129: Purge.
                    130: .PS
                    131: Purge will now remove all files when running in the super user mode.
                    132: .sh
                    133: Copydb
                    134: .PS
                    135: Copydb now works on the vax.
                    136: .sh
                    137: Directory Access.
                    138: .PS
                    139: The INGRES system now uses the directory handling system supplied with 4.2.
                    140: .sh
                    141: Ingconv
                    142: .PS
                    143: There is now a program ingconv, which will convert version 7 databases
                    144: into version 8 databases.
                    145: .sh 1
                    146: General
                    147: .dn
                    148: Concurrency Control
                    149: .PS
                    150: The concurrency control driver is now a user process, rather than a
                    151: kernel device driver.
                    152: .sh
                    153: Sort Function
                    154: .PS
                    155: The program ksort which INGRES uses to sort relation has been made
                    156: part of INGRES. This should cause programs that have sort clauses
                    157: to run faster.
                    158: .sh
                    159: Syserr
                    160: .PS
                    161: When INGRES dies because of a fatal error, it uses the function "perror"
                    162: now, rather then printing the UNIX error number.

unix.superglobalmegacorp.com

This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.