ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/testsuite/FB2reference.log
(Generate patch)

Comparing ibx/trunk/testsuite/FB2reference.log (file contents):
Revision 323 by tony, Thu Feb 25 12:14:35 2021 UTC vs.
Revision 348 by tony, Wed Oct 6 09:38:14 2021 UTC

# Line 642 | Line 642 | Rows printed = 42
642   Current memory = 960,760
643   Delta memory = 9,624
644   Max memory = 1,012,104
645 < Elapsed time= 0.034 sec
645 > Elapsed time= 0.032 sec
646   Cpu = 0.002 sec
647   Buffers = 75
648   Reads = 3
# Line 1452 | Line 1452 | DPB: Item Count = 3
1452    isc_dpb_lc_ctype = UTF8
1453  
1454   Before Disconnect
1455 < localhost:employee Disconnected after 3949 ms
1455 > localhost:employee Disconnected after 3989 ms
1456   Idle Timer Expired for Test_Database_02
1457   Database Closed
1458   Transaction Events
# Line 1475 | Line 1475 | TPB: Item Count = 3
1475    isc_tpb_read
1476  
1477   Transaction Ending
1478 < Transaction Ended after 7 ms
1478 > Transaction Ended after 11 ms
1479   Transaction idle timer test
1480   Requested TPB: Item Count = 3
1481    isc_tpb_concurrency
# Line 1489 | Line 1489 | TPB: Item Count = 3
1489    isc_tpb_read
1490  
1491   Transaction Ending
1492 < Transaction Ended after 2007 ms
1492 > Transaction Ended after 2012 ms
1493   Idle Timer Expired for Test_Transaction_02
1494   Before Disconnect
1495 < localhost:employee Disconnected after 2053 ms
1495 > localhost:employee Disconnected after 2074 ms
1496   SQL Dialect Downgrade test
1497   Before Connect
1498   Connected to localhost:/tmp/ibx-testsuite/testsuite1.fdb
# Line 1504 | Line 1504 | DPB: Item Count = 4
1504  
1505   localhost:/tmp/ibx-testsuite/testsuite1.fdb created
1506   Before Disconnect
1507 < localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 29 ms
1507 > localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 30 ms
1508   Before Connect
1509   Warning: SQL Dialect Downgrade of localhost:/tmp/ibx-testsuite/testsuite1.fdb
1510   Connected to localhost:/tmp/ibx-testsuite/testsuite1.fdb
# Line 1514 | Line 1514 | DPB: Item Count = 3
1514    isc_dpb_lc_ctype = UTF8
1515  
1516   Before Disconnect
1517 < localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 29 ms
1517 > localhost:/tmp/ibx-testsuite/testsuite1.fdb Disconnected after 37 ms
1518  
1519  
1520   ------------------------------------------------------
# Line 3151 | Line 3151 | DEPT_KEY_PATH = 000;600;620;622
3151   Current memory = 952,624
3152   Delta memory = 9,608
3153   Max memory = 1,013,496
3154 < Elapsed time= 0.026 sec
3155 < Cpu = 0.002 sec
3154 > Elapsed time= 0.038 sec
3155 > Cpu = 0.001 sec
3156   Buffers = 75
3157   Reads = 3
3158   Writes = 0
# Line 4055 | Line 4055 | SET TERM ^ ;
4055  
4056   /* Stored procedures Definitions*/
4057  
4058 < CREATE PROCEDURE SHOW_LANGS
4058 > CREATE PROCEDURE SHOW_LANGS
4059   (
4060    CODE VARCHAR(5) CHARACTER SET NONE,
4061    GRADE SMALLINT,
# Line 4068 | Line 4068 | RETURNS
4068   AS
4069   BEGIN SUSPEND; EXIT; END
4070   ^
4071 <
4072 < CREATE PROCEDURE ADD_EMP_PROJ
4071 > CREATE PROCEDURE ADD_EMP_PROJ
4072   (
4073    EMP_NO SMALLINT,
4074    PROJ_ID CHAR(5) CHARACTER SET NONE
# Line 4077 | Line 4076 | CREATE PROCEDURE ADD_EMP_PROJ
4076   AS
4077   BEGIN SUSPEND; EXIT; END
4078   ^
4079 <
4081 < CREATE PROCEDURE ALL_LANGS
4079 > CREATE PROCEDURE ALL_LANGS
4080   RETURNS
4081   (
4082    CODE VARCHAR(5) CHARACTER SET NONE,
# Line 4089 | Line 4087 | RETURNS
4087   AS
4088   BEGIN SUSPEND; EXIT; END
4089   ^
4090 <
4093 < CREATE PROCEDURE DELETE_EMPLOYEE
4090 > CREATE PROCEDURE DELETE_EMPLOYEE
4091   (
4092    EMP_NUM INTEGER
4093   )
4094   AS
4095   BEGIN SUSPEND; EXIT; END
4096   ^
4097 <
4101 < CREATE PROCEDURE DEPT_BUDGET
4097 > CREATE PROCEDURE DEPT_BUDGET
4098   (
4099    DNO CHAR(3) CHARACTER SET NONE
4100   )
# Line 4109 | Line 4105 | RETURNS
4105   AS
4106   BEGIN SUSPEND; EXIT; END
4107   ^
4108 <
4113 < CREATE PROCEDURE GET_EMP_PROJ
4108 > CREATE PROCEDURE GET_EMP_PROJ
4109   (
4110    EMP_NO SMALLINT
4111   )
# Line 4121 | Line 4116 | RETURNS
4116   AS
4117   BEGIN SUSPEND; EXIT; END
4118   ^
4119 <
4125 < CREATE PROCEDURE MAIL_LABEL
4119 > CREATE PROCEDURE MAIL_LABEL
4120   (
4121    CUST_NO INTEGER
4122   )
# Line 4138 | Line 4132 | RETURNS
4132   AS
4133   BEGIN SUSPEND; EXIT; END
4134   ^
4135 <
4142 < CREATE PROCEDURE ORG_CHART
4135 > CREATE PROCEDURE ORG_CHART
4136   RETURNS
4137   (
4138    HEAD_DEPT CHAR(25) CHARACTER SET NONE,
# Line 4151 | Line 4144 | RETURNS
4144   AS
4145   BEGIN SUSPEND; EXIT; END
4146   ^
4147 <
4155 < CREATE PROCEDURE SHIP_ORDER
4147 > CREATE PROCEDURE SHIP_ORDER
4148   (
4149    PO_NUM CHAR(8) CHARACTER SET NONE
4150   )
4151   AS
4152   BEGIN SUSPEND; EXIT; END
4153   ^
4154 <
4163 < CREATE PROCEDURE SUB_TOT_BUDGET
4154 > CREATE PROCEDURE SUB_TOT_BUDGET
4155   (
4156    HEAD_DEPT CHAR(3) CHARACTER SET NONE
4157   )
# Line 4174 | Line 4165 | RETURNS
4165   AS
4166   BEGIN SUSPEND; EXIT; END
4167   ^
4177 –
4168   SET TERM ; ^
4169   COMMIT WORK;
4170   SET AUTODDL ON;
# Line 4230 | Line 4220 | SET TERM ^ ;
4220   /* Stored procedure Bodies */
4221  
4222  
4223 < ALTER PROCEDURE SHOW_LANGS
4223 > ALTER PROCEDURE SHOW_LANGS
4224   (
4225    CODE VARCHAR(5) CHARACTER SET NONE,
4226    GRADE SMALLINT,
# Line 4256 | Line 4246 | BEGIN
4246      SUSPEND;
4247    END
4248   END
4249 < ^
4260 <
4249 > ^
4250  
4251 < ALTER PROCEDURE ADD_EMP_PROJ
4251 > ALTER PROCEDURE ADD_EMP_PROJ
4252   (
4253    EMP_NO SMALLINT,
4254    PROJ_ID CHAR(5) CHARACTER SET NONE
# Line 4273 | Line 4262 | BEGIN
4262          END
4263          SUSPEND;
4264   END
4265 < ^
4277 <
4265 > ^
4266  
4267 < ALTER PROCEDURE ALL_LANGS
4267 > ALTER PROCEDURE ALL_LANGS
4268   RETURNS
4269   (
4270    CODE VARCHAR(5) CHARACTER SET NONE,
# Line 4302 | Line 4290 | AS
4290              SUSPEND;
4291          END
4292      END
4293 < ^
4306 <
4293 > ^
4294  
4295 < ALTER PROCEDURE DELETE_EMPLOYEE
4295 > ALTER PROCEDURE DELETE_EMPLOYEE
4296   (
4297    EMP_NUM INTEGER
4298   )
# Line 4364 | Line 4351 | BEGIN
4351  
4352          SUSPEND;
4353   END
4354 < ^
4368 <
4354 > ^
4355  
4356 < ALTER PROCEDURE DEPT_BUDGET
4356 > ALTER PROCEDURE DEPT_BUDGET
4357   (
4358    DNO CHAR(3) CHARACTER SET NONE
4359   )
# Line 4401 | Line 4387 | BEGIN
4387  
4388          SUSPEND;
4389   END
4390 < ^
4405 <
4390 > ^
4391  
4392 < ALTER PROCEDURE GET_EMP_PROJ
4392 > ALTER PROCEDURE GET_EMP_PROJ
4393   (
4394    EMP_NO SMALLINT
4395   )
# Line 4421 | Line 4406 | BEGIN
4406          DO
4407                  SUSPEND;
4408   END
4409 < ^
4425 <
4409 > ^
4410  
4411 < ALTER PROCEDURE MAIL_LABEL
4411 > ALTER PROCEDURE MAIL_LABEL
4412   (
4413    CUST_NO INTEGER
4414   )
# Line 4492 | Line 4476 | BEGIN
4476  
4477          SUSPEND;
4478   END
4479 < ^
4496 <
4479 > ^
4480  
4481 < ALTER PROCEDURE ORG_CHART
4481 > ALTER PROCEDURE ORG_CHART
4482   RETURNS
4483   (
4484    HEAD_DEPT CHAR(25) CHARACTER SET NONE,
# Line 4535 | Line 4518 | BEGIN
4518                  SUSPEND;
4519          END
4520   END
4521 < ^
4539 <
4521 > ^
4522  
4523 < ALTER PROCEDURE SHIP_ORDER
4523 > ALTER PROCEDURE SHIP_ORDER
4524   (
4525    PO_NUM CHAR(8) CHARACTER SET NONE
4526   )
# Line 4599 | Line 4581 | BEGIN
4581  
4582          SUSPEND;
4583   END
4584 < ^
4603 <
4584 > ^
4585  
4586 < ALTER PROCEDURE SUB_TOT_BUDGET
4586 > ALTER PROCEDURE SUB_TOT_BUDGET
4587   (
4588    HEAD_DEPT CHAR(3) CHARACTER SET NONE
4589   )
# Line 4621 | Line 4602 | BEGIN
4602                  INTO :tot_budget, :avg_budget, :min_budget, :max_budget;
4603          SUSPEND;
4604   END
4605 < ^
4625 <
4605 > ^
4606   SET TERM ; ^
4607   COMMIT WORK;
4608   SET AUTODDL ON;
# Line 7532 | Line 7512 | SET TERM ^ ;
7512  
7513   /* Stored procedures Definitions*/
7514  
7515 < CREATE PROCEDURE SHOW_LANGS
7515 > CREATE PROCEDURE SHOW_LANGS
7516   (
7517    CODE VARCHAR(5) CHARACTER SET NONE,
7518    GRADE SMALLINT,
# Line 7545 | Line 7525 | RETURNS
7525   AS
7526   BEGIN SUSPEND; EXIT; END
7527   ^
7528 <
7549 < CREATE PROCEDURE ADD_EMP_PROJ
7528 > CREATE PROCEDURE ADD_EMP_PROJ
7529   (
7530    EMP_NO SMALLINT,
7531    PROJ_ID CHAR(5) CHARACTER SET NONE
# Line 7554 | Line 7533 | CREATE PROCEDURE ADD_EMP_PROJ
7533   AS
7534   BEGIN EXIT; END
7535   ^
7536 <
7558 < CREATE PROCEDURE ALL_LANGS
7536 > CREATE PROCEDURE ALL_LANGS
7537   RETURNS
7538   (
7539    CODE VARCHAR(5) CHARACTER SET NONE,
# Line 7566 | Line 7544 | RETURNS
7544   AS
7545   BEGIN SUSPEND; EXIT; END
7546   ^
7547 <
7570 < CREATE PROCEDURE DELETE_EMPLOYEE
7547 > CREATE PROCEDURE DELETE_EMPLOYEE
7548   (
7549    EMP_NUM INTEGER
7550   )
7551   AS
7552   BEGIN EXIT; END
7553   ^
7554 <
7578 < CREATE PROCEDURE DEPT_BUDGET
7554 > CREATE PROCEDURE DEPT_BUDGET
7555   (
7556    DNO CHAR(3) CHARACTER SET NONE
7557   )
# Line 7586 | Line 7562 | RETURNS
7562   AS
7563   BEGIN SUSPEND; EXIT; END
7564   ^
7565 <
7590 < CREATE PROCEDURE GET_EMP_PROJ
7565 > CREATE PROCEDURE GET_EMP_PROJ
7566   (
7567    EMP_NO SMALLINT
7568   )
# Line 7598 | Line 7573 | RETURNS
7573   AS
7574   BEGIN SUSPEND; EXIT; END
7575   ^
7576 <
7602 < CREATE PROCEDURE "Has Space"
7576 > CREATE PROCEDURE "Has Space"
7577   (
7578    ARG1 INTEGER
7579   )
7580   AS
7581   BEGIN EXIT; END
7582   ^
7583 <
7610 < CREATE PROCEDURE MAIL_LABEL
7583 > CREATE PROCEDURE MAIL_LABEL
7584   (
7585    CUST_NO INTEGER
7586   )
# Line 7623 | Line 7596 | RETURNS
7596   AS
7597   BEGIN SUSPEND; EXIT; END
7598   ^
7599 <
7627 < CREATE PROCEDURE ORG_CHART
7599 > CREATE PROCEDURE ORG_CHART
7600   RETURNS
7601   (
7602    HEAD_DEPT CHAR(25) CHARACTER SET NONE,
# Line 7636 | Line 7608 | RETURNS
7608   AS
7609   BEGIN SUSPEND; EXIT; END
7610   ^
7611 <
7640 < CREATE PROCEDURE SHIP_ORDER
7611 > CREATE PROCEDURE SHIP_ORDER
7612   (
7613    PO_NUM CHAR(8) CHARACTER SET NONE
7614   )
7615   AS
7616   BEGIN EXIT; END
7617   ^
7618 <
7648 < CREATE PROCEDURE SUB_TOT_BUDGET
7618 > CREATE PROCEDURE SUB_TOT_BUDGET
7619   (
7620    HEAD_DEPT CHAR(3) CHARACTER SET NONE
7621   )
# Line 7659 | Line 7629 | RETURNS
7629   AS
7630   BEGIN SUSPEND; EXIT; END
7631   ^
7632 <
7663 < CREATE PROCEDURE "UC SPACE"
7632 > CREATE PROCEDURE "UC SPACE"
7633   (
7634    ARG1 INTEGER
7635   )
7636   AS
7637   BEGIN EXIT; END
7638   ^
7639 <
7671 < CREATE PROCEDURE "iCASE"
7639 > CREATE PROCEDURE "iCASE"
7640   AS
7641   BEGIN EXIT; END
7642   ^
7675 –
7643   SET TERM ; ^
7644   COMMIT WORK;
7645   SET AUTODDL ON;
# Line 7728 | Line 7695 | SET TERM ^ ;
7695   /* Stored procedure Bodies */
7696  
7697  
7698 < ALTER PROCEDURE SHOW_LANGS
7698 > ALTER PROCEDURE SHOW_LANGS
7699   (
7700    CODE VARCHAR(5) CHARACTER SET NONE,
7701    GRADE SMALLINT,
# Line 7754 | Line 7721 | BEGIN
7721      SUSPEND;
7722    END
7723   END
7724 < ^
7758 <
7724 > ^
7725  
7726 < ALTER PROCEDURE ADD_EMP_PROJ
7726 > ALTER PROCEDURE ADD_EMP_PROJ
7727   (
7728    EMP_NO SMALLINT,
7729    PROJ_ID CHAR(5) CHARACTER SET NONE
# Line 7770 | Line 7736 | BEGIN
7736                  EXCEPTION unknown_emp_id;
7737          END
7738   END
7739 < ^
7774 <
7739 > ^
7740  
7741 < ALTER PROCEDURE ALL_LANGS
7741 > ALTER PROCEDURE ALL_LANGS
7742   RETURNS
7743   (
7744    CODE VARCHAR(5) CHARACTER SET NONE,
# Line 7799 | Line 7764 | BEGIN
7764              SUSPEND;
7765          END
7766      END
7767 < ^
7803 <
7767 > ^
7768  
7769 < ALTER PROCEDURE DELETE_EMPLOYEE
7769 > ALTER PROCEDURE DELETE_EMPLOYEE
7770   (
7771    EMP_NUM INTEGER
7772   )
# Line 7859 | Line 7823 | BEGIN
7823          WHERE emp_no = :emp_num;
7824  
7825   END
7826 < ^
7863 <
7826 > ^
7827  
7828 < ALTER PROCEDURE DEPT_BUDGET
7828 > ALTER PROCEDURE DEPT_BUDGET
7829   (
7830    DNO CHAR(3) CHARACTER SET NONE
7831   )
# Line 7896 | Line 7859 | BEGIN
7859  
7860          SUSPEND;
7861   END
7862 < ^
7900 <
7862 > ^
7863  
7864 < ALTER PROCEDURE GET_EMP_PROJ
7864 > ALTER PROCEDURE GET_EMP_PROJ
7865   (
7866    EMP_NO SMALLINT
7867   )
# Line 7916 | Line 7878 | BEGIN
7878          DO
7879                  SUSPEND;
7880   END
7881 < ^
7920 <
7881 > ^
7882  
7883 < ALTER PROCEDURE "Has Space"
7883 > ALTER PROCEDURE "Has Space"
7884   (
7885    ARG1 INTEGER
7886   )
7887   AS
7888   Begin End
7889 < ^
7929 <
7889 > ^
7890  
7891 < ALTER PROCEDURE MAIL_LABEL
7891 > ALTER PROCEDURE MAIL_LABEL
7892   (
7893    CUST_NO INTEGER
7894   )
# Line 7996 | Line 7956 | BEGIN
7956  
7957          SUSPEND;
7958   END
7959 < ^
8000 <
7959 > ^
7960  
7961 < ALTER PROCEDURE ORG_CHART
7961 > ALTER PROCEDURE ORG_CHART
7962   RETURNS
7963   (
7964    HEAD_DEPT CHAR(25) CHARACTER SET NONE,
# Line 8039 | Line 7998 | BEGIN
7998                  SUSPEND;
7999          END
8000   END
8001 < ^
8043 <
8001 > ^
8002  
8003 < ALTER PROCEDURE SHIP_ORDER
8003 > ALTER PROCEDURE SHIP_ORDER
8004   (
8005    PO_NUM CHAR(8) CHARACTER SET NONE
8006   )
# Line 8099 | Line 8057 | BEGIN
8057          WHERE po_number = :po_num;
8058  
8059   END
8060 < ^
8103 <
8060 > ^
8061  
8062 < ALTER PROCEDURE SUB_TOT_BUDGET
8062 > ALTER PROCEDURE SUB_TOT_BUDGET
8063   (
8064    HEAD_DEPT CHAR(3) CHARACTER SET NONE
8065   )
# Line 8121 | Line 8078 | BEGIN
8078                  INTO :tot_budget, :avg_budget, :min_budget, :max_budget;
8079          SUSPEND;
8080   END
8081 < ^
8125 <
8081 > ^
8082  
8083 < ALTER PROCEDURE "UC SPACE"
8083 > ALTER PROCEDURE "UC SPACE"
8084   (
8085    ARG1 INTEGER
8086   )
8087   AS
8088   Begin End
8089 < ^
8134 <
8089 > ^
8090  
8091 < ALTER PROCEDURE "iCASE"
8091 > ALTER PROCEDURE "iCASE"
8092   AS
8093   Begin End
8094 < ^
8140 <
8094 > ^
8095   SET TERM ; ^
8096   COMMIT WORK;
8097   SET AUTODDL ON;
# Line 9269 | Line 9223 | SET TERM ^ ;
9223  
9224   /* Stored procedures Definitions*/
9225  
9226 < CREATE PROCEDURE SHOW_LANGS
9226 > CREATE PROCEDURE SHOW_LANGS
9227   (
9228    CODE VARCHAR(5) CHARACTER SET NONE,
9229    GRADE SMALLINT,
# Line 9282 | Line 9236 | RETURNS
9236   AS
9237   BEGIN SUSPEND; EXIT; END
9238   ^
9239 <
9286 < CREATE PROCEDURE ADD_EMP_PROJ
9239 > CREATE PROCEDURE ADD_EMP_PROJ
9240   (
9241    EMP_NO SMALLINT,
9242    PROJ_ID CHAR(5) CHARACTER SET NONE
# Line 9291 | Line 9244 | CREATE PROCEDURE ADD_EMP_PROJ
9244   AS
9245   BEGIN EXIT; END
9246   ^
9247 <
9295 < CREATE PROCEDURE ALL_LANGS
9247 > CREATE PROCEDURE ALL_LANGS
9248   RETURNS
9249   (
9250    CODE VARCHAR(5) CHARACTER SET NONE,
# Line 9303 | Line 9255 | RETURNS
9255   AS
9256   BEGIN SUSPEND; EXIT; END
9257   ^
9258 <
9307 < CREATE PROCEDURE DELETE_EMPLOYEE
9258 > CREATE PROCEDURE DELETE_EMPLOYEE
9259   (
9260    EMP_NUM INTEGER
9261   )
9262   AS
9263   BEGIN EXIT; END
9264   ^
9265 <
9315 < CREATE PROCEDURE DEPT_BUDGET
9265 > CREATE PROCEDURE DEPT_BUDGET
9266   (
9267    DNO CHAR(3) CHARACTER SET NONE
9268   )
# Line 9323 | Line 9273 | RETURNS
9273   AS
9274   BEGIN SUSPEND; EXIT; END
9275   ^
9276 <
9327 < CREATE PROCEDURE GET_EMP_PROJ
9276 > CREATE PROCEDURE GET_EMP_PROJ
9277   (
9278    EMP_NO SMALLINT
9279   )
# Line 9335 | Line 9284 | RETURNS
9284   AS
9285   BEGIN SUSPEND; EXIT; END
9286   ^
9287 <
9339 < CREATE PROCEDURE "Has Space"
9287 > CREATE PROCEDURE "Has Space"
9288   (
9289    ARG1 INTEGER
9290   )
9291   AS
9292   BEGIN EXIT; END
9293   ^
9294 <
9347 < CREATE PROCEDURE MAIL_LABEL
9294 > CREATE PROCEDURE MAIL_LABEL
9295   (
9296    CUST_NO INTEGER
9297   )
# Line 9360 | Line 9307 | RETURNS
9307   AS
9308   BEGIN SUSPEND; EXIT; END
9309   ^
9310 <
9364 < CREATE PROCEDURE ORG_CHART
9310 > CREATE PROCEDURE ORG_CHART
9311   RETURNS
9312   (
9313    HEAD_DEPT CHAR(25) CHARACTER SET NONE,
# Line 9373 | Line 9319 | RETURNS
9319   AS
9320   BEGIN SUSPEND; EXIT; END
9321   ^
9322 <
9377 < CREATE PROCEDURE SHIP_ORDER
9322 > CREATE PROCEDURE SHIP_ORDER
9323   (
9324    PO_NUM CHAR(8) CHARACTER SET NONE
9325   )
9326   AS
9327   BEGIN EXIT; END
9328   ^
9329 <
9385 < CREATE PROCEDURE SUB_TOT_BUDGET
9329 > CREATE PROCEDURE SUB_TOT_BUDGET
9330   (
9331    HEAD_DEPT CHAR(3) CHARACTER SET NONE
9332   )
# Line 9396 | Line 9340 | RETURNS
9340   AS
9341   BEGIN SUSPEND; EXIT; END
9342   ^
9343 <
9400 < CREATE PROCEDURE "UC SPACE"
9343 > CREATE PROCEDURE "UC SPACE"
9344   (
9345    ARG1 INTEGER
9346   )
9347   AS
9348   BEGIN EXIT; END
9349   ^
9350 <
9408 < CREATE PROCEDURE "iCASE"
9350 > CREATE PROCEDURE "iCASE"
9351   AS
9352   BEGIN EXIT; END
9353   ^
9412 –
9354   SET TERM ; ^
9355   COMMIT WORK;
9356   SET AUTODDL ON;
# Line 9465 | Line 9406 | SET TERM ^ ;
9406   /* Stored procedure Bodies */
9407  
9408  
9409 < ALTER PROCEDURE SHOW_LANGS
9409 > ALTER PROCEDURE SHOW_LANGS
9410   (
9411    CODE VARCHAR(5) CHARACTER SET NONE,
9412    GRADE SMALLINT,
# Line 9491 | Line 9432 | BEGIN
9432      SUSPEND;
9433    END
9434   END
9435 < ^
9495 <
9435 > ^
9436  
9437 < ALTER PROCEDURE ADD_EMP_PROJ
9437 > ALTER PROCEDURE ADD_EMP_PROJ
9438   (
9439    EMP_NO SMALLINT,
9440    PROJ_ID CHAR(5) CHARACTER SET NONE
# Line 9507 | Line 9447 | BEGIN
9447                  EXCEPTION unknown_emp_id;
9448          END
9449   END
9450 < ^
9511 <
9450 > ^
9451  
9452 < ALTER PROCEDURE ALL_LANGS
9452 > ALTER PROCEDURE ALL_LANGS
9453   RETURNS
9454   (
9455    CODE VARCHAR(5) CHARACTER SET NONE,
# Line 9536 | Line 9475 | BEGIN
9475              SUSPEND;
9476          END
9477      END
9478 < ^
9540 <
9478 > ^
9479  
9480 < ALTER PROCEDURE DELETE_EMPLOYEE
9480 > ALTER PROCEDURE DELETE_EMPLOYEE
9481   (
9482    EMP_NUM INTEGER
9483   )
# Line 9596 | Line 9534 | BEGIN
9534          WHERE emp_no = :emp_num;
9535  
9536   END
9537 < ^
9600 <
9537 > ^
9538  
9539 < ALTER PROCEDURE DEPT_BUDGET
9539 > ALTER PROCEDURE DEPT_BUDGET
9540   (
9541    DNO CHAR(3) CHARACTER SET NONE
9542   )
# Line 9633 | Line 9570 | BEGIN
9570  
9571          SUSPEND;
9572   END
9573 < ^
9637 <
9573 > ^
9574  
9575 < ALTER PROCEDURE GET_EMP_PROJ
9575 > ALTER PROCEDURE GET_EMP_PROJ
9576   (
9577    EMP_NO SMALLINT
9578   )
# Line 9653 | Line 9589 | BEGIN
9589          DO
9590                  SUSPEND;
9591   END
9592 < ^
9657 <
9592 > ^
9593  
9594 < ALTER PROCEDURE "Has Space"
9594 > ALTER PROCEDURE "Has Space"
9595   (
9596    ARG1 INTEGER
9597   )
9598   AS
9599   Begin End
9600 < ^
9666 <
9600 > ^
9601  
9602 < ALTER PROCEDURE MAIL_LABEL
9602 > ALTER PROCEDURE MAIL_LABEL
9603   (
9604    CUST_NO INTEGER
9605   )
# Line 9733 | Line 9667 | BEGIN
9667  
9668          SUSPEND;
9669   END
9670 < ^
9737 <
9670 > ^
9671  
9672 < ALTER PROCEDURE ORG_CHART
9672 > ALTER PROCEDURE ORG_CHART
9673   RETURNS
9674   (
9675    HEAD_DEPT CHAR(25) CHARACTER SET NONE,
# Line 9776 | Line 9709 | BEGIN
9709                  SUSPEND;
9710          END
9711   END
9712 < ^
9780 <
9712 > ^
9713  
9714 < ALTER PROCEDURE SHIP_ORDER
9714 > ALTER PROCEDURE SHIP_ORDER
9715   (
9716    PO_NUM CHAR(8) CHARACTER SET NONE
9717   )
# Line 9836 | Line 9768 | BEGIN
9768          WHERE po_number = :po_num;
9769  
9770   END
9771 < ^
9840 <
9771 > ^
9772  
9773 < ALTER PROCEDURE SUB_TOT_BUDGET
9773 > ALTER PROCEDURE SUB_TOT_BUDGET
9774   (
9775    HEAD_DEPT CHAR(3) CHARACTER SET NONE
9776   )
# Line 9858 | Line 9789 | BEGIN
9789                  INTO :tot_budget, :avg_budget, :min_budget, :max_budget;
9790          SUSPEND;
9791   END
9792 < ^
9862 <
9792 > ^
9793  
9794 < ALTER PROCEDURE "UC SPACE"
9794 > ALTER PROCEDURE "UC SPACE"
9795   (
9796    ARG1 INTEGER
9797   )
9798   AS
9799   Begin End
9800 < ^
9871 <
9800 > ^
9801  
9802 < ALTER PROCEDURE "iCASE"
9802 > ALTER PROCEDURE "iCASE"
9803   AS
9804   Begin End
9805 < ^
9877 <
9805 > ^
9806   SET TERM ; ^
9807   COMMIT WORK;
9808   SET AUTODDL ON;
# Line 9949 | Line 9877 | Output from diff command
9877   < SET AUTODDL OFF;
9878   < SET TERM ^ ;
9879   <
9880 + 1102c1092
9881 + < CREATE PROCEDURE SHOW_LANGS
9882 + ---
9883 + > CREATE PROCEDURE SHOW_LANGS
9884   1114d1103
9885   <
9886 < 1124d1112
9886 > 1116,1117c1105
9887   <
9888 < 1137d1124
9888 > < CREATE PROCEDURE ADD_EMP_PROJ
9889 > ---
9890 > > CREATE PROCEDURE ADD_EMP_PROJ
9891 > 1124d1111
9892   <
9893 < 1146d1132
9893 > 1126,1127c1113
9894   <
9895 < 1159d1144
9895 > < CREATE PROCEDURE ALL_LANGS
9896 > ---
9897 > > CREATE PROCEDURE ALL_LANGS
9898 > 1137d1122
9899   <
9900 < 1172d1156
9900 > 1139,1140c1124
9901   <
9902 < 1181d1164
9902 > < CREATE PROCEDURE DELETE_EMPLOYEE
9903 > ---
9904 > > CREATE PROCEDURE DELETE_EMPLOYEE
9905 > 1146d1129
9906   <
9907 < 1199d1181
9907 > 1148,1149c1131
9908   <
9909 < 1213d1194
9909 > < CREATE PROCEDURE DEPT_BUDGET
9910 > ---
9911 > > CREATE PROCEDURE DEPT_BUDGET
9912 > 1159d1140
9913   <
9914 < 1222d1202
9914 > 1161,1162c1142
9915   <
9916 < 1238d1217
9916 > < CREATE PROCEDURE GET_EMP_PROJ
9917 > ---
9918 > > CREATE PROCEDURE GET_EMP_PROJ
9919 > 1172d1151
9920   <
9921 < 1247d1225
9921 > 1174,1175c1153
9922   <
9923 < 1253d1230
9923 > < CREATE PROCEDURE "Has Space"
9924 > ---
9925 > > CREATE PROCEDURE "Has Space"
9926 > 1181d1158
9927   <
9928 < 1259,1265d1235
9929 < < COMMIT WORK;
9930 < < SET AUTODDL OFF;
9931 < < SET TERM ^ ;
9928 > 1183,1184c1160
9929 > <
9930 > < CREATE PROCEDURE MAIL_LABEL
9931 > ---
9932 > > CREATE PROCEDURE MAIL_LABEL
9933 > 1199d1174
9934 > <
9935 > 1201,1202c1176
9936 > <
9937 > < CREATE PROCEDURE ORG_CHART
9938 > ---
9939 > > CREATE PROCEDURE ORG_CHART
9940 > 1213d1186
9941 > <
9942 > 1215,1216c1188
9943 > <
9944 > < CREATE PROCEDURE SHIP_ORDER
9945 > ---
9946 > > CREATE PROCEDURE SHIP_ORDER
9947 > 1222d1193
9948 > <
9949 > 1224,1225c1195
9950 > <
9951 > < CREATE PROCEDURE SUB_TOT_BUDGET
9952 > ---
9953 > > CREATE PROCEDURE SUB_TOT_BUDGET
9954 > 1238d1207
9955 > <
9956 > 1240,1241c1209
9957 > <
9958 > < CREATE PROCEDURE "UC SPACE"
9959 > ---
9960 > > CREATE PROCEDURE "UC SPACE"
9961 > 1247d1214
9962 > <
9963 > 1249,1250c1216
9964 > <
9965 > < CREATE PROCEDURE "iCASE"
9966 > ---
9967 > > CREATE PROCEDURE "iCASE"
9968 > 1253d1218
9969 > <
9970 > 1255,1262d1219
9971   <
9972   < SET TERM ; ^
9973   < COMMIT WORK;
9974   < SET AUTODDL ON;
9986 – 1731,1738d1700
9975   < COMMIT WORK;
9976   < SET AUTODDL OFF;
9977   < SET TERM ^ ;
9978   <
9979 + 1318c1275
9980 + < ALTER PROCEDURE SHOW_LANGS
9981 + ---
9982 + > ALTER PROCEDURE SHOW_LANGS
9983 + 1344,1345c1301
9984 + <  ^
9985 + <
9986 + ---
9987 + > ^
9988 + 1347c1303
9989 + < ALTER PROCEDURE ADD_EMP_PROJ
9990 + ---
9991 + > ALTER PROCEDURE ADD_EMP_PROJ
9992 + 1360,1361c1316
9993 + <  ^
9994 + <
9995 + ---
9996 + > ^
9997 + 1363c1318
9998 + < ALTER PROCEDURE ALL_LANGS
9999 + ---
10000 + > ALTER PROCEDURE ALL_LANGS
10001 + 1389,1390c1344
10002 + <  ^
10003 + <
10004 + ---
10005 + > ^
10006 + 1392c1346
10007 + < ALTER PROCEDURE DELETE_EMPLOYEE
10008 + ---
10009 + > ALTER PROCEDURE DELETE_EMPLOYEE
10010 + 1449,1450c1403
10011 + <  ^
10012 + <
10013 + ---
10014 + > ^
10015 + 1452c1405
10016 + < ALTER PROCEDURE DEPT_BUDGET
10017 + ---
10018 + > ALTER PROCEDURE DEPT_BUDGET
10019 + 1486,1487c1439
10020 + <  ^
10021 + <
10022 + ---
10023 + > ^
10024 + 1489c1441
10025 + < ALTER PROCEDURE GET_EMP_PROJ
10026 + ---
10027 + > ALTER PROCEDURE GET_EMP_PROJ
10028 + 1506,1507c1458
10029 + <  ^
10030 + <
10031 + ---
10032 + > ^
10033 + 1509c1460
10034 + < ALTER PROCEDURE "Has Space"
10035 + ---
10036 + > ALTER PROCEDURE "Has Space"
10037 + 1515,1516c1466
10038 + <  ^
10039 + <
10040 + ---
10041 + > ^
10042 + 1518c1468
10043 + < ALTER PROCEDURE MAIL_LABEL
10044 + ---
10045 + > ALTER PROCEDURE MAIL_LABEL
10046 + 1586,1587c1536
10047 + <  ^
10048 + <
10049 + ---
10050 + > ^
10051 + 1589c1538
10052 + < ALTER PROCEDURE ORG_CHART
10053 + ---
10054 + > ALTER PROCEDURE ORG_CHART
10055 + 1629,1630c1578
10056 + <  ^
10057 + <
10058 + ---
10059 + > ^
10060 + 1632c1580
10061 + < ALTER PROCEDURE SHIP_ORDER
10062 + ---
10063 + > ALTER PROCEDURE SHIP_ORDER
10064 + 1689,1690c1637
10065 + <  ^
10066 + <
10067 + ---
10068 + > ^
10069 + 1692c1639
10070 + < ALTER PROCEDURE SUB_TOT_BUDGET
10071 + ---
10072 + > ALTER PROCEDURE SUB_TOT_BUDGET
10073 + 1711,1712c1658
10074 + <  ^
10075 + <
10076 + ---
10077 + > ^
10078 + 1714c1660
10079 + < ALTER PROCEDURE "UC SPACE"
10080 + ---
10081 + > ALTER PROCEDURE "UC SPACE"
10082 + 1720,1721c1666
10083 + <  ^
10084 + <
10085 + ---
10086 + > ^
10087 + 1723c1668
10088 + < ALTER PROCEDURE "iCASE"
10089 + ---
10090 + > ALTER PROCEDURE "iCASE"
10091 + 1726,1735c1671
10092 + <  ^
10093   <
10094   < SET TERM ; ^
10095   < COMMIT WORK;
10096   < SET AUTODDL ON;
10097 < 1777d1738
10097 > < COMMIT WORK;
10098 > < SET AUTODDL OFF;
10099 > < SET TERM ^ ;
10100 > <
10101 > <
10102 > ---
10103 > > ^
10104 > 1777d1712
10105   <
10106  
10107  
# Line 10048 | Line 10157 | Message File Location = /opt/firebird2.5
10157   Database Statistics for employee
10158  
10159   Database "/opt/firebird2.5.9/examples/empbuild/employee.fdb"
10160 < Gstat execution time Mon Feb 22 10:28:12 2021
10160 > Gstat execution time Wed Oct  6 10:04:39 2021
10161  
10162   Database header page information:
10163   Flags                   0
10164   Checksum                12345
10165 < Generation              4475
10165 > Generation              6419
10166   Page size               4096
10167   ODS version             11.2
10168 < Oldest transaction      2730
10169 < Oldest active           2731
10170 < Oldest snapshot         2731
10171 < Next transaction        2731
10168 > Oldest transaction      3850
10169 > Oldest active           3851
10170 > Oldest snapshot         3851
10171 > Next transaction        3851
10172   Bumped transaction      1
10173   Sequence number         0
10174 < Next attachment ID      918
10174 > Next attachment ID      1316
10175   Implementation ID       24
10176   Shadow count            0
10177   Page buffers            0
# Line 10187 | Line 10296 | zeus   Tue Jun  9 14:31:01 2020
10296   INET/inet_error: connect errno = 111
10297  
10298   Online Validation
10299 < 10:28:13.55 Validation started
10299 > 10:04:40.20 Validation started
10300  
10301 < 10:28:13.55 Relation 128 (COUNTRY)
10302 < 10:28:13.55   process pointer page    0 of    1
10303 < 10:28:13.56 Index 1 (RDB$PRIMARY1)
10304 < 10:28:13.56 Relation 128 (COUNTRY) is ok
10305 <
10306 < 10:28:13.56 Relation 129 (JOB)
10307 < 10:28:13.56   process pointer page    0 of    1
10308 < 10:28:13.56 Index 1 (RDB$PRIMARY2)
10309 < 10:28:13.56 Index 2 (RDB$FOREIGN3)
10310 < 10:28:13.56 Index 3 (MAXSALX)
10311 < 10:28:13.56 Index 4 (MINSALX)
10312 < 10:28:13.56 Relation 129 (JOB) is ok
10313 <
10314 < 10:28:13.56 Relation 130 (DEPARTMENT)
10315 < 10:28:13.56   process pointer page    0 of    1
10316 < 10:28:13.56 Index 1 (RDB$4)
10317 < 10:28:13.56 Index 2 (RDB$PRIMARY5)
10318 < 10:28:13.56 Index 3 (RDB$FOREIGN6)
10319 < 10:28:13.56 Index 4 (BUDGETX)
10320 < 10:28:13.56 Index 5 (RDB$FOREIGN10)
10321 < 10:28:13.56 Relation 130 (DEPARTMENT) is ok
10322 <
10323 < 10:28:13.56 Relation 131 (EMPLOYEE)
10324 < 10:28:13.56   process pointer page    0 of    1
10325 < 10:28:13.56 Index 1 (RDB$PRIMARY7)
10326 < 10:28:13.56 Index 2 (RDB$FOREIGN8)
10327 < 10:28:13.56 Index 3 (RDB$FOREIGN9)
10328 < 10:28:13.56 Index 4 (NAMEX)
10329 < 10:28:13.56 Relation 131 (EMPLOYEE) is ok
10330 <
10331 < 10:28:13.56 Relation 133 (PROJECT)
10332 < 10:28:13.56   process pointer page    0 of    1
10333 < 10:28:13.56 Index 1 (RDB$11)
10334 < 10:28:13.56 Index 2 (RDB$PRIMARY12)
10335 < 10:28:13.56 Index 3 (RDB$FOREIGN13)
10336 < 10:28:13.56 Index 4 (PRODTYPEX)
10337 < 10:28:13.56 Relation 133 (PROJECT) is ok
10338 <
10339 < 10:28:13.56 Relation 134 (EMPLOYEE_PROJECT)
10340 < 10:28:13.56   process pointer page    0 of    1
10341 < 10:28:13.56 Index 1 (RDB$PRIMARY14)
10342 < 10:28:13.56 Index 2 (RDB$FOREIGN15)
10343 < 10:28:13.57 Index 3 (RDB$FOREIGN16)
10344 < 10:28:13.57 Relation 134 (EMPLOYEE_PROJECT) is ok
10345 <
10346 < 10:28:13.57 Relation 135 (PROJ_DEPT_BUDGET)
10347 < 10:28:13.57   process pointer page    0 of    1
10348 < 10:28:13.57 Index 1 (RDB$PRIMARY17)
10349 < 10:28:13.57 Index 2 (RDB$FOREIGN18)
10350 < 10:28:13.57 Index 3 (RDB$FOREIGN19)
10351 < 10:28:13.57 Relation 135 (PROJ_DEPT_BUDGET) is ok
10352 <
10353 < 10:28:13.57 Relation 136 (SALARY_HISTORY)
10354 < 10:28:13.57   process pointer page    0 of    1
10355 < 10:28:13.57 Index 1 (RDB$PRIMARY20)
10356 < 10:28:13.57 Index 2 (RDB$FOREIGN21)
10357 < 10:28:13.57 Index 3 (CHANGEX)
10358 < 10:28:13.57 Index 4 (UPDATERX)
10359 < 10:28:13.57 Relation 136 (SALARY_HISTORY) is ok
10360 <
10361 < 10:28:13.57 Relation 137 (CUSTOMER)
10362 < 10:28:13.57   process pointer page    0 of    1
10363 < 10:28:13.57 Index 1 (RDB$PRIMARY22)
10364 < 10:28:13.57 Index 2 (RDB$FOREIGN23)
10365 < 10:28:13.57 Index 3 (CUSTNAMEX)
10366 < 10:28:13.57 Index 4 (CUSTREGION)
10367 < 10:28:13.57 Relation 137 (CUSTOMER) is ok
10368 <
10369 < 10:28:13.57 Relation 138 (SALES)
10370 < 10:28:13.58   process pointer page    0 of    1
10371 < 10:28:13.58 Index 1 (RDB$PRIMARY24)
10372 < 10:28:13.58 Index 2 (RDB$FOREIGN25)
10373 < 10:28:13.58 Index 3 (RDB$FOREIGN26)
10374 < 10:28:13.58 Index 4 (NEEDX)
10375 < 10:28:13.58 Index 5 (QTYX)
10376 < 10:28:13.58 Index 6 (SALESTATX)
10377 < 10:28:13.58 Relation 138 (SALES) is ok
10301 > 10:04:40.20 Relation 128 (COUNTRY)
10302 > 10:04:40.20   process pointer page    0 of    1
10303 > 10:04:40.20 Index 1 (RDB$PRIMARY1)
10304 > 10:04:40.20 Relation 128 (COUNTRY) is ok
10305 >
10306 > 10:04:40.20 Relation 129 (JOB)
10307 > 10:04:40.20   process pointer page    0 of    1
10308 > 10:04:40.20 Index 1 (RDB$PRIMARY2)
10309 > 10:04:40.20 Index 2 (RDB$FOREIGN3)
10310 > 10:04:40.20 Index 3 (MAXSALX)
10311 > 10:04:40.20 Index 4 (MINSALX)
10312 > 10:04:40.20 Relation 129 (JOB) is ok
10313 >
10314 > 10:04:40.20 Relation 130 (DEPARTMENT)
10315 > 10:04:40.20   process pointer page    0 of    1
10316 > 10:04:40.20 Index 1 (RDB$4)
10317 > 10:04:40.21 Index 2 (RDB$PRIMARY5)
10318 > 10:04:40.21 Index 3 (RDB$FOREIGN6)
10319 > 10:04:40.21 Index 4 (BUDGETX)
10320 > 10:04:40.21 Index 5 (RDB$FOREIGN10)
10321 > 10:04:40.21 Relation 130 (DEPARTMENT) is ok
10322 >
10323 > 10:04:40.21 Relation 131 (EMPLOYEE)
10324 > 10:04:40.21   process pointer page    0 of    1
10325 > 10:04:40.21 Index 1 (RDB$PRIMARY7)
10326 > 10:04:40.21 Index 2 (RDB$FOREIGN8)
10327 > 10:04:40.21 Index 3 (RDB$FOREIGN9)
10328 > 10:04:40.21 Index 4 (NAMEX)
10329 > 10:04:40.21 Relation 131 (EMPLOYEE) is ok
10330 >
10331 > 10:04:40.21 Relation 133 (PROJECT)
10332 > 10:04:40.21   process pointer page    0 of    1
10333 > 10:04:40.21 Index 1 (RDB$11)
10334 > 10:04:40.21 Index 2 (RDB$PRIMARY12)
10335 > 10:04:40.21 Index 3 (RDB$FOREIGN13)
10336 > 10:04:40.21 Index 4 (PRODTYPEX)
10337 > 10:04:40.21 Relation 133 (PROJECT) is ok
10338 >
10339 > 10:04:40.21 Relation 134 (EMPLOYEE_PROJECT)
10340 > 10:04:40.21   process pointer page    0 of    1
10341 > 10:04:40.21 Index 1 (RDB$PRIMARY14)
10342 > 10:04:40.21 Index 2 (RDB$FOREIGN15)
10343 > 10:04:40.21 Index 3 (RDB$FOREIGN16)
10344 > 10:04:40.21 Relation 134 (EMPLOYEE_PROJECT) is ok
10345 >
10346 > 10:04:40.21 Relation 135 (PROJ_DEPT_BUDGET)
10347 > 10:04:40.21   process pointer page    0 of    1
10348 > 10:04:40.21 Index 1 (RDB$PRIMARY17)
10349 > 10:04:40.21 Index 2 (RDB$FOREIGN18)
10350 > 10:04:40.21 Index 3 (RDB$FOREIGN19)
10351 > 10:04:40.21 Relation 135 (PROJ_DEPT_BUDGET) is ok
10352 >
10353 > 10:04:40.21 Relation 136 (SALARY_HISTORY)
10354 > 10:04:40.21   process pointer page    0 of    1
10355 > 10:04:40.21 Index 1 (RDB$PRIMARY20)
10356 > 10:04:40.21 Index 2 (RDB$FOREIGN21)
10357 > 10:04:40.21 Index 3 (CHANGEX)
10358 > 10:04:40.21 Index 4 (UPDATERX)
10359 > 10:04:40.21 Relation 136 (SALARY_HISTORY) is ok
10360 >
10361 > 10:04:40.21 Relation 137 (CUSTOMER)
10362 > 10:04:40.22   process pointer page    0 of    1
10363 > 10:04:40.22 Index 1 (RDB$PRIMARY22)
10364 > 10:04:40.22 Index 2 (RDB$FOREIGN23)
10365 > 10:04:40.22 Index 3 (CUSTNAMEX)
10366 > 10:04:40.22 Index 4 (CUSTREGION)
10367 > 10:04:40.22 Relation 137 (CUSTOMER) is ok
10368 >
10369 > 10:04:40.22 Relation 138 (SALES)
10370 > 10:04:40.22   process pointer page    0 of    1
10371 > 10:04:40.22 Index 1 (RDB$PRIMARY24)
10372 > 10:04:40.22 Index 2 (RDB$FOREIGN25)
10373 > 10:04:40.22 Index 3 (RDB$FOREIGN26)
10374 > 10:04:40.22 Index 4 (NEEDX)
10375 > 10:04:40.22 Index 5 (QTYX)
10376 > 10:04:40.22 Index 6 (SALESTATX)
10377 > 10:04:40.22 Relation 138 (SALES) is ok
10378  
10379 < 10:28:13.58 Validation finished
10379 > 10:04:40.22 Validation finished
10380  
10381  
10382   Normal Validation
# Line 11777 | Line 11886 | Rows printed = 2
11886   Current memory = 966,728
11887   Delta memory = 9,344
11888   Max memory = 1,012,400
11889 < Elapsed time= 0.103 sec
11890 < Cpu = 0.000 sec
11889 > Elapsed time= 0.106 sec
11890 > Cpu = 0.001 sec
11891   Buffers = 75
11892   Reads = 2
11893   Writes = 0
# Line 13116 | Line 13225 | Create Table LotsOfData (
13225      MyText VarChar(1024),
13226      Primary Key (RowID)
13227    );                
13228 < Loading data into database table. Started at 22/2/2021 10:29:05.094
13229 < Data load completed at 22/2/2021 10:31:52.887 Elapsed Time = 167794 ms, 100000 records loaded
13230 < MD5 checksum = 2bd6187c4b844d60db96a46a04785c20
13231 < Database Read started at 22/2/2021 10:31:52.899
13232 < Read Dataset completed at 22/2/2021 10:32:25.605 Elapsed Time = 32706 ms, 100000 records read
13233 < MD5 checksum = 2bd6187c4b844d60db96a46a04785c20
13228 > Loading data into database table. Started at 06/10/2021 10:05:22.459
13229 > Data load completed at 06/10/2021 10:08:21.403 Elapsed Time = 178944 ms, 100000 records loaded
13230 > Message Hash = 892c561d9a7b1248cbe1289c339cc5d1
13231 > Database Read started at 06/10/2021 10:08:21.411
13232 > Read Dataset completed at 06/10/2021 10:08:52.088 Elapsed Time = 30677 ms, 100000 records read
13233 > Message Hash = 892c561d9a7b1248cbe1289c339cc5d1
13234   Test Completed successfully
13235 < 22/2/2021 10:32:25.605Test 21 passes as long as the MD5 sums are identical
13235 > 06/10/2021 10:08:52.088 Test 21 passes as long as the checksums are identical
13236  
13237  
13238   ------------------------------------------------------

Diff Legend

– Removed lines
+ Added lines
< Changed lines
> Changed lines