|
|
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.