ViewVC Help

View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing

root/public/ibx/branches/udr/testsuite/FB4reference.log

Comparing:
ibx/trunk/fbintf/testsuite/FB4reference.log (file contents), Revision 333 by tony, Fri Feb 26 16:34:26 2021 UTC vs.
ibx/branches/udr/testsuite/FB4reference.log (file contents), Revision 381 by tony, Sat Jan 15 00:06:22 2022 UTC

#	Line 3 | Line 3 | Copyright MWA Software 2016-2021
3
4		Starting Tests
5		Client API Version = 4.0
6	<	Firebird Environment Variable = /opt/firebird4rc1
7	<	Firebird Bin Directory = /opt/firebird4rc1/bin
8	<	Firebird Conf Directory = /opt/firebird4rc1/
9	<	Firebird Client Library Path = /opt/firebird4rc1/lib/libfbclient.so
6	>	Firebird Environment Variable = /opt/firebird4.0.1
7	>	Firebird Bin Directory = /opt/firebird4.0.1/bin
8	>	Firebird Conf Directory = /opt/firebird4.0.1/
9	>	Firebird Client Library Path = /opt/firebird4.0.1/lib/libfbclient.so
10		Running Test 1: Create and Drop a Database
11		Creating a Database with empty parameters
12	<	Create Database fails (as expected): I/O error during "open O_CREAT" operation for file ""
12	>	Create Database fails (as expected): Engine Code: 335544344 I/O error during "open O_CREAT" operation for file ""
13		-Error while trying to create file
14		-No such file or directory
15		Creating a Database using an SQL Statement
#	Line 22 | Line 22 | DB Remote Protocol = TCPv4
22		DB ODS Major Version = 13
23		DB ODS Minor Version = 0
24		User Authentication Method = Srp256
25	<	Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so
25	>	Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so
26		DB Client Implementation Version = 4.0
27		DPB: Item Count = 3
28		isc_dpb_user_name = SYSDBA
#	Line 30 | Line 30 | DPB: Item Count = 3
30		isc_dpb_set_db_sql_dialect = 3
31
32		Firebird Server Version Info
33	<	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
34	<	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:C"
35	<	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:C"
33	>	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
34	>	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:C"
35	>	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:C"
36		on disk structure version 13.0
37
38		Dropping Database
#	Line 44 | Line 44 | DB Remote Protocol = TCPv4
44		DB ODS Major Version = 13
45		DB ODS Minor Version = 0
46		User Authentication Method = Srp256
47	<	Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so
47	>	Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so
48		DB Client Implementation Version = 4.0
49		Dropping Database
50		DPB: Item Count = 4
#	Line 57 | Line 57 | Creating a Database with a DPD
57		Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
58		ODS major = 13
59		ODS minor = 0
60	+	Attachment ID = 4
61		DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
62		DB Charset ID = 4
63		DB SQL Dialect = 3
#	Line 64 | Line 65 | DB Remote Protocol = TCPv4
65		DB ODS Major Version = 13
66		DB ODS Minor Version = 0
67		User Authentication Method = Srp256
68	<	Firebird Library Path = /opt/firebird4rc1/lib/libfbclient.so
68	>	Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so
69		DB Client Implementation Version = 4.0
70		RDB$DESCRIPTION =
71		RDB$RELATION_ID = 128
72	<	RDB$SECURITY_CLASS = SQL$384
72	>	RDB$SECURITY_CLASS = SQL$385
73		RDB$CHARACTER_SET_NAME = UTF8
74		RDB$LINGER =
75		RDB$SQL_SECURITY =
#	Line 77 | Line 78 | Dropping Database
78
79		------------------------------------------------------
80		Running Test 2: Open the employee database and run a query
81	+	Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login
82		Opening inet://localhost/employee
83		Database Open, SQL Dialect = 3
84		TPB: Item Count = 3
#	Line 267 | Line 269 | Scale = 0
269		Charset id = 0
270		Not Null
271		Size = 2
272	+	Value = 0
273
274		EMP_NO = 8
275		FIRST_NAME = Leslie
#	Line 290 | Line 293 | Scale = 0
293		Charset id = 0
294		Not Null
295		Size = 2
296	+	Value = 0
297
298	+	Results for Cursor: Test Cursor
299		EMP_NO = 8
300		FIRST_NAME = Leslie
301		LAST_NAME = Johnson
#	Line 303 | Line 308 | JOB_COUNTRY = USA
308		SALARY = 64,635.00
309		FULL_NAME = Johnson, Leslie
310
311	+	Scollable Cursors
312	+	DB Connect String = inet://localhost/employee
313	+	DB Charset ID = 4
314	+	DB SQL Dialect = 3
315	+	DB Remote Protocol = TCPv4
316	+	DB ODS Major Version = 13
317	+	DB ODS Minor Version = 0
318	+	User Authentication Method = Srp256
319	+	Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so
320	+	DB Client Implementation Version = 4.0
321	+	Do Fetch Next:
322	+	EMP_NO = 2
323	+	FIRST_NAME = Robert
324	+	LAST_NAME = Nelson
325	+	PHONE_EXT = 250
326	+	HIRE_DATE = 1988/12/28 00:00:00.0000
327	+	DEPT_NO = 600
328	+	JOB_CODE = VP
329	+	JOB_GRADE = 2
330	+	JOB_COUNTRY = USA
331	+	SALARY = 105,900.00
332	+	FULL_NAME = Nelson, Robert
333	+	Do Fetch Last:
334	+	Remote Scrollable cursors test fails Engine Code: 335544378 feature is not supported
335		Now open the employee database as a local database
336		TPB: Item Count = 3
337		isc_tpb_read
#	Line 492 | Line 521 | Scale = 0
521		Charset id = 0
522		Not Null
523		Size = 2
524	+	Value = 0
525
526		EMP_NO = 8
527		FIRST_NAME = Leslie
#	Line 515 | Line 545 | Scale = 0
545		Charset id = 0
546		Not Null
547		Size = 2
548	+	Value = 0
549
550	+	Results for Cursor: Test Cursor
551		EMP_NO = 8
552		FIRST_NAME = Leslie
553		LAST_NAME = Johnson
#	Line 528 | Line 560 | JOB_COUNTRY = USA
560		SALARY = 64,635.00
561		FULL_NAME = Johnson, Leslie
562
563	+	Scollable Cursors
564	+	DB Connect String = employee
565	+	DB Charset ID = 4
566	+	DB SQL Dialect = 3
567	+	DB Remote Protocol =
568	+	DB ODS Major Version = 13
569	+	DB ODS Minor Version = 0
570	+	User Authentication Method = User name in DPB
571	+	Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so
572	+	DB Client Implementation Version = 4.0
573	+	Do Fetch Next:
574	+	EMP_NO = 2
575	+	FIRST_NAME = Robert
576	+	LAST_NAME = Nelson
577	+	PHONE_EXT = 250
578	+	HIRE_DATE = 1988/12/28 00:00:00.0000
579	+	DEPT_NO = 600
580	+	JOB_CODE = VP
581	+	JOB_GRADE = 2
582	+	JOB_COUNTRY = USA
583	+	SALARY = 105,900.00
584	+	FULL_NAME = Nelson, Robert
585	+	Do Fetch Last:
586	+	EMP_NO = 145
587	+	FIRST_NAME = Mark
588	+	LAST_NAME = Guckenheimer
589	+	PHONE_EXT = 221
590	+	HIRE_DATE = 1994/05/02 00:00:00.0000
591	+	DEPT_NO = 622
592	+	JOB_CODE = Eng
593	+	JOB_GRADE = 5
594	+	JOB_COUNTRY = USA
595	+	SALARY = 32,000.00
596	+	FULL_NAME = Guckenheimer, Mark
597	+	Do Fetch Prior:
598	+	EMP_NO = 144
599	+	FIRST_NAME = John
600	+	LAST_NAME = Montgomery
601	+	PHONE_EXT = 820
602	+	HIRE_DATE = 1994/03/30 00:00:00.0000
603	+	DEPT_NO = 672
604	+	JOB_CODE = Eng
605	+	JOB_GRADE = 5
606	+	JOB_COUNTRY = USA
607	+	SALARY = 35,000.00
608	+	FULL_NAME = Montgomery, John
609	+	Do Fetch First:
610	+	EMP_NO = 2
611	+	FIRST_NAME = Robert
612	+	LAST_NAME = Nelson
613	+	PHONE_EXT = 250
614	+	HIRE_DATE = 1988/12/28 00:00:00.0000
615	+	DEPT_NO = 600
616	+	JOB_CODE = VP
617	+	JOB_GRADE = 2
618	+	JOB_COUNTRY = USA
619	+	SALARY = 105,900.00
620	+	FULL_NAME = Nelson, Robert
621	+	Do Fetch Abs 8 :
622	+	EMP_NO = 14
623	+	FIRST_NAME = Stewart
624	+	LAST_NAME = Hall
625	+	PHONE_EXT = 227
626	+	HIRE_DATE = 1990/06/04 00:00:00.0000
627	+	DEPT_NO = 900
628	+	JOB_CODE = Finan
629	+	JOB_GRADE = 3
630	+	JOB_COUNTRY = USA
631	+	SALARY = 69,482.63
632	+	FULL_NAME = Hall, Stewart
633	+	Do Fetch Relative -2 :
634	+	EMP_NO = 11
635	+	FIRST_NAME = K. J.
636	+	LAST_NAME = Weston
637	+	PHONE_EXT = 34
638	+	HIRE_DATE = 1990/01/17 00:00:00.0000
639	+	DEPT_NO = 130
640	+	JOB_CODE = SRep
641	+	JOB_GRADE = 4
642	+	JOB_COUNTRY = USA
643	+	SALARY = 86,292.94
644	+	FULL_NAME = Weston, K. J.
645	+	Do Fetch beyond EOF :
646	+	Fetch returned false
647
648
649		------------------------------------------------------
#	Line 535 | Line 651 | Running Test 3: ad hoc queries
651		Opening inet://localhost/employee
652		Database Open
653		Employee Count = 42
654	+	Transaction ID = 8337
655	+	Transaction is Read/Write
656	+	Transaction Database Path = inet://localhost/employee
657	+	Transaction ID = 8337
658	+	Oldest Interesting = 8335
659	+	Oldest Action = 8336
660	+	Oldest Snapshot = 8336
661	+	Oldest Snapshot Number = 1
662	+	Lock Timeout = 0
663	+	Transaction Access = isc_info_tra_readwrite
664	+	Isolation Type = isc_info_tra_concurrency
665		Employee Count = 41
666		Employee Count = 42
667		Employee Count = 41
#	Line 548 | Line 675 | Constrained Employee Count = 3
675		Running Test 4: Update, Insert and Delete Queries
676		Opening inet://localhost/employee
677		Database Open
678	<	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
679	<	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ"
680	<	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1/tcp (zeus)/P16:CZ"
678	>	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
679	>	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
680	>	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
681		on disk structure version 13.0
682		Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
683		EMP_NO = 8
#	Line 565 | Line 692 | JOB_COUNTRY = USA
692		SALARY = 64,635.00
693		FULL_NAME = Johnson, Leslie
694
695	<	Current memory = 19,747,376
695	>	Current memory = 19,762,400
696		Delta memory = 4,464
697	<	Max memory = 19,793,248
698	<	Elapsed time= 0.002 sec
697	>	Max memory = 19,807,728
698	>	Elapsed time= 0.003 sec
699		Cpu = 0.000 sec
700		Buffers = 2048
701		Reads = 0
702	<	Writes = 0
702	>	Writes = 1
703		Fetches = 3
704		Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
705		Relation Name = EMPLOYEE
#	Line 1067 | Line 1194 | Scale = 0
1194		Charset id = 0
1195		Not Null
1196		Size = 4
1197	+	Value = 0
1198
1199		SQLType =SQL_VARYING
1200		sub type = 0
#	Line 1114 | Line 1242 | Scale = 0
1242		Charset id = 0
1243		Not Null
1244		Size = 4
1245	+	Value = 0
1246
1247		ROWID = 1
1248		FIXEDPOINT = 20.28
#	Line 1166 | Line 1295 | Scale = 0
1295		Charset id = 0
1296		Not Null
1297		Size = 4
1298	+	Value = 0
1299
1300		SQLType =SQL_VARYING
1301		sub type = 0
#	Line 1543 | Line 1673 | Scale = 0
1673		Charset id = 0
1674		Not Null
1675		Size = 4
1676	+	Value = 0
1677
1678		SQLType =SQL_VARYING
1679		sub type = 0
#	Line 1590 | Line 1721 | Scale = 0
1721		Charset id = 0
1722		Not Null
1723		Size = 4
1724	+	Value = 0
1725
1726		ROWID = 1
1727		FIXEDPOINT = 20.28
#	Line 1642 | Line 1774 | Scale = 0
1774		Charset id = 0
1775		Not Null
1776		Size = 4
1777	+	Value = 0
1778
1779		SQLType =SQL_VARYING
1780		sub type = 0
#	Line 2019 | Line 2152 | Scale = 0
2152		Charset id = 0
2153		Not Null
2154		Size = 4
2155	+	Value = 0
2156
2157		SQLType =SQL_VARYING
2158		sub type = 0
#	Line 2066 | Line 2200 | Scale = 0
2200		Charset id = 0
2201		Not Null
2202		Size = 4
2203	+	Value = 0
2204
2205		ROWID = 1
2206		FIXEDPOINT = 20.28
#	Line 2118 | Line 2253 | Scale = 0
2253		Charset id = 0
2254		Not Null
2255		Size = 4
2256	+	Value = 0
2257
2258		SQLType =SQL_VARYING
2259		sub type = 0
#	Line 2412 | Line 2548 | Scale = 0
2548		Charset id = 0
2549		Not Null
2550		Size = 4
2551	+	Value = 0
2552
2553		SQLType =SQL_VARYING
2554		sub type = 0
#	Line 2596 | Line 2733 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2733
2734		MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00)
2735
2736	<	MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 14.69) (15: 15.75) (16: 16.79)
2736	>	MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269)
2737
2738
2739		Shrink to 2:10
#	Line 2612 | Line 2749 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2749
2750		MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00)
2751
2752	<	MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 14.69) (15: 15.75) (16: 16.79)
2752	>	MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269)
2753
2754
2755
#	Line 2673 | Line 2810 | Scale = 0
2810		Charset id = 0
2811		Not Null
2812		Size = 4
2813	+	Value = 0
2814
2815		SQLType =SQL_VARYING
2816		sub type = 0
#	Line 2695 | Line 2833 | MYARRAY = Array: (0,-1: A50) (0,0: A51)
2833
2834		------------------------------------------------------
2835		Running Test 9: Database Information tests
2836	<	Database ID = 4 FB = /opt/firebird4rc1/examples/empbuild/employee.fdb SN = zeus
2837	<	Pages =346
2836	>	Database ID = 4 FB = /opt/firebird4.0.1/examples/empbuild/employee.fdb SN = zeus
2837	>	Pages =413
2838		Base Level = 13,4,0,3,
2839		Implementation = 11,7,0,3,66,1,66,
2840		Reserved = 0
2841		ODS minor = 0
2842		ODS major = 13
2843		Page Size = 8192
2844	<	Version = 1: LI-V6.3.0.2353 Firebird 4.0 Release Candidate 1
2844	>	Version = 1: LI-V6.3.1.2692 Firebird 4.0
2845		Database is Read/Write
2846	<	Database Created: 01/2/2021 14:57:08
2847	<	Pages Used = 310
2848	<	Pages Free = 36
2849	<	Server Memory = 19466032
2846	>	Database Created: 21/12/2021 10:52:59
2847	>	Pages Used = 352
2848	>	Pages Free = 61
2849	>	Server Memory = 19476112
2850		Forced Writes  = 1
2851	<	Max Memory  = 19612048
2851	>	Max Memory  = 19506944
2852		Num Buffers  = 2048
2853		Sweep Interval  = 20000
2854		Logged in Users: SYSDBA,
2855		Active Transaction Count = 0
2856	<	Fetches  = 1634
2857	<	Writes  = 8
2858	<	Reads  = 91
2859	<	Page Writes  = 4
2856	>	Fetches  = 1698
2857	>	Writes  = 6
2858	>	Reads  = 97
2859	>	Page Writes  = 3
2860		Record Version Removals Operation Counts
2861
2862		Deletes Operation Counts
#	Line 2733 | Line 2871 | Indexed Reads Count Operation Counts
2871		Table ID = 4
2872		Count = 63
2873		Table ID = 6
2874	<	Count = 23
2874	>	Count = 13
2875		Table ID = 9
2876	<	Count = 3
2876	>	Count = 1
2877		Table ID = 11
2878		Count = 2
2879		Table ID = 12
2880		Count = 24
2881		Table ID = 18
2882	<	Count = 805
2882	>	Count = 952
2883		Table ID = 20
2884		Count = 5
2885		Table ID = 28
#	Line 2755 | Line 2893 | Sequential Table Scans Operation Counts
2893		Table ID = 0
2894		Count = 98
2895		Table ID = 1
2896	<	Count = 24
2896	>	Count = 14
2897
2898		Update Count Operation Counts
2899
#	Line 2769 | Line 2907 | Async Wait Called
2907		Event Signalled
2908		First Event - usually ignored
2909		Signal Event
2910	+	Event Signalled
2911		Event Counts: TESTEVENT, Count = 1
2912		Two more events
2913		Call Async Wait
2914		Async Wait Called
2915		Event Signalled
2777	–	Event Signalled
2916		Deferred Events Caught
2917		Event Counts: TESTEVENT, Count = 2
2918		Signal Event
#	Line 2796 | Line 2934 | SPB: Item Count = 2
2934		password = masterkey
2935
2936		Service Manager Version = 2
2937	<	Server Version = LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1
2937	>	Server Version = LI-V4.0.1.2692 Firebird 4.0
2938		Implementation = Firebird/Linux/AMD/Intel/x64
2939
2940		Lock Directory = /tmp/firebird/
2941	<	Message File = /opt/firebird4rc1/
2942	<	Security File = /opt/firebird4rc1/security4.fdb
2941	>	Message File = /opt/firebird4.0.1/
2942	>	Security File = /opt/firebird4.0.1/security4.fdb
2943
2944		DB Attachments
2945		No. of Attachments = 0
#	Line 2816 | Line 2954 | User ID = 0
2954		Group ID = 0
2955
2956
2957	<	Licence Info: feature is not supported
2957	>	Licence Info: Engine Code: 335544378 feature is not supported
2958		-feature is not supported
2959
2960	<	Licence Mask Info: feature is not supported
2960	>	Licence Mask Info: Engine Code: 335544378 feature is not supported
2961
2962		Capabilities = 6
2963
#	Line 2859 | Line 2997 | Scale = 0
2997		Charset id = 0
2998		Not Null
2999		Size = 4
3000	+	Value = 0
3001
3002		SQLType =SQL_VARYING
3003		sub type = 0
#	Line 2908 | Line 3047 | Charset id = 4
3047		Nullable
3048		Size = 16
3049
3050	+	Show Param Values
3051	+	SQL Params
3052	+	SQLType =SQL_LONG
3053	+	sub type = 0
3054	+	Field Name = ROWID
3055	+	Scale = 0
3056	+	Charset id = 0
3057	+	Not Null
3058	+	Size = 4
3059	+	Value = 1
3060	+
3061	+	SQLType =SQL_VARYING
3062	+	sub type = 0
3063	+	Field Name = TITLE
3064	+	Scale = 0
3065	+	Charset id = 4
3066	+	Nullable
3067	+	Size = 128
3068	+	Value = Blob Test ©€
3069	+
3070	+	SQLType =SQL_VARYING
3071	+	sub type = 0
3072	+	Field Name = NOTES
3073	+	Scale = 0
3074	+	Charset id = 4
3075	+	Nullable
3076	+	Size = 256
3077	+	Value = Écoute moi
3078	+
3079	+	SQLType =SQL_VARYING
3080	+	sub type = 1
3081	+	Field Name = BLOBDATA
3082	+	Scale = 0
3083	+	Charset id = 4
3084	+	Nullable
3085	+	Size = 8192
3086	+	Value = Some German Special Characters like ÖÄÜöäüß
3087	+
3088	+	SQLType =SQL_BLOB
3089	+	sub type = 1
3090	+	Field Name = BLOBDATA2
3091	+	Scale = 0
3092	+	Charset id = 4
3093	+	Nullable
3094	+	Size = 8
3095	+	Value = Some German Special Characters like ÖÄÜöäüß
3096	+
3097	+	SQLType =SQL_VARYING
3098	+	sub type = 0
3099	+	Field Name = INCLEAR
3100	+	Scale = 0
3101	+	Charset id = 1
3102	+	Nullable
3103	+	Size = 16
3104	+	Value = &Test
3105
3106	+
3107	+	SQLType =SQL_VARYING
3108	+	sub type = 0
3109	+	Field Name = FIXEDWIDTH
3110	+	Scale = 0
3111	+	Charset id = 4
3112	+	Nullable
3113	+	Size = 16
3114	+	Value = É
3115	+
3116		Connection Character Set UTF8
3117		ROWID = 1
3118		TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
#	Line 3022 | Line 3226 | ROWID = 1
3226		TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3227		BLOBDATA = (blob), Length = 92514
3228
3229	+	ROWID = 2
3230	+	TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3231	+	BLOBDATA = (blob), Length = 13
3232	+	0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3233
3234		Testdata 2
3235
#	Line 3036 | Line 3244 | Écoute moi
3244		------------------------------------------------------
3245		Running Test 16: Error handling
3246		Invalid Database Name Test
3247	<	Error Handled: I/O error during "open" operation for file "Malformed Name"
3247	>	Error Handled: SQLCODE: -902
3248	>	Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3249	>	I/O error during "open" operation for file "Malformed Name"
3250		-Error while trying to open file
3251		-No such file or directory
3252		Invalid User Name Test
3253	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3253	>	Error Handled: SQLCODE: -902
3254	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3255	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3256		Invalid password Test
3257	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3257	>	Error Handled: SQLCODE: -902
3258	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3259	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3260		Invalid Prepare SQL Test
3261	<	Error Handled: Dynamic SQL Error
3261	>	Error Handled: SQLCODE: -206
3262	>	Engine Code: 335544569 Column does not belong to referenced table
3263	>	Dynamic SQL Error
3264		-SQL error code = -206
3265		-Column unknown
3266		-UNKNOWN_DATE
3267		-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3268		Invalid Open Cursor SQL Test
3269	<	Error Handled: Dynamic SQL Error
3269	>	Error Handled: SQLCODE: -206
3270	>	Engine Code: 335544569 Column does not belong to referenced table
3271	>	Dynamic SQL Error
3272		-SQL error code = -206
3273		-Column unknown
3274		-X
#	Line 3061 | Line 3279 | Invalid Param SQL Type Test
3279		Error Handled: Field "EMP_NO" not found
3280		Case sensitive Param SQL  Test
3281		Error Handled: Field "EMP_NO" not found
3282	+	Stale Reference Check
3283	+	First test correct usage
3284	+	COUNTER = 42
3285	+
3286	+	New Transaction before param set
3287	+	Error Handled: This interface is no longer up-to-date
3288	+	New Transaction before Open Cursor
3289	+	Error Handled: This interface is no longer up-to-date
3290	+	Stop Stale Reference Checks
3291	+	New Transaction before param set
3292	+	COUNTER = 42
3293	+
3294	+	New Transaction before Open Cursor
3295	+	COUNTER = 42
3296	+
3297		Invalid Server Name Test
3298	<	Error Handled: Unable to complete network request to host "unknown".
3298	>	Error Handled: SQLCODE: -902
3299	>	Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3300	>	Unable to complete network request to host "unknown".
3301		-Failed to locate host machine.
3302		-The specified name was not found in the hosts file or Domain Name Services
3303		Invalid User Name Test
3304	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3304	>	Error Handled: SQLCODE: -902
3305	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3306	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3307		Invalid password Test
3308	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3308	>	Error Handled: SQLCODE: -902
3309	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3310	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3311
3312
3313		------------------------------------------------------
3314		Running Test 17: Date/Time tests and Firebird 4 extensions
3315	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
3315	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
3316		Has Local TZ DB = TRUE
3317
3318		Testdata
#	Line 3835 | Line 4074 | TZ_MINUTE = 0
4074
4075		------------------------------------------------------
4076		Running Test 18: Firebird 4 Decfloat extensions
4077	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
4077	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4078
4079		FB4 Testdata_DECFloat
4080
#	Line 3937 | Line 4176 | BigInteger = 123456789123456789
4176		Special = 0
4177		Places = 0
4178		Digits = 12 34 56 78 91 23 45 67 89
4179	+
4180		RowID = 2
4181		Float16 = -64000000000.01
4182		Precision = 13
#	Line 3957 | Line 4197 | BigNumber = -123456123456.123456
4197		Places = 6
4198		Digits = 12 34 56 12 34 56 12 34 56
4199		BigInteger = Null
4200	+
4201		RowID = 3
4202		Float16 = 64100000000.011
4203		Precision = 14
#	Line 3983 | Line 4224 | BiggerNumber = 1112345612345612345612345
4224		Places = 4
4225		Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35
4226		BigInteger = Null
4227	+
4228		RowID = 4
4229		Float16 = 0
4230		Precision = 0
#	Line 4009 | Line 4251 | BiggerNumber = 0.0000
4251		Places = 0
4252		Digits =
4253		BigInteger = Null
4254	+
4255		Metadata
4256		SQLType =SQL_LONG
4257		sub type = 0
#	Line 4096 | Line 4339 | BigNumber Array: (0: 123456123400.123456
4339
4340
4341
4342	+	------------------------------------------------------
4343	+	Running Test 19: Batch Update and Insert Queries
4344	+	Opening inet://localhost/employee
4345	+	Database Open
4346	+	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4347	+	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
4348	+	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
4349	+	on disk structure version 13.0
4350	+	Rows before update
4351	+	EMP_NO = 2
4352	+	FIRST_NAME = Robert
4353	+	LAST_NAME = Nelson
4354	+	PHONE_EXT = 250
4355	+	HIRE_DATE = 1988/12/28 00:00:00.0000
4356	+	DEPT_NO = 600
4357	+	JOB_CODE = VP
4358	+	JOB_GRADE = 2
4359	+	JOB_COUNTRY = USA
4360	+	SALARY = 105,900.00
4361	+	FULL_NAME = Nelson, Robert
4362	+	EMP_NO = 8
4363	+	FIRST_NAME = Leslie
4364	+	LAST_NAME = Johnson
4365	+	PHONE_EXT = 410
4366	+	HIRE_DATE = 1989/04/05 00:00:00.0000
4367	+	DEPT_NO = 180
4368	+	JOB_CODE = Mktg
4369	+	JOB_GRADE = 3
4370	+	JOB_COUNTRY = USA
4371	+	SALARY = 64,635.00
4372	+	FULL_NAME = Johnson, Leslie
4373	+
4374	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4375	+	Batch Completion Info
4376	+	Total rows processed = 2
4377	+	Updated Records = 2
4378	+	Row 1 State = bcNoMoreErrors Msg =
4379	+	Row 2 State = bcNoMoreErrors Msg =
4380	+	Rows after update
4381	+	EMP_NO = 2
4382	+	FIRST_NAME = Robert
4383	+	LAST_NAME = Nelson
4384	+	PHONE_EXT = 250
4385	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4386	+	DEPT_NO = 600
4387	+	JOB_CODE = VP
4388	+	JOB_GRADE = 2
4389	+	JOB_COUNTRY = USA
4390	+	SALARY = 105,900.00
4391	+	FULL_NAME = Nelson, Robert
4392	+	EMP_NO = 8
4393	+	FIRST_NAME = Leslie
4394	+	LAST_NAME = Johnson
4395	+	PHONE_EXT = 410
4396	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4397	+	DEPT_NO = 180
4398	+	JOB_CODE = Mktg
4399	+	JOB_GRADE = 3
4400	+	JOB_COUNTRY = USA
4401	+	SALARY = 64,635.00
4402	+	FULL_NAME = Johnson, Leslie
4403	+
4404	+
4405	+	Repeat but with a last dummy row that is ignored
4406	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4407	+	Batch Completion Info
4408	+	Total rows processed = 2
4409	+	Updated Records = 2
4410	+	Row 1 State = bcNoMoreErrors Msg =
4411	+	Row 2 State = bcNoMoreErrors Msg =
4412	+	Rows after update
4413	+	EMP_NO = 2
4414	+	FIRST_NAME = Robert
4415	+	LAST_NAME = Nelson
4416	+	PHONE_EXT = 250
4417	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4418	+	DEPT_NO = 600
4419	+	JOB_CODE = VP
4420	+	JOB_GRADE = 2
4421	+	JOB_COUNTRY = USA
4422	+	SALARY = 105,900.00
4423	+	FULL_NAME = Nelson, Robert
4424	+	EMP_NO = 8
4425	+	FIRST_NAME = Leslie
4426	+	LAST_NAME = Johnson
4427	+	PHONE_EXT = 410
4428	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4429	+	DEPT_NO = 180
4430	+	JOB_CODE = Mktg
4431	+	JOB_GRADE = 3
4432	+	JOB_COUNTRY = USA
4433	+	SALARY = 64,635.00
4434	+	FULL_NAME = Johnson, Leslie
4435	+
4436	+
4437	+	Insert rows
4438	+	Select Count = 0 InsertCount = 3 UpdateCount = 0 DeleteCount = 0
4439	+	Batch Completion Info
4440	+	Total rows processed = 3
4441	+	Updated Records = 3
4442	+	Row 1 State = bcNoMoreErrors Msg =
4443	+	Row 2 State = bcNoMoreErrors Msg =
4444	+	Row 3 State = bcNoMoreErrors Msg =
4445	+	Rows after insert
4446	+	EMP_NO = 150
4447	+	FIRST_NAME = John
4448	+	LAST_NAME = Doe
4449	+	PHONE_EXT =
4450	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4451	+	DEPT_NO = 600
4452	+	JOB_CODE = Eng
4453	+	JOB_GRADE = 4
4454	+	JOB_COUNTRY = England
4455	+	SALARY = 41,000.89
4456	+	FULL_NAME = Doe, John
4457	+	EMP_NO = 151
4458	+	FIRST_NAME = Jane
4459	+	LAST_NAME = Doe
4460	+	PHONE_EXT =
4461	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4462	+	DEPT_NO = 600
4463	+	JOB_CODE = Eng
4464	+	JOB_GRADE = 4
4465	+	JOB_COUNTRY = England
4466	+	SALARY = 42,000.89
4467	+	FULL_NAME = Doe, Jane
4468	+	EMP_NO = 152
4469	+	FIRST_NAME = John
4470	+	LAST_NAME = SmithAndJonesFamily1
4471	+	PHONE_EXT =
4472	+	HIRE_DATE = 2015/04/03 00:00:00.0000
4473	+	DEPT_NO = 600
4474	+	JOB_CODE = Eng
4475	+	JOB_GRADE = 4
4476	+	JOB_COUNTRY = England
4477	+	SALARY = 41,000.99
4478	+	FULL_NAME = SmithAndJonesFamily1, John
4479	+
4480	+
4481	+	Insert rows - and then cancel
4482	+	Cancel Batch - note - next step will fail with a duplicate key if cancel fails
4483	+
4484	+	Insert rows - ignore last row
4485	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4486	+	Batch Completion Info
4487	+	Total rows processed = 2
4488	+	Updated Records = 2
4489	+	Row 1 State = bcNoMoreErrors Msg =
4490	+	Row 2 State = bcNoMoreErrors Msg =
4491	+	Rows after insert
4492	+	EMP_NO = 150
4493	+	FIRST_NAME = John
4494	+	LAST_NAME = Doe
4495	+	PHONE_EXT =
4496	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4497	+	DEPT_NO = 600
4498	+	JOB_CODE = Eng
4499	+	JOB_GRADE = 4
4500	+	JOB_COUNTRY = England
4501	+	SALARY = 41,000.89
4502	+	FULL_NAME = Doe, John
4503	+	EMP_NO = 151
4504	+	FIRST_NAME = Jane
4505	+	LAST_NAME = Doe
4506	+	PHONE_EXT =
4507	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4508	+	DEPT_NO = 600
4509	+	JOB_CODE = Eng
4510	+	JOB_GRADE = 4
4511	+	JOB_COUNTRY = England
4512	+	SALARY = 42,000.89
4513	+	FULL_NAME = Doe, Jane
4514	+
4515	+	Insert with inline blob
4516	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4517	+	Batch Completion Info
4518	+	Total rows processed = 2
4519	+	Updated Records = 2
4520	+	Row 1 State = bcNoMoreErrors Msg =
4521	+	Row 2 State = bcNoMoreErrors Msg =
4522	+	Rows after insert
4523	+	JOB_CODE = ABC
4524	+	JOB_GRADE = 3
4525	+	JOB_COUNTRY = England
4526	+	JOB_TITLE = Chief Tester
4527	+	MIN_SALARY = 21,000.00
4528	+	MAX_SALARY = 24,000.99
4529	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4530	+
4531	+	The quick brown fox jumped over the lazy dog
4532	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4533	+
4534	+	JOB_CODE = DEF
4535	+	JOB_GRADE = 3
4536	+	JOB_COUNTRY = England
4537	+	JOB_TITLE = Deputy Tester
4538	+	MIN_SALARY = 21,000.00
4539	+	MAX_SALARY = 24,000.99
4540	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4541	+
4542	+	The quick brown fox jumped over the running dog
4543	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4544	+
4545	+
4546	+
4547	+	Insert with explicit blob
4548	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4549	+	Batch Completion Info
4550	+	Total rows processed = 2
4551	+	Updated Records = 2
4552	+	Row 1 State = bcNoMoreErrors Msg =
4553	+	Row 2 State = bcNoMoreErrors Msg =
4554	+	Rows after insert
4555	+	JOB_CODE = ABC
4556	+	JOB_GRADE = 3
4557	+	JOB_COUNTRY = England
4558	+	JOB_TITLE = Chief Tester
4559	+	MIN_SALARY = 21,000.00
4560	+	MAX_SALARY = 24,000.99
4561	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4562	+
4563	+	The quick brown fox jumped over the lazy dog
4564	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4565	+
4566	+	JOB_CODE = DEF
4567	+	JOB_GRADE = 3
4568	+	JOB_COUNTRY = England
4569	+	JOB_TITLE = Deputy Tester
4570	+	MIN_SALARY = 21,000.00
4571	+	MAX_SALARY = 24,000.99
4572	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4573	+
4574	+	The quick brown fox jumped over the running dog
4575	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4576	+
4577	+
4578	+	Test Error Handling
4579	+	Error reported (as expected) when changing param type: Param[0] "": Unable to change from a SQL_TIMESTAMP to a string type
4580	+	Test Error Handling - Update returning should fail
4581	+	Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched
4582	+	Error handling when Insert rows - duplicate key
4583	+	Error reported when inserting: Error Processing update/insert batch on row number 2 - SQLCODE: -803
4584	+	Engine Code: 335544665 Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values
4585	+	violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4586	+	-Problematic key value is ("EMP_NO" = 150)
4587	+	Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
4588	+	Batch Completion Info
4589	+	Total rows processed = 2
4590	+	Updated Records = 1
4591	+	Row 1 State = bcNoMoreErrors Msg =
4592	+	Row 2 State = bcExecuteFailed Msg = violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4593	+	-Problematic key value is ("EMP_NO" = 150)
4594	+
4595	+
4596	+	------------------------------------------------------
4597	+	Running Test 20: Stress Test IBatch interface
4598	+	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4599	+	10000 rows added
4600	+	20000 rows added
4601	+	30000 rows added
4602	+	40000 rows added
4603	+	50000 rows added
4604	+	Batch Execute
4605	+	Intermediate Apply Batch on row 50001
4606	+	Batch Completion Info
4607	+	Total rows processed = 50000
4608	+	Updated Rows = 50000
4609	+	Row 50000 State = bcNoMoreErrors Msg =
4610	+	60000 rows added
4611	+	70000 rows added
4612	+	80000 rows added
4613	+	90000 rows added
4614	+	100000 rows added
4615	+	Batch Execute
4616	+	Batch Completion Info
4617	+	Total rows processed = 50000
4618	+	Updated Rows = 50000
4619	+	Row 50000 State = bcNoMoreErrors Msg =
4620	+	Rows in Dataset = 100000
4621	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4622	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4623	+	Test Completed Successfully
4624	+
4625	+
4626	+	------------------------------------------------------
4627	+	Running Test 21: Exercise setting and getting of numeric data types
4628	+	1234.567 parsed to 1234567 scale = -3
4629	+	As Float =  1.2345670000000000E+003
4630	+	-765.4321 parsed to -7654321 scale = -4
4631	+	As Float = -7.6543209999999999E+002
4632	+	0.1 parsed to 1 scale = -1
4633	+	As Float =  1.0000000000000001E-001
4634	+	0.01 parsed to 1 scale = -2
4635	+	As Float =  1.0000000000000000E-002
4636	+	+123 parsed to 123 scale = 0
4637	+	As Float =  1.2300000000000000E+002
4638	+	1.23456E308 parsed to 123456 scale = 303
4639	+	As Float =  1.2345600000000001E+308
4640	+	-1.2e-02 parsed to -12 scale = -3
4641	+	As Float = -1.2000000000000000E-002
4642	+	10. parsed to 10 scale = 0
4643	+	As Float =  1.0000000000000000E+001
4644	+	.12 parsed to 12 scale = -2
4645	+	As Float =  1.2000000000000000E-001
4646	+	0.12 parsed to 12 scale = -2
4647	+	As Float =  1.2000000000000000E-001
4648	+	Parsing of 1.2E1.2 failed
4649	+	Parsing of 1,000 failed
4650	+	Parsing of 1e1e1 failed
4651	+	Parsing of 1.2+3 failed
4652	+	Validating Numeric Interface - IFBNumeric
4653	+	Value from Currency = 9999.1235
4654	+	Raw Value = 99991235 Scale = -4
4655	+	Value from Currency(rescaled) = 9999.12
4656	+	Raw Value = 999912 Scale = -2
4657	+	Value from Double = 9999.12345678
4658	+	Raw Value = 999912345678 Scale = -8
4659	+	Value from Integer = 9223372036854775807
4660	+	Raw Value = 9223372036854775807 Scale = 0
4661	+	Value from string = 9223372036854775807
4662	+	Raw Value = 9223372036854775807 Scale = 0
4663	+	Value from string = 9999.12345678
4664	+	Raw Value = 999912345678 Scale = -8
4665	+	Value from string = -0.12
4666	+	Raw Value = -12 Scale = -3
4667	+	Value from BCD = 9999.12345678
4668	+	Raw Value = 999912345678 Scale = -8
4669	+	Value from Raw Data = 9999123.456780
4670	+	Raw Value = 9999123456780 Scale = -6
4671	+	Numeric Operations
4672	+	Add 2.23 + 24.12345 = 26.35345
4673	+	Add Double 2.23 + 24.12645 = 26.35645
4674	+	Add integer 2.23 + 2412345 = 2412347.23
4675	+	Subtract 2.23 - 24.12345 = -21.89345
4676	+	Subtract Double 24.12645 - 2.23 = -21.89645
4677	+	Subtract integer 24123.45 - 223 = -23900.45
4678	+	Multiply 2.23 * 24.12345 = 53.7952935
4679	+	Multiply Double 24.12645 * 2.23 = 53.8019835
4680	+	Multiply integer 241.2345 * 223 = 53795.2935
4681	+	Divide 24.12345 / 2.23 = 10.81769
4682	+	Divide Double 2.23 / 24.12645 = 0.09
4683	+	Divide integer 241.2345 / 223 = 1.0818
4684	+	Compare 2.23, -24.12345 = 1
4685	+	Compare integer 2.23, 3 = -1
4686	+	Compare Double 2.23, 2.23 = 0
4687	+	Negate 24.12345 = -24.12345
4688	+	SQL Params
4689	+	SQLType =SQL_LONG
4690	+	sub type = 0
4691	+	Field Name =
4692	+	Scale = 0
4693	+	Charset id = 0
4694	+	Not Null
4695	+	Size = 4
4696	+	Value = 0
4697	+
4698	+	SQLType =SQL_LONG
4699	+	sub type = 0
4700	+	Field Name =
4701	+	Scale = 0
4702	+	Charset id = 0
4703	+	Nullable
4704	+	Size = 4
4705	+
4706	+	SQLType =SQL_INT64
4707	+	sub type = 0
4708	+	Field Name =
4709	+	Scale = 0
4710	+	Charset id = 0
4711	+	Nullable
4712	+	Size = 8
4713	+
4714	+	SQLType =SQL_INT64
4715	+	sub type = 0
4716	+	Field Name =
4717	+	Scale = -4
4718	+	Charset id = 0
4719	+	Nullable
4720	+	Size = 8
4721	+
4722	+	SQLType =SQL_DOUBLE
4723	+	sub type = 0
4724	+	Field Name =
4725	+	Scale = 0
4726	+	Charset id = 0
4727	+	Nullable
4728	+	Size = 8
4729	+
4730	+	SQLType =SQL_INT64
4731	+	sub type = 0
4732	+	Field Name =
4733	+	Scale = -6
4734	+	Charset id = 0
4735	+	Nullable
4736	+	Size = 8
4737	+
4738	+	Expected Error - SQLCODE: -303
4739	+	Engine Code: 335544569 Incompatible column/host variable data type
4740	+	Dynamic SQL Error
4741	+	-SQL error code = -303
4742	+	-conversion error from string "1,000"
4743	+	Expected Error - SQLCODE: -303
4744	+	Engine Code: 335544569 Incompatible column/host variable data type
4745	+	Dynamic SQL Error
4746	+	-SQL error code = -303
4747	+	-conversion error from string "10.0.0"
4748	+	Test Numeric Type
4749	+	ROWID = 1
4750	+	ITYPE = 101
4751	+	I64TYPE = 9223372036854775807
4752	+	CURRTYPE = 10,000.12340000
4753	+	DTYPE = 9,999.12345678
4754	+	FIXEDPOINT = 1,234,567,890.12345700
4755	+	ROWID = 2
4756	+	ITYPE = -32457
4757	+	I64TYPE = -9223372036854775808
4758	+	CURRTYPE = 1,000,001.12000000
4759	+	DTYPE = 1.7E308
4760	+	FIXEDPOINT = -1,234,567,890.12345700
4761	+	ROWID = 3
4762	+	ITYPE = 0
4763	+	I64TYPE = 0
4764	+	CURRTYPE = .00000000
4765	+	DTYPE = .00000000
4766	+	FIXEDPOINT = .00000000
4767	+	ROWID = 4
4768	+	ITYPE = 1
4769	+	I64TYPE = 10
4770	+	CURRTYPE = .02300000
4771	+	DTYPE = .00110000
4772	+	FIXEDPOINT = 233.45600000
4773	+	ROWID = 7
4774	+	ITYPE = 1
4775	+	I64TYPE = 1234567
4776	+	CURRTYPE = .02300000
4777	+	DTYPE = .00110000
4778	+	FIXEDPOINT = 1,234.25000000
4779	+
4780	+
4781	+
4782	+	------------------------------------------------------
4783	+	Running Test 22: Journalling
4784	+	Start Journaling. Session ID = 0
4785	+	1234.567 parsed to 1234567 scale = -3
4786	+	As Float =  1.2345670000000000E+003
4787	+	-765.4321 parsed to -7654321 scale = -4
4788	+	As Float = -7.6543209999999999E+002
4789	+	0.1 parsed to 1 scale = -1
4790	+	As Float =  1.0000000000000001E-001
4791	+	0.01 parsed to 1 scale = -2
4792	+	As Float =  1.0000000000000000E-002
4793	+	+123 parsed to 123 scale = 0
4794	+	As Float =  1.2300000000000000E+002
4795	+	1.23456E308 parsed to 123456 scale = 303
4796	+	As Float =  1.2345600000000001E+308
4797	+	-1.2e-02 parsed to -12 scale = -3
4798	+	As Float = -1.2000000000000000E-002
4799	+	10. parsed to 10 scale = 0
4800	+	As Float =  1.0000000000000000E+001
4801	+	.12 parsed to 12 scale = -2
4802	+	As Float =  1.2000000000000000E-001
4803	+	0.12 parsed to 12 scale = -2
4804	+	As Float =  1.2000000000000000E-001
4805	+	Parsing of 1.2E1.2 failed
4806	+	Parsing of 1,000 failed
4807	+	Parsing of 1e1e1 failed
4808	+	Parsing of 1.2+3 failed
4809	+	SQL Params
4810	+	SQLType =SQL_LONG
4811	+	sub type = 0
4812	+	Field Name =
4813	+	Scale = 0
4814	+	Charset id = 0
4815	+	Not Null
4816	+	Size = 4
4817	+	Value = 0
4818	+
4819	+	SQLType =SQL_LONG
4820	+	sub type = 0
4821	+	Field Name =
4822	+	Scale = 0
4823	+	Charset id = 0
4824	+	Nullable
4825	+	Size = 4
4826	+
4827	+	SQLType =SQL_INT64
4828	+	sub type = 0
4829	+	Field Name =
4830	+	Scale = 0
4831	+	Charset id = 0
4832	+	Nullable
4833	+	Size = 8
4834	+
4835	+	SQLType =SQL_INT64
4836	+	sub type = 0
4837	+	Field Name =
4838	+	Scale = -4
4839	+	Charset id = 0
4840	+	Nullable
4841	+	Size = 8
4842	+
4843	+	SQLType =SQL_DOUBLE
4844	+	sub type = 0
4845	+	Field Name =
4846	+	Scale = 0
4847	+	Charset id = 0
4848	+	Nullable
4849	+	Size = 8
4850	+
4851	+	SQLType =SQL_INT64
4852	+	sub type = 0
4853	+	Field Name =
4854	+	Scale = -6
4855	+	Charset id = 0
4856	+	Nullable
4857	+	Size = 8
4858	+
4859	+
4860	+	Text Tests
4861	+	SQL Params
4862	+	SQLType =SQL_LONG
4863	+	sub type = 0
4864	+	Field Name =
4865	+	Scale = 0
4866	+	Charset id = 0
4867	+	Not Null
4868	+	Size = 4
4869	+	Value = 0
4870	+
4871	+	SQLType =SQL_VARYING
4872	+	sub type = 0
4873	+	Field Name =
4874	+	Scale = 0
4875	+	Charset id = 4
4876	+	Nullable
4877	+	Size = 1024
4878	+
4879	+	SQLType =SQL_BLOB
4880	+	sub type = 1
4881	+	Field Name =
4882	+	Scale = 0
4883	+	Charset id = 4
4884	+	Nullable
4885	+	Size = 8
4886	+
4887	+
4888	+	Binary Blob Tests
4889	+
4890	+	Array Test
4891	+	SQL Params
4892	+	SQLType =SQL_LONG
4893	+	sub type = 0
4894	+	Field Name =
4895	+	Scale = 0
4896	+	Charset id = 0
4897	+	Not Null
4898	+	Size = 4
4899	+	Value = 0
4900	+
4901	+	SQLType =SQL_ARRAY
4902	+	sub type = 0
4903	+	Field Name =
4904	+	Scale = 0
4905	+	Charset id = 0
4906	+	Nullable
4907	+	Size = 8
4908	+
4909	+	ROWID = 1
4910	+	ITYPE = 101
4911	+	I64TYPE = 9223372036854775807
4912	+	CURRTYPE = 10,000.12340000
4913	+	DTYPE = 9,999.12345678
4914	+	FIXEDPOINT = 1,234,567,890.12345700
4915	+	STR = NULL
4916	+	TEXTBLOB = NULL
4917	+	OTHERBLOB = NULL
4918	+	MYARRAY = NULL
4919	+	ROWID = 2
4920	+	ITYPE = -32457
4921	+	I64TYPE = -9223372036854775808
4922	+	CURRTYPE = 1,000,001.12000000
4923	+	DTYPE = 1.7E308
4924	+	FIXEDPOINT = -1,234,567,890.12345700
4925	+	STR = NULL
4926	+	TEXTBLOB = NULL
4927	+	OTHERBLOB = NULL
4928	+	MYARRAY = NULL
4929	+	ROWID = 4
4930	+	ITYPE = 1
4931	+	I64TYPE = 10
4932	+	CURRTYPE = .02300000
4933	+	DTYPE = .00110000
4934	+	FIXEDPOINT = 233.45600000
4935	+	STR = NULL
4936	+	TEXTBLOB = NULL
4937	+	OTHERBLOB = NULL
4938	+	MYARRAY = NULL
4939	+
4940	+	Journal Table
4941	+	IBX$SESSIONID = 1
4942	+	IBX$TRANSACTIONID = 8
4943	+	IBX$OLDTRANSACTIONID = NULL
4944	+	IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4945	+	IBX$CREATED = 2022/01/14 22:58:12.7560
4946	+	IBX$SESSIONID = 1
4947	+	IBX$TRANSACTIONID = 10
4948	+	IBX$OLDTRANSACTIONID = 9
4949	+	IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4950	+	IBX$CREATED = 2022/01/14 22:58:13.0520
4951	+
4952	+	Journal Entries
4953	+	Journal Entry = jeTransStart(Transaction Start)
4954	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4955	+	Attachment ID = 4
4956	+	Session ID = 1
4957	+	Transaction ID = 8
4958	+	Transaction Name = "Transaction_29_1"
4959	+	TPB: Item Count = 3
4960	+	isc_tpb_write
4961	+	isc_tpb_nowait
4962	+	isc_tpb_concurrency
4963	+
4964	+	Default Completion = TACommit
4965	+
4966	+	Journal Entry = jeQuery(Query)
4967	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4968	+	Attachment ID = 4
4969	+	Session ID = 1
4970	+	Transaction ID = 8
4971	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
4972	+
4973	+	Journal Entry = jeQuery(Query)
4974	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4975	+	Attachment ID = 4
4976	+	Session ID = 1
4977	+	Transaction ID = 8
4978	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
4979	+
4980	+	Journal Entry = jeTransCommitRet(Commit Retaining)
4981	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4982	+	Attachment ID = 4
4983	+	Session ID = 1
4984	+	Transaction ID = 9
4985	+	Old TransactionID = 8
4986	+
4987	+	Journal Entry = jeQuery(Query)
4988	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4989	+	Attachment ID = 4
4990	+	Session ID = 1
4991	+	Transaction ID = 9
4992	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
4993	+
4994	+	Journal Entry = jeTransRollbackRet(Rollback Retaining)
4995	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4996	+	Attachment ID = 4
4997	+	Session ID = 1
4998	+	Transaction ID = 10
4999	+	Old TransactionID = 9
5000	+
5001	+	Journal Entry = jeQuery(Query)
5002	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5003	+	Attachment ID = 4
5004	+	Session ID = 1
5005	+	Transaction ID = 10
5006	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
5007	+
5008	+	Journal Entry = jeTransStart(Transaction Start)
5009	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5010	+	Attachment ID = 4
5011	+	Session ID = 1
5012	+	Transaction ID = 11
5013	+	Transaction Name = "Transaction_29_2"
5014	+	TPB: Item Count = 3
5015	+	isc_tpb_write
5016	+	isc_tpb_nowait
5017	+	isc_tpb_concurrency
5018	+
5019	+	Default Completion = TARollback
5020	+
5021	+	Journal Entry = jeTransCommit(Commit)
5022	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5023	+	Attachment ID = 4
5024	+	Session ID = 1
5025	+	Transaction ID = 10
5026	+
5027	+	Journal Entry = jeQuery(Query)
5028	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5029	+	Attachment ID = 4
5030	+	Session ID = 1
5031	+	Transaction ID = 11
5032	+	Query = Insert into TestData(RowID, Str, TextBlob) Values(5,'It''s the quick brown fox jumps over the lazy dog','To be or not to be-that is the question:
5033	+	Whether ''tis nobler in the mind to suffer
5034	+	The slings and arrows of outrageous fortune,
5035	+	Or to take arms against a sea of troubles,
5036	+	And, by opposing, end them. To die, to sleep-
5037	+	No more-and by a sleep to say we end
5038	+	The heartache and the thousand natural shocks
5039	+	That flesh is heir to-''tis a consummation
5040	+	Devoutly to be wished. To die, to sleep-
5041	+	To sleep, perchance to dream. Aye, there''s the rub,
5042	+	For in that sleep of death what dreams may come,
5043	+	When we have shuffled off this mortal coil,
5044	+	Must give us pause. There''s the respect
5045	+	That makes calamity of so long life.
5046	+	For who would bear the whips and scorns of time,
5047	+	Th'' oppressor''s wrong, the proud man''s contumely,
5048	+	The pangs of despised love, the law’s delay,
5049	+	The insolence of office, and the spurns
5050	+	That patient merit of the unworthy takes,
5051	+	When he himself might his quietus make
5052	+	With a bare bodkin? Who would fardels bear,
5053	+	To grunt and sweat under a weary life,
5054	+	But that the dread of something after death,
5055	+	The undiscovered country from whose bourn
5056	+	No traveler returns, puzzles the will
5057	+	And makes us rather bear those ills we have
5058	+	Than fly to others that we know not of?
5059	+	Thus conscience does make cowards of us all,
5060	+	And thus the native hue of resolution
5061	+	Is sicklied o''er with the pale cast of thought,
5062	+	And enterprises of great pitch and moment,
5063	+	With this regard their currents turn awry,
5064	+	And lose the name of action.-Soft you now,
5065	+	The fair Ophelia.-Nymph, in thy orisons
5066	+	Be all my sins remembered
5067	+	')
5068	+
5069	+	Journal Entry = jeQuery(Query)
5070	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5071	+	Attachment ID = 4
5072	+	Session ID = 1
5073	+	Transaction ID = 11
5074	+	Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
5075	+	FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
5076	+	0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
5077	+	01000000010000001A01050001000000DA000000
5078	+	</blob>
5079	+	)
5080	+
5081	+	Journal Entry = jeQuery(Query)
5082	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5083	+	Attachment ID = 4
5084	+	Session ID = 1
5085	+	Transaction ID = 11
5086	+	Query = Insert into TestData(RowID,MyArray) Values (7,<array dim = "1" sqltype = "496" length = "4" relation_name = "TESTDATA" column_name = "MYARRAY" scale = "0" bounds="0:16">
5087	+	<elt ix="0">100</elt>
5088	+	<elt ix="1">99</elt>
5089	+	<elt ix="2">98</elt>
5090	+	<elt ix="3">97</elt>
5091	+	<elt ix="4">96</elt>
5092	+	<elt ix="5">95</elt>
5093	+	<elt ix="6">94</elt>
5094	+	<elt ix="7">93</elt>
5095	+	<elt ix="8">92</elt>
5096	+	<elt ix="9">91</elt>
5097	+	<elt ix="10">90</elt>
5098	+	<elt ix="11">89</elt>
5099	+	<elt ix="12">88</elt>
5100	+	<elt ix="13">87</elt>
5101	+	<elt ix="14">86</elt>
5102	+	<elt ix="15">85</elt>
5103	+	<elt ix="16">84</elt>
5104	+	</array>
5105	+	)
5106	+
5107	+	Journal Entry = jeTransRollback(Rollback)
5108	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5109	+	Attachment ID = 4
5110	+	Session ID = 1
5111	+	Transaction ID = 11
5112	+
5113	+
5114	+
5115		------------------------------------------------------
5116		Test Suite Ends

Diff Legend

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