1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
|
Sun Feb.17 22:45:03 2001 gnade
* The following cursor features have been added:
DECLARE <name> LOCAL CURSOR FOR
Declares a cursor in the local scope. This works only
on scopes, where a decalre section has been put in.
(see examples nobel.adq)
CLOSE <name> FINAL
Deallocates the handle an delete the cursor. Should
not be used for reopeanble cursors.
Thr Feb.15 20:05:00 2001 gnade
* -nodebug changed to -debugcode. By default no debug
code is generated.
* The leading blank of the query has been removed
* Complete revision of the cursor handling incl. of
reopenable cursors.
* If a string with blanks is split, the trim function
did remove the blanks from the next piece of the long
string.
Mon Feb.11 19:50:00 2001 gnade
* The result evaluation is now based upon the SQLSTATE
which has a higer granularity. SQLCODE is still supported
and may be used by the user.
Sun Feb.10 22:45:00 2001 gnade
* Bug 1002.1
NTS Fix has been removed from the code. The procedures
To_String are containing the fix for the NTS problem.
The code fragments for To_String have been contributed
by Sune Falk.
Fri Feb. 9 22:20:22 2001 gnade
* Bug 0802.1
....WHERE NAME = 'Erdmann W' ;
gets translated to
... NAME = 'Erdmann W'",
* Bug 0802.2
If the variable is named empno in the declare section and :Empno in
a sql statement one gets this error
Wed Feb. 7 19:30:25 2001 gnade
* 0702.1 Sune Falk Vers. 0.1l
package body P_Test is ....
package IO is new Ada.Text_IO.Integer_IO (Integer);
Generic packages causing big trouble!!!
* 0702.2 Sune Falk Vers. 0.1l
DECLARE CURSOR xyz FOR SELECT ...
OPEN xyz
FETCH xyz
CLOSE xyz
OPEN should create the resultset, not the declare clause.
For a first step, the open command is isgnored, but this is
no real solution. Rework of the cursor concept is expected
to take place.
Tue Feb. 5 19:40:00 2001 gnade
* 0502.1 Sune Falck Vers. 0.1l
If the -nodebugcode switch is ommited, the generated
code for the esql smaples does not compile any more.
* 0502.2 Sune Falk
A query like
"EXEC SQL SELECT NAME FROM TOWNS WHERE NAME = 'LONDON'
becomes after parsing ... NAME = ' LONDON '.
* 0502.3 Sune Falk
The problem with esql that the last text line in the input file is not
copied to the output if there is any blank lines at the end of the input
file is still existing for Windows NT.
* 0502.4 Sune Falk
".....warninig : table in declare clause ignored"
was generated even the pedatic switch was off.
Sat Feb. 4 19:09:00 2001 gnade
* esql_support has been reworked because the handling
of the statement handle was completly screwed up. Due
to this problem, the wisconsin benchmakr did not
execute after compilation.
Sun Feb. 3 17:00:00 2001 gnade
* Added AT and PORT clause in connect.
* In case of an raise exception, the line number of the
query in the original source is places in the info part
of the exception.
* Bug 0502.1
esql complains SQLWARNING even only SQLERROR is used in
a when ever clause.
Tue Jan 30 21:05:30 2001 gnade
* Long queries are broken up into small strings in order to
fool the gnat.
* Buildvers.sh is part of the makefile
Sat Jan 28 11:25:01 2001 gnade
* Fully qualified SQL types where not recognized any more
due to a change in the Is_ISO92_Type function.
* If a string is not closed and an EOF is found in string
esql loops endless.
Sun Jan 27 11:02:00 2001 gnade
* The Makefile has been changed in such a way, that
the target dist rebuild the main program with the
current Version number of the package.
* Bug 2701.1
An & at the end of a line is not copied into the
output stream. The complete MUMPS style invokation
has been deleted.
Wed Jan 24 21:10:00 2001 gnade
* Bug 2401.1 Reported by Falk Sune
If a comment is found at the end of a file and there is not
end of line (LF) in this line, esql goes into an endless loop.
The scanner has been corrected. This part of the scanner is
potential candicate the for rework because it seems to be
error prone.
* Bug 2401.2 Reported by Falk Sune
Misstypo of warning corrected.
* Bug 2401.3 Reported by Falk Sune
Under Windows NT the last line is not copied if followed
by an empty line. This problem is still open.
Tue Jan 23 18:45:00 2001 gnade
* Bug 2301.01 Reported by Falk Sune
The handling of the last line is not correct. The compilation
of test.adq failes because the blanks at the end of the file
have been removed.
* Bug 2301.01 Reported by Falk Sune
SQLWARNING missspelled.
Sun Jan 20 14:30:00 2001 gnade
* The connect syntax has been changed. Thze declare DB inserts
the connection handle and the connect simply connects to the
named data base:
procedure x (
EXEX SQL DECLARE DB01 DATABASE ; ) is
begin
EXEC SQL AT DB01 SELECT ....... ;
end;
This allows to write libraries containig procedures for
different connections.
EXEC SQL CONNECT ... BY DB01 ... ;
will generate a connect to DB01.
X( EXEC SQL INCLUDE DATABASE NAMED DB01 );
This statement will insert the data base reference into the
procedure call.
Wed Jan 17 19:30:00 2001 gnade
* Bug 1701.1
The terminaing Null hat to be removed. THis will be sone the
simple by means of the NTSFix procedure in the ESQL_Support
package. As a consequnece the type tables have been added.
Tue Jan 16 13:40:01 2001 gnade
* Bug 1601.4
The nobel.adq did not coplie because the host variables
deptno have been reused again. An exception was raised.
* BUG 1601.3
In case of an exception, the location in the code was not
shown.
* BUG 1601.2
The automtic code intend was causing a contraint error
because loop if and case where not handled correctly
* Bug 1601.1
The INCLUDE SQLCA clause was consuming following statements
till the next semicolon.
Tue Jan 16 9:45:00 2001 gnade
* The SQLCA may now be defined localy and named.
* The SQLCA is now used by esql_support
* INCLUDE SQLCA [ NAMED [BY] <identifier> ]
allows to control the name of the SCLA. But you need
the RESET SQLCA <identifer> to reset it the given value
or the default value!
Sat Jan 14 13:01:00 2001 gnade
* The ESQL translator supports now both syntax constructs:
SELECT .. INTO <host-vars> FROM ..... ;
FETCH ... INTO <host-vars> ;
* Bug 1401.1
The esql_support source is copied into the adalib directory
before is is complied.
* Connect clause lined up with the commonly used syntax plus
gnu extension.
* Include clause added. This will simply generate a
warning if pedantic mode is set.
Sun Jan 13 21:50:00 2001 gnade
* VAR clause from PRO*Ada supported. There will be no action
just a simple warning if it is used. In case of pedantic
a sytax error will be raised.
Tue Jan 9 19:34:00 2001 gnade
* Package GNADE renamed to GNU.DB.ESQL_SUPPORT
* SELECT INTO TEMP syntax added
Mon Jan 8 21:35:09 2001 gnade
* Bug 0801.2
test.adb - print_employee doe work only once.
* Bug 0801.1
gnade.adb was not copie into adalib
Sat Jan 7 10:35:09 2001 gnade
* Bug 0701.5
Exception Handling was inserted for internal functions
as well.
* Bug 0701.4
Fetch operation was not generated for a SELECT which is
not associated with a cursor operation.
* Bug 0701.3
Cursor handling was screwed up. changes all over the source.
* Bug 0701.1
The next statement after CLOSE CURSOR was processed
as query.
* Bug 0701.2
If a simple select was given, a useless comma was
generated.
Sun Jan 6 17:00:05 2001 gnade
* -limit <number> switch added, but no function behind it.
* Symboltable package tables.adb introduced
* DECLARE <name> DATABASE added and checks in
case of the AT clause included.
* Exit code handling cleaned up, which means
make will terminate with error code 1 if
an syntax error happens.
* Removed the $log$ sections in some of the files.
Fri Jan 5 16:03:28 2001 gnade
* -noniso92 in order to collect all non iso features
into this flag.
1* Source of ESQL checked into gnade cvs
Tue Jan 2 08:04:41 2001 gnade
* Version 0.1d announced.
* Indicator concept added. GNADE contains meanwhile
the Is_Null function which might be used later on.
* DO action in whenever clause added.
* SQLWARNING in whenever clause added but ignored
* Editoral changes in all modules
Mon Jan 1 18:06:18 2001 gnade
* Connection viariable is automaticaly generated as
GNADE_DB_DEFAULT. Some other package may initialize
it by means of GNADE.CONNECT.
* WHENEVER handling regarding continue reworked.
* Cursor handling is now a part of the GNADE package. Each
cursor is implemented as an OSNC statement handle. The
DECLARE CURSOR, OPEN and CLOSE operation are now
intercepted and not sent to the DBCS.
Sun Dec 31 11:26:35 2000 gnade
* debugging code option -nodebugcode added to esql
* test_db added as test for the gnade package.
* GNADE runtime package upgraded with BindCol and BindParameter
|
