ViewVC Help

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

root/public/ibx/trunk/fbintf/testsuite/FB3reference.log

Comparing ibx/trunk/fbintf/testsuite/FB3reference.log (file contents):
Revision 401 by tony, Sun Oct 24 14:00:52 2021 UTC vs.
Revision 402 by tony, Mon Aug 1 10:07:24 2022 UTC

#	Line 3 | Line 3 | Copyright MWA Software 2016-2021
3
4		Starting Tests
5		Client API Version = 3.0
6	<	Firebird Environment Variable = /opt/firebird3.0.5
7	<	Firebird Bin Directory = /opt/firebird3.0.5/bin
8	<	Firebird Conf Directory = /opt/firebird3.0.5/
9	<	Firebird Client Library Path = /opt/firebird3.0.5/lib/libfbclient.so
6	>	Firebird Environment Variable = /opt/firebird/3.0.5
7	>	Firebird Bin Directory = /opt/firebird/3.0.5/bin
8	>	Firebird Conf Directory = /opt/firebird/3.0.5/
9	>	Firebird Client Library Path = /opt/firebird/3.0.5/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
13	>	I/O error during "open O_CREAT" operation for file ""
14		-Error while trying to create file
15		-No such file or directory
16		Creating a Database using an SQL Statement
#	Line 22 | Line 23 | DB Remote Protocol = TCPv4
23		DB ODS Major Version = 12
24		DB ODS Minor Version = 0
25		User Authentication Method = Srp
26	<	Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
26	>	Firebird Library Path = /opt/firebird/3.0.5/lib/libfbclient.so
27		DB Client Implementation Version = 3.0
28		DPB: Item Count = 3
29		isc_dpb_user_name = SYSDBA
#	Line 44 | Line 45 | DB Remote Protocol = TCPv4
45		DB ODS Major Version = 12
46		DB ODS Minor Version = 0
47		User Authentication Method = Srp
48	<	Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
48	>	Firebird Library Path = /opt/firebird/3.0.5/lib/libfbclient.so
49		DB Client Implementation Version = 3.0
50		Dropping Database
51		DPB: Item Count = 4
#	Line 57 | Line 58 | Creating a Database with a DPD
58		Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
59		ODS major = 12
60		ODS minor = 0
61	+	Attachment ID = 6
62		DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
63		DB Charset ID = 4
64		DB SQL Dialect = 3
#	Line 64 | Line 66 | DB Remote Protocol = TCPv4
66		DB ODS Major Version = 12
67		DB ODS Minor Version = 0
68		User Authentication Method = Srp
69	<	Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
69	>	Firebird Library Path = /opt/firebird/3.0.5/lib/libfbclient.so
70		DB Client Implementation Version = 3.0
71		RDB$DESCRIPTION =
72		RDB$RELATION_ID = 128
#	Line 76 | 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
81	>	Open Database fails Engine Code: 335544472
82	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
83		Opening inet://localhost/employee
84		Database Open, SQL Dialect = 3
85		TPB: Item Count = 3
#	Line 306 | Line 309 | JOB_COUNTRY = USA
309		SALARY = 64,635.00
310		FULL_NAME = Johnson, Leslie
311
312	+	Scollable Cursors
313	+	DB Connect String = inet://localhost/employee
314	+	DB Charset ID = 4
315	+	DB SQL Dialect = 3
316	+	DB Remote Protocol = TCPv4
317	+	DB ODS Major Version = 12
318	+	DB ODS Minor Version = 0
319	+	User Authentication Method = Srp
320	+	Firebird Library Path = /opt/firebird/3.0.5/lib/libfbclient.so
321	+	DB Client Implementation Version = 3.0
322	+	Do Fetch Next:
323	+	EMP_NO = 2
324	+	FIRST_NAME = Robert
325	+	LAST_NAME = Nelson
326	+	PHONE_EXT = 250
327	+	HIRE_DATE = 1988/12/28 00:00:00.0000
328	+	DEPT_NO = 600
329	+	JOB_CODE = VP
330	+	JOB_GRADE = 2
331	+	JOB_COUNTRY = USA
332	+	SALARY = 105,900.00
333	+	FULL_NAME = Nelson, Robert
334	+	Do Fetch Last:
335	+	Remote Scrollable cursors test fails Engine Code: 335544378
336	+	feature is not supported
337		Now open the employee database as a local database
338		TPB: Item Count = 3
339		isc_tpb_read
#	Line 542 | Line 570 | DB Remote Protocol =
570		DB ODS Major Version = 12
571		DB ODS Minor Version = 0
572		User Authentication Method = User name in DPB
573	<	Firebird Library Path = /opt/firebird3.0.5/lib/libfbclient.so
573	>	Firebird Library Path = /opt/firebird/3.0.5/lib/libfbclient.so
574		DB Client Implementation Version = 3.0
575		Do Fetch Next:
576		EMP_NO = 2
#	Line 625 | Line 653 | Running Test 3: ad hoc queries
653		Opening inet://localhost/employee
654		Database Open
655		Employee Count = 42
656	+	Transaction ID = 6513
657	+	Transaction is Read/Write
658	+	Transaction Database Path = inet://localhost/employee
659	+	Transaction ID = 6513
660	+	Oldest Interesting = 6511
661	+	Oldest Action = 6512
662	+	Oldest Snapshot = 6512
663	+	Oldest Interesting = 0
664		Employee Count = 41
665		Employee Count = 42
666		Employee Count = 41
#	Line 655 | Line 691 | JOB_COUNTRY = USA
691		SALARY = 64,635.00
692		FULL_NAME = Johnson, Leslie
693
694	<	Current memory = 19,694,032
694	>	Current memory = 19,694,800
695		Delta memory = 4,480
696	<	Max memory = 19,755,888
696	>	Max memory = 19,756,272
697		Elapsed time= 0.002 sec
698		Cpu = 0.000 sec
699		Buffers = 2048
#	Line 2696 | Line 2732 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2732
2733		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)
2734
2735	<	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)
2735	>	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)
2736
2737
2738		Shrink to 2:10
#	Line 2712 | Line 2748 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2748
2749		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)
2750
2751	<	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)
2751	>	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)
2752
2753
2754
#	Line 2796 | Line 2832 | MYARRAY = Array: (0,-1: A50) (0,0: A51)
2832
2833		------------------------------------------------------
2834		Running Test 9: Database Information tests
2835	<	Database ID = 4 FB = /opt/firebird3.0.5/examples/empbuild/employee.fdb SN = zeus
2835	>	Database ID = 4 FB = /opt/firebird/3.0.5/examples/empbuild/employee.fdb SN = zeus
2836		Pages =307
2837		Base Level = 13,4,0,3,
2838		Implementation = 11,7,0,3,65,1,65,
#	Line 2807 | Line 2843 | Page Size = 8192
2843		Version = 1: LI-V6.3.5.33220 Firebird 3.0
2844		Database is Read/Write
2845		Database Created: 09/1/2020 13:13:45
2846	<	Pages Used = 297
2847	<	Pages Free = 10
2848	<	Server Memory = 19196128
2846	>	Pages Used = 300
2847	>	Pages Free = 7
2848	>	Server Memory = 18987232
2849		Forced Writes  = 1
2850	<	Max Memory  = 19316896
2850	>	Max Memory  = 19024416
2851		Num Buffers  = 2048
2852		Sweep Interval  = 20000
2853		Logged in Users: SYSDBA,
2854		Active Transaction Count = 0
2855	<	Fetches  = 452
2856	<	Writes  = 8
2857	<	Reads  = 57
2858	<	Page Writes  = 4
2855	>	Fetches  = 408
2856	>	Writes  = 5
2857	>	Reads  = 55
2858	>	Page Writes  = 2
2859		Record Version Removals Operation Counts
2860
2861		Deletes Operation Counts
#	Line 2834 | Line 2870 | Indexed Reads Count Operation Counts
2870		Table ID = 4
2871		Count = 28
2872		Table ID = 6
2873	<	Count = 15
2873	>	Count = 5
2874		Table ID = 9
2875	<	Count = 3
2875	>	Count = 1
2876		Table ID = 11
2877		Count = 1
2878		Table ID = 12
#	Line 2848 | Line 2884 | Count = 1
2884
2885		Sequential Table Scans Operation Counts
2886		Table ID = 0
2887	<	Count = 94
2887	>	Count = 96
2888		Table ID = 1
2889		Count = 2
2890
#	Line 2864 | Line 2900 | Async Wait Called
2900		Event Signalled
2901		First Event - usually ignored
2902		Signal Event
2903	+	Event Signalled
2904		Event Counts: TESTEVENT, Count = 1
2905		Two more events
2906		Call Async Wait
2907		Async Wait Called
2908		Event Signalled
2872	–	Event Signalled
2909		Deferred Events Caught
2910		Event Counts: TESTEVENT, Count = 2
2911		Signal Event
#	Line 2881 | Line 2917 | Event Cancelled
2917		Time Out - Cancel Worked!
2918		Sync wait
2919		Event Signalled
2920	<	Event Counts: TESTEVENT, Count = 1
2920	>	Event Counts: TESTEVENT, Count = 0
2921
2922
2923		------------------------------------------------------
#	Line 2895 | Line 2931 | Server Version = LI-V3.0.5.33220 Firebir
2931		Implementation = Firebird/Linux/AMD/Intel/x64
2932
2933		Lock Directory = /tmp/firebird/
2934	<	Message File = /opt/firebird3.0.5/
2934	>	Message File = /opt/firebird/3.0.5/
2935		Security File = security.db
2936
2937		DB Attachments
#	Line 2911 | Line 2947 | User ID = 0
2947		Group ID = 0
2948
2949
2950	<	Licence Info: feature is not supported
2950	>	Licence Info: Engine Code: 335544378
2951	>	feature is not supported
2952		-feature is not supported
2953
2954	<	Licence Mask Info: feature is not supported
2954	>	Licence Mask Info: Engine Code: 335544378
2955	>	feature is not supported
2956
2957		Capabilities = 6
2958
#	Line 3201 | Line 3239 | Écoute moi
3239		------------------------------------------------------
3240		Running Test 16: Error handling
3241		Invalid Database Name Test
3242	<	Error Handled: I/O error during "open" operation for file "Malformed Name"
3242	>	Error Handled: SQLCODE: -902
3243	>	Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3244	>	Engine Code: 335544344
3245	>	I/O error during "open" operation for file "Malformed Name"
3246		-Error while trying to open file
3247		-No such file or directory
3248		Invalid User Name Test
3249	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3249	>	Error Handled: SQLCODE: -902
3250	>	Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3251	>	Engine Code: 335544472
3252	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3253		Invalid password 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	>	Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3256	>	Engine Code: 335544472
3257	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3258		Invalid Prepare SQL Test
3259	<	Error Handled: Dynamic SQL Error
3259	>	Error Handled: SQLCODE: -206
3260	>	Column does not belong to referenced table
3261	>	Engine Code: 335544569
3262	>	Dynamic SQL Error
3263		-SQL error code = -206
3264		-Column unknown
3265		-UNKNOWN_DATE
3266		-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3267		Invalid Open Cursor SQL Test
3268	<	Error Handled: Dynamic SQL Error
3268	>	Error Handled: SQLCODE: -206
3269	>	Column does not belong to referenced table
3270	>	Engine Code: 335544569
3271	>	Dynamic SQL Error
3272		-SQL error code = -206
3273		-Column unknown
3274		-X
#	Line 3242 | Line 3295 | 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	>	Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3300	>	Engine Code: 335544721
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	>	Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3307	>	Engine Code: 335544472
3308	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3309		Invalid password Test
3310	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3310	>	Error Handled: SQLCODE: -902
3311	>	Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3312	>	Engine Code: 335544472
3313	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3314
3315
3316		------------------------------------------------------
#	Line 3379 | Line 3441 | Parsing of 1.2E1.2 failed
3441		Parsing of 1,000 failed
3442		Parsing of 1e1e1 failed
3443		Parsing of 1.2+3 failed
3444	+	Validating Numeric Interface - IFBNumeric
3445	+	Value from Currency = 9999.1235
3446	+	Raw Value = 99991235 Scale = -4
3447	+	Value from Currency(rescaled) = 9999.12
3448	+	Raw Value = 999912 Scale = -2
3449	+	Value from Double = 9999.12345678
3450	+	Raw Value = 999912345678 Scale = -8
3451	+	Value from Integer = 9223372036854775807
3452	+	Raw Value = 9223372036854775807 Scale = 0
3453	+	Value from string = 9223372036854775807
3454	+	Raw Value = 9223372036854775807 Scale = 0
3455	+	Value from string = 9999.12345678
3456	+	Raw Value = 999912345678 Scale = -8
3457	+	Value from string = -0.12
3458	+	Raw Value = -12 Scale = -3
3459	+	Value from BCD = 9999.12345678
3460	+	Raw Value = 999912345678 Scale = -8
3461	+	Value from Raw Data = 9999123.456780
3462	+	Raw Value = 9999123456780 Scale = -6
3463	+	Numeric Operations
3464	+	Add 2.23 + 24.12345 = 26.35345
3465	+	Add Double 2.23 + 24.12645 = 26.35645
3466	+	Add integer 2.23 + 2412345 = 2412347.23
3467	+	Subtract 2.23 - 24.12345 = -21.89345
3468	+	Subtract Double 24.12645 - 2.23 = -21.89645
3469	+	Subtract integer 24123.45 - 223 = -23900.45
3470	+	Multiply 2.23 * 24.12345 = 53.7952935
3471	+	Multiply Double 24.12645 * 2.23 = 53.8019835
3472	+	Multiply integer 241.2345 * 223 = 53795.2935
3473	+	Divide 24.12345 / 2.23 = 10.81769
3474	+	Divide Double 2.23 / 24.12645 = 0.09
3475	+	Divide integer 241.2345 / 223 = 1.0818
3476	+	Compare 2.23, -24.12345 = 1
3477	+	Compare integer 2.23, 3 = -1
3478	+	Compare Double 2.23, 2.23 = 0
3479	+	Negate 24.12345 = -24.12345
3480		SQL Params
3481		SQLType =SQL_LONG
3482		sub type = 0
#	Line 3429 | Line 3527 | Charset id = 0
3527		Nullable
3528		Size = 8
3529
3530	<	Expected Error - Dynamic SQL Error
3530	>	Expected Error - SQLCODE: -303
3531	>	Incompatible column/host variable data type
3532	>	Engine Code: 335544569
3533	>	Dynamic SQL Error
3534		-SQL error code = -303
3535		-conversion error from string "1,000"
3536	<	Expected Error - Dynamic SQL Error
3536	>	Expected Error - SQLCODE: -303
3537	>	Incompatible column/host variable data type
3538	>	Engine Code: 335544569
3539	>	Dynamic SQL Error
3540		-SQL error code = -303
3541		-conversion error from string "10.0.0"
3542	+	Test Numeric Type
3543		ROWID = 1
3544		ITYPE = 101
3545		I64TYPE = 9223372036854775807
#	Line 3459 | Line 3564 | I64TYPE = 10
3564		CURRTYPE = .02300000
3565		DTYPE = .00110000
3566		FIXEDPOINT = 233.45600000
3567	+	ROWID = 7
3568	+	ITYPE = 1
3569	+	I64TYPE = 1234567
3570	+	CURRTYPE = .02300000
3571	+	DTYPE = .00110000
3572	+	FIXEDPOINT = 1,234.25000000
3573	+
3574	+
3575	+
3576	+	------------------------------------------------------
3577	+	Running Test 22: Journalling
3578	+	Start Journaling. Session ID = 0
3579	+	1234.567 parsed to 1234567 scale = -3
3580	+	As Float =  1.2345670000000000E+003
3581	+	-765.4321 parsed to -7654321 scale = -4
3582	+	As Float = -7.6543209999999999E+002
3583	+	0.1 parsed to 1 scale = -1
3584	+	As Float =  1.0000000000000001E-001
3585	+	0.01 parsed to 1 scale = -2
3586	+	As Float =  1.0000000000000000E-002
3587	+	+123 parsed to 123 scale = 0
3588	+	As Float =  1.2300000000000000E+002
3589	+	1.23456E308 parsed to 123456 scale = 303
3590	+	As Float =  1.2345600000000001E+308
3591	+	-1.2e-02 parsed to -12 scale = -3
3592	+	As Float = -1.2000000000000000E-002
3593	+	10. parsed to 10 scale = 0
3594	+	As Float =  1.0000000000000000E+001
3595	+	.12 parsed to 12 scale = -2
3596	+	As Float =  1.2000000000000000E-001
3597	+	0.12 parsed to 12 scale = -2
3598	+	As Float =  1.2000000000000000E-001
3599	+	Parsing of 1.2E1.2 failed
3600	+	Parsing of 1,000 failed
3601	+	Parsing of 1e1e1 failed
3602	+	Parsing of 1.2+3 failed
3603	+	SQL Params
3604	+	SQLType =SQL_LONG
3605	+	sub type = 0
3606	+	Field Name =
3607	+	Scale = 0
3608	+	Charset id = 0
3609	+	Not Null
3610	+	Size = 4
3611	+	Value = 0
3612	+
3613	+	SQLType =SQL_LONG
3614	+	sub type = 0
3615	+	Field Name =
3616	+	Scale = 0
3617	+	Charset id = 0
3618	+	Nullable
3619	+	Size = 4
3620	+
3621	+	SQLType =SQL_INT64
3622	+	sub type = 0
3623	+	Field Name =
3624	+	Scale = 0
3625	+	Charset id = 0
3626	+	Nullable
3627	+	Size = 8
3628	+
3629	+	SQLType =SQL_INT64
3630	+	sub type = 0
3631	+	Field Name =
3632	+	Scale = -4
3633	+	Charset id = 0
3634	+	Nullable
3635	+	Size = 8
3636	+
3637	+	SQLType =SQL_DOUBLE
3638	+	sub type = 0
3639	+	Field Name =
3640	+	Scale = 0
3641	+	Charset id = 0
3642	+	Nullable
3643	+	Size = 8
3644	+
3645	+	SQLType =SQL_INT64
3646	+	sub type = 0
3647	+	Field Name =
3648	+	Scale = -6
3649	+	Charset id = 0
3650	+	Nullable
3651	+	Size = 8
3652	+
3653	+
3654	+	Text Tests
3655	+	SQL Params
3656	+	SQLType =SQL_LONG
3657	+	sub type = 0
3658	+	Field Name =
3659	+	Scale = 0
3660	+	Charset id = 0
3661	+	Not Null
3662	+	Size = 4
3663	+	Value = 0
3664	+
3665	+	SQLType =SQL_VARYING
3666	+	sub type = 0
3667	+	Field Name =
3668	+	Scale = 0
3669	+	Charset id = 4
3670	+	Nullable
3671	+	Size = 1024
3672	+
3673	+	SQLType =SQL_BLOB
3674	+	sub type = 1
3675	+	Field Name =
3676	+	Scale = 0
3677	+	Charset id = 4
3678	+	Nullable
3679	+	Size = 8
3680	+
3681	+
3682	+	Binary Blob Tests
3683	+
3684	+	Array Test
3685	+	SQL Params
3686	+	SQLType =SQL_LONG
3687	+	sub type = 0
3688	+	Field Name =
3689	+	Scale = 0
3690	+	Charset id = 0
3691	+	Not Null
3692	+	Size = 4
3693	+	Value = 0
3694	+
3695	+	SQLType =SQL_ARRAY
3696	+	sub type = 0
3697	+	Field Name = MYARRAY
3698	+	Scale = 0
3699	+	Charset id = 0
3700	+	Nullable
3701	+	Size = 8
3702	+
3703	+	ROWID = 1
3704	+	ITYPE = 101
3705	+	I64TYPE = 9223372036854775807
3706	+	CURRTYPE = 10,000.12340000
3707	+	DTYPE = 9,999.12345678
3708	+	FIXEDPOINT = 1,234,567,890.12345700
3709	+	STR = NULL
3710	+	TEXTBLOB = NULL
3711	+	OTHERBLOB = NULL
3712	+	MYARRAY = NULL
3713	+	ROWID = 2
3714	+	ITYPE = -32457
3715	+	I64TYPE = -9223372036854775808
3716	+	CURRTYPE = 1,000,001.12000000
3717	+	DTYPE = 1.7E308
3718	+	FIXEDPOINT = -1,234,567,890.12345700
3719	+	STR = NULL
3720	+	TEXTBLOB = NULL
3721	+	OTHERBLOB = NULL
3722	+	MYARRAY = NULL
3723	+	ROWID = 4
3724	+	ITYPE = 1
3725	+	I64TYPE = 10
3726	+	CURRTYPE = .02300000
3727	+	DTYPE = .00110000
3728	+	FIXEDPOINT = 233.45600000
3729	+	STR = NULL
3730	+	TEXTBLOB = NULL
3731	+	OTHERBLOB = NULL
3732	+	MYARRAY = NULL
3733	+
3734	+	Journal Table
3735	+	IBX$SESSIONID = 1
3736	+	IBX$TRANSACTIONID = 9
3737	+	IBX$OLDTRANSACTIONID = NULL
3738	+	IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3739	+	IBX$CREATED = 2022/07/18 14:41:19.5000
3740	+	IBX$SESSIONID = 1
3741	+	IBX$TRANSACTIONID = 11
3742	+	IBX$OLDTRANSACTIONID = 10
3743	+	IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
3744	+	IBX$CREATED = 2022/07/18 14:41:19.5800
3745	+
3746	+	Journal Entries
3747	+	Journal Entry = jeTransStart(Transaction Start)
3748	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3749	+	Attachment ID = 6
3750	+	Session ID = 1
3751	+	Transaction ID = 9
3752	+	Transaction Name = "Transaction_29_1"
3753	+	TPB: Item Count = 3
3754	+	isc_tpb_write
3755	+	isc_tpb_nowait
3756	+	isc_tpb_concurrency
3757	+
3758	+	Default Completion = TACommit
3759	+
3760	+	Journal Entry = jeQuery(Query)
3761	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3762	+	Attachment ID = 6
3763	+	Session ID = 1
3764	+	Transaction ID = 9
3765	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
3766	+
3767	+	Journal Entry = jeQuery(Query)
3768	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3769	+	Attachment ID = 6
3770	+	Session ID = 1
3771	+	Transaction ID = 9
3772	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
3773	+
3774	+	Journal Entry = jeTransCommitRet(Commit Retaining)
3775	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3776	+	Attachment ID = 6
3777	+	Session ID = 1
3778	+	Transaction ID = 10
3779	+	Old TransactionID = 9
3780	+
3781	+	Journal Entry = jeQuery(Query)
3782	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3783	+	Attachment ID = 6
3784	+	Session ID = 1
3785	+	Transaction ID = 10
3786	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
3787	+
3788	+	Journal Entry = jeTransRollbackRet(Rollback Retaining)
3789	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3790	+	Attachment ID = 6
3791	+	Session ID = 1
3792	+	Transaction ID = 11
3793	+	Old TransactionID = 10
3794	+
3795	+	Journal Entry = jeQuery(Query)
3796	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3797	+	Attachment ID = 6
3798	+	Session ID = 1
3799	+	Transaction ID = 11
3800	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
3801	+
3802	+	Journal Entry = jeTransStart(Transaction Start)
3803	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3804	+	Attachment ID = 6
3805	+	Session ID = 1
3806	+	Transaction ID = 12
3807	+	Transaction Name = "Transaction_29_2"
3808	+	TPB: Item Count = 3
3809	+	isc_tpb_write
3810	+	isc_tpb_nowait
3811	+	isc_tpb_concurrency
3812	+
3813	+	Default Completion = TARollback
3814	+
3815	+	Journal Entry = jeTransCommit(Commit)
3816	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3817	+	Attachment ID = 6
3818	+	Session ID = 1
3819	+	Transaction ID = 11
3820	+
3821	+	Journal Entry = jeQuery(Query)
3822	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3823	+	Attachment ID = 6
3824	+	Session ID = 1
3825	+	Transaction ID = 12
3826	+	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:
3827	+	Whether ''tis nobler in the mind to suffer
3828	+	The slings and arrows of outrageous fortune,
3829	+	Or to take arms against a sea of troubles,
3830	+	And, by opposing, end them. To die, to sleep-
3831	+	No more-and by a sleep to say we end
3832	+	The heartache and the thousand natural shocks
3833	+	That flesh is heir to-''tis a consummation
3834	+	Devoutly to be wished. To die, to sleep-
3835	+	To sleep, perchance to dream. Aye, there''s the rub,
3836	+	For in that sleep of death what dreams may come,
3837	+	When we have shuffled off this mortal coil,
3838	+	Must give us pause. There''s the respect
3839	+	That makes calamity of so long life.
3840	+	For who would bear the whips and scorns of time,
3841	+	Th'' oppressor''s wrong, the proud man''s contumely,
3842	+	The pangs of despised love, the law’s delay,
3843	+	The insolence of office, and the spurns
3844	+	That patient merit of the unworthy takes,
3845	+	When he himself might his quietus make
3846	+	With a bare bodkin? Who would fardels bear,
3847	+	To grunt and sweat under a weary life,
3848	+	But that the dread of something after death,
3849	+	The undiscovered country from whose bourn
3850	+	No traveler returns, puzzles the will
3851	+	And makes us rather bear those ills we have
3852	+	Than fly to others that we know not of?
3853	+	Thus conscience does make cowards of us all,
3854	+	And thus the native hue of resolution
3855	+	Is sicklied o''er with the pale cast of thought,
3856	+	And enterprises of great pitch and moment,
3857	+	With this regard their currents turn awry,
3858	+	And lose the name of action.-Soft you now,
3859	+	The fair Ophelia.-Nymph, in thy orisons
3860	+	Be all my sins remembered
3861	+	')
3862	+
3863	+	Journal Entry = jeQuery(Query)
3864	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3865	+	Attachment ID = 6
3866	+	Session ID = 1
3867	+	Transaction ID = 12
3868	+	Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
3869	+	FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
3870	+	0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
3871	+	01000000010000001A01050001000000DA000000
3872	+	</blob>
3873	+	)
3874	+
3875	+	Journal Entry = jeQuery(Query)
3876	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3877	+	Attachment ID = 6
3878	+	Session ID = 1
3879	+	Transaction ID = 12
3880	+	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">
3881	+	<elt ix="0">100</elt>
3882	+	<elt ix="1">99</elt>
3883	+	<elt ix="2">98</elt>
3884	+	<elt ix="3">97</elt>
3885	+	<elt ix="4">96</elt>
3886	+	<elt ix="5">95</elt>
3887	+	<elt ix="6">94</elt>
3888	+	<elt ix="7">93</elt>
3889	+	<elt ix="8">92</elt>
3890	+	<elt ix="9">91</elt>
3891	+	<elt ix="10">90</elt>
3892	+	<elt ix="11">89</elt>
3893	+	<elt ix="12">88</elt>
3894	+	<elt ix="13">87</elt>
3895	+	<elt ix="14">86</elt>
3896	+	<elt ix="15">85</elt>
3897	+	<elt ix="16">84</elt>
3898	+	</array>
3899	+	)
3900	+
3901	+	Journal Entry = jeTransRollback(Rollback)
3902	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
3903	+	Attachment ID = 6
3904	+	Session ID = 1
3905	+	Transaction ID = 12
3906
3907
3908

Diff Legend

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