ViewVC Help

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

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

Comparing ibx/branches/udr/testsuite/FB4reference.log (file contents):
Revision 370 by tony, Wed Jan 5 14:59:15 2022 UTC vs.
Revision 371 by tony, Wed Jan 5 15:21:22 2022 UTC

#	Line 3 | Line 3 | Copyright MWA Software 2016-2021
3
4		Starting Tests
5		Client API Version = 4.0
6	<	Firebird Environment Variable = /opt/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
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/firebird4.0.0/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.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"
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/firebird4.0.0/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 65 | 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/firebird4.0.0/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
#	Line 78 | 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 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 316 | Line 316 | 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
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
#	Line 331 | Line 331 | 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
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 568 | Line 568 | 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
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
#	Line 651 | Line 651 | Running Test 3: ad hoc queries
651		Opening inet://localhost/employee
652		Database Open
653		Employee Count = 42
654	<	Transaction ID = 6547
654	>	Transaction ID = 173
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
657	>	Transaction ID = 173
658	>	Oldest Interesting = 171
659	>	Oldest Action = 172
660	>	Oldest Snapshot = 172
661		Oldest Snapshot Number = 2
662		Lock Timeout = 0
663		Transaction Access = isc_info_tra_readwrite
#	Line 675 | 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.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"
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 692 | Line 692 | JOB_COUNTRY = USA
692		SALARY = 64,635.00
693		FULL_NAME = Johnson, Leslie
694
695	<	Current memory = 19,767,952
695	>	Current memory = 19,767,936
696		Delta memory = 4,464
697	<	Max memory = 19,813,568
698	<	Elapsed time= 0.001 sec
697	>	Max memory = 19,813,552
698	>	Elapsed time= 0.002 sec
699		Cpu = 0.000 sec
700		Buffers = 2048
701		Reads = 0
#	Line 2733 | 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: 0.42) (15: 42.45) (16: 4269)
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 2749 | 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: 0.42) (15: 42.45) (16: 4269)
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 2833 | 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/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus
2837	<	Pages =1075
2836	>	Database ID = 4 FB = /opt/firebird4.0.1/examples/empbuild/employee.fdb SN = zeus
2837	>	Pages =346
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.2496 Firebird 4.0
2844	>	Version = 1: LI-V6.3.1.2692 Firebird 4.0
2845		Database is Read/Write
2846	<	Database Created: 29/5/2021 16:47:30
2847	<	Pages Used = 313
2848	<	Pages Free = 762
2849	<	Server Memory = 19484112
2846	>	Database Created: 21/12/2021 10:52:59
2847	>	Pages Used = 310
2848	>	Pages Free = 36
2849	>	Server Memory = 19482432
2850		Forced Writes  = 1
2851	<	Max Memory  = 19630384
2851	>	Max Memory  = 19629552
2852		Num Buffers  = 2048
2853		Sweep Interval  = 20000
2854		Logged in Users: SYSDBA,
2855		Active Transaction Count = 0
2856	<	Fetches  = 1653
2856	>	Fetches  = 1634
2857		Writes  = 8
2858	<	Reads  = 92
2858	>	Reads  = 91
2859		Page Writes  = 4
2860		Record Version Removals Operation Counts
2861
#	Line 2879 | Line 2879 | Count = 2
2879		Table ID = 12
2880		Count = 24
2881		Table ID = 18
2882	<	Count = 821
2882	>	Count = 805
2883		Table ID = 20
2884		Count = 5
2885		Table ID = 28
#	Line 2891 | Line 2891 | Count = 1
2891
2892		Sequential Table Scans Operation Counts
2893		Table ID = 0
2894	<	Count = 100
2894	>	Count = 98
2895		Table ID = 1
2896		Count = 24
2897
#	Line 2934 | Line 2934 | SPB: Item Count = 2
2934		password = masterkey
2935
2936		Service Manager Version = 2
2937	<	Server Version = LI-V4.0.0.2496 Firebird 4.0
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/firebird4.0.0/
2942	<	Security File = /opt/firebird4.0.0/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 2954 | 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 3244 | Line 3244 | Écoute moi
3244		------------------------------------------------------
3245		Running Test 16: Error handling
3246		Invalid Database Name Test
3247	<	Error Handled: I/O error during "open" operation for file "Malformed Name"
3247	>	Error Handled: SQLCODE: -902
3248	>	Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3249	>	I/O error during "open" operation for file "Malformed Name"
3250		-Error while trying to open file
3251		-No such file or directory
3252		Invalid User Name Test
3253	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3253	>	Error Handled: SQLCODE: -902
3254	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3255	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3256		Invalid password Test
3257	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3257	>	Error Handled: SQLCODE: -902
3258	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3259	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3260		Invalid Prepare SQL Test
3261	<	Error Handled: Dynamic SQL Error
3261	>	Error Handled: SQLCODE: -206
3262	>	Engine Code: 335544569 Column does not belong to referenced table
3263	>	Dynamic SQL Error
3264		-SQL error code = -206
3265		-Column unknown
3266		-UNKNOWN_DATE
3267		-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3268		Invalid Open Cursor SQL Test
3269	<	Error Handled: Dynamic SQL Error
3269	>	Error Handled: SQLCODE: -206
3270	>	Engine Code: 335544569 Column does not belong to referenced table
3271	>	Dynamic SQL Error
3272		-SQL error code = -206
3273		-Column unknown
3274		-X
#	Line 3285 | 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	>	Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3300	>	Unable to complete network request to host "unknown".
3301		-Failed to locate host machine.
3302		-The specified name was not found in the hosts file or Domain Name Services
3303		Invalid User Name Test
3304	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3304	>	Error Handled: SQLCODE: -902
3305	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3306	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3307		Invalid password Test
3308	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3308	>	Error Handled: SQLCODE: -902
3309	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3310	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3311
3312
3313		------------------------------------------------------
3314		Running Test 17: Date/Time tests and Firebird 4 extensions
3315	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
3315	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
3316		Has Local TZ DB = TRUE
3317
3318		Testdata
#	Line 4058 | Line 4074 | TZ_MINUTE = 0
4074
4075		------------------------------------------------------
4076		Running Test 18: Firebird 4 Decfloat extensions
4077	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4077	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4078
4079		FB4 Testdata_DECFloat
4080
#	Line 4327 | Line 4343 | BigNumber Array: (0: 123456123400.123456
4343		Running Test 19: Batch Update and Insert Queries
4344		Opening inet://localhost/employee
4345		Database Open
4346	<	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4347	<	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4348	<	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4346	>	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4347	>	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
4348	>	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
4349		on disk structure version 13.0
4350		Rows before update
4351		EMP_NO = 2
#	Line 4560 | Line 4576 | LANGUAGE_REQ = Array: (1: Eng) (2: Fra)
4576
4577
4578		Test Error Handling
4579	<	Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING
4579	>	Error reported (as expected) when changing param type: Param[0] "": Unable to change from a SQL_TIMESTAMP to a string type
4580		Test Error Handling - Update returning should fail
4581		Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched
4582		Error handling when Insert rows - duplicate key
4583	<	Error reported when inserting: Error Processing update/insert batch on row number 2 - violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4583	>	Error reported when inserting: Error Processing update/insert batch on row number 2 - SQLCODE: -803
4584	>	Engine Code: 335544665 Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values
4585	>	violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4586		-Problematic key value is ("EMP_NO" = 150)
4587		Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
4588		Batch Completion Info
#	Line 4577 | Line 4595 | Row 2 State = bcExecuteFailed Msg = viol
4595
4596		------------------------------------------------------
4597		Running Test 20: Stress Test IBatch interface
4598	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4598	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4599		10000 rows added
4600		20000 rows added
4601		30000 rows added
#	Line 4631 | Line 4649 | Parsing of 1.2E1.2 failed
4649		Parsing of 1,000 failed
4650		Parsing of 1e1e1 failed
4651		Parsing of 1.2+3 failed
4652	+	Validating Numeric Interface - IFBNumeric
4653	+	Value from Currency = 9999.1235
4654	+	Raw Value = 99991235 Scale = -4
4655	+	Value from Currency(rescaled) = 9999.12
4656	+	Raw Value = 999912 Scale = -2
4657	+	Value from Double = 9999.12345678
4658	+	Raw Value = 999912345678 Scale = -8
4659	+	Value from Integer = 9223372036854775807
4660	+	Raw Value = 9223372036854775807 Scale = 0
4661	+	Value from string = 9223372036854775807
4662	+	Raw Value = 9223372036854775807 Scale = 0
4663	+	Value from string = 9999.12345678
4664	+	Raw Value = 999912345678 Scale = -8
4665	+	Value from string = -0.12
4666	+	Raw Value = -12 Scale = -3
4667	+	Value from BCD = 9999.12345678
4668	+	Raw Value = 999912345678 Scale = -8
4669	+	Value from Raw Data = 9999123.456780
4670	+	Raw Value = 9999123456780 Scale = -6
4671		SQL Params
4672		SQLType =SQL_LONG
4673		sub type = 0
#	Line 4691 | Line 4728 | Engine Code: 335544569 Incompatible colu
4728		Dynamic SQL Error
4729		-SQL error code = -303
4730		-conversion error from string "10.0.0"
4731	+	Test Numeric Type
4732		ROWID = 1
4733		ITYPE = 101
4734		I64TYPE = 9223372036854775807
#	Line 4715 | Line 4753 | I64TYPE = 10
4753		CURRTYPE = .02300000
4754		DTYPE = .00110000
4755		FIXEDPOINT = 233.45600000
4756	+	ROWID = 7
4757	+	ITYPE = 1
4758	+	I64TYPE = 1234567
4759	+	CURRTYPE = .02300000
4760	+	DTYPE = .00110000
4761	+	FIXEDPOINT = 1,234.25000000
4762
4763
4764
4765		------------------------------------------------------
4766		Running Test 22: Journalling
4767	<	Start Journaling. Session ID = 1
4767	>	Start Journaling. Session ID = 0
4768		1234.567 parsed to 1234567 scale = -3
4769		As Float =  1.2345670000000000E+003
4770		-765.4321 parsed to -7654321 scale = -4
#	Line 4881 | Line 4925 | IBX$SESSIONID = 1
4925		IBX$TRANSACTIONID = 9
4926		IBX$OLDTRANSACTIONID = NULL
4927		IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4928	<	IBX$CREATED = 2021/12/07 09:50:08.4430
4928	>	IBX$CREATED = 2022/01/02 14:16:56.6410
4929		IBX$SESSIONID = 1
4930		IBX$TRANSACTIONID = 11
4931		IBX$OLDTRANSACTIONID = 10
4932		IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4933	<	IBX$CREATED = 2021/12/07 09:50:08.7940
4933	>	IBX$CREATED = 2022/01/02 14:16:56.9850
4934
4935		Journal Entries
4936		Journal Entry = jeTransStart(Transaction Start)
4937	<	Timestamp = 2021/12/07 09:50:08.4700
4937	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4938	>	Attachment ID = 4
4939		Session ID = 1
4940		Transaction ID = 9
4941		Transaction Name = "Transaction_29_1"
#	Line 4902 | Line 4947 | TPB: Item Count = 3
4947		Default Completion = TACommit
4948
4949		Journal Entry = jeQuery(Query)
4950	<	Timestamp = 2021/12/07 09:50:08.5300
4950	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4951	>	Attachment ID = 4
4952		Session ID = 1
4953		Transaction ID = 9
4954		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
4955
4956		Journal Entry = jeQuery(Query)
4957	<	Timestamp = 2021/12/07 09:50:08.5510
4957	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4958	>	Attachment ID = 4
4959		Session ID = 1
4960		Transaction ID = 9
4961		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
4962
4963		Journal Entry = jeTransCommitRet(Commit Retaining)
4964	<	Timestamp = 2021/12/07 09:50:08.6650
4964	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4965	>	Attachment ID = 4
4966		Session ID = 1
4967		Transaction ID = 10
4968		Old TransactionID = 9
4969
4970		Journal Entry = jeQuery(Query)
4971	<	Timestamp = 2021/12/07 09:50:08.6870
4971	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4972	>	Attachment ID = 4
4973		Session ID = 1
4974		Transaction ID = 10
4975		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
4976
4977		Journal Entry = jeTransRollbackRet(Rollback Retaining)
4978	<	Timestamp = 2021/12/07 09:50:08.7900
4978	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4979	>	Attachment ID = 4
4980		Session ID = 1
4981		Transaction ID = 11
4982		Old TransactionID = 10
4983
4984		Journal Entry = jeQuery(Query)
4985	<	Timestamp = 2021/12/07 09:50:08.8140
4985	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4986	>	Attachment ID = 4
4987		Session ID = 1
4988		Transaction ID = 11
4989		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
4990
4991		Journal Entry = jeTransStart(Transaction Start)
4992	<	Timestamp = 2021/12/07 09:50:08.8260
4992	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4993	>	Attachment ID = 4
4994		Session ID = 1
4995		Transaction ID = 12
4996		Transaction Name = "Transaction_29_2"
#	Line 4950 | Line 5002 | TPB: Item Count = 3
5002		Default Completion = TARollback
5003
5004		Journal Entry = jeTransCommit(Commit)
5005	<	Timestamp = 2021/12/07 09:50:08.8860
5005	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5006	>	Attachment ID = 4
5007		Session ID = 1
5008		Transaction ID = 11
5009
5010		Journal Entry = jeQuery(Query)
5011	<	Timestamp = 2021/12/07 09:50:08.9660
5011	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5012	>	Attachment ID = 4
5013		Session ID = 1
5014		Transaction ID = 12
5015		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:
#	Line 4996 | Line 5050 | Be all my sins remembered
5050		')
5051
5052		Journal Entry = jeQuery(Query)
5053	<	Timestamp = 2021/12/07 09:50:09.0130
5053	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5054	>	Attachment ID = 4
5055		Session ID = 1
5056		Transaction ID = 12
5057		Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
#	Line 5007 | Line 5062 | FFD8FFE000104A46494600010101004800480000
5062		)
5063
5064		Journal Entry = jeQuery(Query)
5065	<	Timestamp = 2021/12/07 09:50:09.0380
5065	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5066	>	Attachment ID = 4
5067		Session ID = 1
5068		Transaction ID = 12
5069		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">
#	Line 5032 | Line 5088 | Query = Insert into TestData(RowID,MyArr
5088		)
5089
5090		Journal Entry = jeTransRollback(Rollback)
5091	<	Timestamp = 2021/12/07 09:50:09.1560
5091	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5092	>	Attachment ID = 4
5093		Session ID = 1
5094		Transaction ID = 12
5095

Diff Legend

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