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/journaling/fbintf/testsuite/FB4reference.log (file contents), Revision 363 by tony, Tue Dec 7 13:30:05 2021 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.0
7	>	Firebird Bin Directory = /opt/firebird4.0.0/bin
8	>	Firebird Conf Directory = /opt/firebird4.0.0/
9	>	Firebird Client Library Path = /opt/firebird4.0.0/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 ""
#	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.0/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.0.2496 Firebird 4.0"
34	>	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C"
35	>	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16: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.0/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.0/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 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.0/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 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.0/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 = 6547
655	+	Transaction is Read/Write
656	+	Transaction Database Path = inet://localhost/employee
657	+	Transaction ID = 6547
658	+	Oldest Interesting = 6545
659	+	Oldest Action = 6546
660	+	Oldest Snapshot = 6546
661	+	Oldest Snapshot Number = 2
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.0.2496 Firebird 4.0"
679	>	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
680	>	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16: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,767,952
696		Delta memory = 4,464
697	<	Max memory = 19,793,248
698	<	Elapsed time= 0.002 sec
697	>	Max memory = 19,813,568
698	>	Elapsed time= 0.001 sec
699		Cpu = 0.000 sec
700		Buffers = 2048
701		Reads = 0
#	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.45) (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.45) (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.0/examples/empbuild/employee.fdb SN = zeus
2837	>	Pages =1075
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.0.2496 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: 29/5/2021 16:47:30
2847	>	Pages Used = 313
2848	>	Pages Free = 762
2849	>	Server Memory = 19484112
2850		Forced Writes  = 1
2851	<	Max Memory  = 19612048
2851	>	Max Memory  = 19630384
2852		Num Buffers  = 2048
2853		Sweep Interval  = 20000
2854		Logged in Users: SYSDBA,
2855		Active Transaction Count = 0
2856	<	Fetches  = 1634
2856	>	Fetches  = 1653
2857		Writes  = 8
2858	<	Reads  = 91
2858	>	Reads  = 92
2859		Page Writes  = 4
2860		Record Version Removals Operation Counts
2861
#	Line 2741 | Line 2879 | Count = 2
2879		Table ID = 12
2880		Count = 24
2881		Table ID = 18
2882	<	Count = 805
2882	>	Count = 821
2883		Table ID = 20
2884		Count = 5
2885		Table ID = 28
#	Line 2753 | Line 2891 | Count = 1
2891
2892		Sequential Table Scans Operation Counts
2893		Table ID = 0
2894	<	Count = 98
2894	>	Count = 100
2895		Table ID = 1
2896		Count = 24
2897
#	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.0.2496 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.0/
2942	>	Security File = /opt/firebird4.0.0/security4.fdb
2943
2944		DB Attachments
2945		No. of Attachments = 0
#	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 3061 | Line 3269 | Invalid Param SQL Type Test
3269		Error Handled: Field "EMP_NO" not found
3270		Case sensitive Param SQL  Test
3271		Error Handled: Field "EMP_NO" not found
3272	+	Stale Reference Check
3273	+	First test correct usage
3274	+	COUNTER = 42
3275	+
3276	+	New Transaction before param set
3277	+	Error Handled: This interface is no longer up-to-date
3278	+	New Transaction before Open Cursor
3279	+	Error Handled: This interface is no longer up-to-date
3280	+	Stop Stale Reference Checks
3281	+	New Transaction before param set
3282	+	COUNTER = 42
3283	+
3284	+	New Transaction before Open Cursor
3285	+	COUNTER = 42
3286	+
3287		Invalid Server Name Test
3288		Error Handled: Unable to complete network request to host "unknown".
3289		-Failed to locate host machine.
#	Line 3073 | Line 3296 | Error Handled: Your user name and passwo
3296
3297		------------------------------------------------------
3298		Running Test 17: Date/Time tests and Firebird 4 extensions
3299	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
3299	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
3300		Has Local TZ DB = TRUE
3301
3302		Testdata
#	Line 3835 | Line 4058 | TZ_MINUTE = 0
4058
4059		------------------------------------------------------
4060		Running Test 18: Firebird 4 Decfloat extensions
4061	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2353 Firebird 4.0 Release Candidate 1"
4061	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4062
4063		FB4 Testdata_DECFloat
4064
#	Line 3937 | Line 4160 | BigInteger = 123456789123456789
4160		Special = 0
4161		Places = 0
4162		Digits = 12 34 56 78 91 23 45 67 89
4163	+
4164		RowID = 2
4165		Float16 = -64000000000.01
4166		Precision = 13
#	Line 3957 | Line 4181 | BigNumber = -123456123456.123456
4181		Places = 6
4182		Digits = 12 34 56 12 34 56 12 34 56
4183		BigInteger = Null
4184	+
4185		RowID = 3
4186		Float16 = 64100000000.011
4187		Precision = 14
#	Line 3983 | Line 4208 | BiggerNumber = 1112345612345612345612345
4208		Places = 4
4209		Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35
4210		BigInteger = Null
4211	+
4212		RowID = 4
4213		Float16 = 0
4214		Precision = 0
#	Line 4009 | Line 4235 | BiggerNumber = 0.0000
4235		Places = 0
4236		Digits =
4237		BigInteger = Null
4238	+
4239		Metadata
4240		SQLType =SQL_LONG
4241		sub type = 0
#	Line 4096 | Line 4323 | BigNumber Array: (0: 123456123400.123456
4323
4324
4325
4326	+	------------------------------------------------------
4327	+	Running Test 19: Batch Update and Insert Queries
4328	+	Opening inet://localhost/employee
4329	+	Database Open
4330	+	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4331	+	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4332	+	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4333	+	on disk structure version 13.0
4334	+	Rows before update
4335	+	EMP_NO = 2
4336	+	FIRST_NAME = Robert
4337	+	LAST_NAME = Nelson
4338	+	PHONE_EXT = 250
4339	+	HIRE_DATE = 1988/12/28 00:00:00.0000
4340	+	DEPT_NO = 600
4341	+	JOB_CODE = VP
4342	+	JOB_GRADE = 2
4343	+	JOB_COUNTRY = USA
4344	+	SALARY = 105,900.00
4345	+	FULL_NAME = Nelson, Robert
4346	+	EMP_NO = 8
4347	+	FIRST_NAME = Leslie
4348	+	LAST_NAME = Johnson
4349	+	PHONE_EXT = 410
4350	+	HIRE_DATE = 1989/04/05 00:00:00.0000
4351	+	DEPT_NO = 180
4352	+	JOB_CODE = Mktg
4353	+	JOB_GRADE = 3
4354	+	JOB_COUNTRY = USA
4355	+	SALARY = 64,635.00
4356	+	FULL_NAME = Johnson, Leslie
4357	+
4358	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4359	+	Batch Completion Info
4360	+	Total rows processed = 2
4361	+	Updated Records = 2
4362	+	Row 1 State = bcNoMoreErrors Msg =
4363	+	Row 2 State = bcNoMoreErrors Msg =
4364	+	Rows after update
4365	+	EMP_NO = 2
4366	+	FIRST_NAME = Robert
4367	+	LAST_NAME = Nelson
4368	+	PHONE_EXT = 250
4369	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4370	+	DEPT_NO = 600
4371	+	JOB_CODE = VP
4372	+	JOB_GRADE = 2
4373	+	JOB_COUNTRY = USA
4374	+	SALARY = 105,900.00
4375	+	FULL_NAME = Nelson, Robert
4376	+	EMP_NO = 8
4377	+	FIRST_NAME = Leslie
4378	+	LAST_NAME = Johnson
4379	+	PHONE_EXT = 410
4380	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4381	+	DEPT_NO = 180
4382	+	JOB_CODE = Mktg
4383	+	JOB_GRADE = 3
4384	+	JOB_COUNTRY = USA
4385	+	SALARY = 64,635.00
4386	+	FULL_NAME = Johnson, Leslie
4387	+
4388	+
4389	+	Repeat but with a last dummy row that is ignored
4390	+	Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4391	+	Batch Completion Info
4392	+	Total rows processed = 2
4393	+	Updated Records = 2
4394	+	Row 1 State = bcNoMoreErrors Msg =
4395	+	Row 2 State = bcNoMoreErrors Msg =
4396	+	Rows after update
4397	+	EMP_NO = 2
4398	+	FIRST_NAME = Robert
4399	+	LAST_NAME = Nelson
4400	+	PHONE_EXT = 250
4401	+	HIRE_DATE = 2018/05/28 00:00:00.0000
4402	+	DEPT_NO = 600
4403	+	JOB_CODE = VP
4404	+	JOB_GRADE = 2
4405	+	JOB_COUNTRY = USA
4406	+	SALARY = 105,900.00
4407	+	FULL_NAME = Nelson, Robert
4408	+	EMP_NO = 8
4409	+	FIRST_NAME = Leslie
4410	+	LAST_NAME = Johnson
4411	+	PHONE_EXT = 410
4412	+	HIRE_DATE = 2016/01/31 00:00:00.0000
4413	+	DEPT_NO = 180
4414	+	JOB_CODE = Mktg
4415	+	JOB_GRADE = 3
4416	+	JOB_COUNTRY = USA
4417	+	SALARY = 64,635.00
4418	+	FULL_NAME = Johnson, Leslie
4419	+
4420	+
4421	+	Insert rows
4422	+	Select Count = 0 InsertCount = 3 UpdateCount = 0 DeleteCount = 0
4423	+	Batch Completion Info
4424	+	Total rows processed = 3
4425	+	Updated Records = 3
4426	+	Row 1 State = bcNoMoreErrors Msg =
4427	+	Row 2 State = bcNoMoreErrors Msg =
4428	+	Row 3 State = bcNoMoreErrors Msg =
4429	+	Rows after insert
4430	+	EMP_NO = 150
4431	+	FIRST_NAME = John
4432	+	LAST_NAME = Doe
4433	+	PHONE_EXT =
4434	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4435	+	DEPT_NO = 600
4436	+	JOB_CODE = Eng
4437	+	JOB_GRADE = 4
4438	+	JOB_COUNTRY = England
4439	+	SALARY = 41,000.89
4440	+	FULL_NAME = Doe, John
4441	+	EMP_NO = 151
4442	+	FIRST_NAME = Jane
4443	+	LAST_NAME = Doe
4444	+	PHONE_EXT =
4445	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4446	+	DEPT_NO = 600
4447	+	JOB_CODE = Eng
4448	+	JOB_GRADE = 4
4449	+	JOB_COUNTRY = England
4450	+	SALARY = 42,000.89
4451	+	FULL_NAME = Doe, Jane
4452	+	EMP_NO = 152
4453	+	FIRST_NAME = John
4454	+	LAST_NAME = SmithAndJonesFamily1
4455	+	PHONE_EXT =
4456	+	HIRE_DATE = 2015/04/03 00:00:00.0000
4457	+	DEPT_NO = 600
4458	+	JOB_CODE = Eng
4459	+	JOB_GRADE = 4
4460	+	JOB_COUNTRY = England
4461	+	SALARY = 41,000.99
4462	+	FULL_NAME = SmithAndJonesFamily1, John
4463	+
4464	+
4465	+	Insert rows - and then cancel
4466	+	Cancel Batch - note - next step will fail with a duplicate key if cancel fails
4467	+
4468	+	Insert rows - ignore last row
4469	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4470	+	Batch Completion Info
4471	+	Total rows processed = 2
4472	+	Updated Records = 2
4473	+	Row 1 State = bcNoMoreErrors Msg =
4474	+	Row 2 State = bcNoMoreErrors Msg =
4475	+	Rows after insert
4476	+	EMP_NO = 150
4477	+	FIRST_NAME = John
4478	+	LAST_NAME = Doe
4479	+	PHONE_EXT =
4480	+	HIRE_DATE = 2015/04/01 00:00:00.0000
4481	+	DEPT_NO = 600
4482	+	JOB_CODE = Eng
4483	+	JOB_GRADE = 4
4484	+	JOB_COUNTRY = England
4485	+	SALARY = 41,000.89
4486	+	FULL_NAME = Doe, John
4487	+	EMP_NO = 151
4488	+	FIRST_NAME = Jane
4489	+	LAST_NAME = Doe
4490	+	PHONE_EXT =
4491	+	HIRE_DATE = 2015/04/02 00:00:00.0000
4492	+	DEPT_NO = 600
4493	+	JOB_CODE = Eng
4494	+	JOB_GRADE = 4
4495	+	JOB_COUNTRY = England
4496	+	SALARY = 42,000.89
4497	+	FULL_NAME = Doe, Jane
4498	+
4499	+	Insert with inline blob
4500	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4501	+	Batch Completion Info
4502	+	Total rows processed = 2
4503	+	Updated Records = 2
4504	+	Row 1 State = bcNoMoreErrors Msg =
4505	+	Row 2 State = bcNoMoreErrors Msg =
4506	+	Rows after insert
4507	+	JOB_CODE = ABC
4508	+	JOB_GRADE = 3
4509	+	JOB_COUNTRY = England
4510	+	JOB_TITLE = Chief Tester
4511	+	MIN_SALARY = 21,000.00
4512	+	MAX_SALARY = 24,000.99
4513	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4514	+
4515	+	The quick brown fox jumped over the lazy dog
4516	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4517	+
4518	+	JOB_CODE = DEF
4519	+	JOB_GRADE = 3
4520	+	JOB_COUNTRY = England
4521	+	JOB_TITLE = Deputy Tester
4522	+	MIN_SALARY = 21,000.00
4523	+	MAX_SALARY = 24,000.99
4524	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4525	+
4526	+	The quick brown fox jumped over the running dog
4527	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4528	+
4529	+
4530	+
4531	+	Insert with explicit blob
4532	+	Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4533	+	Batch Completion Info
4534	+	Total rows processed = 2
4535	+	Updated Records = 2
4536	+	Row 1 State = bcNoMoreErrors Msg =
4537	+	Row 2 State = bcNoMoreErrors Msg =
4538	+	Rows after insert
4539	+	JOB_CODE = ABC
4540	+	JOB_GRADE = 3
4541	+	JOB_COUNTRY = England
4542	+	JOB_TITLE = Chief Tester
4543	+	MIN_SALARY = 21,000.00
4544	+	MAX_SALARY = 24,000.99
4545	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4546	+
4547	+	The quick brown fox jumped over the lazy dog
4548	+	LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4549	+
4550	+	JOB_CODE = DEF
4551	+	JOB_GRADE = 3
4552	+	JOB_COUNTRY = England
4553	+	JOB_TITLE = Deputy Tester
4554	+	MIN_SALARY = 21,000.00
4555	+	MAX_SALARY = 24,000.99
4556	+	JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4557	+
4558	+	The quick brown fox jumped over the running dog
4559	+	LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4560	+
4561	+
4562	+	Test Error Handling
4563	+	Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING
4564	+	Test Error Handling - Update returning should fail
4565	+	Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched
4566	+	Error handling when Insert rows - duplicate key
4567	+	Error reported when inserting: Error Processing update/insert batch on row number 2 - violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4568	+	-Problematic key value is ("EMP_NO" = 150)
4569	+	Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
4570	+	Batch Completion Info
4571	+	Total rows processed = 2
4572	+	Updated Records = 1
4573	+	Row 1 State = bcNoMoreErrors Msg =
4574	+	Row 2 State = bcExecuteFailed Msg = violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4575	+	-Problematic key value is ("EMP_NO" = 150)
4576	+
4577	+
4578	+	------------------------------------------------------
4579	+	Running Test 20: Stress Test IBatch interface
4580	+	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4581	+	10000 rows added
4582	+	20000 rows added
4583	+	30000 rows added
4584	+	40000 rows added
4585	+	50000 rows added
4586	+	Batch Execute
4587	+	Intermediate Apply Batch on row 50001
4588	+	Batch Completion Info
4589	+	Total rows processed = 50000
4590	+	Updated Rows = 50000
4591	+	Row 50000 State = bcNoMoreErrors Msg =
4592	+	60000 rows added
4593	+	70000 rows added
4594	+	80000 rows added
4595	+	90000 rows added
4596	+	100000 rows added
4597	+	Batch Execute
4598	+	Batch Completion Info
4599	+	Total rows processed = 50000
4600	+	Updated Rows = 50000
4601	+	Row 50000 State = bcNoMoreErrors Msg =
4602	+	Rows in Dataset = 100000
4603	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4604	+	Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4605	+	Test Completed Successfully
4606	+
4607	+
4608	+	------------------------------------------------------
4609	+	Running Test 21: Exercise setting and getting of numeric data types
4610	+	1234.567 parsed to 1234567 scale = -3
4611	+	As Float =  1.2345670000000000E+003
4612	+	-765.4321 parsed to -7654321 scale = -4
4613	+	As Float = -7.6543209999999999E+002
4614	+	0.1 parsed to 1 scale = -1
4615	+	As Float =  1.0000000000000001E-001
4616	+	0.01 parsed to 1 scale = -2
4617	+	As Float =  1.0000000000000000E-002
4618	+	+123 parsed to 123 scale = 0
4619	+	As Float =  1.2300000000000000E+002
4620	+	1.23456E308 parsed to 123456 scale = 303
4621	+	As Float =  1.2345600000000001E+308
4622	+	-1.2e-02 parsed to -12 scale = -3
4623	+	As Float = -1.2000000000000000E-002
4624	+	10. parsed to 10 scale = 0
4625	+	As Float =  1.0000000000000000E+001
4626	+	.12 parsed to 12 scale = -2
4627	+	As Float =  1.2000000000000000E-001
4628	+	0.12 parsed to 12 scale = -2
4629	+	As Float =  1.2000000000000000E-001
4630	+	Parsing of 1.2E1.2 failed
4631	+	Parsing of 1,000 failed
4632	+	Parsing of 1e1e1 failed
4633	+	Parsing of 1.2+3 failed
4634	+	SQL Params
4635	+	SQLType =SQL_LONG
4636	+	sub type = 0
4637	+	Field Name =
4638	+	Scale = 0
4639	+	Charset id = 0
4640	+	Not Null
4641	+	Size = 4
4642	+	Value = 0
4643	+
4644	+	SQLType =SQL_LONG
4645	+	sub type = 0
4646	+	Field Name =
4647	+	Scale = 0
4648	+	Charset id = 0
4649	+	Nullable
4650	+	Size = 4
4651	+
4652	+	SQLType =SQL_INT64
4653	+	sub type = 0
4654	+	Field Name =
4655	+	Scale = 0
4656	+	Charset id = 0
4657	+	Nullable
4658	+	Size = 8
4659	+
4660	+	SQLType =SQL_INT64
4661	+	sub type = 0
4662	+	Field Name =
4663	+	Scale = -4
4664	+	Charset id = 0
4665	+	Nullable
4666	+	Size = 8
4667	+
4668	+	SQLType =SQL_DOUBLE
4669	+	sub type = 0
4670	+	Field Name =
4671	+	Scale = 0
4672	+	Charset id = 0
4673	+	Nullable
4674	+	Size = 8
4675	+
4676	+	SQLType =SQL_INT64
4677	+	sub type = 0
4678	+	Field Name =
4679	+	Scale = -6
4680	+	Charset id = 0
4681	+	Nullable
4682	+	Size = 8
4683	+
4684	+	Expected Error - SQLCODE: -303
4685	+	Engine Code: 335544569 Incompatible column/host variable data type
4686	+	Dynamic SQL Error
4687	+	-SQL error code = -303
4688	+	-conversion error from string "1,000"
4689	+	Expected Error - SQLCODE: -303
4690	+	Engine Code: 335544569 Incompatible column/host variable data type
4691	+	Dynamic SQL Error
4692	+	-SQL error code = -303
4693	+	-conversion error from string "10.0.0"
4694	+	ROWID = 1
4695	+	ITYPE = 101
4696	+	I64TYPE = 9223372036854775807
4697	+	CURRTYPE = 10,000.12340000
4698	+	DTYPE = 9,999.12345678
4699	+	FIXEDPOINT = 1,234,567,890.12345700
4700	+	ROWID = 2
4701	+	ITYPE = -32457
4702	+	I64TYPE = -9223372036854775808
4703	+	CURRTYPE = 1,000,001.12000000
4704	+	DTYPE = 1.7E308
4705	+	FIXEDPOINT = -1,234,567,890.12345700
4706	+	ROWID = 3
4707	+	ITYPE = 0
4708	+	I64TYPE = 0
4709	+	CURRTYPE = .00000000
4710	+	DTYPE = .00000000
4711	+	FIXEDPOINT = .00000000
4712	+	ROWID = 4
4713	+	ITYPE = 1
4714	+	I64TYPE = 10
4715	+	CURRTYPE = .02300000
4716	+	DTYPE = .00110000
4717	+	FIXEDPOINT = 233.45600000
4718	+
4719	+
4720	+
4721	+	------------------------------------------------------
4722	+	Running Test 22: Journalling
4723	+	Start Journaling. Session ID = 1
4724	+	1234.567 parsed to 1234567 scale = -3
4725	+	As Float =  1.2345670000000000E+003
4726	+	-765.4321 parsed to -7654321 scale = -4
4727	+	As Float = -7.6543209999999999E+002
4728	+	0.1 parsed to 1 scale = -1
4729	+	As Float =  1.0000000000000001E-001
4730	+	0.01 parsed to 1 scale = -2
4731	+	As Float =  1.0000000000000000E-002
4732	+	+123 parsed to 123 scale = 0
4733	+	As Float =  1.2300000000000000E+002
4734	+	1.23456E308 parsed to 123456 scale = 303
4735	+	As Float =  1.2345600000000001E+308
4736	+	-1.2e-02 parsed to -12 scale = -3
4737	+	As Float = -1.2000000000000000E-002
4738	+	10. parsed to 10 scale = 0
4739	+	As Float =  1.0000000000000000E+001
4740	+	.12 parsed to 12 scale = -2
4741	+	As Float =  1.2000000000000000E-001
4742	+	0.12 parsed to 12 scale = -2
4743	+	As Float =  1.2000000000000000E-001
4744	+	Parsing of 1.2E1.2 failed
4745	+	Parsing of 1,000 failed
4746	+	Parsing of 1e1e1 failed
4747	+	Parsing of 1.2+3 failed
4748	+	SQL Params
4749	+	SQLType =SQL_LONG
4750	+	sub type = 0
4751	+	Field Name =
4752	+	Scale = 0
4753	+	Charset id = 0
4754	+	Not Null
4755	+	Size = 4
4756	+	Value = 0
4757	+
4758	+	SQLType =SQL_LONG
4759	+	sub type = 0
4760	+	Field Name =
4761	+	Scale = 0
4762	+	Charset id = 0
4763	+	Nullable
4764	+	Size = 4
4765	+
4766	+	SQLType =SQL_INT64
4767	+	sub type = 0
4768	+	Field Name =
4769	+	Scale = 0
4770	+	Charset id = 0
4771	+	Nullable
4772	+	Size = 8
4773	+
4774	+	SQLType =SQL_INT64
4775	+	sub type = 0
4776	+	Field Name =
4777	+	Scale = -4
4778	+	Charset id = 0
4779	+	Nullable
4780	+	Size = 8
4781	+
4782	+	SQLType =SQL_DOUBLE
4783	+	sub type = 0
4784	+	Field Name =
4785	+	Scale = 0
4786	+	Charset id = 0
4787	+	Nullable
4788	+	Size = 8
4789	+
4790	+	SQLType =SQL_INT64
4791	+	sub type = 0
4792	+	Field Name =
4793	+	Scale = -6
4794	+	Charset id = 0
4795	+	Nullable
4796	+	Size = 8
4797	+
4798	+
4799	+	Text Tests
4800	+	SQL Params
4801	+	SQLType =SQL_LONG
4802	+	sub type = 0
4803	+	Field Name =
4804	+	Scale = 0
4805	+	Charset id = 0
4806	+	Not Null
4807	+	Size = 4
4808	+	Value = 0
4809	+
4810	+	SQLType =SQL_VARYING
4811	+	sub type = 0
4812	+	Field Name =
4813	+	Scale = 0
4814	+	Charset id = 4
4815	+	Nullable
4816	+	Size = 1024
4817	+
4818	+	SQLType =SQL_BLOB
4819	+	sub type = 1
4820	+	Field Name =
4821	+	Scale = 0
4822	+	Charset id = 4
4823	+	Nullable
4824	+	Size = 8
4825	+
4826	+
4827	+	Binary Blob Tests
4828	+
4829	+	Array Test
4830	+	SQL Params
4831	+	SQLType =SQL_LONG
4832	+	sub type = 0
4833	+	Field Name =
4834	+	Scale = 0
4835	+	Charset id = 0
4836	+	Not Null
4837	+	Size = 4
4838	+	Value = 0
4839	+
4840	+	SQLType =SQL_ARRAY
4841	+	sub type = 0
4842	+	Field Name =
4843	+	Scale = 0
4844	+	Charset id = 0
4845	+	Nullable
4846	+	Size = 8
4847	+
4848	+	ROWID = 1
4849	+	ITYPE = 101
4850	+	I64TYPE = 9223372036854775807
4851	+	CURRTYPE = 10,000.12340000
4852	+	DTYPE = 9,999.12345678
4853	+	FIXEDPOINT = 1,234,567,890.12345700
4854	+	STR = NULL
4855	+	TEXTBLOB = NULL
4856	+	OTHERBLOB = NULL
4857	+	MYARRAY = NULL
4858	+	ROWID = 2
4859	+	ITYPE = -32457
4860	+	I64TYPE = -9223372036854775808
4861	+	CURRTYPE = 1,000,001.12000000
4862	+	DTYPE = 1.7E308
4863	+	FIXEDPOINT = -1,234,567,890.12345700
4864	+	STR = NULL
4865	+	TEXTBLOB = NULL
4866	+	OTHERBLOB = NULL
4867	+	MYARRAY = NULL
4868	+	ROWID = 4
4869	+	ITYPE = 1
4870	+	I64TYPE = 10
4871	+	CURRTYPE = .02300000
4872	+	DTYPE = .00110000
4873	+	FIXEDPOINT = 233.45600000
4874	+	STR = NULL
4875	+	TEXTBLOB = NULL
4876	+	OTHERBLOB = NULL
4877	+	MYARRAY = NULL
4878	+
4879	+	Journal Table
4880	+	IBX$SESSIONID = 1
4881	+	IBX$TRANSACTIONID = 9
4882	+	IBX$OLDTRANSACTIONID = NULL
4883	+	IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4884	+	IBX$CREATED = 2021/12/07 09:50:08.4430
4885	+	IBX$SESSIONID = 1
4886	+	IBX$TRANSACTIONID = 11
4887	+	IBX$OLDTRANSACTIONID = 10
4888	+	IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4889	+	IBX$CREATED = 2021/12/07 09:50:08.7940
4890	+
4891	+	Journal Entries
4892	+	Journal Entry = jeTransStart(Transaction Start)
4893	+	Timestamp = 2021/12/07 09:50:08.4700
4894	+	Session ID = 1
4895	+	Transaction ID = 9
4896	+	Transaction Name = "Transaction_29_1"
4897	+	TPB: Item Count = 3
4898	+	isc_tpb_write
4899	+	isc_tpb_nowait
4900	+	isc_tpb_concurrency
4901	+
4902	+	Default Completion = TACommit
4903	+
4904	+	Journal Entry = jeQuery(Query)
4905	+	Timestamp = 2021/12/07 09:50:08.5300
4906	+	Session ID = 1
4907	+	Transaction ID = 9
4908	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
4909	+
4910	+	Journal Entry = jeQuery(Query)
4911	+	Timestamp = 2021/12/07 09:50:08.5510
4912	+	Session ID = 1
4913	+	Transaction ID = 9
4914	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
4915	+
4916	+	Journal Entry = jeTransCommitRet(Commit Retaining)
4917	+	Timestamp = 2021/12/07 09:50:08.6650
4918	+	Session ID = 1
4919	+	Transaction ID = 10
4920	+	Old TransactionID = 9
4921	+
4922	+	Journal Entry = jeQuery(Query)
4923	+	Timestamp = 2021/12/07 09:50:08.6870
4924	+	Session ID = 1
4925	+	Transaction ID = 10
4926	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
4927	+
4928	+	Journal Entry = jeTransRollbackRet(Rollback Retaining)
4929	+	Timestamp = 2021/12/07 09:50:08.7900
4930	+	Session ID = 1
4931	+	Transaction ID = 11
4932	+	Old TransactionID = 10
4933	+
4934	+	Journal Entry = jeQuery(Query)
4935	+	Timestamp = 2021/12/07 09:50:08.8140
4936	+	Session ID = 1
4937	+	Transaction ID = 11
4938	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
4939	+
4940	+	Journal Entry = jeTransStart(Transaction Start)
4941	+	Timestamp = 2021/12/07 09:50:08.8260
4942	+	Session ID = 1
4943	+	Transaction ID = 12
4944	+	Transaction Name = "Transaction_29_2"
4945	+	TPB: Item Count = 3
4946	+	isc_tpb_write
4947	+	isc_tpb_nowait
4948	+	isc_tpb_concurrency
4949	+
4950	+	Default Completion = TARollback
4951	+
4952	+	Journal Entry = jeTransCommit(Commit)
4953	+	Timestamp = 2021/12/07 09:50:08.8860
4954	+	Session ID = 1
4955	+	Transaction ID = 11
4956	+
4957	+	Journal Entry = jeQuery(Query)
4958	+	Timestamp = 2021/12/07 09:50:08.9660
4959	+	Session ID = 1
4960	+	Transaction ID = 12
4961	+	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:
4962	+	Whether ''tis nobler in the mind to suffer
4963	+	The slings and arrows of outrageous fortune,
4964	+	Or to take arms against a sea of troubles,
4965	+	And, by opposing, end them. To die, to sleep-
4966	+	No more-and by a sleep to say we end
4967	+	The heartache and the thousand natural shocks
4968	+	That flesh is heir to-''tis a consummation
4969	+	Devoutly to be wished. To die, to sleep-
4970	+	To sleep, perchance to dream. Aye, there''s the rub,
4971	+	For in that sleep of death what dreams may come,
4972	+	When we have shuffled off this mortal coil,
4973	+	Must give us pause. There''s the respect
4974	+	That makes calamity of so long life.
4975	+	For who would bear the whips and scorns of time,
4976	+	Th'' oppressor''s wrong, the proud man''s contumely,
4977	+	The pangs of despised love, the law’s delay,
4978	+	The insolence of office, and the spurns
4979	+	That patient merit of the unworthy takes,
4980	+	When he himself might his quietus make
4981	+	With a bare bodkin? Who would fardels bear,
4982	+	To grunt and sweat under a weary life,
4983	+	But that the dread of something after death,
4984	+	The undiscovered country from whose bourn
4985	+	No traveler returns, puzzles the will
4986	+	And makes us rather bear those ills we have
4987	+	Than fly to others that we know not of?
4988	+	Thus conscience does make cowards of us all,
4989	+	And thus the native hue of resolution
4990	+	Is sicklied o''er with the pale cast of thought,
4991	+	And enterprises of great pitch and moment,
4992	+	With this regard their currents turn awry,
4993	+	And lose the name of action.-Soft you now,
4994	+	The fair Ophelia.-Nymph, in thy orisons
4995	+	Be all my sins remembered
4996	+	')
4997	+
4998	+	Journal Entry = jeQuery(Query)
4999	+	Timestamp = 2021/12/07 09:50:09.0130
5000	+	Session ID = 1
5001	+	Transaction ID = 12
5002	+	Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
5003	+	FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
5004	+	0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
5005	+	01000000010000001A01050001000000DA000000
5006	+	</blob>
5007	+	)
5008	+
5009	+	Journal Entry = jeQuery(Query)
5010	+	Timestamp = 2021/12/07 09:50:09.0380
5011	+	Session ID = 1
5012	+	Transaction ID = 12
5013	+	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">
5014	+	<elt ix="0">100</elt>
5015	+	<elt ix="1">99</elt>
5016	+	<elt ix="2">98</elt>
5017	+	<elt ix="3">97</elt>
5018	+	<elt ix="4">96</elt>
5019	+	<elt ix="5">95</elt>
5020	+	<elt ix="6">94</elt>
5021	+	<elt ix="7">93</elt>
5022	+	<elt ix="8">92</elt>
5023	+	<elt ix="9">91</elt>
5024	+	<elt ix="10">90</elt>
5025	+	<elt ix="11">89</elt>
5026	+	<elt ix="12">88</elt>
5027	+	<elt ix="13">87</elt>
5028	+	<elt ix="14">86</elt>
5029	+	<elt ix="15">85</elt>
5030	+	<elt ix="16">84</elt>
5031	+	</array>
5032	+	)
5033	+
5034	+	Journal Entry = jeTransRollback(Rollback)
5035	+	Timestamp = 2021/12/07 09:50:09.1560
5036	+	Session ID = 1
5037	+	Transaction ID = 12
5038	+
5039	+
5040	+
5041		------------------------------------------------------
5042		Test Suite Ends

Diff Legend

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