|
|
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.
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.