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 375 by tony, Sun Jan 9 23:42:58 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 = 5281
655	+	Transaction is Read/Write
656	+	Transaction Database Path = inet://localhost/employee
657	+	Transaction ID = 5281
658	+	Oldest Interesting = 1895
659	+	Oldest Action = 5280
660	+	Oldest Snapshot = 5280
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,192
696		Delta memory = 4,464
697	<	Max memory = 19,793,248
697	>	Max memory = 19,807,520
698		Elapsed time= 0.002 sec
699		Cpu = 0.000 sec
700		Buffers = 2048
#	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.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: 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.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: 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 = 351
2848	>	Pages Free = 62
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  = 1683
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 = 940
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 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 2833 | Line 2971 | Local Backup
2971
2972
2973
2974	+
2975		Local Backup Complete
2976
2977		Local Restore
#	Line 2859 | Line 2998 | Scale = 0
2998		Charset id = 0
2999		Not Null
3000		Size = 4
3001	+	Value = 0
3002
3003		SQLType =SQL_VARYING
3004		sub type = 0
#	Line 2908 | Line 3048 | Charset id = 4
3048		Nullable
3049		Size = 16
3050
3051	+	Show Param Values
3052	+	SQL Params
3053	+	SQLType =SQL_LONG
3054	+	sub type = 0
3055	+	Field Name = ROWID
3056	+	Scale = 0
3057	+	Charset id = 0
3058	+	Not Null
3059	+	Size = 4
3060	+	Value = 1
3061	+
3062	+	SQLType =SQL_VARYING
3063	+	sub type = 0
3064	+	Field Name = TITLE
3065	+	Scale = 0
3066	+	Charset id = 4
3067	+	Nullable
3068	+	Size = 128
3069	+	Value = Blob Test ©€
3070	+
3071	+	SQLType =SQL_VARYING
3072	+	sub type = 0
3073	+	Field Name = NOTES
3074	+	Scale = 0
3075	+	Charset id = 4
3076	+	Nullable
3077	+	Size = 256
3078	+	Value = Écoute moi
3079	+
3080	+	SQLType =SQL_VARYING
3081	+	sub type = 1
3082	+	Field Name = BLOBDATA
3083	+	Scale = 0
3084	+	Charset id = 4
3085	+	Nullable
3086	+	Size = 8192
3087	+	Value = Some German Special Characters like ÖÄÜöäüß
3088	+
3089	+	SQLType =SQL_BLOB
3090	+	sub type = 1
3091	+	Field Name = BLOBDATA2
3092	+	Scale = 0
3093	+	Charset id = 4
3094	+	Nullable
3095	+	Size = 8
3096	+	Value = Some German Special Characters like ÖÄÜöäüß
3097	+
3098	+	SQLType =SQL_VARYING
3099	+	sub type = 0
3100	+	Field Name = INCLEAR
3101	+	Scale = 0
3102	+	Charset id = 1
3103	+	Nullable
3104	+	Size = 16
3105	+	Value = &Test
3106
3107	+
3108	+	SQLType =SQL_VARYING
3109	+	sub type = 0
3110	+	Field Name = FIXEDWIDTH
3111	+	Scale = 0
3112	+	Charset id = 4
3113	+	Nullable
3114	+	Size = 16
3115	+	Value = É
3116	+
3117		Connection Character Set UTF8
3118		ROWID = 1
3119		TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
#	Line 3022 | Line 3227 | ROWID = 1
3227		TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3228		BLOBDATA = (blob), Length = 92514
3229
3230	+	ROWID = 2
3231	+	TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3232	+	BLOBDATA = (blob), Length = 13
3233	+	0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3234
3235		Testdata 2
3236
#	Line 3036 | Line 3245 | Écoute moi
3245		------------------------------------------------------
3246		Running Test 16: Error handling
3247		Invalid Database Name Test
3248	<	Error Handled: I/O error during "open" operation for file "Malformed Name"
3248	>	Error Handled: SQLCODE: -902
3249	>	Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3250	>	I/O error during "open" operation for file "Malformed Name"
3251		-Error while trying to open file
3252		-No such file or directory
3253		Invalid User Name Test
3254	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3254	>	Error Handled: SQLCODE: -902
3255	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3256	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3257		Invalid password Test
3258	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3258	>	Error Handled: SQLCODE: -902
3259	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3260	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3261		Invalid Prepare SQL Test
3262	<	Error Handled: Dynamic SQL Error
3262	>	Error Handled: SQLCODE: -206
3263	>	Engine Code: 335544569 Column does not belong to referenced table
3264	>	Dynamic SQL Error
3265		-SQL error code = -206
3266		-Column unknown
3267		-UNKNOWN_DATE
3268		-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3269		Invalid Open Cursor SQL Test
3270	<	Error Handled: Dynamic SQL Error
3270	>	Error Handled: SQLCODE: -206
3271	>	Engine Code: 335544569 Column does not belong to referenced table
3272	>	Dynamic SQL Error
3273		-SQL error code = -206
3274		-Column unknown
3275		-X
#	Line 3061 | Line 3280 | Invalid Param SQL Type Test
3280		Error Handled: Field "EMP_NO" not found
3281		Case sensitive Param SQL  Test
3282		Error Handled: Field "EMP_NO" not found
3283	+	Stale Reference Check
3284	+	First test correct usage
3285	+	COUNTER = 42
3286	+
3287	+	New Transaction before param set
3288	+	Error Handled: This interface is no longer up-to-date
3289	+	New Transaction before Open Cursor
3290	+	Error Handled: This interface is no longer up-to-date
3291	+	Stop Stale Reference Checks
3292	+	New Transaction before param set
3293	+	COUNTER = 42
3294	+
3295	+	New Transaction before Open Cursor
3296	+	COUNTER = 42
3297	+
3298		Invalid Server Name Test
3299	<	Error Handled: Unable to complete network request to host "unknown".
3299	>	Error Handled: SQLCODE: -902
3300	>	Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3301	>	Unable to complete network request to host "unknown".
3302		-Failed to locate host machine.
3303		-The specified name was not found in the hosts file or Domain Name Services
3304		Invalid User Name Test
3305	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3305	>	Error Handled: SQLCODE: -902
3306	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3307	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3308		Invalid password Test
3309	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3309	>	Error Handled: SQLCODE: -902
3310	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3311	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3312
3313
3314		------------------------------------------------------
3315		Running Test 17: Date/Time tests and Firebird 4 extensions
3316	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
3316	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
3317		Has Local TZ DB = TRUE
3318
3319		Testdata
#	Line 3835 | Line 4075 | TZ_MINUTE = 0
4075
4076		------------------------------------------------------
4077		Running Test 18: Firebird 4 Decfloat extensions
4078	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
4078	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4079
4080		FB4 Testdata_DECFloat
4081
#	Line 3937 | Line 4177 | BigInteger = 123456789123456789
4177		Special = 0
4178		Places = 0
4179		Digits = 12 34 56 78 91 23 45 67 89
4180	+
4181		RowID = 2
4182		Float16 = -64000000000.01
4183		Precision = 13
#	Line 3957 | Line 4198 | BigNumber = -123456123456.123456
4198		Places = 6
4199		Digits = 12 34 56 12 34 56 12 34 56
4200		BigInteger = Null
4201	+
4202		RowID = 3
4203		Float16 = 64100000000.011
4204		Precision = 14
#	Line 3983 | Line 4225 | BiggerNumber = 1112345612345612345612345
4225		Places = 4
4226		Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35
4227		BigInteger = Null
4228	+
4229		RowID = 4
4230		Float16 = 0
4231		Precision = 0
#	Line 4009 | Line 4252 | BiggerNumber = 0.0000
4252		Places = 0
4253		Digits =
4254		BigInteger = Null
4255	+
4256		Metadata
4257		SQLType =SQL_LONG
4258		sub type = 0
#	Line 4096 | Line 4340 | BigNumber Array: (0: 123456123400.123456
4340
4341
4342
4343	+	------------------------------------------------------
4344	+	Running Test 19: Batch Update and Insert Queries
4345	+	Opening inet://localhost/employee
4346	+	Database Open
4347	+	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4348	+	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
4349	+	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
4350	+	on disk structure version 13.0
4351	+	Rows before update
4352	+	EMP_NO = 2
4353	+	FIRST_NAME = Robert
4354	+	LAST_NAME = Nelson
4355	+	PHONE_EXT = 250
4356	+	HIRE_DATE = 1988/12/28 00:00:00.0000
4357	+	DEPT_NO = 600
4358	+	JOB_CODE = VP
4359	+	JOB_GRADE = 2
4360	+	JOB_COUNTRY = USA
4361	+	SALARY = 105,900.00
4362	+	FULL_NAME = Nelson, Robert
4363	+	EMP_NO = 8
4364	+	FIRST_NAME = Leslie
4365	+	LAST_NAME = Johnson
4366	+	PHONE_EXT = 410
4367	+	HIRE_DATE = 1989/04/05 00:00:00.0000
4368	+	DEPT_NO = 180
4369	+	JOB_CODE = Mktg
4370	+	JOB_GRADE = 3
4371	+	JOB_COUNTRY = USA
4372	+	SALARY = 64,635.00
4373	+	FULL_NAME = Johnson, Leslie
4374	+
4375	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4376	+	Batch Completion Info
4377	+	Total rows processed = 2
4378	+	Updated Records = 2
4379	+	Row 1 State = bcNoMoreErrors Msg =
4380	+	Row 2 State = bcNoMoreErrors Msg =
4381	+	Rows after update
4382	+	EMP_NO = 2
4383	+	FIRST_NAME = Robert
4384	+	LAST_NAME = Nelson
4385	+	PHONE_EXT = 250
4386	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4387	+	DEPT_NO = 600
4388	+	JOB_CODE = VP
4389	+	JOB_GRADE = 2
4390	+	JOB_COUNTRY = USA
4391	+	SALARY = 105,900.00
4392	+	FULL_NAME = Nelson, Robert
4393	+	EMP_NO = 8
4394	+	FIRST_NAME = Leslie
4395	+	LAST_NAME = Johnson
4396	+	PHONE_EXT = 410
4397	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4398	+	DEPT_NO = 180
4399	+	JOB_CODE = Mktg
4400	+	JOB_GRADE = 3
4401	+	JOB_COUNTRY = USA
4402	+	SALARY = 64,635.00
4403	+	FULL_NAME = Johnson, Leslie
4404	+
4405	+
4406	+	Repeat but with a last dummy row that is ignored
4407	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4408	+	Batch Completion Info
4409	+	Total rows processed = 2
4410	+	Updated Records = 2
4411	+	Row 1 State = bcNoMoreErrors Msg =
4412	+	Row 2 State = bcNoMoreErrors Msg =
4413	+	Rows after update
4414	+	EMP_NO = 2
4415	+	FIRST_NAME = Robert
4416	+	LAST_NAME = Nelson
4417	+	PHONE_EXT = 250
4418	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4419	+	DEPT_NO = 600
4420	+	JOB_CODE = VP
4421	+	JOB_GRADE = 2
4422	+	JOB_COUNTRY = USA
4423	+	SALARY = 105,900.00
4424	+	FULL_NAME = Nelson, Robert
4425	+	EMP_NO = 8
4426	+	FIRST_NAME = Leslie
4427	+	LAST_NAME = Johnson
4428	+	PHONE_EXT = 410
4429	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4430	+	DEPT_NO = 180
4431	+	JOB_CODE = Mktg
4432	+	JOB_GRADE = 3
4433	+	JOB_COUNTRY = USA
4434	+	SALARY = 64,635.00
4435	+	FULL_NAME = Johnson, Leslie
4436	+
4437	+
4438	+	Insert rows
4439	+	Select Count = 0 InsertCount = 3 UpdateCount = 0 DeleteCount = 0
4440	+	Batch Completion Info
4441	+	Total rows processed = 3
4442	+	Updated Records = 3
4443	+	Row 1 State = bcNoMoreErrors Msg =
4444	+	Row 2 State = bcNoMoreErrors Msg =
4445	+	Row 3 State = bcNoMoreErrors Msg =
4446	+	Rows after insert
4447	+	EMP_NO = 150
4448	+	FIRST_NAME = John
4449	+	LAST_NAME = Doe
4450	+	PHONE_EXT =
4451	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4452	+	DEPT_NO = 600
4453	+	JOB_CODE = Eng
4454	+	JOB_GRADE = 4
4455	+	JOB_COUNTRY = England
4456	+	SALARY = 41,000.89
4457	+	FULL_NAME = Doe, John
4458	+	EMP_NO = 151
4459	+	FIRST_NAME = Jane
4460	+	LAST_NAME = Doe
4461	+	PHONE_EXT =
4462	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4463	+	DEPT_NO = 600
4464	+	JOB_CODE = Eng
4465	+	JOB_GRADE = 4
4466	+	JOB_COUNTRY = England
4467	+	SALARY = 42,000.89
4468	+	FULL_NAME = Doe, Jane
4469	+	EMP_NO = 152
4470	+	FIRST_NAME = John
4471	+	LAST_NAME = SmithAndJonesFamily1
4472	+	PHONE_EXT =
4473	+	HIRE_DATE = 2015/04/03 00:00:00.0000
4474	+	DEPT_NO = 600
4475	+	JOB_CODE = Eng
4476	+	JOB_GRADE = 4
4477	+	JOB_COUNTRY = England
4478	+	SALARY = 41,000.99
4479	+	FULL_NAME = SmithAndJonesFamily1, John
4480	+
4481	+
4482	+	Insert rows - and then cancel
4483	+	Cancel Batch - note - next step will fail with a duplicate key if cancel fails
4484	+
4485	+	Insert rows - ignore last row
4486	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4487	+	Batch Completion Info
4488	+	Total rows processed = 2
4489	+	Updated Records = 2
4490	+	Row 1 State = bcNoMoreErrors Msg =
4491	+	Row 2 State = bcNoMoreErrors Msg =
4492	+	Rows after insert
4493	+	EMP_NO = 150
4494	+	FIRST_NAME = John
4495	+	LAST_NAME = Doe
4496	+	PHONE_EXT =
4497	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4498	+	DEPT_NO = 600
4499	+	JOB_CODE = Eng
4500	+	JOB_GRADE = 4
4501	+	JOB_COUNTRY = England
4502	+	SALARY = 41,000.89
4503	+	FULL_NAME = Doe, John
4504	+	EMP_NO = 151
4505	+	FIRST_NAME = Jane
4506	+	LAST_NAME = Doe
4507	+	PHONE_EXT =
4508	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4509	+	DEPT_NO = 600
4510	+	JOB_CODE = Eng
4511	+	JOB_GRADE = 4
4512	+	JOB_COUNTRY = England
4513	+	SALARY = 42,000.89
4514	+	FULL_NAME = Doe, Jane
4515	+
4516	+	Insert with inline blob
4517	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4518	+	Batch Completion Info
4519	+	Total rows processed = 2
4520	+	Updated Records = 2
4521	+	Row 1 State = bcNoMoreErrors Msg =
4522	+	Row 2 State = bcNoMoreErrors Msg =
4523	+	Rows after insert
4524	+	JOB_CODE = ABC
4525	+	JOB_GRADE = 3
4526	+	JOB_COUNTRY = England
4527	+	JOB_TITLE = Chief Tester
4528	+	MIN_SALARY = 21,000.00
4529	+	MAX_SALARY = 24,000.99
4530	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4531	+
4532	+	The quick brown fox jumped over the lazy dog
4533	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4534	+
4535	+	JOB_CODE = DEF
4536	+	JOB_GRADE = 3
4537	+	JOB_COUNTRY = England
4538	+	JOB_TITLE = Deputy Tester
4539	+	MIN_SALARY = 21,000.00
4540	+	MAX_SALARY = 24,000.99
4541	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4542	+
4543	+	The quick brown fox jumped over the running dog
4544	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4545	+
4546	+
4547	+
4548	+	Insert with explicit blob
4549	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4550	+	Batch Completion Info
4551	+	Total rows processed = 2
4552	+	Updated Records = 2
4553	+	Row 1 State = bcNoMoreErrors Msg =
4554	+	Row 2 State = bcNoMoreErrors Msg =
4555	+	Rows after insert
4556	+	JOB_CODE = ABC
4557	+	JOB_GRADE = 3
4558	+	JOB_COUNTRY = England
4559	+	JOB_TITLE = Chief Tester
4560	+	MIN_SALARY = 21,000.00
4561	+	MAX_SALARY = 24,000.99
4562	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4563	+
4564	+	The quick brown fox jumped over the lazy dog
4565	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4566	+
4567	+	JOB_CODE = DEF
4568	+	JOB_GRADE = 3
4569	+	JOB_COUNTRY = England
4570	+	JOB_TITLE = Deputy Tester
4571	+	MIN_SALARY = 21,000.00
4572	+	MAX_SALARY = 24,000.99
4573	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4574	+
4575	+	The quick brown fox jumped over the running dog
4576	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4577	+
4578	+
4579	+	Test Error Handling
4580	+	Error reported (as expected) when changing param type: Param[0] "": Unable to change from a SQL_TIMESTAMP to a string type
4581	+	Test Error Handling - Update returning should fail
4582	+	Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched
4583	+	Error handling when Insert rows - duplicate key
4584	+	Error reported when inserting: Error Processing update/insert batch on row number 2 - SQLCODE: -803
4585	+	Engine Code: 335544665 Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values
4586	+	violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4587	+	-Problematic key value is ("EMP_NO" = 150)
4588	+	Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
4589	+	Batch Completion Info
4590	+	Total rows processed = 2
4591	+	Updated Records = 1
4592	+	Row 1 State = bcNoMoreErrors Msg =
4593	+	Row 2 State = bcExecuteFailed Msg = violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4594	+	-Problematic key value is ("EMP_NO" = 150)
4595	+
4596	+
4597	+	------------------------------------------------------
4598	+	Running Test 20: Stress Test IBatch interface
4599	+	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4600	+	10000 rows added
4601	+	20000 rows added
4602	+	30000 rows added
4603	+	40000 rows added
4604	+	50000 rows added
4605	+	Batch Execute
4606	+	Intermediate Apply Batch on row 50001
4607	+	Batch Completion Info
4608	+	Total rows processed = 50000
4609	+	Updated Rows = 50000
4610	+	Row 50000 State = bcNoMoreErrors Msg =
4611	+	60000 rows added
4612	+	70000 rows added
4613	+	80000 rows added
4614	+	90000 rows added
4615	+	100000 rows added
4616	+	Batch Execute
4617	+	Batch Completion Info
4618	+	Total rows processed = 50000
4619	+	Updated Rows = 50000
4620	+	Row 50000 State = bcNoMoreErrors Msg =
4621	+	Rows in Dataset = 100000
4622	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4623	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4624	+	Test Completed Successfully
4625	+
4626	+
4627	+	------------------------------------------------------
4628	+	Running Test 21: Exercise setting and getting of numeric data types
4629	+	1234.567 parsed to 1234567 scale = -3
4630	+	As Float =  1.2345670000000000E+003
4631	+	-765.4321 parsed to -7654321 scale = -4
4632	+	As Float = -7.6543209999999999E+002
4633	+	0.1 parsed to 1 scale = -1
4634	+	As Float =  1.0000000000000001E-001
4635	+	0.01 parsed to 1 scale = -2
4636	+	As Float =  1.0000000000000000E-002
4637	+	+123 parsed to 123 scale = 0
4638	+	As Float =  1.2300000000000000E+002
4639	+	1.23456E308 parsed to 123456 scale = 303
4640	+	As Float =  1.2345600000000001E+308
4641	+	-1.2e-02 parsed to -12 scale = -3
4642	+	As Float = -1.2000000000000000E-002
4643	+	10. parsed to 10 scale = 0
4644	+	As Float =  1.0000000000000000E+001
4645	+	.12 parsed to 12 scale = -2
4646	+	As Float =  1.2000000000000000E-001
4647	+	0.12 parsed to 12 scale = -2
4648	+	As Float =  1.2000000000000000E-001
4649	+	Parsing of 1.2E1.2 failed
4650	+	Parsing of 1,000 failed
4651	+	Parsing of 1e1e1 failed
4652	+	Parsing of 1.2+3 failed
4653	+	Validating Numeric Interface - IFBNumeric
4654	+	Value from Currency = 9999.1235
4655	+	Raw Value = 99991235 Scale = -4
4656	+	Value from Currency(rescaled) = 9999.12
4657	+	Raw Value = 999912 Scale = -2
4658	+	Value from Double = 9999.12345678
4659	+	Raw Value = 999912345678 Scale = -8
4660	+	Value from Integer = 9223372036854775807
4661	+	Raw Value = 9223372036854775807 Scale = 0
4662	+	Value from string = 9223372036854775807
4663	+	Raw Value = 9223372036854775807 Scale = 0
4664	+	Value from string = 9999.12345678
4665	+	Raw Value = 999912345678 Scale = -8
4666	+	Value from string = -0.12
4667	+	Raw Value = -12 Scale = -3
4668	+	Value from BCD = 9999.12345678
4669	+	Raw Value = 999912345678 Scale = -8
4670	+	Value from Raw Data = 9999123.456780
4671	+	Raw Value = 9999123456780 Scale = -6
4672	+	SQL Params
4673	+	SQLType =SQL_LONG
4674	+	sub type = 0
4675	+	Field Name =
4676	+	Scale = 0
4677	+	Charset id = 0
4678	+	Not Null
4679	+	Size = 4
4680	+	Value = 0
4681	+
4682	+	SQLType =SQL_LONG
4683	+	sub type = 0
4684	+	Field Name =
4685	+	Scale = 0
4686	+	Charset id = 0
4687	+	Nullable
4688	+	Size = 4
4689	+
4690	+	SQLType =SQL_INT64
4691	+	sub type = 0
4692	+	Field Name =
4693	+	Scale = 0
4694	+	Charset id = 0
4695	+	Nullable
4696	+	Size = 8
4697	+
4698	+	SQLType =SQL_INT64
4699	+	sub type = 0
4700	+	Field Name =
4701	+	Scale = -4
4702	+	Charset id = 0
4703	+	Nullable
4704	+	Size = 8
4705	+
4706	+	SQLType =SQL_DOUBLE
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 = -6
4718	+	Charset id = 0
4719	+	Nullable
4720	+	Size = 8
4721	+
4722	+	Expected Error - SQLCODE: -303
4723	+	Engine Code: 335544569 Incompatible column/host variable data type
4724	+	Dynamic SQL Error
4725	+	-SQL error code = -303
4726	+	-conversion error from string "1,000"
4727	+	Expected Error - SQLCODE: -303
4728	+	Engine Code: 335544569 Incompatible column/host variable data type
4729	+	Dynamic SQL Error
4730	+	-SQL error code = -303
4731	+	-conversion error from string "10.0.0"
4732	+	Test Numeric Type
4733	+	ROWID = 1
4734	+	ITYPE = 101
4735	+	I64TYPE = 9223372036854775807
4736	+	CURRTYPE = 10,000.12340000
4737	+	DTYPE = 9,999.12345678
4738	+	FIXEDPOINT = 1,234,567,890.12345700
4739	+	ROWID = 2
4740	+	ITYPE = -32457
4741	+	I64TYPE = -9223372036854775808
4742	+	CURRTYPE = 1,000,001.12000000
4743	+	DTYPE = 1.7E308
4744	+	FIXEDPOINT = -1,234,567,890.12345700
4745	+	ROWID = 3
4746	+	ITYPE = 0
4747	+	I64TYPE = 0
4748	+	CURRTYPE = .00000000
4749	+	DTYPE = .00000000
4750	+	FIXEDPOINT = .00000000
4751	+	ROWID = 4
4752	+	ITYPE = 1
4753	+	I64TYPE = 10
4754	+	CURRTYPE = .02300000
4755	+	DTYPE = .00110000
4756	+	FIXEDPOINT = 233.45600000
4757	+	ROWID = 7
4758	+	ITYPE = 1
4759	+	I64TYPE = 1234567
4760	+	CURRTYPE = .02300000
4761	+	DTYPE = .00110000
4762	+	FIXEDPOINT = 1,234.25000000
4763	+
4764	+
4765	+
4766	+	------------------------------------------------------
4767	+	Running Test 22: Journalling
4768	+	Start Journaling. Session ID = 0
4769	+	1234.567 parsed to 1234567 scale = -3
4770	+	As Float =  1.2345670000000000E+003
4771	+	-765.4321 parsed to -7654321 scale = -4
4772	+	As Float = -7.6543209999999999E+002
4773	+	0.1 parsed to 1 scale = -1
4774	+	As Float =  1.0000000000000001E-001
4775	+	0.01 parsed to 1 scale = -2
4776	+	As Float =  1.0000000000000000E-002
4777	+	+123 parsed to 123 scale = 0
4778	+	As Float =  1.2300000000000000E+002
4779	+	1.23456E308 parsed to 123456 scale = 303
4780	+	As Float =  1.2345600000000001E+308
4781	+	-1.2e-02 parsed to -12 scale = -3
4782	+	As Float = -1.2000000000000000E-002
4783	+	10. parsed to 10 scale = 0
4784	+	As Float =  1.0000000000000000E+001
4785	+	.12 parsed to 12 scale = -2
4786	+	As Float =  1.2000000000000000E-001
4787	+	0.12 parsed to 12 scale = -2
4788	+	As Float =  1.2000000000000000E-001
4789	+	Parsing of 1.2E1.2 failed
4790	+	Parsing of 1,000 failed
4791	+	Parsing of 1e1e1 failed
4792	+	Parsing of 1.2+3 failed
4793	+	SQL Params
4794	+	SQLType =SQL_LONG
4795	+	sub type = 0
4796	+	Field Name =
4797	+	Scale = 0
4798	+	Charset id = 0
4799	+	Not Null
4800	+	Size = 4
4801	+	Value = 0
4802	+
4803	+	SQLType =SQL_LONG
4804	+	sub type = 0
4805	+	Field Name =
4806	+	Scale = 0
4807	+	Charset id = 0
4808	+	Nullable
4809	+	Size = 4
4810	+
4811	+	SQLType =SQL_INT64
4812	+	sub type = 0
4813	+	Field Name =
4814	+	Scale = 0
4815	+	Charset id = 0
4816	+	Nullable
4817	+	Size = 8
4818	+
4819	+	SQLType =SQL_INT64
4820	+	sub type = 0
4821	+	Field Name =
4822	+	Scale = -4
4823	+	Charset id = 0
4824	+	Nullable
4825	+	Size = 8
4826	+
4827	+	SQLType =SQL_DOUBLE
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 = -6
4839	+	Charset id = 0
4840	+	Nullable
4841	+	Size = 8
4842	+
4843	+
4844	+	Text Tests
4845	+	SQL Params
4846	+	SQLType =SQL_LONG
4847	+	sub type = 0
4848	+	Field Name =
4849	+	Scale = 0
4850	+	Charset id = 0
4851	+	Not Null
4852	+	Size = 4
4853	+	Value = 0
4854	+
4855	+	SQLType =SQL_VARYING
4856	+	sub type = 0
4857	+	Field Name =
4858	+	Scale = 0
4859	+	Charset id = 4
4860	+	Nullable
4861	+	Size = 1024
4862	+
4863	+	SQLType =SQL_BLOB
4864	+	sub type = 1
4865	+	Field Name =
4866	+	Scale = 0
4867	+	Charset id = 4
4868	+	Nullable
4869	+	Size = 8
4870	+
4871	+
4872	+	Binary Blob Tests
4873	+
4874	+	Array Test
4875	+	SQL Params
4876	+	SQLType =SQL_LONG
4877	+	sub type = 0
4878	+	Field Name =
4879	+	Scale = 0
4880	+	Charset id = 0
4881	+	Not Null
4882	+	Size = 4
4883	+	Value = 0
4884	+
4885	+	SQLType =SQL_ARRAY
4886	+	sub type = 0
4887	+	Field Name =
4888	+	Scale = 0
4889	+	Charset id = 0
4890	+	Nullable
4891	+	Size = 8
4892	+
4893	+	ROWID = 1
4894	+	ITYPE = 101
4895	+	I64TYPE = 9223372036854775807
4896	+	CURRTYPE = 10,000.12340000
4897	+	DTYPE = 9,999.12345678
4898	+	FIXEDPOINT = 1,234,567,890.12345700
4899	+	STR = NULL
4900	+	TEXTBLOB = NULL
4901	+	OTHERBLOB = NULL
4902	+	MYARRAY = NULL
4903	+	ROWID = 2
4904	+	ITYPE = -32457
4905	+	I64TYPE = -9223372036854775808
4906	+	CURRTYPE = 1,000,001.12000000
4907	+	DTYPE = 1.7E308
4908	+	FIXEDPOINT = -1,234,567,890.12345700
4909	+	STR = NULL
4910	+	TEXTBLOB = NULL
4911	+	OTHERBLOB = NULL
4912	+	MYARRAY = NULL
4913	+	ROWID = 4
4914	+	ITYPE = 1
4915	+	I64TYPE = 10
4916	+	CURRTYPE = .02300000
4917	+	DTYPE = .00110000
4918	+	FIXEDPOINT = 233.45600000
4919	+	STR = NULL
4920	+	TEXTBLOB = NULL
4921	+	OTHERBLOB = NULL
4922	+	MYARRAY = NULL
4923	+
4924	+	Journal Table
4925	+	IBX$SESSIONID = 1
4926	+	IBX$TRANSACTIONID = 8
4927	+	IBX$OLDTRANSACTIONID = NULL
4928	+	IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4929	+	IBX$CREATED = 2022/01/09 15:24:09.1790
4930	+	IBX$SESSIONID = 1
4931	+	IBX$TRANSACTIONID = 10
4932	+	IBX$OLDTRANSACTIONID = 9
4933	+	IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4934	+	IBX$CREATED = 2022/01/09 15:24:09.5040
4935	+
4936	+	Journal Entries
4937	+	Journal Entry = jeTransStart(Transaction Start)
4938	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4939	+	Attachment ID = 4
4940	+	Session ID = 1
4941	+	Transaction ID = 8
4942	+	Transaction Name = "Transaction_29_1"
4943	+	TPB: Item Count = 3
4944	+	isc_tpb_write
4945	+	isc_tpb_nowait
4946	+	isc_tpb_concurrency
4947	+
4948	+	Default Completion = TACommit
4949	+
4950	+	Journal Entry = jeQuery(Query)
4951	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4952	+	Attachment ID = 4
4953	+	Session ID = 1
4954	+	Transaction ID = 8
4955	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
4956	+
4957	+	Journal Entry = jeQuery(Query)
4958	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4959	+	Attachment ID = 4
4960	+	Session ID = 1
4961	+	Transaction ID = 8
4962	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
4963	+
4964	+	Journal Entry = jeTransCommitRet(Commit Retaining)
4965	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4966	+	Attachment ID = 4
4967	+	Session ID = 1
4968	+	Transaction ID = 9
4969	+	Old TransactionID = 8
4970	+
4971	+	Journal Entry = jeQuery(Query)
4972	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4973	+	Attachment ID = 4
4974	+	Session ID = 1
4975	+	Transaction ID = 9
4976	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
4977	+
4978	+	Journal Entry = jeTransRollbackRet(Rollback Retaining)
4979	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4980	+	Attachment ID = 4
4981	+	Session ID = 1
4982	+	Transaction ID = 10
4983	+	Old TransactionID = 9
4984	+
4985	+	Journal Entry = jeQuery(Query)
4986	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4987	+	Attachment ID = 4
4988	+	Session ID = 1
4989	+	Transaction ID = 10
4990	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
4991	+
4992	+	Journal Entry = jeTransStart(Transaction Start)
4993	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4994	+	Attachment ID = 4
4995	+	Session ID = 1
4996	+	Transaction ID = 11
4997	+	Transaction Name = "Transaction_29_2"
4998	+	TPB: Item Count = 3
4999	+	isc_tpb_write
5000	+	isc_tpb_nowait
5001	+	isc_tpb_concurrency
5002	+
5003	+	Default Completion = TARollback
5004	+
5005	+	Journal Entry = jeTransCommit(Commit)
5006	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5007	+	Attachment ID = 4
5008	+	Session ID = 1
5009	+	Transaction ID = 10
5010	+
5011	+	Journal Entry = jeQuery(Query)
5012	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5013	+	Attachment ID = 4
5014	+	Session ID = 1
5015	+	Transaction ID = 11
5016	+	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:
5017	+	Whether ''tis nobler in the mind to suffer
5018	+	The slings and arrows of outrageous fortune,
5019	+	Or to take arms against a sea of troubles,
5020	+	And, by opposing, end them. To die, to sleep-
5021	+	No more-and by a sleep to say we end
5022	+	The heartache and the thousand natural shocks
5023	+	That flesh is heir to-''tis a consummation
5024	+	Devoutly to be wished. To die, to sleep-
5025	+	To sleep, perchance to dream. Aye, there''s the rub,
5026	+	For in that sleep of death what dreams may come,
5027	+	When we have shuffled off this mortal coil,
5028	+	Must give us pause. There''s the respect
5029	+	That makes calamity of so long life.
5030	+	For who would bear the whips and scorns of time,
5031	+	Th'' oppressor''s wrong, the proud man''s contumely,
5032	+	The pangs of despised love, the law’s delay,
5033	+	The insolence of office, and the spurns
5034	+	That patient merit of the unworthy takes,
5035	+	When he himself might his quietus make
5036	+	With a bare bodkin? Who would fardels bear,
5037	+	To grunt and sweat under a weary life,
5038	+	But that the dread of something after death,
5039	+	The undiscovered country from whose bourn
5040	+	No traveler returns, puzzles the will
5041	+	And makes us rather bear those ills we have
5042	+	Than fly to others that we know not of?
5043	+	Thus conscience does make cowards of us all,
5044	+	And thus the native hue of resolution
5045	+	Is sicklied o''er with the pale cast of thought,
5046	+	And enterprises of great pitch and moment,
5047	+	With this regard their currents turn awry,
5048	+	And lose the name of action.-Soft you now,
5049	+	The fair Ophelia.-Nymph, in thy orisons
5050	+	Be all my sins remembered
5051	+	')
5052	+
5053	+	Journal Entry = jeQuery(Query)
5054	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5055	+	Attachment ID = 4
5056	+	Session ID = 1
5057	+	Transaction ID = 11
5058	+	Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
5059	+	FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
5060	+	0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
5061	+	01000000010000001A01050001000000DA000000
5062	+	</blob>
5063	+	)
5064	+
5065	+	Journal Entry = jeQuery(Query)
5066	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5067	+	Attachment ID = 4
5068	+	Session ID = 1
5069	+	Transaction ID = 11
5070	+	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">
5071	+	<elt ix="0">100</elt>
5072	+	<elt ix="1">99</elt>
5073	+	<elt ix="2">98</elt>
5074	+	<elt ix="3">97</elt>
5075	+	<elt ix="4">96</elt>
5076	+	<elt ix="5">95</elt>
5077	+	<elt ix="6">94</elt>
5078	+	<elt ix="7">93</elt>
5079	+	<elt ix="8">92</elt>
5080	+	<elt ix="9">91</elt>
5081	+	<elt ix="10">90</elt>
5082	+	<elt ix="11">89</elt>
5083	+	<elt ix="12">88</elt>
5084	+	<elt ix="13">87</elt>
5085	+	<elt ix="14">86</elt>
5086	+	<elt ix="15">85</elt>
5087	+	<elt ix="16">84</elt>
5088	+	</array>
5089	+	)
5090	+
5091	+	Journal Entry = jeTransRollback(Rollback)
5092	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5093	+	Attachment ID = 4
5094	+	Session ID = 1
5095	+	Transaction ID = 11
5096	+
5097	+
5098	+
5099		------------------------------------------------------
5100		Test Suite Ends

Diff Legend

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