[ViewVC] Diff of: public/ibx/branches/journaling/testsuite/FB3reference.log

Comparing ibx/trunk/testsuite/FB3reference.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 644 \| Line 644 \| Rows printed = 42
644		Current memory = 19,651,152
645		Delta memory = 13,040
646		Max memory = 19,779,424
647	<	Elapsed time= 0.027 sec
648	<	Cpu = 0.010 sec
647	>	Elapsed time= 0.022 sec
648	>	Cpu = 0.000 sec
649		Buffers = 2048
650		Reads = 2
651		Writes = 0
#	Line 1445 \| Line 1445 \| DPB: Item Count = 3
1445		isc_dpb_lc_ctype = UTF8
1446
1447		Before Disconnect
1448	<	inet://localhost/employee Disconnected after 18 ms
1448	>	inet://localhost/employee Disconnected after 21 ms
1449		Before Connect
1450		Connected to inet://localhost/employee
1451		DPB: Item Count = 3
#	Line 1454 \| Line 1454 \| DPB: Item Count = 3
1454		isc_dpb_lc_ctype = UTF8
1455
1456		Before Disconnect
1457	<	inet://localhost/employee Disconnected after 3952 ms
1457	>	inet://localhost/employee Disconnected after 4015 ms
1458		Idle Timer Expired for Test_Database_02
1459		Database Closed
1460		Transaction Events
#	Line 1494 \| Line 1494 \| Transaction Ending
1494		Transaction Ended after 2000 ms
1495		Idle Timer Expired for Test_Transaction_02
1496		Before Disconnect
1497	<	inet://localhost/employee Disconnected after 2029 ms
1497	>	inet://localhost/employee Disconnected after 2040 ms
1498		SQL Dialect Downgrade test
1499		Before Connect
1500		Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
#	Line 1506 \| Line 1506 \| DPB: Item Count = 4
1506
1507		inet://localhost//tmp/ibx-testsuite/testsuite1.fdb created
1508		Before Disconnect
1509	<	inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 21 ms
1509	>	inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 20 ms
1510		Before Connect
1511		Warning: SQL Dialect Downgrade of inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
1512		Connected to inet://localhost//tmp/ibx-testsuite/testsuite1.fdb
#	Line 1516 \| Line 1516 \| DPB: Item Count = 3
1516		isc_dpb_lc_ctype = UTF8
1517
1518		Before Disconnect
1519	<	inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 28 ms
1519	>	inet://localhost//tmp/ibx-testsuite/testsuite1.fdb Disconnected after 36 ms
1520
1521
1522		------------------------------------------------------
#	Line 3172 \| Line 3172 \| Current memory = 19,653,504
3172		Delta memory = 13,072
3173		Max memory = 19,729,584
3174		Elapsed time= 0.023 sec
3175	<	Cpu = 0.010 sec
3175	>	Cpu = 0.020 sec
3176		Buffers = 2048
3177		Reads = 2
3178		Writes = 0
#	Line 4075 \| Line 4075 \| SET TERM ^ ;
4075
4076		/* Stored procedures Definitions*/
4077
4078	<	CREATE PROCEDURE SHOW_LANGS
4078	>	CREATE PROCEDURE SHOW_LANGS
4079		(
4080		CODE VARCHAR(5) CHARACTER SET NONE,
4081		GRADE SMALLINT,
#	Line 4088 \| Line 4088 \| RETURNS
4088		AS
4089		BEGIN SUSPEND; EXIT; END
4090		^
4091	<
4092	<	CREATE PROCEDURE ADD_EMP_PROJ
4091	>	CREATE PROCEDURE ADD_EMP_PROJ
4092		(
4093		EMP_NO SMALLINT,
4094		PROJ_ID CHAR(5) CHARACTER SET NONE
#	Line 4097 \| Line 4096 \| CREATE PROCEDURE ADD_EMP_PROJ
4096		AS
4097		BEGIN SUSPEND; EXIT; END
4098		^
4099	<
4101	<	CREATE PROCEDURE ALL_LANGS
4099	>	CREATE PROCEDURE ALL_LANGS
4100		RETURNS
4101		(
4102		CODE VARCHAR(5) CHARACTER SET NONE,
#	Line 4109 \| Line 4107 \| RETURNS
4107		AS
4108		BEGIN SUSPEND; EXIT; END
4109		^
4110	<
4113	<	CREATE PROCEDURE DELETE_EMPLOYEE
4110	>	CREATE PROCEDURE DELETE_EMPLOYEE
4111		(
4112		EMP_NUM INTEGER
4113		)
4114		AS
4115		BEGIN SUSPEND; EXIT; END
4116		^
4117	<
4121	<	CREATE PROCEDURE DEPT_BUDGET
4117	>	CREATE PROCEDURE DEPT_BUDGET
4118		(
4119		DNO CHAR(3) CHARACTER SET NONE
4120		)
#	Line 4129 \| Line 4125 \| RETURNS
4125		AS
4126		BEGIN SUSPEND; EXIT; END
4127		^
4128	<
4133	<	CREATE PROCEDURE GET_EMP_PROJ
4128	>	CREATE PROCEDURE GET_EMP_PROJ
4129		(
4130		EMP_NO SMALLINT
4131		)
#	Line 4141 \| Line 4136 \| RETURNS
4136		AS
4137		BEGIN SUSPEND; EXIT; END
4138		^
4139	<
4145	<	CREATE PROCEDURE MAIL_LABEL
4139	>	CREATE PROCEDURE MAIL_LABEL
4140		(
4141		CUST_NO INTEGER
4142		)
#	Line 4158 \| Line 4152 \| RETURNS
4152		AS
4153		BEGIN SUSPEND; EXIT; END
4154		^
4155	<
4162	<	CREATE PROCEDURE ORG_CHART
4155	>	CREATE PROCEDURE ORG_CHART
4156		RETURNS
4157		(
4158		HEAD_DEPT CHAR(25) CHARACTER SET NONE,
#	Line 4171 \| Line 4164 \| RETURNS
4164		AS
4165		BEGIN SUSPEND; EXIT; END
4166		^
4167	<
4175	<	CREATE PROCEDURE SHIP_ORDER
4167	>	CREATE PROCEDURE SHIP_ORDER
4168		(
4169		PO_NUM CHAR(8) CHARACTER SET NONE
4170		)
4171		AS
4172		BEGIN SUSPEND; EXIT; END
4173		^
4174	<
4183	<	CREATE PROCEDURE SUB_TOT_BUDGET
4174	>	CREATE PROCEDURE SUB_TOT_BUDGET
4175		(
4176		HEAD_DEPT CHAR(3) CHARACTER SET NONE
4177		)
#	Line 4194 \| Line 4185 \| RETURNS
4185		AS
4186		BEGIN SUSPEND; EXIT; END
4187		^
4197	–
4188		SET TERM ; ^
4189		COMMIT WORK;
4190		SET AUTODDL ON;
#	Line 4250 \| Line 4240 \| SET TERM ^ ;
4240		/* Stored procedure Bodies */
4241
4242
4243	<	ALTER PROCEDURE SHOW_LANGS
4243	>	ALTER PROCEDURE SHOW_LANGS
4244		(
4245		CODE VARCHAR(5) CHARACTER SET NONE,
4246		GRADE SMALLINT,
#	Line 4276 \| Line 4266 \| BEGIN
4266		SUSPEND;
4267		END
4268		END
4269	<	^
4280	<
4269	>	^
4270
4271	<	ALTER PROCEDURE ADD_EMP_PROJ
4271	>	ALTER PROCEDURE ADD_EMP_PROJ
4272		(
4273		EMP_NO SMALLINT,
4274		PROJ_ID CHAR(5) CHARACTER SET NONE
#	Line 4293 \| Line 4282 \| BEGIN
4282		END
4283		SUSPEND;
4284		END
4285	<	^
4297	<
4285	>	^
4286
4287	<	ALTER PROCEDURE ALL_LANGS
4287	>	ALTER PROCEDURE ALL_LANGS
4288		RETURNS
4289		(
4290		CODE VARCHAR(5) CHARACTER SET NONE,
#	Line 4322 \| Line 4310 \| BEGIN
4310		SUSPEND;
4311		END
4312		END
4313	<	^
4326	<
4313	>	^
4314
4315	<	ALTER PROCEDURE DELETE_EMPLOYEE
4315	>	ALTER PROCEDURE DELETE_EMPLOYEE
4316		(
4317		EMP_NUM INTEGER
4318		)
#	Line 4384 \| Line 4371 \| BEGIN
4371
4372		SUSPEND;
4373		END
4374	<	^
4388	<
4374	>	^
4375
4376	<	ALTER PROCEDURE DEPT_BUDGET
4376	>	ALTER PROCEDURE DEPT_BUDGET
4377		(
4378		DNO CHAR(3) CHARACTER SET NONE
4379		)
#	Line 4421 \| Line 4407 \| BEGIN
4407
4408		SUSPEND;
4409		END
4410	<	^
4425	<
4410	>	^
4411
4412	<	ALTER PROCEDURE GET_EMP_PROJ
4412	>	ALTER PROCEDURE GET_EMP_PROJ
4413		(
4414		EMP_NO SMALLINT
4415		)
#	Line 4441 \| Line 4426 \| BEGIN
4426		DO
4427		SUSPEND;
4428		END
4429	<	^
4445	<
4429	>	^
4430
4431	<	ALTER PROCEDURE MAIL_LABEL
4431	>	ALTER PROCEDURE MAIL_LABEL
4432		(
4433		CUST_NO INTEGER
4434		)
#	Line 4512 \| Line 4496 \| BEGIN
4496
4497		SUSPEND;
4498		END
4499	<	^
4516	<
4499	>	^
4500
4501	<	ALTER PROCEDURE ORG_CHART
4501	>	ALTER PROCEDURE ORG_CHART
4502		RETURNS
4503		(
4504		HEAD_DEPT CHAR(25) CHARACTER SET NONE,
#	Line 4555 \| Line 4538 \| BEGIN
4538		SUSPEND;
4539		END
4540		END
4541	<	^
4559	<
4541	>	^
4542
4543	<	ALTER PROCEDURE SHIP_ORDER
4543	>	ALTER PROCEDURE SHIP_ORDER
4544		(
4545		PO_NUM CHAR(8) CHARACTER SET NONE
4546		)
#	Line 4619 \| Line 4601 \| BEGIN
4601
4602		SUSPEND;
4603		END
4604	<	^
4623	<
4604	>	^
4605
4606	<	ALTER PROCEDURE SUB_TOT_BUDGET
4606	>	ALTER PROCEDURE SUB_TOT_BUDGET
4607		(
4608		HEAD_DEPT CHAR(3) CHARACTER SET NONE
4609		)
#	Line 4641 \| Line 4622 \| BEGIN
4622		INTO :tot_budget, :avg_budget, :min_budget, :max_budget;
4623		SUSPEND;
4624		END
4625	<	^
4645	<
4625	>	^
4626		SET TERM ; ^
4627		COMMIT WORK;
4628		SET AUTODDL ON;
#	Line 5686 \| Line 5666 \| CREATE VIEW DEPTLIST (
5666		SALARY,
5667		FULL_NAME,
5668		DEPT_PATH,
5669	<	DEPT_KEY_PATH
5669	>	DEPT_KEY_PATH,
5670	>	"Payment Status"
5671		) AS
5672		with recursive Depts As (
5673		Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,
#	Line 5700 \| Line 5681 \| JOIN Depts On D.HEAD_DEPT = Depts.DEPT_N
5681		)
5682
5683		Select distinct A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,
5684	<	A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH
5684	>	A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH,
5685	>	CASE When A.SALARY > 10000 then 'higher paid' else 'lower paid' End
5686		From EMPLOYEE A
5687		JOIN Depts D On D.DEPT_NO = A.DEPT_NO
5688		;
#	Line 5830 \| Line 5812 \| begin
5812
5813		procedure get_lines returns (lines fb$out_type);
5814		end
5815	<	^
5815	>	^
5816
5817		CREATE PACKAGE SELECT$TEST
5818		AS
#	Line 5838 \| Line 5820 \| AS
5820		Begin
5821		Procedure ShowItems(IPARAM Integer) RETURNS (OutParam integer);
5822		End
5823	<	^
5823	>	^
5824
5825	<	SET TERM ; ^
5825	>	SET TERM ;^
5826		COMMIT WORK;
5827		SET AUTODDL ON;
5828		COMMIT WORK;
#	Line 5909 \| Line 5891 \| BEGIN SUSPEND; EXIT; END
5891
5892		^
5893
5894	+	CREATE PROCEDURE EMPLOYEE_PAY_STATUS
5895	+	(
5896	+	EMP_NO SMALLINT
5897	+	)
5898	+	RETURNS
5899	+	(
5900	+	PAY_STATUS VARCHAR(6) CHARACTER SET NONE
5901	+	)
5902	+	AS
5903	+	BEGIN EXIT; END
5904	+
5905	+	^
5906	+
5907	+
5908		CREATE PROCEDURE GET_EMP_PROJ
5909		(
5910		EMP_NO SMALLINT
#	Line 6003 \| Line 5999 \| BEGIN EXIT; END
5999
6000		^
6001
6002	<	SET TERM ; ^
6002	>	SET TERM ;^
6003		COMMIT WORK;
6004		SET AUTODDL ON;
6005		COMMIT WORK;
#	Line 6019 \| Line 6015 \| CREATE FUNCTION F (X INTEGER)
6015		^
6016
6017
6018	<	SET TERM ; ^
6018	>	SET TERM ;^
6019		COMMIT WORK;
6020		SET AUTODDL ON;
6021		SET TERM ^ ;
#	Line 6032 \| Line 6028 \| ACTIVE ON CONNECT POSITION 0
6028		as
6029		begin
6030		End
6031	<	^
6031	>	^
6032		CREATE TRIGGER "BEFORE CREATE TABLE"
6033		ACTIVE BEFORE CREATE TABLE POSITION 0
6034		AS BEGIN END
6035	<	^
6035	>	^
6036		CREATE TRIGGER "AFTER CREATE TABLE"
6037		ACTIVE AFTER CREATE TABLE POSITION 0
6038		AS BEGIN END
6039	<	^
6039	>	^
6040		CREATE TRIGGER "BEFORE ALTER TABLE"
6041		ACTIVE BEFORE ALTER TABLE POSITION 0
6042		AS BEGIN END
6043	<	^
6043	>	^
6044		CREATE TRIGGER "AFTER ALTER TABLE"
6045		ACTIVE AFTER ALTER TABLE POSITION 0
6046		AS BEGIN END
6047	<	^
6047	>	^
6048		CREATE TRIGGER "AFTER CREATE/Alter TABLE"
6049		ACTIVE AFTER CREATE TABLE OR ALTER TABLE POSITION 0
6050		AS BEGIN END
6051	<	^
6051	>	^
6052		CREATE TRIGGER "BEFORE DROP TABLE"
6053		ACTIVE BEFORE Drop TABLE POSITION 0
6054		AS BEGIN END
6055	<	^
6055	>	^
6056		CREATE TRIGGER "AFTER DROP TABLE"
6057		ACTIVE AFTER Drop TABLE POSITION 0
6058		AS BEGIN END
6059	<	^
6059	>	^
6060		CREATE TRIGGER "BEFORE CREATE PROCEDURE"
6061		ACTIVE BEFORE CREATE PROCEDURE POSITION 0
6062		AS BEGIN END
6063	<	^
6063	>	^
6064		CREATE TRIGGER "AFTER CREATE PROCEDURE"
6065		ACTIVE AFTER CREATE PROCEDURE POSITION 0
6066		AS BEGIN END
6067	<	^
6067	>	^
6068		CREATE TRIGGER "BEFORE ALTER PROCEDURE"
6069		ACTIVE BEFORE ALTER PROCEDURE POSITION 0
6070		AS BEGIN END
6071	<	^
6071	>	^
6072		CREATE TRIGGER "AFTER ALTER PROCEDURE"
6073		ACTIVE AFTER ALTER PROCEDURE POSITION 0
6074		AS BEGIN END
6075	<	^
6075	>	^
6076		CREATE TRIGGER "BEFORE DROP PROCEDURE"
6077		ACTIVE BEFORE Drop PROCEDURE POSITION 0
6078		AS BEGIN END
6079	<	^
6079	>	^
6080		CREATE TRIGGER "AFTER DROP PROCEDURE"
6081		ACTIVE AFTER Drop PROCEDURE POSITION 0
6082		AS BEGIN END
6083	<	^
6083	>	^
6084		CREATE TRIGGER "BEFORE CREATE FUNCTION"
6085		ACTIVE BEFORE CREATE FUNCTION POSITION 0
6086		AS BEGIN END
6087	<	^
6087	>	^
6088		CREATE TRIGGER "AFTER CREATE FUNCTION"
6089		ACTIVE AFTER CREATE FUNCTION POSITION 0
6090		AS BEGIN END
6091	<	^
6091	>	^
6092		CREATE TRIGGER "BEFORE ALTER FUNCTION"
6093		ACTIVE BEFORE ALTER FUNCTION POSITION 0
6094		AS BEGIN END
6095	<	^
6095	>	^
6096		CREATE TRIGGER "AFTER ALTER FUNCTION"
6097		ACTIVE AFTER ALTER FUNCTION POSITION 0
6098		AS BEGIN END
6099	<	^
6099	>	^
6100		CREATE TRIGGER "BEFORE DROP FUNCTION"
6101		ACTIVE BEFORE Drop FUNCTION POSITION 0
6102		AS BEGIN END
6103	<	^
6103	>	^
6104		CREATE TRIGGER "AFTER DROP FUNCTION"
6105		ACTIVE AFTER Drop FUNCTION POSITION 0
6106		AS BEGIN END
6107	<	^
6107	>	^
6108		CREATE TRIGGER "BEFORE CREATE TRIGGER"
6109		ACTIVE BEFORE CREATE TRIGGER POSITION 0
6110		AS BEGIN END
6111	<	^
6111	>	^
6112		CREATE TRIGGER "AFTER CREATE TRIGGER"
6113		ACTIVE AFTER CREATE TRIGGER POSITION 0
6114		AS BEGIN END
6115	<	^
6115	>	^
6116		CREATE TRIGGER "BEFORE ALTER TRIGGER"
6117		ACTIVE BEFORE ALTER TRIGGER POSITION 0
6118		AS BEGIN END
6119	<	^
6119	>	^
6120		CREATE TRIGGER "AFTER ALTER TRIGGER"
6121		ACTIVE AFTER ALTER TRIGGER POSITION 0
6122		AS BEGIN END
6123	<	^
6123	>	^
6124		CREATE TRIGGER "BEFORE DROP TRIGGER"
6125		ACTIVE BEFORE Drop TRIGGER POSITION 0
6126		AS BEGIN END
6127	<	^
6127	>	^
6128		CREATE TRIGGER "AFTER DROP TRIGGER"
6129		ACTIVE AFTER Drop TRIGGER POSITION 0
6130		AS BEGIN END
6131	<	^
6131	>	^
6132		CREATE TRIGGER "BEFORE CREATE EXCEPTION"
6133		ACTIVE BEFORE CREATE EXCEPTION POSITION 0
6134		AS BEGIN END
6135	<	^
6135	>	^
6136		CREATE TRIGGER "AFTER CREATE EXCEPTION"
6137		ACTIVE AFTER CREATE EXCEPTION POSITION 0
6138		AS BEGIN END
6139	<	^
6139	>	^
6140		CREATE TRIGGER "BEFORE ALTER EXCEPTION"
6141		ACTIVE BEFORE ALTER EXCEPTION POSITION 0
6142		AS BEGIN END
6143	<	^
6143	>	^
6144		CREATE TRIGGER "AFTER ALTER EXCEPTION"
6145		ACTIVE AFTER ALTER EXCEPTION POSITION 0
6146		AS BEGIN END
6147	<	^
6147	>	^
6148		CREATE TRIGGER "BEFORE DROP EXCEPTION"
6149		ACTIVE BEFORE Drop EXCEPTION POSITION 0
6150		AS BEGIN END
6151	<	^
6151	>	^
6152		CREATE TRIGGER "AFTER DROP EXCEPTION"
6153		ACTIVE AFTER Drop EXCEPTION POSITION 0
6154		AS BEGIN END
6155	<	^
6155	>	^
6156		CREATE TRIGGER "BEFORE CREATE VIEW"
6157		ACTIVE BEFORE CREATE VIEW POSITION 0
6158		AS BEGIN END
6159	<	^
6159	>	^
6160		CREATE TRIGGER "AFTER CREATE VIEW"
6161		ACTIVE AFTER CREATE VIEW POSITION 0
6162		AS BEGIN END
6163	<	^
6163	>	^
6164		CREATE TRIGGER "BEFORE ALTER VIEW"
6165		ACTIVE BEFORE ALTER VIEW POSITION 0
6166		AS BEGIN END
6167	<	^
6167	>	^
6168		CREATE TRIGGER "AFTER ALTER VIEW"
6169		ACTIVE AFTER ALTER VIEW POSITION 0
6170		AS BEGIN END
6171	<	^
6171	>	^
6172		CREATE TRIGGER "BEFORE DROP VIEW"
6173		ACTIVE BEFORE Drop VIEW POSITION 0
6174		AS BEGIN END
6175	<	^
6175	>	^
6176		CREATE TRIGGER "AFTER DROP VIEW"
6177		ACTIVE AFTER Drop VIEW POSITION 0
6178		AS BEGIN END
6179	<	^
6179	>	^
6180		CREATE TRIGGER "BEFORE CREATE DOMAIN"
6181		ACTIVE BEFORE CREATE DOMAIN POSITION 0
6182		AS BEGIN END
6183	<	^
6183	>	^
6184		CREATE TRIGGER "AFTER CREATE DOMAIN"
6185		ACTIVE AFTER CREATE DOMAIN POSITION 0
6186		AS BEGIN END
6187	<	^
6187	>	^
6188		CREATE TRIGGER "BEFORE ALTER DOMAIN"
6189		ACTIVE BEFORE ALTER DOMAIN POSITION 0
6190		AS BEGIN END
6191	<	^
6191	>	^
6192		CREATE TRIGGER "AFTER ALTER DOMAIN"
6193		ACTIVE AFTER ALTER DOMAIN POSITION 0
6194		AS BEGIN END
6195	<	^
6195	>	^
6196		CREATE TRIGGER "BEFORE DROP DOMAIN"
6197		ACTIVE BEFORE Drop DOMAIN POSITION 0
6198		AS BEGIN END
6199	<	^
6199	>	^
6200		CREATE TRIGGER "AFTER DROP DOMAIN"
6201		ACTIVE AFTER Drop DOMAIN POSITION 0
6202		AS BEGIN END
6203	<	^
6203	>	^
6204		CREATE TRIGGER "BEFORE CREATE ROLE"
6205		ACTIVE BEFORE CREATE ROLE POSITION 0
6206		AS BEGIN END
6207	<	^
6207	>	^
6208		CREATE TRIGGER "AFTER CREATE ROLE"
6209		ACTIVE AFTER CREATE ROLE POSITION 0
6210		AS BEGIN END
6211	<	^
6211	>	^
6212		CREATE TRIGGER "BEFORE ALTER ROLE"
6213		ACTIVE BEFORE ALTER ROLE POSITION 0
6214		AS BEGIN END
6215	<	^
6215	>	^
6216		CREATE TRIGGER "AFTER ALTER ROLE"
6217		ACTIVE AFTER ALTER ROLE POSITION 0
6218		AS BEGIN END
6219	<	^
6219	>	^
6220		CREATE TRIGGER "BEFORE DROP ROLE"
6221		ACTIVE BEFORE Drop ROLE POSITION 0
6222		AS BEGIN END
6223	<	^
6223	>	^
6224		CREATE TRIGGER "AFTER DROP ROLE"
6225		ACTIVE AFTER Drop ROLE POSITION 0
6226		AS BEGIN END
6227	<	^
6227	>	^
6228		CREATE TRIGGER "BEFORE CREATE INDEX"
6229		ACTIVE BEFORE CREATE INDEX POSITION 0
6230		AS BEGIN END
6231	<	^
6231	>	^
6232		CREATE TRIGGER "AFTER CREATE INDEX"
6233		ACTIVE AFTER CREATE INDEX POSITION 0
6234		AS BEGIN END
6235	<	^
6235	>	^
6236		CREATE TRIGGER "BEFORE ALTER INDEX"
6237		ACTIVE BEFORE ALTER INDEX POSITION 0
6238		AS BEGIN END
6239	<	^
6239	>	^
6240		CREATE TRIGGER "AFTER ALTER INDEX"
6241		ACTIVE AFTER ALTER INDEX POSITION 0
6242		AS BEGIN END
6243	<	^
6243	>	^
6244		CREATE TRIGGER "BEFORE DROP INDEX"
6245		ACTIVE BEFORE Drop INDEX POSITION 0
6246		AS BEGIN END
6247	<	^
6247	>	^
6248		CREATE TRIGGER "AFTER DROP INDEX"
6249		ACTIVE AFTER Drop INDEX POSITION 0
6250		AS BEGIN END
6251	<	^
6251	>	^
6252		CREATE TRIGGER "BEFORE CREATE SEQUENCE"
6253		ACTIVE BEFORE CREATE SEQUENCE POSITION 0
6254		AS BEGIN END
6255	<	^
6255	>	^
6256		CREATE TRIGGER "AFTER CREATE SEQUENCE"
6257		ACTIVE AFTER CREATE SEQUENCE POSITION 0
6258		AS BEGIN END
6259	<	^
6259	>	^
6260		CREATE TRIGGER "BEFORE ALTER SEQUENCE"
6261		ACTIVE BEFORE ALTER SEQUENCE POSITION 0
6262		AS BEGIN END
6263	<	^
6263	>	^
6264		CREATE TRIGGER "AFTER ALTER SEQUENCE"
6265		ACTIVE AFTER ALTER SEQUENCE POSITION 0
6266		AS BEGIN END
6267	<	^
6267	>	^
6268		CREATE TRIGGER "BEFORE DROP SEQUENCE"
6269		ACTIVE BEFORE Drop SEQUENCE POSITION 0
6270		AS BEGIN END
6271	<	^
6271	>	^
6272		CREATE TRIGGER "AFTER DROP SEQUENCE"
6273		ACTIVE AFTER Drop SEQUENCE POSITION 0
6274		AS BEGIN END
6275	<	^
6275	>	^
6276		CREATE TRIGGER "BEFORE CREATE USER"
6277		ACTIVE BEFORE CREATE USER POSITION 0
6278		AS BEGIN END
6279	<	^
6279	>	^
6280		CREATE TRIGGER "AFTER CREATE USER"
6281		ACTIVE AFTER CREATE USER POSITION 0
6282		AS BEGIN END
6283	<	^
6283	>	^
6284		CREATE TRIGGER "BEFORE ALTER USER"
6285		ACTIVE BEFORE ALTER USER POSITION 0
6286		AS BEGIN END
6287	<	^
6287	>	^
6288		CREATE TRIGGER "AFTER ALTER USER"
6289		ACTIVE AFTER ALTER USER POSITION 0
6290		AS BEGIN END
6291	<	^
6291	>	^
6292		CREATE TRIGGER "BEFORE DROP USER"
6293		ACTIVE BEFORE Drop USER POSITION 0
6294		AS BEGIN END
6295	<	^
6295	>	^
6296		CREATE TRIGGER "AFTER DROP USER"
6297		ACTIVE AFTER Drop USER POSITION 0
6298		AS BEGIN END
6299	<	^
6299	>	^
6300		CREATE TRIGGER "BEFORE CREATE COLLATION"
6301		ACTIVE BEFORE CREATE COLLATION POSITION 0
6302		AS BEGIN END
6303	<	^
6303	>	^
6304		CREATE TRIGGER "AFTER CREATE COLLATION"
6305		ACTIVE AFTER CREATE COLLATION POSITION 0
6306		AS BEGIN END
6307	<	^
6307	>	^
6308		CREATE TRIGGER "BEFORE DROP COLLATION"
6309		ACTIVE BEFORE Drop COLLATION POSITION 0
6310		AS BEGIN END
6311	<	^
6311	>	^
6312		CREATE TRIGGER "AFTER DROP COLLATION"
6313		ACTIVE AFTER Drop COLLATION POSITION 0
6314		AS BEGIN END
6315	<	^
6315	>	^
6316		CREATE TRIGGER "BEFORE ALTER CHARACTER SET"
6317		ACTIVE BEFORE ALTER CHARACTER SET POSITION 0
6318		AS BEGIN END
6319	<	^
6319	>	^
6320		CREATE TRIGGER "AFTER ALTER CHARACTER SET"
6321		ACTIVE AFTER ALTER CHARACTER SET POSITION 0
6322		AS BEGIN END
6323	<	^
6323	>	^
6324		CREATE TRIGGER "BEFORE CREATE PACKAGE"
6325		ACTIVE BEFORE CREATE PACKAGE POSITION 0
6326		AS BEGIN END
6327	<	^
6327	>	^
6328		CREATE TRIGGER "AFTER CREATE PACKAGE"
6329		ACTIVE AFTER CREATE PACKAGE POSITION 0
6330		AS BEGIN END
6331	<	^
6331	>	^
6332		CREATE TRIGGER "BEFORE ALTER PACKAGE"
6333		ACTIVE BEFORE ALTER PACKAGE POSITION 0
6334		AS BEGIN END
6335	<	^
6335	>	^
6336		CREATE TRIGGER "AFTER ALTER PACKAGE"
6337		ACTIVE AFTER ALTER PACKAGE POSITION 0
6338		AS BEGIN END
6339	<	^
6339	>	^
6340		CREATE TRIGGER "BEFORE DROP PACKAGE"
6341		ACTIVE BEFORE Drop PACKAGE POSITION 0
6342		AS BEGIN END
6343	<	^
6343	>	^
6344		CREATE TRIGGER "AFTER DROP PACKAGE"
6345		ACTIVE AFTER Drop PACKAGE POSITION 0
6346		AS BEGIN END
6347	<	^
6347	>	^
6348		CREATE TRIGGER "BEFORE CREATE PACKAGE BODY"
6349		ACTIVE BEFORE CREATE PACKAGE BODY POSITION 0
6350		AS BEGIN END
6351	<	^
6351	>	^
6352		CREATE TRIGGER "AFTER CREATE PACKAGE BODY"
6353		ACTIVE AFTER CREATE PACKAGE BODY POSITION 0
6354		AS BEGIN END
6355	<	^
6355	>	^
6356		CREATE TRIGGER "BEFORE DROP PACKAGE BODY"
6357		ACTIVE BEFORE Drop PACKAGE BODY POSITION 0
6358		AS BEGIN END
6359	<	^
6359	>	^
6360		CREATE TRIGGER "AFTER DROP PACKAGE BODY"
6361		ACTIVE AFTER Drop PACKAGE BODY POSITION 0
6362		AS BEGIN END
6363	<	^
6363	>	^
6364		CREATE TRIGGER "BEFORE ANY DDL STATEMENT"
6365		ACTIVE BEFORE ANY DDL STATEMENT POSITION 0
6366		AS BEGIN END
6367	<	^
6367	>	^
6368		CREATE TRIGGER "AFTER ANY DDL STATEMENT"
6369		ACTIVE AFTER ANY DDL STATEMENT POSITION 0
6370		AS BEGIN END
6371	<	^
6371	>	^
6372		CREATE TRIGGER SET_CUST_NO FOR CUSTOMER
6373		ACTIVE BEFORE INSERT POSITION 0
6374		AS
#	Line 6380 \| Line 6376 \| BEGIN
6376		if (new.cust_no is null) then
6377		new.cust_no = gen_id(cust_no_gen, 1);
6378		END
6379	<	^
6379	>	^
6380		CREATE TRIGGER SET_EMP_NO FOR EMPLOYEE
6381		ACTIVE BEFORE INSERT POSITION 0
6382		AS
#	Line 6388 \| Line 6384 \| BEGIN
6384		if (new.emp_no is null) then
6385		new.emp_no = gen_id(emp_no_gen, 1);
6386		END
6387	<	^
6387	>	^
6388		CREATE TRIGGER SAVE_SALARY_CHANGE FOR EMPLOYEE
6389		ACTIVE AFTER UPDATE POSITION 0
6390		AS
#	Line 6403 \| Line 6399 \| BEGIN
6399		old.salary,
6400		(new.salary - old.salary) * 100 / old.salary);
6401		END
6402	<	^
6402	>	^
6403		CREATE TRIGGER POST_NEW_ORDER FOR SALES
6404		ACTIVE AFTER INSERT POSITION 0
6405		AS
6406		BEGIN
6407		POST_EVENT 'new_order';
6408		END
6409	<	^
6410	<	COMMIT WORK ^
6409	>	^
6410	>	COMMIT WORK^
6411		SET TERM ;^
6412		COMMIT WORK;
6413		SET AUTODDL OFF;
#	Line 6476 \| Line 6472 \| begin
6472		execute procedure clear;
6473		end
6474		end
6475	<	^
6475	>	^
6476
6477		CREATE PACKAGE BODY SELECT$TEST
6478		AS
#	Line 6488 \| Line 6484 \| Begin
6484		SUSPEND;
6485		End
6486		End
6487	<	^
6487	>	^
6488
6489	<	SET TERM ; ^
6489	>	SET TERM ;^
6490		COMMIT WORK;
6491		SET AUTODDL ON;
6492		COMMIT WORK;
#	Line 6526 \| Line 6522 \| BEGIN
6522		SUSPEND;
6523		END
6524		END
6525	<	^
6525	>	^
6526
6527
6528		ALTER PROCEDURE ADD_EMP_PROJ
#	Line 6542 \| Line 6538 \| BEGIN
6538		EXCEPTION unknown_emp_id;
6539		END
6540		END
6541	<	^
6546	<
6541	>	^
6542
6543		ALTER PROCEDURE ALL_LANGS
6544		RETURNS
#	Line 6571 \| Line 6566 \| BEGIN
6566		SUSPEND;
6567		END
6568		END
6569	<	^
6569	>	^
6570
6571
6572		ALTER PROCEDURE DELETE_EMPLOYEE
#	Line 6585 \| Line 6580 \| BEGIN
6580
6581		/*
6582		* If there are any sales records referencing this employee,
6583	<	* can't delete the employee until the sales are re-assigned
6583	>	* cannot delete the employee until the sales are re-assigned
6584		* to another employee or changed to NULL.
6585		*/
6586		SELECT count(po_number)
#	Line 6631 \| Line 6626 \| BEGIN
6626		WHERE emp_no = :emp_num;
6627
6628		END
6629	<	^
6629	>	^
6630
6631
6632		ALTER PROCEDURE DEPT_BUDGET
#	Line 6668 \| Line 6663 \| BEGIN
6663
6664		SUSPEND;
6665		END
6666	<	^
6666	>	^
6667
6668	+	ALTER PROCEDURE EMPLOYEE_PAY_STATUS
6669	+	(
6670	+	EMP_NUM SMALLINT
6671	+	)
6672	+	RETURNS
6673	+	(
6674	+	PAY_STATUS VARCHAR(6) CHARACTER SET NONE,
6675	+	SALARY NUMERIC(10,2)
6676	+	)
6677	+	AS
6678	+	BEGIN
6679	+	Select SALARY, Case
6680	+	When SALARY > 10000 and SALARY <= 100000 then 'higher'
6681	+	When SALARY > 100000 then 'gross'
6682	+	else 'lower' End
6683	+	From employee
6684	+	WHERE emp_no = :EMP_NUM
6685	+	into :SALARY, :PAY_STATUS;
6686	+	END
6687	+	^
6688
6689		ALTER PROCEDURE GET_EMP_PROJ
6690		(
#	Line 6688 \| Line 6703 \| BEGIN
6703		DO
6704		SUSPEND;
6705		END
6706	<	^
6706	>	^
6707
6708
6709		ALTER PROCEDURE "Has Space"
#	Line 6697 \| Line 6712 \| ALTER PROCEDURE "Has Space"
6712		)
6713		AS
6714		Begin End
6715	<	^
6715	>	^
6716
6717
6718		ALTER PROCEDURE MAIL_LABEL
#	Line 6768 \| Line 6783 \| BEGIN
6783
6784		SUSPEND;
6785		END
6786	<	^
6786	>	^
6787
6788
6789		ALTER PROCEDURE ORG_CHART
#	Line 6811 \| Line 6826 \| BEGIN
6826		SUSPEND;
6827		END
6828		END
6829	<	^
6829	>	^
6830
6831
6832		ALTER PROCEDURE SHIP_ORDER
#	Line 6871 \| Line 6886 \| BEGIN
6886		WHERE po_number = :po_num;
6887
6888		END
6889	<	^
6889	>	^
6890
6891
6892		ALTER PROCEDURE SUB_TOT_BUDGET
#	Line 6893 \| Line 6908 \| BEGIN
6908		INTO :tot_budget, :avg_budget, :min_budget, :max_budget;
6909		SUSPEND;
6910		END
6911	<	^
6911	>	^
6912
6913
6914		ALTER PROCEDURE "UC SPACE"
#	Line 6902 \| Line 6917 \| ALTER PROCEDURE "UC SPACE"
6917		)
6918		AS
6919		Begin End
6920	<	^
6920	>	^
6921
6922
6923		ALTER PROCEDURE "iCASE"
6924		AS
6925		Begin End
6926	<	^
6926	>	^
6927
6928	<	SET TERM ; ^
6928	>	SET TERM ;^
6929		COMMIT WORK;
6930		SET AUTODDL ON;
6931		COMMIT WORK;
#	Line 6928 \| Line 6943 \| END
6943		^
6944
6945
6946	<	SET TERM ; ^
6946	>	SET TERM ;^
6947		COMMIT WORK;
6948		SET AUTODDL ON;
6949
#	Line 6942 \| Line 6957 \| COMMENT ON CHARACTER SET UTF8 IS 'Defaul
6957		/* Role: TESTROLE, Owner: SYSDBA */
6958
6959		CREATE ROLE TESTROLE SET SYSTEM PRIVILEGES TO CREATE_DATABASE;
6960	<	Error processing SQL statement: On Line 2246 Character 1: Dynamic SQL Error
6960	>	Error processing SQL statement: On Line 2281 Character 1: Dynamic SQL Error
6961		-SQL error code = -104
6962		-Token unknown - line 1, column 22
6963		-SET When Executing: CREATE ROLE TESTROLE SET SYSTEM PRIVILEGES TO CREATE_DATABASE
#	Line 7976 \| Line 7991 \| CREATE VIEW DEPTLIST (
7991		SALARY,
7992		FULL_NAME,
7993		DEPT_PATH,
7994	<	DEPT_KEY_PATH
7994	>	DEPT_KEY_PATH,
7995	>	"Payment Status"
7996		) AS
7997		with recursive Depts As (
7998		Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,
#	Line 7990 \| Line 8006 \| JOIN Depts On D.HEAD_DEPT = Depts.DEPT_N
8006		)
8007
8008		Select distinct A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,
8009	<	A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH
8009	>	A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH,
8010	>	CASE When A.SALARY > 10000 then 'higher paid' else 'lower paid' End
8011		From EMPLOYEE A
8012		JOIN Depts D On D.DEPT_NO = A.DEPT_NO
8013		;
#	Line 8139 \| Line 8156 \| SET TERM ^ ;
8156
8157		/* Stored procedures Definitions*/
8158
8159	<	CREATE PROCEDURE SHOW_LANGS
8159	>	CREATE PROCEDURE SHOW_LANGS
8160		(
8161		CODE VARCHAR(5) CHARACTER SET NONE,
8162		GRADE SMALLINT,
#	Line 8152 \| Line 8169 \| RETURNS
8169		AS
8170		BEGIN SUSPEND; EXIT; END
8171		^
8172	<
8156	<	CREATE PROCEDURE ADD_EMP_PROJ
8172	>	CREATE PROCEDURE ADD_EMP_PROJ
8173		(
8174		EMP_NO SMALLINT,
8175		PROJ_ID CHAR(5) CHARACTER SET NONE
#	Line 8161 \| Line 8177 \| CREATE PROCEDURE ADD_EMP_PROJ
8177		AS
8178		BEGIN EXIT; END
8179		^
8180	<
8165	<	CREATE PROCEDURE ALL_LANGS
8180	>	CREATE PROCEDURE ALL_LANGS
8181		RETURNS
8182		(
8183		CODE VARCHAR(5) CHARACTER SET NONE,
#	Line 8173 \| Line 8188 \| RETURNS
8188		AS
8189		BEGIN SUSPEND; EXIT; END
8190		^
8191	<
8177	<	CREATE PROCEDURE DELETE_EMPLOYEE
8191	>	CREATE PROCEDURE DELETE_EMPLOYEE
8192		(
8193		EMP_NUM INTEGER
8194		)
8195		AS
8196		BEGIN EXIT; END
8197		^
8198	<
8185	<	CREATE PROCEDURE DEPT_BUDGET
8198	>	CREATE PROCEDURE DEPT_BUDGET
8199		(
8200		DNO CHAR(3) CHARACTER SET NONE
8201		)
#	Line 8193 \| Line 8206 \| RETURNS
8206		AS
8207		BEGIN SUSPEND; EXIT; END
8208		^
8209	<
8210	<	CREATE PROCEDURE GET_EMP_PROJ
8209	>	CREATE PROCEDURE EMPLOYEE_PAY_STATUS
8210	>	(
8211	>	EMP_NUM SMALLINT
8212	>	)
8213	>	RETURNS
8214	>	(
8215	>	PAY_STATUS VARCHAR(6) CHARACTER SET NONE,
8216	>	SALARY NUMERIC(10, 2)
8217	>	)
8218	>	AS
8219	>	BEGIN EXIT; END
8220	>	^
8221	>	CREATE PROCEDURE GET_EMP_PROJ
8222		(
8223		EMP_NO SMALLINT
8224		)
#	Line 8205 \| Line 8229 \| RETURNS
8229		AS
8230		BEGIN SUSPEND; EXIT; END
8231		^
8232	<
8209	<	CREATE PROCEDURE "Has Space"
8232	>	CREATE PROCEDURE "Has Space"
8233		(
8234		ARG1 INTEGER
8235		)
8236		AS
8237		BEGIN EXIT; END
8238		^
8239	<
8217	<	CREATE PROCEDURE MAIL_LABEL
8239	>	CREATE PROCEDURE MAIL_LABEL
8240		(
8241		CUST_NO INTEGER
8242		)
#	Line 8230 \| Line 8252 \| RETURNS
8252		AS
8253		BEGIN SUSPEND; EXIT; END
8254		^
8255	<
8234	<	CREATE PROCEDURE ORG_CHART
8255	>	CREATE PROCEDURE ORG_CHART
8256		RETURNS
8257		(
8258		HEAD_DEPT CHAR(25) CHARACTER SET NONE,
#	Line 8243 \| Line 8264 \| RETURNS
8264		AS
8265		BEGIN SUSPEND; EXIT; END
8266		^
8267	<
8247	<	CREATE PROCEDURE SHIP_ORDER
8267	>	CREATE PROCEDURE SHIP_ORDER
8268		(
8269		PO_NUM CHAR(8) CHARACTER SET NONE
8270		)
8271		AS
8272		BEGIN EXIT; END
8273		^
8274	<
8255	<	CREATE PROCEDURE SUB_TOT_BUDGET
8274	>	CREATE PROCEDURE SUB_TOT_BUDGET
8275		(
8276		HEAD_DEPT CHAR(3) CHARACTER SET NONE
8277		)
#	Line 8266 \| Line 8285 \| RETURNS
8285		AS
8286		BEGIN SUSPEND; EXIT; END
8287		^
8288	<
8270	<	CREATE PROCEDURE "UC SPACE"
8288	>	CREATE PROCEDURE "UC SPACE"
8289		(
8290		ARG1 INTEGER
8291		)
8292		AS
8293		BEGIN EXIT; END
8294		^
8295	<
8278	<	CREATE PROCEDURE "iCASE"
8295	>	CREATE PROCEDURE "iCASE"
8296		AS
8297		BEGIN EXIT; END
8298		^
8282	–
8299		SET TERM ; ^
8300		COMMIT WORK;
8301		SET AUTODDL ON;
#	Line 8776 \| Line 8792 \| SET TERM ^ ;
8792		/* Stored procedure Bodies */
8793
8794
8795	<	ALTER PROCEDURE SHOW_LANGS
8795	>	ALTER PROCEDURE SHOW_LANGS
8796		(
8797		CODE VARCHAR(5) CHARACTER SET NONE,
8798		GRADE SMALLINT,
#	Line 8802 \| Line 8818 \| BEGIN
8818		SUSPEND;
8819		END
8820		END
8821	<	^
8806	<
8821	>	^
8822
8823	<	ALTER PROCEDURE ADD_EMP_PROJ
8823	>	ALTER PROCEDURE ADD_EMP_PROJ
8824		(
8825		EMP_NO SMALLINT,
8826		PROJ_ID CHAR(5) CHARACTER SET NONE
#	Line 8818 \| Line 8833 \| BEGIN
8833		EXCEPTION unknown_emp_id;
8834		END
8835		END
8836	<	^
8822	<
8836	>	^
8837
8838	<	ALTER PROCEDURE ALL_LANGS
8838	>	ALTER PROCEDURE ALL_LANGS
8839		RETURNS
8840		(
8841		CODE VARCHAR(5) CHARACTER SET NONE,
#	Line 8847 \| Line 8861 \| BEGIN
8861		SUSPEND;
8862		END
8863		END
8864	<	^
8851	<
8864	>	^
8865
8866	<	ALTER PROCEDURE DELETE_EMPLOYEE
8866	>	ALTER PROCEDURE DELETE_EMPLOYEE
8867		(
8868		EMP_NUM INTEGER
8869		)
#	Line 8861 \| Line 8874 \| BEGIN
8874
8875		/*
8876		* If there are any sales records referencing this employee,
8877	<	* can't delete the employee until the sales are re-assigned
8877	>	* cannot delete the employee until the sales are re-assigned
8878		* to another employee or changed to NULL.
8879		*/
8880		SELECT count(po_number)
#	Line 8907 \| Line 8920 \| BEGIN
8920		WHERE emp_no = :emp_num;
8921
8922		END
8923	<	^
8911	<
8923	>	^
8924
8925	<	ALTER PROCEDURE DEPT_BUDGET
8925	>	ALTER PROCEDURE DEPT_BUDGET
8926		(
8927		DNO CHAR(3) CHARACTER SET NONE
8928		)
#	Line 8944 \| Line 8956 \| BEGIN
8956
8957		SUSPEND;
8958		END
8959	<	^
8959	>	^
8960
8961	+	ALTER PROCEDURE EMPLOYEE_PAY_STATUS
8962	+	(
8963	+	EMP_NUM SMALLINT
8964	+	)
8965	+	RETURNS
8966	+	(
8967	+	PAY_STATUS VARCHAR(6) CHARACTER SET NONE,
8968	+	SALARY NUMERIC(10, 2)
8969	+	)
8970	+	AS
8971	+	BEGIN
8972	+	Select SALARY, Case
8973	+	When SALARY > 10000 and SALARY <= 100000 then 'higher'
8974	+	When SALARY > 100000 then 'gross'
8975	+	else 'lower' End
8976	+	From employee
8977	+	WHERE emp_no = :EMP_NUM
8978	+	into :SALARY, :PAY_STATUS;
8979	+	END
8980	+	^
8981
8982	<	ALTER PROCEDURE GET_EMP_PROJ
8982	>	ALTER PROCEDURE GET_EMP_PROJ
8983		(
8984		EMP_NO SMALLINT
8985		)
#	Line 8964 \| Line 8996 \| BEGIN
8996		DO
8997		SUSPEND;
8998		END
8999	<	^
8968	<
8999	>	^
9000
9001	<	ALTER PROCEDURE "Has Space"
9001	>	ALTER PROCEDURE "Has Space"
9002		(
9003		ARG1 INTEGER
9004		)
9005		AS
9006		Begin End
9007	<	^
8977	<
9007	>	^
9008
9009	<	ALTER PROCEDURE MAIL_LABEL
9009	>	ALTER PROCEDURE MAIL_LABEL
9010		(
9011		CUST_NO INTEGER
9012		)
#	Line 9044 \| Line 9074 \| BEGIN
9074
9075		SUSPEND;
9076		END
9077	<	^
9048	<
9077	>	^
9078
9079	<	ALTER PROCEDURE ORG_CHART
9079	>	ALTER PROCEDURE ORG_CHART
9080		RETURNS
9081		(
9082		HEAD_DEPT CHAR(25) CHARACTER SET NONE,
#	Line 9087 \| Line 9116 \| BEGIN
9116		SUSPEND;
9117		END
9118		END
9119	<	^
9091	<
9119	>	^
9120
9121	<	ALTER PROCEDURE SHIP_ORDER
9121	>	ALTER PROCEDURE SHIP_ORDER
9122		(
9123		PO_NUM CHAR(8) CHARACTER SET NONE
9124		)
#	Line 9147 \| Line 9175 \| BEGIN
9175		WHERE po_number = :po_num;
9176
9177		END
9178	<	^
9151	<
9178	>	^
9179
9180	<	ALTER PROCEDURE SUB_TOT_BUDGET
9180	>	ALTER PROCEDURE SUB_TOT_BUDGET
9181		(
9182		HEAD_DEPT CHAR(3) CHARACTER SET NONE
9183		)
#	Line 9169 \| Line 9196 \| BEGIN
9196		INTO :tot_budget, :avg_budget, :min_budget, :max_budget;
9197		SUSPEND;
9198		END
9199	<	^
9173	<
9199	>	^
9200
9201	<	ALTER PROCEDURE "UC SPACE"
9201	>	ALTER PROCEDURE "UC SPACE"
9202		(
9203		ARG1 INTEGER
9204		)
9205		AS
9206		Begin End
9207	<	^
9182	<
9207	>	^
9208
9209	<	ALTER PROCEDURE "iCASE"
9209	>	ALTER PROCEDURE "iCASE"
9210		AS
9211		Begin End
9212	<	^
9188	<
9212	>	^
9213		SET TERM ; ^
9214		COMMIT WORK;
9215		SET AUTODDL ON;
#	Line 10240 \| Line 10264 \| CREATE VIEW DEPTLIST (
10264		SALARY,
10265		FULL_NAME,
10266		DEPT_PATH,
10267	<	DEPT_KEY_PATH
10267	>	DEPT_KEY_PATH,
10268	>	"Payment Status"
10269		) AS
10270		with recursive Depts As (
10271		Select DEPT_NO, DEPARTMENT, HEAD_DEPT, cast(DEPARTMENT as VarChar(256)) as DEPT_PATH,
#	Line 10254 \| Line 10279 \| JOIN Depts On D.HEAD_DEPT = Depts.DEPT_N
10279		)
10280
10281		Select distinct A.EMP_NO, A.FIRST_NAME, A.LAST_NAME, A.PHONE_EXT, A.HIRE_DATE, A.DEPT_NO, A.JOB_CODE,
10282	<	A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH
10282	>	A.JOB_GRADE, A.JOB_COUNTRY, A.SALARY, A.FULL_NAME, D.DEPT_PATH, D.DEPT_KEY_PATH,
10283	>	CASE When A.SALARY > 10000 then 'higher paid' else 'lower paid' End
10284		From EMPLOYEE A
10285		JOIN Depts D On D.DEPT_NO = A.DEPT_NO
10286		;
#	Line 10403 \| Line 10429 \| SET TERM ^ ;
10429
10430		/* Stored procedures Definitions*/
10431
10432	<	CREATE PROCEDURE SHOW_LANGS
10432	>	CREATE PROCEDURE SHOW_LANGS
10433		(
10434		CODE VARCHAR(5) CHARACTER SET NONE,
10435		GRADE SMALLINT,
#	Line 10416 \| Line 10442 \| RETURNS
10442		AS
10443		BEGIN SUSPEND; EXIT; END
10444		^
10445	<
10420	<	CREATE PROCEDURE ADD_EMP_PROJ
10445	>	CREATE PROCEDURE ADD_EMP_PROJ
10446		(
10447		EMP_NO SMALLINT,
10448		PROJ_ID CHAR(5) CHARACTER SET NONE
#	Line 10425 \| Line 10450 \| CREATE PROCEDURE ADD_EMP_PROJ
10450		AS
10451		BEGIN EXIT; END
10452		^
10453	<
10429	<	CREATE PROCEDURE ALL_LANGS
10453	>	CREATE PROCEDURE ALL_LANGS
10454		RETURNS
10455		(
10456		CODE VARCHAR(5) CHARACTER SET NONE,
#	Line 10437 \| Line 10461 \| RETURNS
10461		AS
10462		BEGIN SUSPEND; EXIT; END
10463		^
10464	<
10441	<	CREATE PROCEDURE DELETE_EMPLOYEE
10464	>	CREATE PROCEDURE DELETE_EMPLOYEE
10465		(
10466		EMP_NUM INTEGER
10467		)
10468		AS
10469		BEGIN EXIT; END
10470		^
10471	<
10449	<	CREATE PROCEDURE DEPT_BUDGET
10471	>	CREATE PROCEDURE DEPT_BUDGET
10472		(
10473		DNO CHAR(3) CHARACTER SET NONE
10474		)
#	Line 10457 \| Line 10479 \| RETURNS
10479		AS
10480		BEGIN SUSPEND; EXIT; END
10481		^
10482	<
10483	<	CREATE PROCEDURE GET_EMP_PROJ
10482	>	CREATE PROCEDURE EMPLOYEE_PAY_STATUS
10483	>	(
10484	>	EMP_NUM SMALLINT
10485	>	)
10486	>	RETURNS
10487	>	(
10488	>	PAY_STATUS VARCHAR(6) CHARACTER SET NONE,
10489	>	SALARY NUMERIC(10, 2)
10490	>	)
10491	>	AS
10492	>	BEGIN EXIT; END
10493	>	^
10494	>	CREATE PROCEDURE GET_EMP_PROJ
10495		(
10496		EMP_NO SMALLINT
10497		)
#	Line 10469 \| Line 10502 \| RETURNS
10502		AS
10503		BEGIN SUSPEND; EXIT; END
10504		^
10505	<
10473	<	CREATE PROCEDURE "Has Space"
10505	>	CREATE PROCEDURE "Has Space"
10506		(
10507		ARG1 INTEGER
10508		)
10509		AS
10510		BEGIN EXIT; END
10511		^
10512	<
10481	<	CREATE PROCEDURE MAIL_LABEL
10512	>	CREATE PROCEDURE MAIL_LABEL
10513		(
10514		CUST_NO INTEGER
10515		)
#	Line 10494 \| Line 10525 \| RETURNS
10525		AS
10526		BEGIN SUSPEND; EXIT; END
10527		^
10528	<
10498	<	CREATE PROCEDURE ORG_CHART
10528	>	CREATE PROCEDURE ORG_CHART
10529		RETURNS
10530		(
10531		HEAD_DEPT CHAR(25) CHARACTER SET NONE,
#	Line 10507 \| Line 10537 \| RETURNS
10537		AS
10538		BEGIN SUSPEND; EXIT; END
10539		^
10540	<
10511	<	CREATE PROCEDURE SHIP_ORDER
10540	>	CREATE PROCEDURE SHIP_ORDER
10541		(
10542		PO_NUM CHAR(8) CHARACTER SET NONE
10543		)
10544		AS
10545		BEGIN EXIT; END
10546		^
10547	<
10519	<	CREATE PROCEDURE SUB_TOT_BUDGET
10547	>	CREATE PROCEDURE SUB_TOT_BUDGET
10548		(
10549		HEAD_DEPT CHAR(3) CHARACTER SET NONE
10550		)
#	Line 10530 \| Line 10558 \| RETURNS
10558		AS
10559		BEGIN SUSPEND; EXIT; END
10560		^
10561	<
10534	<	CREATE PROCEDURE "UC SPACE"
10561	>	CREATE PROCEDURE "UC SPACE"
10562		(
10563		ARG1 INTEGER
10564		)
10565		AS
10566		BEGIN EXIT; END
10567		^
10568	<
10542	<	CREATE PROCEDURE "iCASE"
10568	>	CREATE PROCEDURE "iCASE"
10569		AS
10570		BEGIN EXIT; END
10571		^
10546	–
10572		SET TERM ; ^
10573		COMMIT WORK;
10574		SET AUTODDL ON;
#	Line 11040 \| Line 11065 \| SET TERM ^ ;
11065		/* Stored procedure Bodies */
11066
11067
11068	<	ALTER PROCEDURE SHOW_LANGS
11068	>	ALTER PROCEDURE SHOW_LANGS
11069		(
11070		CODE VARCHAR(5) CHARACTER SET NONE,
11071		GRADE SMALLINT,
#	Line 11066 \| Line 11091 \| BEGIN
11091		SUSPEND;
11092		END
11093		END
11094	<	^
11070	<
11094	>	^
11095
11096	<	ALTER PROCEDURE ADD_EMP_PROJ
11096	>	ALTER PROCEDURE ADD_EMP_PROJ
11097		(
11098		EMP_NO SMALLINT,
11099		PROJ_ID CHAR(5) CHARACTER SET NONE
#	Line 11082 \| Line 11106 \| BEGIN
11106		EXCEPTION unknown_emp_id;
11107		END
11108		END
11109	<	^
11086	<
11109	>	^
11110
11111	<	ALTER PROCEDURE ALL_LANGS
11111	>	ALTER PROCEDURE ALL_LANGS
11112		RETURNS
11113		(
11114		CODE VARCHAR(5) CHARACTER SET NONE,
#	Line 11111 \| Line 11134 \| BEGIN
11134		SUSPEND;
11135		END
11136		END
11137	<	^
11115	<
11137	>	^
11138
11139	<	ALTER PROCEDURE DELETE_EMPLOYEE
11139	>	ALTER PROCEDURE DELETE_EMPLOYEE
11140		(
11141		EMP_NUM INTEGER
11142		)
#	Line 11125 \| Line 11147 \| BEGIN
11147
11148		/*
11149		* If there are any sales records referencing this employee,
11150	<	* can't delete the employee until the sales are re-assigned
11150	>	* cannot delete the employee until the sales are re-assigned
11151		* to another employee or changed to NULL.
11152		*/
11153		SELECT count(po_number)
#	Line 11171 \| Line 11193 \| BEGIN
11193		WHERE emp_no = :emp_num;
11194
11195		END
11196	<	^
11175	<
11196	>	^
11197
11198	<	ALTER PROCEDURE DEPT_BUDGET
11198	>	ALTER PROCEDURE DEPT_BUDGET
11199		(
11200		DNO CHAR(3) CHARACTER SET NONE
11201		)
#	Line 11208 \| Line 11229 \| BEGIN
11229
11230		SUSPEND;
11231		END
11232	<	^
11232	>	^
11233
11234	+	ALTER PROCEDURE EMPLOYEE_PAY_STATUS
11235	+	(
11236	+	EMP_NUM SMALLINT
11237	+	)
11238	+	RETURNS
11239	+	(
11240	+	PAY_STATUS VARCHAR(6) CHARACTER SET NONE,
11241	+	SALARY NUMERIC(10, 2)
11242	+	)
11243	+	AS
11244	+	BEGIN
11245	+	Select SALARY, Case
11246	+	When SALARY > 10000 and SALARY <= 100000 then 'higher'
11247	+	When SALARY > 100000 then 'gross'
11248	+	else 'lower' End
11249	+	From employee
11250	+	WHERE emp_no = :EMP_NUM
11251	+	into :SALARY, :PAY_STATUS;
11252	+	END
11253	+	^
11254
11255	<	ALTER PROCEDURE GET_EMP_PROJ
11255	>	ALTER PROCEDURE GET_EMP_PROJ
11256		(
11257		EMP_NO SMALLINT
11258		)
#	Line 11228 \| Line 11269 \| BEGIN
11269		DO
11270		SUSPEND;
11271		END
11272	<	^
11232	<
11272	>	^
11273
11274	<	ALTER PROCEDURE "Has Space"
11274	>	ALTER PROCEDURE "Has Space"
11275		(
11276		ARG1 INTEGER
11277		)
11278		AS
11279		Begin End
11280	<	^
11241	<
11280	>	^
11281
11282	<	ALTER PROCEDURE MAIL_LABEL
11282	>	ALTER PROCEDURE MAIL_LABEL
11283		(
11284		CUST_NO INTEGER
11285		)
#	Line 11308 \| Line 11347 \| BEGIN
11347
11348		SUSPEND;
11349		END
11350	<	^
11312	<
11350	>	^
11351
11352	<	ALTER PROCEDURE ORG_CHART
11352	>	ALTER PROCEDURE ORG_CHART
11353		RETURNS
11354		(
11355		HEAD_DEPT CHAR(25) CHARACTER SET NONE,
#	Line 11351 \| Line 11389 \| BEGIN
11389		SUSPEND;
11390		END
11391		END
11392	<	^
11355	<
11392	>	^
11393
11394	<	ALTER PROCEDURE SHIP_ORDER
11394	>	ALTER PROCEDURE SHIP_ORDER
11395		(
11396		PO_NUM CHAR(8) CHARACTER SET NONE
11397		)
#	Line 11411 \| Line 11448 \| BEGIN
11448		WHERE po_number = :po_num;
11449
11450		END
11451	<	^
11415	<
11451	>	^
11452
11453	<	ALTER PROCEDURE SUB_TOT_BUDGET
11453	>	ALTER PROCEDURE SUB_TOT_BUDGET
11454		(
11455		HEAD_DEPT CHAR(3) CHARACTER SET NONE
11456		)
#	Line 11433 \| Line 11469 \| BEGIN
11469		INTO :tot_budget, :avg_budget, :min_budget, :max_budget;
11470		SUSPEND;
11471		END
11472	<	^
11437	<
11472	>	^
11473
11474	<	ALTER PROCEDURE "UC SPACE"
11474	>	ALTER PROCEDURE "UC SPACE"
11475		(
11476		ARG1 INTEGER
11477		)
11478		AS
11479		Begin End
11480	<	^
11446	<
11480	>	^
11481
11482	<	ALTER PROCEDURE "iCASE"
11482	>	ALTER PROCEDURE "iCASE"
11483		AS
11484		Begin End
11485	<	^
11452	<
11485	>	^
11486		SET TERM ; ^
11487		COMMIT WORK;
11488		SET AUTODDL ON;
#	Line 11556 \| Line 11589 \| Output from diff command
11589		<
11590		236d224
11591		<
11592	<	1122c1110
11592	>	990c978
11593	>	< DEPT_KEY_PATH,
11594	>	---
11595	>	> DEPT_KEY_PATH,
11596	>	1124c1112
11597		< CREATE PACKAGE FB$OUT
11598		---
11599		> CREATE PACKAGE FB$OUT
11600		1136c1124
11601	+	< ^
11602	+	---
11603	+	> ^
11604	+	1138c1126
11605		< CREATE PACKAGE SELECT$TEST
11606		---
11607		> CREATE PACKAGE SELECT$TEST
11608	<	1165d1152
11608	>	1144c1132
11609	>	< ^
11610	>	---
11611	>	> ^
11612	>	1146c1134
11613	>	< SET TERM ;^
11614	>	---
11615	>	> SET TERM ; ^
11616	>	1155c1143
11617	>	< CREATE PROCEDURE SHOW_LANGS
11618	>	---
11619	>	> CREATE PROCEDURE SHOW_LANGS
11620	>	1167d1154
11621		<
11622	<	1175d1161
11622	>	1169,1170c1156
11623		<
11624	<	1188d1173
11624	>	< CREATE PROCEDURE ADD_EMP_PROJ
11625	>	---
11626	>	> CREATE PROCEDURE ADD_EMP_PROJ
11627	>	1177d1162
11628	>	<
11629	>	1179,1180c1164
11630	>	<
11631	>	< CREATE PROCEDURE ALL_LANGS
11632	>	---
11633	>	> CREATE PROCEDURE ALL_LANGS
11634	>	1190d1173
11635	>	<
11636	>	1192,1193c1175
11637		<
11638	<	1197d1181
11638	>	< CREATE PROCEDURE DELETE_EMPLOYEE
11639	>	---
11640	>	> CREATE PROCEDURE DELETE_EMPLOYEE
11641	>	1199d1180
11642		<
11643	<	1210d1193
11643	>	1201,1202c1182
11644		<
11645	<	1223d1205
11645	>	< CREATE PROCEDURE DEPT_BUDGET
11646	>	---
11647	>	> CREATE PROCEDURE DEPT_BUDGET
11648	>	1212d1191
11649		<
11650	<	1232d1213
11650	>	1214d1192
11651		<
11652	<	1250d1230
11652	>	1217c1195
11653	>	< EMP_NO SMALLINT
11654	>	---
11655	>	> EMP_NUM SMALLINT
11656	>	1221c1199,1200
11657	>	< PAY_STATUS VARCHAR(6) CHARACTER SET NONE
11658	>	---
11659	>	> PAY_STATUS VARCHAR(6) CHARACTER SET NONE,
11660	>	> SALARY NUMERIC(10, 2)
11661	>	1225d1203
11662		<
11663	<	1264d1243
11663	>	1227,1229c1205
11664		<
11585	–	1273d1251
11665		<
11666	<	1289d1266
11666	>	< CREATE PROCEDURE GET_EMP_PROJ
11667	>	---
11668	>	> CREATE PROCEDURE GET_EMP_PROJ
11669	>	1239d1214
11670		<
11671	<	1298d1274
11671	>	1241,1242c1216
11672	>	<
11673	>	< CREATE PROCEDURE "Has Space"
11674	>	---
11675	>	> CREATE PROCEDURE "Has Space"
11676	>	1248d1221
11677	>	<
11678	>	1250,1251c1223
11679	>	<
11680	>	< CREATE PROCEDURE MAIL_LABEL
11681	>	---
11682	>	> CREATE PROCEDURE MAIL_LABEL
11683	>	1266d1237
11684	>	<
11685	>	1268,1269c1239
11686	>	<
11687	>	< CREATE PROCEDURE ORG_CHART
11688	>	---
11689	>	> CREATE PROCEDURE ORG_CHART
11690	>	1280d1249
11691	>	<
11692	>	1282,1283c1251
11693	>	<
11694	>	< CREATE PROCEDURE SHIP_ORDER
11695	>	---
11696	>	> CREATE PROCEDURE SHIP_ORDER
11697	>	1289d1256
11698	>	<
11699	>	1291,1292c1258
11700	>	<
11701	>	< CREATE PROCEDURE SUB_TOT_BUDGET
11702	>	---
11703	>	> CREATE PROCEDURE SUB_TOT_BUDGET
11704	>	1305d1270
11705	>	<
11706	>	1307,1308c1272
11707	>	<
11708	>	< CREATE PROCEDURE "UC SPACE"
11709	>	---
11710	>	> CREATE PROCEDURE "UC SPACE"
11711	>	1314d1277
11712	>	<
11713	>	1316,1317c1279
11714	>	<
11715	>	< CREATE PROCEDURE "iCASE"
11716	>	---
11717	>	> CREATE PROCEDURE "iCASE"
11718	>	1320d1281
11719		<
11720	<	1304d1279
11720	>	1322,1323c1283
11721		<
11722	<	1319d1293
11722	>	< SET TERM ;^
11723	>	---
11724	>	> SET TERM ; ^
11725	>	1335d1294
11726		<
11727	<	1723c1697
11727	>	1339c1298
11728	>	< SET TERM ;^
11729	>	---
11730	>	> SET TERM ; ^
11731	>	1352c1311
11732	>	< ^
11733	>	---
11734	>	> ^
11735	>	1356c1315
11736	>	< ^
11737	>	---
11738	>	> ^
11739	>	1360c1319
11740	>	< ^
11741	>	---
11742	>	> ^
11743	>	1364c1323
11744	>	< ^
11745	>	---
11746	>	> ^
11747	>	1368c1327
11748	>	< ^
11749	>	---
11750	>	> ^
11751	>	1372c1331
11752	>	< ^
11753	>	---
11754	>	> ^
11755	>	1376c1335
11756	>	< ^
11757	>	---
11758	>	> ^
11759	>	1380c1339
11760	>	< ^
11761	>	---
11762	>	> ^
11763	>	1384c1343
11764	>	< ^
11765	>	---
11766	>	> ^
11767	>	1388c1347
11768	>	< ^
11769	>	---
11770	>	> ^
11771	>	1392c1351
11772	>	< ^
11773	>	---
11774	>	> ^
11775	>	1396c1355
11776	>	< ^
11777	>	---
11778	>	> ^
11779	>	1400c1359
11780	>	< ^
11781	>	---
11782	>	> ^
11783	>	1404c1363
11784	>	< ^
11785	>	---
11786	>	> ^
11787	>	1408c1367
11788	>	< ^
11789	>	---
11790	>	> ^
11791	>	1412c1371
11792	>	< ^
11793	>	---
11794	>	> ^
11795	>	1416c1375
11796	>	< ^
11797	>	---
11798	>	> ^
11799	>	1420c1379
11800	>	< ^
11801	>	---
11802	>	> ^
11803	>	1424c1383
11804	>	< ^
11805	>	---
11806	>	> ^
11807	>	1428c1387
11808	>	< ^
11809	>	---
11810	>	> ^
11811	>	1432c1391
11812	>	< ^
11813	>	---
11814	>	> ^
11815	>	1436c1395
11816	>	< ^
11817	>	---
11818	>	> ^
11819	>	1440c1399
11820	>	< ^
11821	>	---
11822	>	> ^
11823	>	1444c1403
11824	>	< ^
11825	>	---
11826	>	> ^
11827	>	1448c1407
11828	>	< ^
11829	>	---
11830	>	> ^
11831	>	1452c1411
11832	>	< ^
11833	>	---
11834	>	> ^
11835	>	1456c1415
11836	>	< ^
11837	>	---
11838	>	> ^
11839	>	1460c1419
11840	>	< ^
11841	>	---
11842	>	> ^
11843	>	1464c1423
11844	>	< ^
11845	>	---
11846	>	> ^
11847	>	1468c1427
11848	>	< ^
11849	>	---
11850	>	> ^
11851	>	1472c1431
11852	>	< ^
11853	>	---
11854	>	> ^
11855	>	1476c1435
11856	>	< ^
11857	>	---
11858	>	> ^
11859	>	1480c1439
11860	>	< ^
11861	>	---
11862	>	> ^
11863	>	1484c1443
11864	>	< ^
11865	>	---
11866	>	> ^
11867	>	1488c1447
11868	>	< ^
11869	>	---
11870	>	> ^
11871	>	1492c1451
11872	>	< ^
11873	>	---
11874	>	> ^
11875	>	1496c1455
11876	>	< ^
11877	>	---
11878	>	> ^
11879	>	1500c1459
11880	>	< ^
11881	>	---
11882	>	> ^
11883	>	1504c1463
11884	>	< ^
11885	>	---
11886	>	> ^
11887	>	1508c1467
11888	>	< ^
11889	>	---
11890	>	> ^
11891	>	1512c1471
11892	>	< ^
11893	>	---
11894	>	> ^
11895	>	1516c1475
11896	>	< ^
11897	>	---
11898	>	> ^
11899	>	1520c1479
11900	>	< ^
11901	>	---
11902	>	> ^
11903	>	1524c1483
11904	>	< ^
11905	>	---
11906	>	> ^
11907	>	1528c1487
11908	>	< ^
11909	>	---
11910	>	> ^
11911	>	1532c1491
11912	>	< ^
11913	>	---
11914	>	> ^
11915	>	1536c1495
11916	>	< ^
11917	>	---
11918	>	> ^
11919	>	1540c1499
11920	>	< ^
11921	>	---
11922	>	> ^
11923	>	1544c1503
11924	>	< ^
11925	>	---
11926	>	> ^
11927	>	1548c1507
11928	>	< ^
11929	>	---
11930	>	> ^
11931	>	1552c1511
11932	>	< ^
11933	>	---
11934	>	> ^
11935	>	1556c1515
11936	>	< ^
11937	>	---
11938	>	> ^
11939	>	1560c1519
11940	>	< ^
11941	>	---
11942	>	> ^
11943	>	1564c1523
11944	>	< ^
11945	>	---
11946	>	> ^
11947	>	1568c1527
11948	>	< ^
11949	>	---
11950	>	> ^
11951	>	1572c1531
11952	>	< ^
11953	>	---
11954	>	> ^
11955	>	1576c1535
11956	>	< ^
11957	>	---
11958	>	> ^
11959	>	1580c1539
11960	>	< ^
11961	>	---
11962	>	> ^
11963	>	1584c1543
11964	>	< ^
11965	>	---
11966	>	> ^
11967	>	1588c1547
11968	>	< ^
11969	>	---
11970	>	> ^
11971	>	1592c1551
11972	>	< ^
11973	>	---
11974	>	> ^
11975	>	1596c1555
11976	>	< ^
11977	>	---
11978	>	> ^
11979	>	1600c1559
11980	>	< ^
11981	>	---
11982	>	> ^
11983	>	1604c1563
11984	>	< ^
11985	>	---
11986	>	> ^
11987	>	1608c1567
11988	>	< ^
11989	>	---
11990	>	> ^
11991	>	1612c1571
11992	>	< ^
11993	>	---
11994	>	> ^
11995	>	1616c1575
11996	>	< ^
11997	>	---
11998	>	> ^
11999	>	1620c1579
12000	>	< ^
12001	>	---
12002	>	> ^
12003	>	1624c1583
12004	>	< ^
12005	>	---
12006	>	> ^
12007	>	1628c1587
12008	>	< ^
12009	>	---
12010	>	> ^
12011	>	1632c1591
12012	>	< ^
12013	>	---
12014	>	> ^
12015	>	1636c1595
12016	>	< ^
12017	>	---
12018	>	> ^
12019	>	1640c1599
12020	>	< ^
12021	>	---
12022	>	> ^
12023	>	1644c1603
12024	>	< ^
12025	>	---
12026	>	> ^
12027	>	1648c1607
12028	>	< ^
12029	>	---
12030	>	> ^
12031	>	1652c1611
12032	>	< ^
12033	>	---
12034	>	> ^
12035	>	1656c1615
12036	>	< ^
12037	>	---
12038	>	> ^
12039	>	1660c1619
12040	>	< ^
12041	>	---
12042	>	> ^
12043	>	1664c1623
12044	>	< ^
12045	>	---
12046	>	> ^
12047	>	1668c1627
12048	>	< ^
12049	>	---
12050	>	> ^
12051	>	1672c1631
12052	>	< ^
12053	>	---
12054	>	> ^
12055	>	1676c1635
12056	>	< ^
12057	>	---
12058	>	> ^
12059	>	1680c1639
12060	>	< ^
12061	>	---
12062	>	> ^
12063	>	1684c1643
12064	>	< ^
12065	>	---
12066	>	> ^
12067	>	1688c1647
12068	>	< ^
12069	>	---
12070	>	> ^
12071	>	1692c1651
12072	>	< ^
12073	>	---
12074	>	> ^
12075	>	1700c1659
12076	>	< ^
12077	>	---
12078	>	> ^
12079	>	1708c1667
12080	>	< ^
12081	>	---
12082	>	> ^
12083	>	1723c1682
12084	>	< ^
12085	>	---
12086	>	> ^
12087	>	1730,1731c1689,1690
12088	>	< ^
12089	>	< COMMIT WORK^
12090	>	---
12091	>	> ^
12092	>	> COMMIT WORK ^
12093	>	1739c1698
12094		< CREATE PACKAGE BODY FB$OUT
12095		---
12096		> CREATE PACKAGE BODY FB$OUT
12097	<	1782c1756
12097	>	1796c1755
12098	>	< ^
12099	>	---
12100	>	> ^
12101	>	1798c1757
12102		< CREATE PACKAGE BODY SELECT$TEST
12103		---
12104		> CREATE PACKAGE BODY SELECT$TEST
12105	<	2242,2245d2215
12105	>	1808c1767
12106	>	< ^
12107	>	---
12108	>	> ^
12109	>	1810c1769
12110	>	< SET TERM ;^
12111	>	---
12112	>	> SET TERM ; ^
12113	>	1820c1779
12114	>	< ALTER PROCEDURE SHOW_LANGS
12115	>	---
12116	>	> ALTER PROCEDURE SHOW_LANGS
12117	>	1848,1849c1807
12118	>	<
12119	>	< ALTER PROCEDURE ADD_EMP_PROJ
12120	>	---
12121	>	> ALTER PROCEDURE ADD_EMP_PROJ
12122	>	1864c1822
12123	>	< ALTER PROCEDURE ALL_LANGS
12124	>	---
12125	>	> ALTER PROCEDURE ALL_LANGS
12126	>	1892,1893c1850
12127	>	<
12128	>	< ALTER PROCEDURE DELETE_EMPLOYEE
12129	>	---
12130	>	> ALTER PROCEDURE DELETE_EMPLOYEE
12131	>	1952,1953c1909
12132	>	<
12133	>	< ALTER PROCEDURE DEPT_BUDGET
12134	>	---
12135	>	> ALTER PROCEDURE DEPT_BUDGET
12136	>	1996c1952
12137	>	< SALARY NUMERIC(10,2)
12138	>	---
12139	>	> SALARY NUMERIC(10, 2)
12140	>	2010c1966
12141	>	< ALTER PROCEDURE GET_EMP_PROJ
12142	>	---
12143	>	> ALTER PROCEDURE GET_EMP_PROJ
12144	>	2029,2030c1985
12145	>	<
12146	>	< ALTER PROCEDURE "Has Space"
12147	>	---
12148	>	> ALTER PROCEDURE "Has Space"
12149	>	2038,2039c1993
12150	>	<
12151	>	< ALTER PROCEDURE MAIL_LABEL
12152	>	---
12153	>	> ALTER PROCEDURE MAIL_LABEL
12154	>	2109,2110c2063
12155	>	<
12156	>	< ALTER PROCEDURE ORG_CHART
12157	>	---
12158	>	> ALTER PROCEDURE ORG_CHART
12159	>	2152,2153c2105
12160	>	<
12161	>	< ALTER PROCEDURE SHIP_ORDER
12162	>	---
12163	>	> ALTER PROCEDURE SHIP_ORDER
12164	>	2212,2213c2164
12165	>	<
12166	>	< ALTER PROCEDURE SUB_TOT_BUDGET
12167	>	---
12168	>	> ALTER PROCEDURE SUB_TOT_BUDGET
12169	>	2234,2235c2185
12170	>	<
12171	>	< ALTER PROCEDURE "UC SPACE"
12172	>	---
12173	>	> ALTER PROCEDURE "UC SPACE"
12174	>	2243,2244c2193
12175	>	<
12176	>	< ALTER PROCEDURE "iCASE"
12177	>	---
12178	>	> ALTER PROCEDURE "iCASE"
12179	>	2248,2249c2197
12180	>	<
12181	>	< SET TERM ;^
12182	>	---
12183	>	> SET TERM ; ^
12184	>	2267c2215
12185	>	< SET TERM ;^
12186	>	---
12187	>	> SET TERM ; ^
12188	>	2277,2280d2224
12189		<
12190		< /* Role: TESTROLE, Owner: SYSDBA */
12191		<
#	Line 11659 \| Line 12244 \| Message File Location = /opt/firebird3.0
12244		Database Statistics for employee
12245
12246		Database "/opt/firebird3.0.5/examples/empbuild/employee.fdb"
12247	<	Gstat execution time Mon Feb 22 10:35:32 2021
12247	>	Gstat execution time Wed Oct 6 09:54:45 2021
12248
12249		Database header page information:
12250		Flags 0
12251	<	Generation 2198
12251	>	Generation 3338
12252		System Change Number 0
12253		Page size 8192
12254		ODS version 12.0
12255	<	Oldest transaction 2485
12256	<	Oldest active 2486
12257	<	Oldest snapshot 2486
12258	<	Next transaction 2486
12255	>	Oldest transaction 3763
12256	>	Oldest active 3764
12257	>	Oldest snapshot 3764
12258	>	Next transaction 3764
12259		Sequence number 0
12260	<	Next attachment ID 2248
12260	>	Next attachment ID 3517
12261		Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
12262		Shadow count 0
12263		Page buffers 0
#	Line 11819 \| Line 12404 \| Fill distribution:
12404		60 - 79% = 0
12405		80 - 99% = 0
12406
12407	<	Gstat completion time Mon Feb 22 10:35:32 2021
12407	>	Gstat completion time Wed Oct 6 09:54:45 2021
12408
12409
12410
#	Line 11829 \| Line 12414 \| zeus Tue Jun 9 15:11:28 2020
12414		bin/fbguard: guardian starting /opt/firebird3.0.5/bin/firebird
12415
12416		Online Validation
12417	<	10:35:32.67 Validation started
12417	>	09:54:46.38 Validation started
12418
12419	<	10:35:32.67 Relation 128 (COUNTRY)
12420	<	10:35:32.67 process pointer page 0 of 1
12421	<	10:35:32.67 Index 1 (RDB$PRIMARY1)
12422	<	10:35:32.67 Relation 128 (COUNTRY) is ok
12423	<
12424	<	10:35:32.67 Relation 129 (JOB)
12425	<	10:35:32.67 process pointer page 0 of 1
12426	<	10:35:32.67 Index 1 (RDB$PRIMARY2)
12427	<	10:35:32.67 Index 2 (RDB$FOREIGN3)
12428	<	10:35:32.67 Index 3 (MAXSALX)
12429	<	10:35:32.67 Index 4 (MINSALX)
12430	<	10:35:32.67 Relation 129 (JOB) is ok
12431	<
12432	<	10:35:32.67 Relation 130 (DEPARTMENT)
12433	<	10:35:32.67 process pointer page 0 of 1
12434	<	10:35:32.67 Index 1 (RDB$4)
12435	<	10:35:32.67 Index 2 (RDB$PRIMARY5)
12436	<	10:35:32.67 Index 3 (RDB$FOREIGN6)
12437	<	10:35:32.67 Index 4 (BUDGETX)
12438	<	10:35:32.67 Index 5 (RDB$FOREIGN10)
12439	<	10:35:32.67 Relation 130 (DEPARTMENT) is ok
12440	<
12441	<	10:35:32.67 Relation 131 (EMPLOYEE)
12442	<	10:35:32.67 process pointer page 0 of 1
12443	<	10:35:32.67 Index 1 (RDB$PRIMARY7)
12444	<	10:35:32.67 Index 2 (RDB$FOREIGN8)
12445	<	10:35:32.67 Index 3 (RDB$FOREIGN9)
12446	<	10:35:32.67 Index 4 (NAMEX)
12447	<	10:35:32.67 Relation 131 (EMPLOYEE) is ok
12448	<
12449	<	10:35:32.67 Relation 133 (PROJECT)
12450	<	10:35:32.67 process pointer page 0 of 1
12451	<	10:35:32.67 Index 1 (RDB$11)
12452	<	10:35:32.67 Index 2 (RDB$PRIMARY12)
12453	<	10:35:32.67 Index 3 (RDB$FOREIGN13)
12454	<	10:35:32.67 Index 4 (PRODTYPEX)
12455	<	10:35:32.67 Relation 133 (PROJECT) is ok
12456	<
12457	<	10:35:32.67 Relation 134 (EMPLOYEE_PROJECT)
12458	<	10:35:32.67 process pointer page 0 of 1
12459	<	10:35:32.67 Index 1 (RDB$PRIMARY14)
12460	<	10:35:32.67 Index 2 (RDB$FOREIGN15)
12461	<	10:35:32.67 Index 3 (RDB$FOREIGN16)
12462	<	10:35:32.67 Relation 134 (EMPLOYEE_PROJECT) is ok
12463	<
12464	<	10:35:32.67 Relation 135 (PROJ_DEPT_BUDGET)
12465	<	10:35:32.67 process pointer page 0 of 1
12466	<	10:35:32.68 Index 1 (RDB$PRIMARY17)
12467	<	10:35:32.68 Index 2 (RDB$FOREIGN18)
12468	<	10:35:32.68 Index 3 (RDB$FOREIGN19)
12469	<	10:35:32.68 Relation 135 (PROJ_DEPT_BUDGET) is ok
12470	<
12471	<	10:35:32.68 Relation 136 (SALARY_HISTORY)
12472	<	10:35:32.68 process pointer page 0 of 1
12473	<	10:35:32.68 Index 1 (RDB$PRIMARY20)
12474	<	10:35:32.68 Index 2 (RDB$FOREIGN21)
12475	<	10:35:32.68 Index 3 (CHANGEX)
12476	<	10:35:32.68 Index 4 (UPDATERX)
12477	<	10:35:32.68 Relation 136 (SALARY_HISTORY) is ok
12478	<
12479	<	10:35:32.68 Relation 137 (CUSTOMER)
12480	<	10:35:32.68 process pointer page 0 of 1
12481	<	10:35:32.68 Index 1 (RDB$PRIMARY22)
12482	<	10:35:32.68 Index 2 (RDB$FOREIGN23)
12483	<	10:35:32.68 Index 3 (CUSTNAMEX)
12484	<	10:35:32.68 Index 4 (CUSTREGION)
12485	<	10:35:32.68 Relation 137 (CUSTOMER) is ok
12486	<
12487	<	10:35:32.68 Relation 138 (SALES)
12488	<	10:35:32.68 process pointer page 0 of 1
12489	<	10:35:32.68 Index 1 (RDB$PRIMARY24)
12490	<	10:35:32.68 Index 2 (RDB$FOREIGN25)
12491	<	10:35:32.68 Index 3 (RDB$FOREIGN26)
12492	<	10:35:32.68 Index 4 (NEEDX)
12493	<	10:35:32.68 Index 5 (QTYX)
12494	<	10:35:32.68 Index 6 (SALESTATX)
12495	<	10:35:32.68 Relation 138 (SALES) is ok
12419	>	09:54:46.39 Relation 128 (COUNTRY)
12420	>	09:54:46.39 process pointer page 0 of 1
12421	>	09:54:46.39 Index 1 (RDB$PRIMARY1)
12422	>	09:54:46.39 Relation 128 (COUNTRY) is ok
12423	>
12424	>	09:54:46.39 Relation 129 (JOB)
12425	>	09:54:46.39 process pointer page 0 of 1
12426	>	09:54:46.39 Index 1 (RDB$PRIMARY2)
12427	>	09:54:46.39 Index 2 (RDB$FOREIGN3)
12428	>	09:54:46.39 Index 3 (MAXSALX)
12429	>	09:54:46.39 Index 4 (MINSALX)
12430	>	09:54:46.39 Relation 129 (JOB) is ok
12431	>
12432	>	09:54:46.39 Relation 130 (DEPARTMENT)
12433	>	09:54:46.39 process pointer page 0 of 1
12434	>	09:54:46.39 Index 1 (RDB$4)
12435	>	09:54:46.40 Index 2 (RDB$PRIMARY5)
12436	>	09:54:46.40 Index 3 (RDB$FOREIGN6)
12437	>	09:54:46.40 Index 4 (BUDGETX)
12438	>	09:54:46.40 Index 5 (RDB$FOREIGN10)
12439	>	09:54:46.40 Relation 130 (DEPARTMENT) is ok
12440	>
12441	>	09:54:46.40 Relation 131 (EMPLOYEE)
12442	>	09:54:46.40 process pointer page 0 of 1
12443	>	09:54:46.40 Index 1 (RDB$PRIMARY7)
12444	>	09:54:46.40 Index 2 (RDB$FOREIGN8)
12445	>	09:54:46.40 Index 3 (RDB$FOREIGN9)
12446	>	09:54:46.40 Index 4 (NAMEX)
12447	>	09:54:46.40 Relation 131 (EMPLOYEE) is ok
12448	>
12449	>	09:54:46.40 Relation 133 (PROJECT)
12450	>	09:54:46.40 process pointer page 0 of 1
12451	>	09:54:46.40 Index 1 (RDB$11)
12452	>	09:54:46.40 Index 2 (RDB$PRIMARY12)
12453	>	09:54:46.40 Index 3 (RDB$FOREIGN13)
12454	>	09:54:46.40 Index 4 (PRODTYPEX)
12455	>	09:54:46.40 Relation 133 (PROJECT) is ok
12456	>
12457	>	09:54:46.40 Relation 134 (EMPLOYEE_PROJECT)
12458	>	09:54:46.40 process pointer page 0 of 1
12459	>	09:54:46.40 Index 1 (RDB$PRIMARY14)
12460	>	09:54:46.40 Index 2 (RDB$FOREIGN15)
12461	>	09:54:46.40 Index 3 (RDB$FOREIGN16)
12462	>	09:54:46.40 Relation 134 (EMPLOYEE_PROJECT) is ok
12463	>
12464	>	09:54:46.40 Relation 135 (PROJ_DEPT_BUDGET)
12465	>	09:54:46.40 process pointer page 0 of 1
12466	>	09:54:46.40 Index 1 (RDB$PRIMARY17)
12467	>	09:54:46.40 Index 2 (RDB$FOREIGN18)
12468	>	09:54:46.40 Index 3 (RDB$FOREIGN19)
12469	>	09:54:46.40 Relation 135 (PROJ_DEPT_BUDGET) is ok
12470	>
12471	>	09:54:46.40 Relation 136 (SALARY_HISTORY)
12472	>	09:54:46.40 process pointer page 0 of 1
12473	>	09:54:46.40 Index 1 (RDB$PRIMARY20)
12474	>	09:54:46.40 Index 2 (RDB$FOREIGN21)
12475	>	09:54:46.40 Index 3 (CHANGEX)
12476	>	09:54:46.40 Index 4 (UPDATERX)
12477	>	09:54:46.41 Relation 136 (SALARY_HISTORY) is ok
12478	>
12479	>	09:54:46.41 Relation 137 (CUSTOMER)
12480	>	09:54:46.41 process pointer page 0 of 1
12481	>	09:54:46.41 Index 1 (RDB$PRIMARY22)
12482	>	09:54:46.41 Index 2 (RDB$FOREIGN23)
12483	>	09:54:46.41 Index 3 (CUSTNAMEX)
12484	>	09:54:46.41 Index 4 (CUSTREGION)
12485	>	09:54:46.41 Relation 137 (CUSTOMER) is ok
12486	>
12487	>	09:54:46.41 Relation 138 (SALES)
12488	>	09:54:46.41 process pointer page 0 of 1
12489	>	09:54:46.41 Index 1 (RDB$PRIMARY24)
12490	>	09:54:46.41 Index 2 (RDB$FOREIGN25)
12491	>	09:54:46.41 Index 3 (RDB$FOREIGN26)
12492	>	09:54:46.41 Index 4 (NEEDX)
12493	>	09:54:46.41 Index 5 (QTYX)
12494	>	09:54:46.41 Index 6 (SALESTATX)
12495	>	09:54:46.41 Relation 138 (SALES) is ok
12496
12497	<	10:35:32.68 Validation finished
12497	>	09:54:46.41 Validation finished
12498
12499
12500		Normal Validation
#	Line 15083 \| Line 15668 \| Create Table LotsOfData (
15668		MyText VarChar(1024),
15669		Primary Key (RowID)
15670		);
15671	<	Loading data into database table. Started at 22/2/2021 10:36:29.554
15672	<	Data load completed at 22/2/2021 10:38:03.989 Elapsed Time = 94435 ms, 100000 records loaded
15673	<	MD5 checksum = c64feb9fc39310ba79ee10a629ac32ba
15674	<	Database Read started at 22/2/2021 10:38:03.997
15675	<	Read Dataset completed at 22/2/2021 10:38:36.093 Elapsed Time = 32096 ms, 100000 records read
15676	<	MD5 checksum = c64feb9fc39310ba79ee10a629ac32ba
15671	>	Loading data into database table. Started at 06/10/2021 09:55:30.702
15672	>	Data load completed at 06/10/2021 09:57:14.355 Elapsed Time = 103653 ms, 100000 records loaded
15673	>	Message Hash = aada768f1d5fa8c549d255798b6df8ab
15674	>	Database Read started at 06/10/2021 09:57:14.365
15675	>	Read Dataset completed at 06/10/2021 09:57:44.461 Elapsed Time = 30096 ms, 100000 records read
15676	>	Message Hash = aada768f1d5fa8c549d255798b6df8ab
15677		Test Completed successfully
15678	<	22/2/2021 10:38:36.093 Test 21 passes as long as the MD5 sums are identical
15678	>	06/10/2021 09:57:44.461 Test 21 passes as long as the checksums are identical
15679
15680
15681		------------------------------------------------------

Diff Legend

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

Comparing ibx/trunk/testsuite/FB3reference.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

Diff Legend

Comparing ibx/trunk/testsuite/FB3reference.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