| NODB | ESQLI | ECI | ECP | IFXODBC | SQLITE | PGODBC | PG8 | MYSQL |
| 11-04-2007 18-07-45 | 11-04-2007 19-30-06 | 11-04-2007 18-24-35 | 11-04-2007 18-46-34 | 11-04-2007 18-51-44 | 11-04-2007 19-04-31 | 11-04-2007 19-11-21 | 11-04-2007 20-53-30 | 11-04-2007 19-22-14 |
| 1.00-32 | 1.00-32 | 1.00-32 | 1.00-32 | 1.00-32 | 1.00-32 | 1.00-32 | 1.00-32 | 1.00-32 |
Test No | | | | | | | | | | | Description |
1 | | | | | | | | | | Test setting some basic types to null |
3 | | | | | | | | | | Simple menu test |
4 | | | | | | | | | | Simple PROMPT |
6 | | | | | | | | | | testing fgl_drawbox |
8 | | | | | | | | | | Simple ERROR statement |
9 | | | | | | | | | | Compilation and linking using GLOBALS |
10 | | | | | | | | | | Simple combination of UI commands |
11 | | | | | | | | | | Basic UI exercising |
12 | | | | | | | | | | Decimal handling |
13 | | | | | | | | | | 4GL comparison testing |
14 | | | | | | | | | | Simple foreach handling |
15 | | | | | | | | | | Prompt testing |
21 | | | | | | | | | | Pretty empty report |
22 | | | | | | | | | | Input array testing |
23 | | | | | | | | | | input without defaults |
24 | | | | | | | | | | Fairly comprehensive Input test |
25 | | | | | | | | | | Another simple report - with page header and page trailer |
26 | | | | | | | | | | More input array testing |
27 | | | | | | | | | | before field/next field in an input |
28 | | | | | | | | | | Very basic datetime arithmetic |
29 | | | | | | | | | | Testing for memory corruption (obsolete <) |
30 | | | | | | | | | | Checking field values in before clauses in Input array |
31 | | | | | | | | | | INPUT from a wordwrap field |
32 | | | | | | | | | | Another simple report test |
33 | | | | | | | | | | Next field in before row |
34 | | | | | | | | | | exit input in input array |
35 | | | | | | | | | | Check for an early arithmetic bug |
36 | | | | | | | | | | Test a foreach when an open has already been done |
37 | | | | | | | | | | |
38 | | | | | | | | | | |
39 | | | | | | | | | | |
40 | | | | | | | | | | |
41 | | | | | | | | | | |
42 | | | | | | | | | | |
47 | | | | | | | | | | |
48 | | | | | | | | | | |
49 | | | | | | | | | | |
50 | | | | | | | | | | |
51 | | | | | | | | | | |
52 | | | | | | | | | | |
53 | | | | | | | | | | |
54 | | | | | | | | | | |
56 | | | | | | | | | | |
57 | | | | | | | | | | |
58 | | | | | | | | | | |
59 | | | | | | | | | | |
60 | | | | | | | | | | |
61 | | | | | | | | | | |
62 | | | | | | | | | | |
63 | | | | | | | | | | |
64 | | | | | | | | | | Some report GROUP , header and footer checks |
65 | | | | | | | | | | |
66 | | | | | | | | | | |
67 | | | | | | | | | | |
68 | | | | | | | | | | Null string date/datetime checking |
69 | | | | | | | | | | |
70 | | | | | | | | | | |
71 | | | | | | | | | | |
72 | | | | | | | | | | Simple report checking when using ORDER BY (not ORDER EXTERNAL..) |
73 | | | | | | | | | | declare.. into.. fetch (no var) |
74 | | | | | | | | | | |
75 | | | | | | | | | | |
76 | | | | | | | | | | Basic DB exercising of Datetimes |
77 | | | | | | | | | | |
78 | | | | | | | | | | |
79 | | | | | | | | | | |
80 | | | | | | | | | | Some simple form handling |
82 | | | | | | | | | | |
84 | | | | | | | | | | |
86 | | | | | | | | | | |
90 | | | | | | | | | | |
91 | | | | | | | | | | Old makefile |
92 | | | | | | | | | | |
93 | | | | | | | | | | |
94 | | | | | | | | | | insert,declare,foreach |
95 | | | | | | | | | | UPDATE ... WHERE CURRENT OF.. |
96 | | | | | | | | | | |
97 | | | | | | | | | | |
98 | | | | | | | | | | Some basic testing of sqlerrd[2] and sqlerrd[6] (SERIAL) |
99 | | | | | | | | | | Test of Aubit4GL extension - IN and EXISTS as 4GL expression |
100 | | | | | | | | | | insert cursor (in a similar way to an order by report) |
101 | | | | | | | | | | Tests for NOTFOUND status code after select statement executed on empty temporary table. |
102 | | | | | | | | | | Test for starmasked display when displaying numerical value To field too short to show all numbers. |
103 | | | | | | | | | | Geraman characters (umlauts) test. Needs explicit LANG setting (provided by makefile). |
104 | | | | | | | | | | CONSTRUCT BY NAME without FROM clause. |
105 | | | | | | | | | | |
106 | | | | | | | | | | SELECT FIRST and SQL - END SQL block |
107 | | | | | | | | | | UNLOAD TO with SELECT statement and WHERE part |
108 | | | | | | | | | | Testing for invalid file name in UNLOAD |
109 | | | | | | | | | | Test for core dump when opening a cursor |
110 | | | | | | | | | | Test for core dump in LOAD FROM |
111 | | | | | | | | | | channel functions - 4js Aubit and Querix only |
112 | | | | | | | | | | Opening resource files from DBPATH |
113 | | | | | | | | | | Test for invalid cursor type & name detection that was causing : Warning - cursor FLUSH was previously thought to be a SELECT cursor but now turns out to be an INSERT cursor.You will need to add PRAGMA EMULATE INSERT CURSOR FOR FLUSH Note that this tes |
114 | | | | | | | | | | Test for declaring insert cursor with static (not variable) value in insert cursor declaration This was causing Aubit to print EC code (INFORMIX dialect) with missing opening left curly bracket. |
115 | | | | | | | | | | Statement re-use without closing |
202 | | | | | | | | | | Multiple input statements |
203 | | | | | | | | | | 4Jstyle dynamic array handling |
204 | | | | | | | | | | Test of the 'ord' function |
205 | | | | | | | | | | Simple test of 'showhelp' function |
206 | | | | | | | | | | Simple test of what happens when a row is not returned from a select |
207 | | | | | | | | | | This test checks the validity of date/datetime comparisons Its more for the SQL side than 4GL.. |
208 | | | | | | | | | | This program checks for the validity of the null test for integers This was known to be wrong for one platform and has been changed - This is to pick it up if it happens again.. |
209 | | | | | | | | | | This test checks that the return key moves down in a display array |
210 | | | | | | | | | | this test detects whether the prompt statement properly handles non-ascii keypresses when 'for char' is used |
211 | | | | | | | | | | this tests the field validation processing for a few datatypes |
212 | | | | | | | | | | VALIDATE check |
213 | | | | | | | | | | This test checks that a format of ####,### works correctly MID:407 |
214 | | | | | | | | | | Check last record when a row is inserted into an input array (MID408) |
215 | | | | | | | | | | This checks the field validation processing for Input Array |
216 | | | | | | | | | | Tests an empty report can be compiled - don't need to check the output... |
217 | | | | | | | | | | _variable(...) handling test - also tests shared library creation |
218 | | | | | | | | | | ONC RPC client/server test |
219 | | | | | | | | | | Test for screen flickering when RUN'ing many sequential shell statements |
220 | | | | | | | | | | This is a test of menu flattening |
221 | | | | | | | | | | This tests the scroll command |
222 | | | | | | | | | | This is a check for datatypes within a form (MID 410) |
223 | | | | | | | | | | This test exercises the 'scroll' command |
224 | | | | | | | | | | This tests that a date + integer = datetime works properly (MID 425) |
225 | | | | | | | | | | This tests the return type for some date/integer arithmetic |
226 | | | | | | | | | | This tests embedded ^L (FF) in the 4gl code |
227 | | | | | | | | | | This is a test to check some bug fixes reported by Art Kagel |
228 | | | | | | | | | | This is a short test for the associative arrays |
229 | | | | | | | | | | This test checks that the comments are removed after an input/input array |
230 | | | | | | | | | | This is a test to ensure that the message line and prompt lines are calculated correctly |
231 | | | | | | | | | | This tests the functionality of PgDn within a display array This can be modified by setting A4GL_SCROLLTOEND=Y (in which case the test will fail) |
232 | | | | | | | | | | This is a test of resetting the current window within an input statement |
233 | | | | | | | | | | This is a test to ensure the current window is set within an Input Array/Display Array |
234 | | | | | | | | | | This is a test of basic Insert Cursor/PUT functionality |
235 | | | | | | | | | | Tests input by name ... without defaults |
236 | | | | | | | | | | This is a test of the CLEAR SCREEN statement - to ensure it does a current window is screen first |
237 | | | | | | | | | | Tests variable manupulation within report |
238 | | | | | | | | | | Tests before field, after field, on key and errorlog |
239 | | | | | | | | | | Test of compiling a form into an executable (using fcompile -c) |
240 | | | | | | | | | | This is a test of the USING keyword |
241 | | | | | | | | | | This is a of some after field datatype validation |
242 | | | | | | | | | | This is a simple test for some UI elements |
244 | | | | | | | | | | This is a test to check for before/after fields in a construct MID 459 |
245 | | | | | | | | | | Tests skipping over a display only field in an input array MID 471 |
246 | | | | | | | | | | This tests the RETURN and TAB keys when pressed on the last editable field - with a noentry field after it in an input array |
247 | | | | | | | | | | Check that a prompt line is removed correctly during input |
248 | | | | | | | | | | DECIMAL assignments test |
249 | | | | | | | | | | No idea what this is testing Maybe GUI related. No run-time checking |
250 | | | | | | | | | | display a value which is too large to fit |
251 | | | | | | | | | | Aubits non-comments {! .. !} treated as comments by other 4GL compilers but not by Aubit4GL |
252 | | | | | | | | | | Tabs vs. spaces in form file. |
253 | | | | | | | | | | Tests the menu compilers and decompiler |
254 | | | | | | | | | | This tests the form compilers ability to compile a form with tabs in it |
255 | | | | | | | | | | This tests the ability to create a table with a MONEY field |
256 | | | | | | | | | | checks a select with an order by with into temp - tests whether STRIP_ORDER_BY_INTO_TEMP is required eg for use with postgres |
257 | | | | | | | | | | This is a test for MID 512 |
258 | | | | | | | | | | Tests mantis bug 516 (private bug) ecpg crashed on declare cursor for select statement - the select statement has an 'into clause' of 3 members of a structure. It works fine when the number is less than 3. |
259 | | | | | | | | | | This tests the compilers ability to recognise numbers specified with an 'E' (like 1E3 = 1000) |
260 | | | | | | | | | | Test for mantis bug 509 - input array handling with noentry fields |
261 | | | | | | | | | | This is a test for mantis ID 531 - conditional colours in a form not working |
262 | | | | | | | | | | Test relating to mantis bug 529 - after field not triggered at the last row |
263 | | | | | | | | | | Open and display form, checking screen display and spacing. |
264 | | | | | | | | | | This is a test for MID 534 - In comparing a numeric field with a char field, the comparison would fail if the char length is 6 or 8. |
265 | | | | | | | | | | This is a basic test of comparing datetimes (MID 537) |
266 | | | | | | | | | | Test for MID 511 |
267 | | | | | | | | | | test for mantis id 538 - problem with decimal conversions |
268 | | | | | | | | | | Complex INPUT ARRAY test with ON KEY. |
269 | | | | | | | | | | Tests if 'display at' correctly resets the status variable |
270 | | | | | | | | | | A quick test of the define variable like dbname:tablename.column and record like dbname:tablename.\< |
271 | | | | | | | | | | This is a test for MID 549 - assignment of an invalid value to a datetime |
272 | | | | | | | | | | This checks 'continue construct' functionality |
273 | | | | | | | | | | This checks that a fields default value (as defined in the form) is not used during a construct |
274 | | | | | | | | | | This tests that an interrupted construct statement does NOT set the variable to 1=1 |
275 | | | | | | | | | | ARRAY value assign from function call. No run-time checking |
276 | | | | | | | | | | Basic test of some error handling (for obtaining window sizes) - also end of line clearing |
277 | | | | | | | | | | Basic test of some error handling (for obtaining window sizes) - also end of line clearing |
278 | | | | | | | | | | This is a test of handling of multi occurences of the same name for a fieldname in a form |
279 | | | | | | | | | | Some date/datetime/ interval checking |
280 | | | | | | | | | | Datetime arithmetic problems mantis bug 566 (private) There are 2 problems with datetime arithmetic: 1. In doing substraction on a datetime variable which is the 1st day of a month, the result is always a null. 2. In doing addition or subtraction on a |
281 | | | | | | | | | | Test NULL in function call as a parameter |
282 | | | | | | | | | | This is a test to see if a page header is run at the correct point in time. At the time of submitting this test - the declare isn't performed until something is printed in another block and hence isn't available in the on every row. Workaround is to pr |
283 | | | | | | | | | | Form file input with 'options input no wrap' |
284 | | | | | | | | | | This tests an issue with using the insert key when data is already in the field |
285 | | | | | | | | | | NULL in the function call |
286 | | | | | | | | | | This is a test for the UNLOAD bug reported |
287 | | | | | | | | | | Another UNLOAD test |
288 | | | | | | | | | | tests show option all - mid 612 |
289 | | | | | | | | | | Quick test on using foreach on a declare which used variables |
290 | | | | | | | | | | This tests a problem with the use of datetime variables (reported by Fernando Ortiz) |
291 | | | | | | | | | | Quick test of display at with nulls |
292 | | | | | | | | | | |
296 | | | | | | | | | | This tests private bug 587 - upshift on a single character field with include not working consistantly |
297 | | | | | | | | | | Tests the implementation of the time function |
298 | | | | | | | | | | This is a sample 4gl program which connects to a db specified via a variable and selects into an array |
299 | | | | | | | | | | differences with display array - mid 613 |
300 | | | | | | | | | | A simple Hello World program |
301 | | | | | | | | | | A program with database, a globals file and globals define |
302 | | | | | | | | | | A database definition, a globals include file, modulars variables and a function. |
303 | | | | | | | | | | A database definition and modular defines |
304 | | | | | | | | | | An empty 4gl file |
305 | | | | | | | | | | Empty main and empty function |
306 | | | | | | | | | | Global includes and global defines mixed |
307 | | | | | | | | | | A global include, global define, modular and function |
308 | | | | | | | | | | Modular defines and a simple function |
309 | | | | | | | | | | Just a database statement |
310 | | | | | | | | | | With just a simple function |
311 | | | | | | | | | | Just a globals include |
312 | | | | | | | | | | Just a global define |
313 | | | | | | | | | | Just a simple main function |
314 | | | | | | | | | | Just modular variables |
315 | | | | | | | | | | Just three global includes |
316 | | | | | | | | | | Two simple modular variables with reserved name identifier |
317 | | | | | | | | | | A simple call of a function without parameters or return values |
318 | | | | | | | | | | Call with one parameter |
319 | | | | | | | | | | Call with several parameters |
320 | | | | | | | | | | Call with let and one return value |
321 | | | | | | | | | | Call with several return values |
322 | | | | | | | | | | A call with several parameters and return values |
323 | | | | | | | | | | A simple case with values on WHEN |
324 | | | | | | | | | | An empty case |
325 | | | | | | | | | | A case with expressions on WHEN |
326 | | | | | | | | | | A case with otherwise |
327 | | | | | | | | | | Database inside function |
328 | | | | | | | | | | Simple for loop |
329 | | | | | | | | | | For loop with step |
330 | | | | | | | | | | For loop with exit for |
331 | | | | | | | | | | For loop with exit for |
332 | | | | | | | | | | Foreach loop with into one var |
333 | | | | | | | | | | Foreach loop with into two var(s) |
334 | | | | | | | | | | Foreach loop with CONTINUE FOREACH |
335 | | | | | | | | | | Foreach loop with CONTINUE FOREACH |
336 | | | | | | | | | | Empty foreach loop |
337 | | | | | | | | | | Label and Goto |
338 | | | | | | | | | | Simple while |
339 | | | | | | | | | | Empty WHILE loop. No run-time error checking implemented |
340 | | | | | | | | | | WHILE loop with EXIT WHILE. No run-time error checking implemented |
341 | | | | | | | | | | WHILE loop with CONTINUE. No run-time error checking implemented |
342 | | | | | | | | | | Simple IF. No run-time checking. |
343 | | | | | | | | | | Empty IF statement. No run-time checking. |
344 | | | | | | | | | | IF...ELSE statement. No run-time checking. |
345 | | | | | | | | | | IF statement with empty ELSE. No run-time checking. |
346 | | | | | | | | | | Nested IF. No run-time checking. |
347 | | | | | | | | | | Empty MAIN block - NOT SURE WHAT IS REPORT DOING THEN.... No run-time checking. |
348 | | | | | | | | | | Report with FORMAT EVERY ROW. No run-time checking. |
349 | | | | | | | | | | All combinations of START REPORT. No run-time checking. |
350 | | | | | | | | | | REPORT with one parameter. No run-time checking. |
351 | | | | | | | | | | REPORT with 2 parameters. No run-time checking. |
352 | | | | | | | | | | DATABASE statement inside of the FUNCTION block No run-time checking |
353 | | | | | | | | | | DATABASE as global declaration and in function block No run-time checking. |
354 | | | | | | | | | | DATABASE in MAIN block. No run-time checking. |
355 | | | | | | | | | | DEFER INTERRUPT in MAIN block. No run-time checking. |
356 | | | | | | | | | | DEFER QUIT in MAIN block. No run-time checking. |
357 | | | | | | | | | | WHENEVER ERROR STOP in function, but not called from MAIN - FIXME< No run-time checking. |
358 | | | | | | | | | | WHENEVER ERROR CALL test - not called from main - FIXME No run-time checking. |
359 | | | | | | | | | | WHENEVER ERROR GOTO- not called from MAIN - FIXME No run-time checking. |
360 | | | | | | | | | | WHENEVER WARNING STOP - not called from MAIN - FIXME No run-time checking. |
361 | | | | | | | | | | WHENEVER WARNING CALL - not called from MAIN - FIXME No run-time checking. |
362 | | | | | | | | | | WHENEVER WARNING GOTO - not called from MAIN No run-time checking. |
363 | | | | | | | | | | WHENEVER ANY ERROR - not called from MAIN - FIXME No run-time checking. |
364 | | | | | | | | | | WHENEVER SQLWARNING - not called from MAIN - fixme No run-time checking. |
365 | | | | | | | | | | WHENEVER SQLERROR - not called from main. No run-time error checking. |
366 | | | | | | | | | | WHENEVER NOT FOUND - not called from MAIN - FIXME No run-time checking. |
367 | | | | | | | | | | WHENEVER ERROR CONTINUE - not called from MAIN - FIXME No run-time checking. |
368 | | | | | | | | | | simple INITIALIZE. No run-time checking. |
369 | | | | | | | | | | INITIALIZE list. No run-time checking. |
370 | | | | | | | | | | INITIALIZE record. No run-time checking. |
371 | | | | | | | | | | Simple INITIALIZE ... LIKE ... No run-time checking. |
372 | | | | | | | | | | List Initialize like with table |
373 | | | | | | | | | | List Initialize like with dot-star notation |
374 | | | | | | | | | | Simple validate |
375 | | | | | | | | | | Validate list - TEST IS INVALID (see source code) |
376 | | | | | | | | | | Validate with 'star' notation |
377 | | | | | | | | | | Validate with table qualifier - TEST IS INVALID (see source code) |
378 | | | | | | | | | | Simple locate in memory |
379 | | | | | | | | | | Simple locate in file |
380 | | | | | | | | | | List locate in memory |
381 | | | | | | | | | | List locate in file |
382 | | | | | | | | | | Simple open window dimensioned |
383 | | | | | | | | | | Open window dimensioned with attributes |
384 | | | | | | | | | | Simple open window with form |
385 | | | | | | | | | | Open window with form and attributes |
386 | | | | | | | | | | Open form |
387 | | | | | | | | | | Close window |
388 | | | | | | | | | | Close form |
389 | | | | | | | | | | Simple sleep from constant |
390 | | | | | | | | | | Sleep from variable |
391 | | | | | | | | | | Sleep from integer expression |
392 | | | | | | | | | | Current window is window |
393 | | | | | | | | | | Current window is screen |
394 | | | | | | | | | | Clear window with name |
395 | | | | | | | | | | clear screen |
396 | | | | | | | | | | Clear form! |
397 | | | | | | | | | | Clear single field |
398 | | | | | | | | | | Clear several fields |
399 | | | | | | | | | | Error single string |
400 | | | | | | | | | | Error with variable |
401 | | | | | | | | | | Error with list |
402 | | | | | | | | | | Error with all attributes |
403 | | | | | | | | | | Simple display form |
404 | | | | | | | | | | Display form with attributes |
405 | | | | | | | | | | Message with string |
406 | | | | | | | | | | Message with variable |
407 | | | | | | | | | | Message with comma separated list |
408 | | | | | | | | | | Message with attributes |
409 | | | | | | | | | | Single comment line OPTION |
410 | | | | | | | | | | Single Error line OPTION |
411 | | | | | | | | | | Form line OPTION |
412 | | | | | | | | | | MENU LINE OPTION |
413 | | | | | | | | | | MESSAGE LINE OPTION |
414 | | | | | | | | | | PROMPT LINE OPTION |
415 | | | | | | | | | | ACCEPT KEY OPTION |
416 | | | | | | | | | | DELETE KEY OPTION |
417 | | | | | | | | | | INSERT KEY OPTION |
418 | | | | | | | | | | NEXT KEY OPTION |
419 | | | | | | | | | | PREVIOUS KEY OPTION |
420 | | | | | | | | | | HELP KEY OPTION |
421 | | | | | | | | | | DISPLAY ATTRIBUTE OPTION |
422 | | | | | | | | | | INPUT ATTRIBUTE OPTION |
423 | | | | | | | | | | INPUT WRAP OPTION |
424 | | | | | | | | | | INPUT NOWRAP OPTION |
425 | | | | | | | | | | FIELD ORDER UNCONSTRAINED OPTION |
426 | | | | | | | | | | FIELD ORDER CONSTRAINED OPTION |
427 | | | | | | | | | | SQL INTERRUPT ON OPTION |
428 | | | | | | | | | | SQL INTERRUPT OFF OPTION |
429 | | | | | | | | | | Simple propmpt |
430 | | | | | | | | | | Prompt with string |
431 | | | | | | | | | | Prompt with variable |
440 | | | | | | | | | | MENU with title in a varible. No run-time checking. |
441 | | | | | | | | | | MENU with NEXT OPTION. No run-time checking. |
442 | | | | | | | | | | MENU with SHOW/HIDE OPTION. No run-time checking. |
443 | | | | | | | | | | No test files - FIXME |
444 | | | | | | | | | | FIXME - no test files |
445 | | | | | | | | | | MENU with CONTINUE. No run-time checking. |
446 | | | | | | | | | | FIXME - no test files |
447 | | | | | | | | | | MENU with COMMAND KEY. No run-time checking. |
448 | | | | | | | | | | MENU with HELP. No run-time checking. |
449 | | | | | | | | | | MENU without COMMAND descriptions. No runtime checking. |
450 | | | | | | | | | | MENU with empty COMMAND. No run-time checking. |
451 | | | | | | | | | | MENU with BEFORE MENU. No run-time checking. |
452 | | | | | | | | | | Complex MENU statement. No run-time checking. |
453 | | | | | | | | | | MENU with HIDE/SHOW ALL. No run-time checking. |
454 | | | | | | | | | | Simple DISPLAY without AT. No run-time checking. |
455 | | | | | | | | | | DISPLAY with char variable. No run-time checking. |
456 | | | | | | | | | | DISPLAY without AT - all variable types. No run-time checking. |
457 | | | | | | | | | | DISPLAY with COLUMN. No run-time checking. |
458 | | | | | | | | | | Simple DISPLAY AT with PROMPT. No run-time checking. |
459 | | | | | | | | | | DIAPLAY AT with variable and PROMPT. No run-time checking. |
460 | | | | | | | | | | DISPLAY AT coordinate based on expresion. No run-time checking. |
461 | | | | | | | | | | DISPLAY AT with all ATTRIBUTEs. No run-time checking. |
462 | | | | | | | | | | DISPLAY with CLIPPED. No run-time checking. |
463 | | | | | | | | | | DISPLAY with USING. No run-time checking. |
464 | | | | | | | | | | DISPLAY with ASCII. No run-time checking. |
465 | | | | | | | | | | Simple DISPLAY to a form field. No run-time checking. |
466 | | | | | | | | | | DISPLAY with BY NAME and one variable. No run-time checking. |
467 | | | | | | | | | | DISPLAY BY NAME with list of variables. No run-time checking. |
468 | | | | | | | | | | INPUT BY NAME with WITHOUT DEFAULTS. No run-time checking. |
469 | | | | | | | | | | DISPLAY TO on form with list. No run-time checking. |
470 | | | | | | | | | | DISPLAY TO form fields with all ATTRIBUTES. No run-tiem checking. |
471 | | | | | | | | | | DISPLAY BY NAME with all ATTRIBUTES. No run-time checking. |
472 | | | | | | | | | | Simple DISPLAY ARRAY with OPTIONS and set_count(). No run-time checking. |
473 | | | | | | | | | | DISPLAY ARRAY with all ATTRIBUTES. No run-time checking. |
474 | | | | | | | | | | DISPLAY ARRAY with ON KEY. No run-time checking. |
475 | | | | | | | | | | Complex DISPLAY ARRAY. No run-time checking. |
476 | | | | | | | | | | DEFINE LIKE - all combinations. No run-tme checking. |
477 | | | | | | | | | | DEFINE LIKE with dot-star notation. No run-time checking. |
478 | | | | | | | | | | DEFINE RECORD LIKE with qualifier - all combinations. No run-time checking. |
479 | | | | | | | | | | DEFINE - all combinations of simple data types. No run-time checking. |
480 | | | | | | | | | | DEFINE ARRAY - simple types. No run-time checking. |
481 | | | | | | | | | | DEFINE ARRAY ... OF RECORD. No run-time checking. |
482 | | | | | | | | | | DEFINE ARRAY with TEXT/BYTE LOB's. No run-time checking. |
483 | | | | | | | | | | DEFINE RECORD with one variable. No run-time checking. |
484 | | | | | | | | | | FIXME - missing test files |
485 | | | | | | | | | | DEFINE RECORD of records (nested). No run-time checking. |
486 | | | | | | | | | | SCROLL down one field in DISPLAY ARRAY. No run-time checking. |
487 | | | | | | | | | | SCROLL DOWN in DISPLAY ARRAY with fiels list. No run-time checking. |
488 | | | | | | | | | | SCROLL UP in DISPLAY ARRAY with field list |
489 | | | | | | | | | | SCROLL in DISPLAY ARRAY several lines UP/DOWN No run-time checking. |
490 | | | | | | | | | | SCROLL in DISPLAY ARRAY by variable number of lines UP/DOWN. No run-time checking. |
491 | | | | | | | | | | FIXME-missing test files. |
492 | | | | | | | | | | Simple RUN. No run-time checking. |
493 | | | | | | | | | | RUN with variable. No run-time checking. |
494 | | | | | | | | | | RUN with return variable. No run-time checking. |
495 | | | | | | | | | | RUN WITHOUT WAITING - not called from MAIN. No run-time checking. |
496 | | | | | | | | | | INPUT ARRAY with AFTER INPUT and BEFORE ROW. No run-time checking. |
497 | | | | | | | | | | Simple data types assignment and display. No error checking |
498 | | | | | | | | | | Simple INPUT BY MANE in form. No error checking - no keys.in |
499 | | | | | | | | | | Input from with list. |
500 | | | | | | | | | | INPUT BY NAME - one field. No run-time checking. |
501 | | | | | | | | | | INPUT BY NAME with list. No run-time checking. |
502 | | | | | | | | | | INPUT WITHOUT DEFAULTS ... FROM. No run-time checking. |
503 | | | | | | | | | | INPUT BY NAME WITHOUT DEFAULTS. No run-time checking. |
504 | | | | | | | | | | INPUT BY NAME WTIHOUT DEFAULTS and all ATTRIBUTES. No run-time checking. |
505 | | | | | | | | | | INPUT BY NAME with HELP number. No run-time checking. |
506 | | | | | | | | | | INPUT BY NAME with AFTER INPUT. No run-time checking. |
507 | | | | | | | | | | INPUT BY NAME ... WITHOUT DEFAULTS No run-time checking. |
508 | | | | | | | | | | INPUT BY NAME with BEFORE FIELD. No run-time checking. |
509 | | | | | | | | | | INPUT BY NAME with BEFORE FIELD. No run-time checking. |
510 | | | | | | | | | | INPUT BY NAME with BEFORE INPUT. No run-time checking. |
511 | | | | | | | | | | FIXME - nothing in MAIN block |
512 | | | | | | | | | | Complex INPUT block. No run-time checking. |
513 | | | | | | | | | | Simple CONSTRUCT. No run-time checking. |
514 | | | | | | | | | | CONDSTRUCT on one field. No run-time checking. |
515 | | | | | | | | | | CONSTRUCT on field list. No run-time checking. |
516 | | | | | | | | | | CONSTRUCT BY NAME with all attributes. No run-time checking. |
517 | | | | | | | | | | CONSTRUCT BY NAME with HELP No run-time checking. |
518 | | | | | | | | | | CONSTRUCT with dot-star notation No run-time checking. |
519 | | | | | | | | | | CONSTRUCT with BEFORE CONSTRUCT. No run-time checking. |
520 | | | | | | | | | | CONSTRUCT with AFTER CONSTRUCT. No run-time checking. |
521 | | | | | | | | | | CONSTRUCT with BEFORE FIELD. No run-time checking. |
522 | | | | | | | | | | CONSTRUCT with BEFORE FIELD list No run-time checking. |
523 | | | | | | | | | | CONSTRUCT with AFTER FIELD. No run-time checking. |
524 | | | | | | | | | | CONSTRUCT with AFTER FIELD list. No run-time checking. |
525 | | | | | | | | | | CONSTRUCT with ON KEY. No run-time checking. |
526 | | | | | | | | | | CONSTRUCT with flow control (NEXT FIELD,CONTINUE...). No run-time checking. |
527 | | | | | | | | | | FIXME-missing test files. |
528 | | | | | | | | | | Simple CREATE and DROP table. No run-time checking. |
529 | | | | | | | | | | FIXME - duplicate of test 528 |
530 | | | | | | | | | | CREATE TABLE with database.owner specified. No run-time checking. |
531 | | | | | | | | | | CREATE TABLE with all (Informix) data types. No run-time checking. |
532 | | | | | | | | | | CREATE TABLE with NOT NULL. No run-time checking. |
533 | | | | | | | | | | CREATE TEMP TABLE. No run-time checking. |
534 | | | | | | | | | | CREATE TABLE ... WITH NO LOG No run-time checking. |
535 | | | | | | | | | | CREATE TABLE with storage information. No run-time checking. |
536 | | | | | | | | | | CREATE TABLE with PRIMARY KEY clause. No run-time checking. NOTE: fails with -ifx-p. |
537 | | | | | | | | | | CREATE TABLE with 2 columns and PRIMARY KEY. No run-time checking. NOTE: fails with -ifx-p. |
538 | | | | | | | | | | CREATE TABLE with UNIQUE clause. No run-time checking. |
539 | | | | | | | | | | CREATE TABLE with 2 columns and UNIQUE/DISTINCT clause. No run-time checking. |
540 | | | | | | | | | | CREATE TABLE with FOREIGN key. No run-time checking. NOTE: fails with -ifx-p. |
541 | | | | | | | | | | CREATE TABLE with two columns and FOREIGN KEY with REFERENCES clause. No run-time checking. NOTE: fails with -ifx-p. |
542 | | | | | | | | | | CREATE TABLE with CHECK clause. No run-time checking. NOTE: fails with -ifx-p. |
543 | | | | | | | | | | CREATE TABLE with DEFAULT clause. No run-time checking. NOTE: fails with -ifx-p. |
544 | | | | | | | | | | CREATE TABLE with DISTINCT/UNIQUE clause. No run-time checking. |
545 | | | | | | | | | | CREATE/DROP DATABASE. Test is invalid - Aubit refuses to compile DROP DATABASE statement. |
546 | | | | | | | | | | DROP DATABASE - test is invalid - see test #545 |
547 | | | | | | | | | | CREATE/DROP DATABASE with Informix On-Line specific sintax. Test is invalid - see test #545. |
548 | | | | | | | | | | CREATE/DROP DATABASE with Informix SE specific syntax. Test is invalid - see test #545. |
549 | | | | | | | | | | DATABSE statement with complex names. No run-time checking. |
550 | | | | | | | | | | Open DATABASE with EXCLUSIVE clause. No run-time checking. |
551 | | | | | | | | | | Simple ALTER TABLE. No run-time checking. |
552 | | | | | | | | | | ALTER TABLE with ADD clause. No run-time ckecking. |
553 | | | | | | | | | | ALTER TABLE with DROP clause. No run-time checking. |
554 | | | | | | | | | | ALTER TABLE with ADD CONSTRAINT clause. No run-time checking. NOTE: fails to compile with -ifx-p. |
555 | | | | | | | | | | ALTER TABLE with DROP CONSTRAINT clause. No run-time ckecking. NOTE: fails to compile with -ifx-p. |
556 | | | | | | | | | | ALTER TABLE with NEXT SIZE clause. No run-time checking. |
557 | | | | | | | | | | ALTER TABLE with LOCK MODE clause. No run-time checking. |
558 | | | | | | | | | | ALTER TABLE ... ADD with all (Informix) types. No run-time checking. NOTE: fails to compile with -ifx-p. |
559 | | | | | | | | | | ALTER TABLE ADD with BEFORE clause. No run-time checking. |
560 | | | | | | | | | | ALTER TABLE with MODIFY (all Informix types). No run-time checking. NOTE: fails to compile with -ifx-p. |
561 | | | | | | | | | | ALTER TABLE ... MODIFY with column CONSTRAINT clause. No run-time checking. NOTE: fails to compile with -ifx-p. |
562 | | | | | | | | | | ALTER TABLE ... ADD with column CONSTRAINT clause. No run-time checking. NOTE: fails to compile with -ifx-p. |
563 | | | | | | | | | | Simple CREATE INDEX. No run-time checking. |
564 | | | | | | | | | | CREATE INDEX on several columns. No run-time checking. |
565 | | | | | | | | | | CREATE UNIQUE INDEX. No run-time checking. |
566 | | | | | | | | | | CREATE CLUSTER INDEX. No run-time checking. |
567 | | | | | | | | | | CREATE INDEX with ASC clause. No run-time checking. |
568 | | | | | | | | | | CREATE INDEX with DESC clause. No run-time checking. |
569 | | | | | | | | | | Complex CREATE INDEX. No run-time checking. NOTE: fails to compile with -ifx-p. |
570 | | | | | | | | | | CREATE SYNONYM statement. No run-time checking. |
571 | | | | | | | | | | CREATE PUBLIC SYNONYM database statement. No run-time checking. NOTE: fails to compile with -ifx-p. |
572 | | | | | | | | | | CREATE PRIVATE SYNONYM database statement. No run-time checking. NOTE: fails to compile with -ifx-p. |
573 | | | | | | | | | | CREATE SYNONYM with full name. |
574 | | | | | | | | | | DROP INDEX database statement. No run-time checking. |
575 | | | | | | | | | | DROP INDEX with full name. |
576 | | | | | | | | | | DROP SYNONYM database statement. No run-time checking. |
577 | | | | | | | | | | DROP SYNONYM with full name. |
578 | | | | | | | | | | DROP TABLE database statement. No run-time checking. |
579 | | | | | | | | | | DROP TABLE with full names. |
580 | | | | | | | | | | DROP INDEX database statement. No run-time checking. |
581 | | | | | | | | | | DROP INDEX with full name. |
582 | | | | | | | | | | PREPARE database statement from variable. No run-time checking. |
583 | | | | | | | | | | PREPARE database statement from string. No run-time checking. |
584 | | | | | | | | | | EXECUTE prepared database statement. No run-time checking. |
585 | | | | | | | | | | EXECUTE with USING clause. No run-time checking. |
586 | | | | | | | | | | EXECUTE INTO with USING clause. No run-time checking. NOTE: compiles, but Aubit library code missing. |
587 | | | | | | | | | | FREE prepared and executed statement. No run-time checking. |
588 | | | | | | | | | | FREE a cursor. No run-time checking. |
589 | | | | | | | | | | FREE defined LOB (TEXT/BYTE). No run-time checking.. |
590 | | | | | | | | | | SET EXPLAIN ON database statement. No run-time checking. Note that this test may fail because of Informix configuration issues. For example, if your oninit permissions look like this: -rwSr-sr-- 1 informix informix 8497828 Mar 3 2002 /opt/informix/bin/ |
591 | | | | | | | | | | SET EXPLAIN OFF database statement. No run-time checking. |
592 | | | | | | | | | | CREATE VIEW database statement. No run-time checking. |
593 | | | | | | | | | | CREATE VIEW with full names. |
594 | | | | | | | | | | Simple UPDATE STATISTICS. No run-time checking. |
595 | | | | | | | | | | LOCK TABLE with SHARED MODE. No run-time checking. |
596 | | | | | | | | | | LOCK TABLE with EXCLUSIVE MODE. No run-time checking. |
597 | | | | | | | | | | LOCK TABLE with full names. |
598 | | | | | | | | | | UNLOCK TABLE database statement. No run-time checking. |
599 | | | | | | | | | | UNLOCK TABLE with full names. |
600 | | | | | | | | | | DROP TRIGGER database statement. Does not compile even with -ifx-p so probably invalid. |
602 | | | | | | | | | | DROP VIEW database statement. No run-time checking. |
603 | | | | | | | | | | DROP VIEW with full names. |
605 | | | | | | | | | | RENAME TABLE database statement. No run-time checking. |
606 | | | | | | | | | | RENAME COLUMN database statement. No run-time checking. |
607 | | | | | | | | | | RENAME COLUMN with full names. |
609 | | | | | | | | | | CREATE VIEW ... AS SELECT database statement. No run-time checking. |
610 | | | | | | | | | | CREATE VIEW ... AS SELECT with named columns. No run-time checking. |
611 | | | | | | | | | | CREATE VIEW with CHECK OPTION. No run-time checking. |
612 | | | | | | | | | | Complex CREATE VIEW database statement. No run-time checking. |
613 | | | | | | | | | | Simple INSERT. No run-time checking. |
614 | | | | | | | | | | INSERT without naming columns. No run-time checking. |
615 | | | | | | | | | | INSERT INTO ... SELECT FROM database statement. No run-time checking. |
616 | | | | | | | | | | INSERT from procedure (Informix specific) No run-time checking. SEE NOTE IN THE CODE. |
618 | | | | | | | | | | Simple DELETE database statement. No run-time checking. |
619 | | | | | | | | | | DELETE with WHERE clause. No run-time checking. |
620 | | | | | | | | | | DELETE with WHERE CURRENT OF clause. No run-time checking. |
621 | | | | | | | | | | DELETE with sub-query No run-time checking. |
622 | | | | | | | | | | DELETE with EXISTS sub-query. No run-time checking. |
623 | | | | | | | | | | DELETE ... WHERE ALL/SOME/ANY. No run-time checking. |
624 | | | | | | | | | | DELETE with IS NOT NULL. No run-time checking. |
625 | | | | | | | | | | Complex DELETE database statement. No run-time checking. |
626 | | | | | | | | | | LOAD FROM ... INSERT INTO statement. No run-time checking. |
627 | | | | | | | | | | LOAD FROM ... INSERT INTO with file name in variable. No run-time checking. |
628 | | | | | | | | | | LOAD FROM with DELIMITER clause. No run-time checking. |
629 | | | | | | | | | | LOAD FROM with INSERT statement in variable. No run-time checking. |
630 | | | | | | | | | | LOAD FROM ... INSERT INTO with one column. No run-time checking. |
631 | | | | | | | | | | LOAD FROM ... INSERT INTO with several columns. No run-time checking. |
632 | | | | | | | | | | Simple UNLOAD TO statement. No run-time checking. |
633 | | | | | | | | | | UNLOAD TO with file name in variable. No run-time checking. |
634 | | | | | | | | | | UNLOAD with specified DELIMITER. No run-time checking. |
635 | | | | | | | | | | UNLOAD TO with query string in variable. No run-time checking. |
636 | | | | | | | | | | Complex UNLOAD statement. No run-time checking. |
637 | | | | | | | | | | Simple UPDATE database statement. No run-time checking. |
638 | | | | | | | | | | SET LOCK MODE TO WAIT directive. No run-time checking. |
639 | | | | | | | | | | SET LOCK MODE TO WAIT with seconds specified. No run-time checking. |
640 | | | | | | | | | | SET LOCK MODE TO NOT WAIT directive. No run-time checking. |
642 | | | | | | | | | | SET ISOLATION TO DIRTY READ directive. No run-time checking. NOTE: requires transaction support. |
643 | | | | | | | | | | SET ISOLATION TO CURSOR STABILITY directive. No run-time checking. |
644 | | | | | | | | | | SET ISOLATION TO REPEATABLE READ directive. No run-time checking. |
645 | | | | | | | | | | GRANT TO ... PUBLIC database statement. No run-time checking. |
646 | | | | | | | | | | GRANT ... TO user database statement. No run-time checking. |
647 | | | | | | | | | | GRANT table privileges with TO PUBLIC clause. No run-time checking. |
648 | | | | | | | | | | GRANT on table to user list. No run-time checking. |
649 | | | | | | | | | | GRANT INSERT on table to user. No run-time checking. |
650 | | | | | | | | | | GRANT DELETE on table to user list. No run-time checking. |
651 | | | | | | | | | | GRANT UPDATE on table to user list. No run-time checking. |
652 | | | | | | | | | | GRANT INDEX on table to user list. No run-time checking. |
653 | | | | | | | | | | GRANT ALTER on table to user list. No run-time checking. |
654 | | | | | | | | | | GRANT on table will full name. |
655 | | | | | | | | | | Complex GRANT on table. No run-time checking. |
656 | | | | | | | | | | REVOKE ... FROM PUBLIC database statement. No run-time checking. |
657 | | | | | | | | | | REVOKE ... from user list. No run-time checking. |
658 | | | | | | | | | | REVOKE on table from PUBLIC database statement. No run-time checking. |
659 | | | | | | | | | | REVOKE on table from user list. No run-time checking. |
660 | | | | | | | | | | REVOKE INSERT on table. No run-time checking. |
661 | | | | | | | | | | REVOKE DELETE on table. No run-time checking. |
662 | | | | | | | | | | REVOKE SELECT on table. No run-time checking. |
663 | | | | | | | | | | REVOKE UPDATE on table. No run-time checking. |
664 | | | | | | | | | | REVOKE INDEX on table. No run-time checking. |
665 | | | | | | | | | | REVOKE ALTER on table. No run-time checking. |
666 | | | | | | | | | | GRANT SELECT in all variants. No run-time checking. |
667 | | | | | | | | | | GRANT on table with GRANT OPTION. No run-time checking. |
668 | | | | | | | | | | GRANT on table AS GRANTOR No run-time checking. |
669 | | | | | | | | | | REVOKE on table with full names. |
670 | | | | | | | | | | INSERT with all (Informix) data types. No run-time checking. Need minimum version 7.31 of Ifx to work with -ifx-p |
671 | | | | | | | | | | UPDATE with all (Informix) database data types. No run-time checking. TEST IS INVALID (<) |
672 | | | | | | | | | | DELETE with all (Informix) data types. No run-time checking. TEST IS INVALID (<) |
673 | | | | | | | | | | SELECT with (Informix) data types. No run-time checking. TEST IS INVALID (<) |
674 | | | | | | | | | | MIssing test files |
675 | | | | | | | | | | UPDATE SYNONYM No run-time checking. |
676 | | | | | | | | | | UPDATE on VIEW No run-time checking. |
677 | | | | | | | | | | UPDATE on multi-table VIEW. No run-time checking. |
678 | | | | | | | | | | UPDATE with Informic-style SET syntax (column=value) No run-time checking. |
679 | | | | | | | | | | UPDATE with Informix-style SET syntax (multiple columns/values) No run-time checking. |
680 | | | | | | | | | | UPDATE with dot-star notation (Informix syntax) No run-time checking. |
681 | | | | | | | | | | UPDATE with constants in SET clause (Informix syntax) No run-time checking. |
682 | | | | | | | | | | UPDATE with expresion in SET and column list (Informix syntax) No run-time checking. |
683 | | | | | | | | | | UPDATE with function calls in expresion (Informix syntax) No run-time checking. |
684 | | | | | | | | | | Missing test files - test invalid Please provide brief description of functionality tested here. |
685 | | | | | | | | | | UPDATE with variables in SET clause (Informix syntax). No run-tiem checking. |
686 | | | | | | | | | | UPDATE with SET sub-expression (Informix syntax) No run-time checking. |
687 | | | | | | | | | | UPDATE ... SET with UNITS. No run-time checking. |
689 | | | | | | | | | | UPDATE VIEW with Informix-style SET. No run-time checking. |
690 | | | | | | | | | | UPDATE ... SET one column (ANSI SQL 92 standard syntax). No run-time checking. |
691 | | | | | | | | | | UPDATE SET columns (ANSI SQL 92 syntax). No run-time checking. |
692 | | | | | | | | | | UPDATE standard SET with SQL expression. No run-time checking. |
693 | | | | | | | | | | UPDATE SET with SELECT (std ANSI SQL 92 syntax) No run-time checking. |
694 | | | | | | | | | | UPDATE SET with variable (std ANSI SQL 92 syntax) No run-time checking. |
695 | | | | | | | | | | UPDATE SET WHERE CURRENT OF (std. syntax) No run-time checking. |
696 | | | | | | | | | | UPDATE with THRU syntax. No run-time checking. |
697 | | | | | | | | | | Complex UPDATE. No run-time checking. |
698 | | | | | | | | | | INSERT into VIEW. No run-time checking. |
699 | | | | | | | | | | INSERT on multi-table view. No run-time checking. |
700 | | | | | | | | | | INSERT on synonym. NO run-time checking. |
701 | | | | | | | | | | UPDATE SET with sub-expression (std syntax). No run-time checking. |
702 | | | | | | | | | | UPDATE SET with function call in expression (std syntax). No run-time checking. |
703 | | | | | | | | | | UPDATE SET with variable (std syntax) No run-time checking. |
704 | | | | | | | | | | UPDATE SET with sub-expression (std syntax). No run-time checking. |
705 | | | | | | | | | | UPDATE SET units (std syntax). No run-time checking. |
706 | | | | | | | | | | Select with constants and expresions, all combinations. Informix specific syntax. |
707 | | | | | | | | | | |
710 | | | | | | | | | | INSERT witl fully qualified table names. |
711 | | | | | | | | | | DELETE from view. No run-time checking. |
712 | | | | | | | | | | DELETE on multi-table view. No run-time checking. |
713 | | | | | | | | | | DELETE on synonym. No run-time checking. |
714 | | | | | | | | | | DELETE with fully qualified table names. |
715 | | | | | | | | | | Simple SELECT test. |
716 | | | | | | | | | | SELECT several columns. |
717 | | | | | | | | | | SELECT ALL. |
718 | | | | | | | | | | SELECT DISTINCT |
719 | | | | | | | | | | SELECT AS |
720 | | | | | | | | | | SELECT with quoted strings. |
721 | | | | | | | | | | Check if column expressions is correctly fetched. |
722 | | | | | | | | | | SELECT with expresion. Informix SQL dialect (<). |
723 | | | | | | | | | | Check if select with substring fecth the correct values. |
724 | | | | | | | | | | Check if a select with \< fetch all correct values. |
725 | | | | | | | | | | Check if a select with \< fetch all correct values. |
726 | | | | | | | | | | Check if a select with over two tables fetch the correct values. |
727 | | | | | | | | | | Check if a select with over two tables fetch the correct values AS ALIAS. |
728 | | | | | | | | | | Check if a select with over two tables with outer fetch the correct values. |
729 | | | | | | | | | | Check if a select with over two tables with two outer fetch the correct values. |
730 | | | | | | | | | | Check if a select with over two tables with two outer fetch the correct values. |
731 | | | | | | | | | | SELECT with named ORDER BY. |
732 | | | | | | | | | | SELECT with numbered ORDER BY |
733 | | | | | | | | | | SELECT with DEC and ASC ORDER BY clause |
734 | | | | | | | | | | SELECT with complex ORDER BY. |
735 | | | | | | | | | | Check if a named group by fetches the correct values. . |
736 | | | | | | | | | | Check if a numbered group by fetches the correct values. |
737 | | | | | | | | | | Check if a numbered group by fetches the correct values. Mixed GROUP BY. |
738 | | | | | | | | | | Check if a select into temp insert the correct values and then they are correctly fetched. |
739 | | | | | | | | | | select into temp with no log.. |
740 | | | | | | | | | | Check if a select with a join between two tables fetch the correct values. |
741 | | | | | | | | | | Check if a simple select with a NOT condition fetch the correct values. |
742 | | | | | | | | | | Check if a simple select with a simple comparison condition fetch the correct values. |
743 | | | | | | | | | | Check if a simple select with a IN subquery in where condition fetch the correct values. |
744 | | | | | | | | | | Check if a simple select with a EXISTS subquery in where condition fetch the correct values |
745 | | | | | | | | | | Check if a simple select with ALL subquery in where condition fetch the correct values. |
746 | | | | | | | | | | Check if a simple select with between in where condition fetch the correct values. |
747 | | | | | | | | | | Check if a simple select with IN expression (not subquery) in where condition fetch the correct values |
748 | | | | | | | | | | Check if a simple select wth IN expression (not subquery) in where condition fetch the correct values. |
749 | | | | | | | | | | Check if a simple select with LIKE in where condition fetch the correct values. |
750 | | | | | | | | | | Check if a simple select with MATCHES in where condition fetch the correct values |
751 | | | | | | | | | | Check if a simple select with MATCHES in where condition using a variable fetch the correct values. |
752 | | | | | | | | | | Check if units on select list return the correct values. |
753 | | | | | | | | | | Check if a simple select that uses the rowid fetch the correct values values |
754 | | | | | | | | | | Check if a simple select with LIKE and characters escaped in where condition fetch the correct values |
755 | | | | | | | | | | Check if a simple select with < operatoor on where condition fetch the correct values. |
756 | | | | | | | | | | Check if a simple select with > operator on where condition fetch the correct values |
757 | | | | | | | | | | Check if a simple select with <= operatoor on where condition fetch the correct values |
758 | | | | | | | | | | Check if a simple select with LIKE in where condition using a variable fetch the correct values. |
759 | | | | | | | | | | Check if a simple select with GREATER or equal the in where condition fetch the correct values. |
760 | | | | | | | | | | Check if a simple select with diferent the in where condition fetch the correct values |
761 | | | | | | | | | | Check if a simple select with MATCHES and characters escaped in where condition fetch the correct values. |
762 | | | | | | | | | | Check if a simple select with AND in where condition fetch the correct values. |
763 | | | | | | | | | | Check if a simple select with OR in where condition fetch the correct values. |
764 | | | | | | | | | | Check if a simple select with LIKE in where condition using a variable fetch the correct values. |
765 | | | | | | | | | | Test a select from a column to a smaller variable |
766 | | | | | | | | | | Tests to exemplify the behaviour of cursor location with aubit and standard 4gl. |
767 | | | | | | | | | | Testing if the values returned by fgl_keyval is equal to the values of informix. |
768 | | | | | | | | | | Check if a simple select with ANY subquery in where condition fetch the correct values. |
769 | | | | | | | | | | Check if a simple select with SOME subquery in where condition fetch the correct values |
770 | | | | | | | | | | Check if a simple select with NOT IN expression (not subquery) in where condition fetch the correct values. |
771 | | | | | | | | | | Check if a select without a join between two tables fetch the correct cartesian product. |
772 | | | | | | | | | | Check if a simple select with NOT BETWEEN in where condition fetch the correct values. |
773 | | | | | | | | | | Check if a simple select with IS NULL in where condition using a variable fetch the correct values. |
774 | | | | | | | | | | Check if a simple select with NOT LIKE in where condition using a variable fetch the correct values. |
775 | | | | | | | | | | Check if a simple select with NOT MATCHES in where condition fetch the correct values. |
776 | | | | | | | | | | Check if a simple select with LIKE in where condition using a variable fetch the correct values. |
778 | | | | | | | | | | Check if a simple select with COUNT(<) in select list fetch the correct values. |
779 | | | | | | | | | | Check if a simple select with AVG in select list fetch the correct values.. |
780 | | | | | | | | | | Check if a simple select with MAX in select list fetch the correct values. |
781 | | | | | | | | | | Check if a simple select with MIN in select list fetch the correct values. |
782 | | | | | | | | | | Check if a simple select with SUM in select list fetch the correct values. |
783 | | | | | | | | | | Check if a simple select with COUNT distinct in select list fetch the correct values. |
784 | | | | | | | | | | Check if a simple select with MAX(ALL) in select list fetch the correct values. |
785 | | | | | | | | | | Check if a simple select with AVG(ALL) in select list fetch the correct values. |
786 | | | | | | | | | | Check if a simple select with MIN(ALL) in select list fetch the correct values. |
787 | | | | | | | | | | Check if a simple select with SUM ALL in select list fetch the correct values. |
788 | | | | | | | | | | Check if a simple select with HAVING condition using a variable fetch the correct values. |
789 | | | | | | | | | | Check with UNION in where condition fetch the correct values. |
790 | | | | | | | | | | Check with UNION ALL in where condition fetch the correct values. |
791 | | | | | | | | | | Check if a ROLLBACK WORK works ok. |
792 | | | | | | | | | | Check if the commit work statement after a transaction work |
793 | | | | | | | | | | Check if the create audit statement works. Note that this statement only works on Informix SE |
794 | | | | | | | | | | Check if the drop audit statement works. Note that this statement only works on Informix SE |
795 | | | | | | | | | | Check if the RECOVER TABLE statement works Note that this statement only works on Informix SE. |
796 | | | | | | | | | | Check if the ROLLFORWARD DATABASE statement works. Note that this statement only works on Informix SE. |
797 | | | | | | | | | | Check if the SET CONSTRAINTS ALL IMEDIATE statement works |
798 | | | | | | | | | | Check if a simple select with rowid in select list fetch the correct values. |
800 | | | | | | | | | | This test tests if the compiler accepts the EXECUTE IMMEDIATE keyword. |
801 | | | | | | | | | | This test checks if VARCHAR is handled OK |
802 | | | | | | | | | | This tests check if construct works with a varchar |
803 | | | | | | | | | | Testing DISPLAY ... ATTRIBUTE(variable) Syntax |
900 | | | | | | | | | | Test if the sqlca.sqlcode is assigned with an obvious sql error. |
901 | | | | | | | | | | Test if the sqlca.sqlcode is assigned with NOTFOUND sql error. |
902 | | | | | | | | | | Test if the sqlca.sqlerrm is assigned with an obvious sql error. |
903 | | | | | | | | | | Test if the sqlca.sqlerrm is assigned with an obvious sql error. |
904 | | | | | | | | | | Test if the sqlca.sqlerrd[1] is assigned with NOTFOUND sql error. |
905 | | | | | | | | | | Test if the sqlca.sqlerrd[2] is assigned with last serial inserted. |
906 | | | | | | | | | | Test if the sqlca.sqlerrd[2] is assigned with the ISAM error with a lock |
907 | | | | | | | | | | Test if the sqlca.sqlerrd[3] is assigned with the number of rows inserted updated and deleted. |
908 | | | | | | | | | | Test if the sqlca.sqlerrd[4] is assigned with the estimated cost of query. |
909 | | | | | | | | | | Test if the sqlca.sqlerrd[5] is assigned with the offset of an error in an wrong sql statement. |
910 | | | | | | | | | | Test if the sqlca.sqlerrd[6] is assigned with last rowid inserted. |
911 | | | | | | | | | | Test if the sqlca.sqlarn[1] is assigned with a W |
912 | | | | | | | | | | Test if the sqlca.sqlarn[2] is assigned with a W after a truncation in a select. |
913 | | | | | | | | | | Test if the sqlca.sqlarn[2] is assigned with a W after using a database without transactions. |
914 | | | | | | | | | | Test if the sqlca.sqlawarn[3] is assigned with a W after a null in an agregate function of a select. |
915 | | | | | | | | | | Test if the sqlca.sqlawarn[4] is assigned with a W after a select with more on a select list then on into |
916 | | | | | | | | | | Test if the sqlca.sqlawarn[5] is assigned with a W after a select from a float to a decimal. |
917 | | | | | | | | | | Test if the sqlca.sqlawarn[6] is assigned with a W after an update with non ansi syntax. |
918 | | | | | | | | | | Test 918 for deccvasc |
919 | | | | | | | | | | Test if a char conversion to decimal with c function works ok |
920 | | | | | | | | | | |
921 | | | | | | | | | | Test if a decimal conversion to int with c function works ok |
922 | | | | | | | | | | Test if a long conversion to decimal with c function works ok |
923 | | | | | | | | | | Test if a decimal conversion to long with c function works ok |
924 | | | | | | | | | | Test if a float conversion to decimal with c function works ok |
925 | | | | | | | | | | Test if a decimal conversion to float with c function works ok |
926 | | | | | | | | | | Test if a double conversion to decimal with c function works ok |
927 | | | | | | | | | | |
928 | | | | | | | | | | |
929 | | | | | | | | | | |
930 | | | | | | | | | | |
931 | | | | | | | | | | |
932 | | | | | | | | | | |
933 | | | | | | | | | | |
934 | | | | | | | | | | |
935 | | | | | | | | | | |
936 | | | | | | | | | | Test if the SET LOG 4gl statement works OK |
937 | | | | | | | | | | Test if the START DATABASE 4gl statement works OK. Note - This test only works with SE engine |
938 | | | | | | | | | | pop_short |
939 | | | | | | | | | | pop_int |
940 | | | | | | | | | | pop_long |
941 | | | | | | | | | | pop_flo |
942 | | | | | | | | | | pop_dub |
943 | | | | | | | | | | pop_dec |
944 | | | | | | | | | | pop_quote |
945 | | | | | | | | | | pop_vchar |
946 | | | | | | | | | | pop_date |
947 | | | | | | | | | | pop_dtime |
948 | | | | | | | | | | Test if the stack function(s) for interval(s) works. |
949 | | | | | | | | | | |
950 | | | | | | | | | | |
951 | | | | | | | | | | |
952 | | | | | | | | | | |
953 | | | | | | | | | | |
954 | | | | | | | | | | |
955 | | | | | | | | | | |
956 | | | | | | | | | | Test if the fglstart function works ok |
957 | | | | | | | | | | |
958 | | | | | | | | | | |
959 | | | | | | | | | | |
960 | | | | | | | | | | Test the character variable limits |
961 | | | | | | | | | | Test the date variable limits |
962 | | | | | | | | | | Test the decimal variable limits. |
963 | | | | | | | | | | Test the smallfloat variable limits |
964 | | | | | | | | | | Test the float variable limits |
965 | | | | | | | | | | Test the integer variable limits. |
966 | | | | | | | | | | Test the MONEY variable limits |
967 | | | | | | | | | | Test the SMALLINT variable limits |
968 | | | | | | | | | | Test the variable length character variable limits |
970 | | | | | | | | | | Test the datetime variable limits |
971 | | | | | | | | | | Test the interval variable limits |
973 | | | | | | | | | | Test if the conversion from char to another char works |
974 | | | | | | | | | | Test if the conversion from char to a varchar work |
975 | | | | | | | | | | Test if the conversion from char to a INTEGER work |
976 | | | | | | | | | | Test if the conversion from char to a smallint work |
977 | | | | | | | | | | Test if the conversion from char to a float work |
978 | | | | | | | | | | Test if the conversion from char to a SMALLFLOAT work |
979 | | | | | | | | | | Test if the conversion from char to a decimal work |
980 | | | | | | | | | | Test if the conversion from char to a money work |
981 | | | | | | | | | | Test the conversion from CHAR to DATE |
982 | | | | | | | | | | Test the conversion from char(s) to datetime(s) |
983 | | | | | | | | | | Test the conversion from char to interval works. |
984 | | | | | | | | | | Test if the conversion from a varchar to a char work |
985 | | | | | | | | | | Test if the conversion from a varchar to a varchar work |
986 | | | | | | | | | | Test if the conversion from varchar to an integer work |
987 | | | | | | | | | | Test if the conversion from varchar to a smallint work |
988 | | | | | | | | | | Test if the conversion from varchar to a float work |
989 | | | | | | | | | | Test if the conversion from varchar to a SMALLFLOAT work. |
990 | | | | | | | | | | Test if the conversion from varchar to a decimal work |
991 | | | | | | | | | | Test if the conversion from varchar to a money work |
992 | | | | | | | | | | Test the conversion from VARCHAR to DATE |
993 | | | | | | | | | | Test the conversion from varchar(s) to datetime(s). |
994 | | | | | | | | | | Test the conversion from varchar to interval works |
995 | | | | | | | | | | Test if the conversion from INTEGER to a char work |
996 | | | | | | | | | | Test if the conversion from INTEGER to a varchar work |
997 | | | | | | | | | | Test if the conversion from INTEGER to a FLOAT work |
998 | | | | | | | | | | Test if the conversion from INTEGER to a FLOAT work |
999 | | | | | | | | | | Test if the conversion from INTEGER to a DECIAL work |
1000 | | | | | | | | | | Test if the conversion from INTEGER to a MONEY work |
1001 | | | | | | | | | | Test if the conversion from an integer to a date works |
1002 | | | | | | | | | | Test if the conversion from SMALLINT to a char work |
1003 | | | | | | | | | | Test if the conversion from SMALLINT to a varchar work |
1004 | | | | | | | | | | Test if the conversion from SMALLINT to INTEGER work |
1005 | | | | | | | | | | Test if the conversion from SMALLINT to FLOAT work |
1006 | | | | | | | | | | Test if the conversion from SMALLINT to SMALLFLOAT work |
1007 | | | | | | | | | | Test if the conversion from SMALLINT to DECIMAL work |
1008 | | | | | | | | | | Test if Portguese Characters are correctly displayed. |
1009 | | | | | | | | | | cursor for update declared twice that second thime thinks it does not exist |
1060 | | | | | | | | | | Testing a way to pass values between shell and 4gl using a temporary file. |
1200 | | | | | | | | | | This is a fairly comprehensive declare/open test for input/output binding |
1201 | | | | | | | | | | Test behavious of status variable. No run-time checking |
1202 | | | | | | | | | | infield() in ON KEY/INPUT BY NAME. Test is invalid - missing form file and keys.in |
1203 | | | | | | | | | | Tests if finished an already finished report causes a core dump |
1204 | | | | | | | | | | Check the clear line in a display |
1205 | | | | | | | | | | passing null strings to a function |
1206 | | | | | | | | | | ord() server-side function in SELECT and UPDATE SQL statements |
1207 | | | | | | | | | | Tests conversion from/to money/smallint (MID 639) |
1208 | | | | | | | | | | Simple unload test for MID 591 Note that for this test to work, in most cases, the database engine needs to have sufficient privileges to write to the test directory |
1209 | | | | | | | | | | lineno in context of REPORT block |
1210 | | | | | | | | | | handling of -ve decimal numbers |
1211 | | | | | | | | | | This checks a reports output can be set within the report |
1212 | | | | | | | | | | This is a quick test of next key next |
1213 | | | | | | | | | | Report test |
1214 | | | | | | | | | | Report test |
1215 | | | | | | | | | | Report test |
1216 | | | | | | | | | | |
1217 | | | | | | | | | | Tests some comparsons on dates using string literals |
1218 | | | | | | | | | | 'units day' calculations and mdy() assignments |
1219 | | | | | | | | | | This is a test of several issues - mid 655 656 657 |
1220 | | | | | | | | | | Tests the SQL drivers ability to select fewer or more columns than variables |
1221 | | | | | | | | | | Tests empty foreach loops (bug reported by James Scott) |
1222 | | | | | | | | | | Test of using a 0 in a numeric field on a construct |
1223 | | | | | | | | | | after group clauses where there is no every row |
1224 | | | | | | | | | | MID 663 - ensure that the number of function parameters is checked |
1225 | | | | | | | | | | Brief test of the implementation of PRINT FILE |
1226 | | | | | | | | | | This tests passing NULL values to DAY, MONTH, YEAR and MDY functions |
1227 | | | | | | | | | | MID 666 |
1228 | | | | | | | | | | MID 661 Note that for this test to work, in most cases, the database engine needs to have sufficient privileges to write to the test directory |
1229 | | | | | | | | | | MID 672 - spaces at the start if a PICTURE |
1230 | | | | | | | | | | MID 670 construct on date field (part 1) |
1231 | | | | | | | | | | MID 670 construct on date field (part 1) |
1232 | | | | | | | | | | MID 669 - construct on DECIMAL field |
1233 | | | | | | | | | | MID 676 : Extra spaces in print date and print sum where |
1234 | | | | | | | | | | This tests the setting of a portion of a string with a null value |
1235 | | | | | | | | | | Tests using numbers for form colours... |
1236 | | | | | | | | | | Test for MID 677 - construct it is not allowing criteria mark as noentry in a form |
1237 | | | | | | | | | | match, is null and length test on a variable |
1238 | | | | | | | | | | MID 676 : Extra spaces in print date and print sum where .. for MDY2/ |
1239 | | | | | | | | | | Test of interval/character string math that was causing problems |
1240 | | | | | | | | | | Basic exercising of string types |
1241 | | | | | | | | | | Keyword 'user' test |
1242 | | | | | | | | | | Basic testing of libfile directory functions |
1243 | | | | | | | | | | some basic testing on libfile filehandling functionality |
1244 | | | | | | | | | | MESSAGE LINE, PROPMPT LINE and DISPLAY AT positioning |
1245 | | | | | | | | | | NULL in DATE |
1246 | | | | | | | | | | Tests a rollback work |
1247 | | | | | | | | | | Assigning decimal variable by division |
1248 | | | | | | | | | | Tests rolling back - mid 717 |
1249 | | | | | | | | | | Date tests of some sort |
1250 | | | | | | | | | | This is a test provided by Miguel Caldera which demonstates some corruption |
1251 | | | | | | | | | | date handling , mid 720 |
1252 | | | | | | | | | | Yes another report test , mid 721 (varchars) |
1253 | | | | | | | | | | Tests a bug using consecutive constructs not blanking the field properly |
1254 | | | | | | | | | | Tests use of a dynamic field |
1255 | | | | | | | | | | tests start report to expression |
1256 | | | | | | | | | | LOAD FROM from test. Uses FILESCHEMA as database type when compiling |
1257 | | | | | | | | | | This tests for a core dump when using a specific unload routine, known to fail on some platforms (they should remove the #define KAGEL_UNLOAD from lib/libsql/esqlc/esql.ec if set) |
1258 | | | | | | | | | | This tests the summation of nulls within a report |
1259 | | | | | | | | | | This is a test for fgl_getenv returning null when an environment variable is not set |
1260 | | | | | | | | | | VISUAL TEST checks to see if a terminal can change colours.. |
1261 | | | | | | | | | | Escape characters in form file |
1262 | | | | | | | | | | Checks sqlerrd[3] is set after a LOAD |
1263 | | | | | | | | | | Test sqlerrd[3] is set after a fetch |
1264 | | | | | | | | | | Another test for sqlerrd[3] not being set for a fetch |
1265 | | | | | | | | | | Checks the value of variables after a fetch with too few columns in the select |
1266 | | | | | | | | | | Tests the ability to generate a pdf report |
1267 | | | | | | | | | | Report TOP OF PAGE test maybe< |
1268 | | | | | | | | | | Tests implementation of TOP OF PAGE |
1269 | | | | | | | | | | Tests implementation of TOP OF PAGE |
1270 | | | | | | | | | | Tests implementation of top of page |
1271 | | | | | | | | | | This ensures caseinsensitivity on HIDE OPTION/SHOW OPTION |
1272 | | | | | | | | | | Newline and MATCHES in string |
1273 | | | | | | | | | | Tests selecting into from a union'd statement with no cursor |
1274 | | | | | | | | | | Various DATETIME variants inserted |
1275 | | | | | | | | | | DISPLAY in loops |
1276 | | | | | | | | | | This tests iterations within a for loop |
1277 | | | | | | | | | | Expression testing at the top of a 'while' |
1278 | | | | | | | | | | Test for setting default in a form |
1279 | | | | | | | | | | Check on passing a record to a function |
1280 | | | | | | | | | | Test for include=(' ') |
1281 | | | | | | | | | | channel::read/channel::write test |
1282 | | | | | | | | | | Tests order by using varchar , MID 764 |
1283 | | | | | | | | | | INITIALIZE elements of the record |
1284 | | | | | | | | | | Test of BEFORE INSERT with an input array |
1285 | | | | | | | | | | Postgres issue with BEGIN WORK and the implicit CLOSE used with a foreach |
1286 | | | | | | | | | | ON KEY inside of the INPU BY NAME |
1287 | | | | | | | | | | Test of BEFORE INSERT with an input array |
1288 | | | | | | | | | | INPUT BY NAME |
1289 | | | | | | | | | | DISPLAY and NULL - no checking performed |
1290 | | | | | | | | | | Tests the clearing of a field before entry for a simple numeric field |
1291 | | | | | | | | | | tests a having with no group by |
1292 | | | | | | | | | | DATETIME YEAR TO SECOND assigned CURRENT |
1293 | | | | | | | | | | Tests of some dates with interactions with the database |
1294 | | | | | | | | | | Test decimal with no scale |
1295 | | | | | | | | | | PROMPT - no checking and missing form file |
1296 | | | | | | | | | | Tests rounding of decimal places on a form |
1297 | | | | | | | | | | Quick check that compiler compiles variables for attributes |
1298 | | | | | | | | | | Mantis bug 790 , comment line misplaced |
1299 | | | | | | | | | | More testing of comment line, default is different for a window and SCREEN |
1300 | | | | | | | | | | CREATE TABLE with PRIMARY KEY clause. No run-time checking. NOTE: fails with -ifx-p. |
1301 | | | | | | | | | | CREATE TABLE with DEFAULT clause. No run-time checking. NOTE: fails with -ifx-p. |
1302 | | | | | | | | | | UPDATE with constants in SET clause (Informix syntax) No run-time checking. |
1303 | | | | | | | | | | UPDATE with expresion in SET and column list (Informix syntax) No run-time checking. |
1304 | | | | | | | | | | Check if a simple select with GREATER or equal the in where condition fetch the correct values. |
1305 | | | | | | | | | | Null string date/datetime checking |
1400 | | | | | | | | | | Substring checking |
1401 | | | | | | | | | | check comma in decimal (may not work with informix) |
1402 | | | | | | | | | | CONSTRUCT BY NAME and MESSAGE |
1403 | | | | | | | | | | This tests the resetting of arr_count between input array and display array calls |
1404 | | | | | | | | | | This checks the resetting of arr_count between input array and display array calls |
1405 | | | | | | | | | | This is a check for error recovery with SQL errors |
1406 | | | | | | | | | | Checks the usage of a blank string in an SQL statement , basically making sure it not treated as null |
1407 | | | | | | | | | | INITIALIZE CLIPPED and NULL |
1408 | | | | | | | | | | DECLARE CURSOR and FOREACH ... INTO |
1409 | | | | | | | | | | Ensure menu options can only be selected when not hidden , MID 820 |
1410 | | | | | | | | | | test wordwrap - MID 755 |
1411 | | | | | | | | | | When using substring in a column with alias, the table alias is removed and an ambigous column error may be thrown |
1412 | | | | | | | | | | Tests broken case statement |
1413 | | | | | | | | | | Example logical report layout testing |
1414 | | | | | | | | | | Select smallint into char |
1415 | | | | | | | | | | BUGFIX:cant substr if @ in fieldname |
1416 | | | | | | | | | | Tests order by desc within a report |
1417 | | | | | | | | | | Tests report order by |
1418 | | | | | | | | | | Tests using datetimes in a report |
1419 | | | | | | | | | | Tests running a report several times |
1420 | | | | | | | | | | report linenumber test |
1421 | | | | | | | | | | Another report test |
1422 | | | | | | | | | | Tests returning into a substring of a variable |
1423 | | | | | | | | | | |
1424 | | | | | | | | | | Tests setting an environment variable using the aclfgl_setenv function |
1425 | | | | | | | | | | Channel library test |
1426 | | | | | | | | | | Channel test |
1427 | | | | | | | | | | |
1428 | | | | | | | | | | |
1429 | | | | | | | | | | |
1430 | | | | | | | | | | |
1431 | | | | | | | | | | |
1432 | | | | | | | | | | |
1433 | | | | | | | | | | |
1434 | | | | | | | | | | |
1435 | | | | | | | | | | |
1436 | | | | | | | | | | |
1437 | | | | | | | | | | printing null values in report |
1438 | | | | | | | | | | printing null substrings in report |
1439 | | | | | | | | | | 0000898: no-printable ascii corrupt column position |
1440 | | | | | | | | | | |
1441 | | | | | | | | | | 0000900: division by zero -> Floating point exception |
1442 | | | | | | | | | | 880: display decimal field to smaller field in form, omit decimal part |
1443 | | | | | | | | | | 918: include statement in form ignored |
1444 | | | | | | | | | | 862: input 'without defaults' is clipping the program array fields |
1445 | | | | | | | | | | 924: construct blanking |
1446 | | | | | | | | | | 923: report length not breaking correctly |
1447 | | | | | | | | | | 931: bad bad looping problem |
1448 | | | | | | | | | | 929: comparison between (current hour to min) and string |
1449 | | | | | | | | | | 930: using hour to minute in if statement |
1450 | | | | | | | | | | 936: a report affected by the output section of the previous report |
1451 | | | | | | | | | | 949: window name limitation |
1452 | | | | | | | | | | 962: construct statement weirdness |
1600 | | | | | | | | | | Do some ordering, before/after group with null values. Mantis bug 902. |
1601 | | | | | | | | | | Check USING formating with (((#)) mask. Mantis bug 901. |
1602 | | | | | | | | | | Conversion from bad string to integer works fine, to smallinteger aborts, mantis bug 904 |
1603 | | | | | | | | | | Printing extended ascii (128-255) miscalculte column. mantis bug 905. |
1604 | | | | | | | | | | Do some calculation, check rounding problems. |
1605 | | | | | | | | | | Compile test selecting byte field, mantis bug 906. |
1606 | | | | | | | | | | Interval variable as a report parameter with order by -> syntax error, mantis bug 907 |
1607 | | | | | | | | | | Funny run-time error, input array fails with EC and works fine with C. |
1608 | | | | | | | | | | Use of tab and arrow keys during multi line field, mantis bug 909 (related 755). |
1609 | | | | | | | | | | Load of text file without END OF LINE (EOL) fails, mantis bug 912. |
1610 | | | | | | | | | | Selecting varchar return string padded with spaces up to the maximun length, mantis bug 915. |
1611 | | | | | | | | | | error concatenating subtrings, mantis bug 916. |
1612 | | | | | | | | | | input without defaults, bad editing if smallint and after smallint field. mantis bug 917 |
1613 | | | | | | | | | | Assertion failed mdy() with year argument = 0. MID 921 |
1614 | | | | | | | | | | Memory corruption, print varchar (with define lilke) wordwrap in after group. |
1615 | | | | | | | | | | set_count() of a display is ignored if inside an input array. MID 926. |
1616 | | | | | | | | | | segmentation fault, construct numeric field and type char. MID 927. |
1617 | | | | | | | | | | begin/commit work inside a report, end prematurly. MID 932. |
1618 | | | | | | | | | | pageno is not updated as in I-4GL(tm), problem in before group. MID 934. |
1619 | | | | | | | | | | construct, range of integers ':' nor '..' working. MID 938. |
1620 | | | | | | | | | | wordwrap of long_text_without_spaces print only last line. MID 939. |
1621 | | | | | | | | | | lineno contains last line printed of previous page after new page, I-4gl contains zero. MID 940. |
1622 | | | | | | | | | | SQL with mulitply money field, not all decimals considered. MID 941. |
1623 | | | | | | | | | | Garbage if accessing varchar beyond size. MID 942. |
1624 | | | | | | | | | | Ascii 0 can not be printed in a report. Please describe here. |
1625 | | | | | | | | | | The scale exceeds the maximum precision specified.. MID 953. |
1626 | | | | | | | | | | moving around fields (without editing), destroy full length content if display width is smaller tan content |
1627 | | | | | | | | | | With two inputs arrays, the arr_count() of the second takes the value of the first |
| 485 OK 7 Fail 463 Skip 98% OK | 404 OK Fail 559 Skip 100% OK | 399 OK Fail 564 Skip 100% OK | 254 OK 28 Fail 681 Skip 90% OK | 380 OK 21 Fail 562 Skip 94% OK | 275 OK 126 Fail 562 Skip 68% OK | 236 OK 74 Fail 653 Skip 76% OK | 306 OK 100 Fail 557 Skip 75% OK | 292 OK 114 Fail 557 Skip 71% OK |