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 375 by tony, Sun Jan 9 23:42:58 2022 UTC

#	Line 3 | Line 3 | Copyright MWA Software 2016-2021
3
4		Starting Tests
5		Client API Version = 4.0
6	<	Firebird Environment Variable = /opt/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 = 5281
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
657	>	Transaction ID = 5281
658	>	Oldest Interesting = 1895
659	>	Oldest Action = 5280
660	>	Oldest Snapshot = 5280
661	>	Oldest Snapshot Number = 1
662		Lock Timeout = 0
663		Transaction Access = isc_info_tra_readwrite
664		Isolation Type = isc_info_tra_concurrency
#	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,762,192
696		Delta memory = 4,464
697	<	Max memory = 19,813,568
698	<	Elapsed time= 0.001 sec
697	>	Max memory = 19,807,520
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 =413
2838		Base Level = 13,4,0,3,
2839		Implementation = 11,7,0,3,66,1,66,
2840		Reserved = 0
2841		ODS minor = 0
2842		ODS major = 13
2843		Page Size = 8192
2844	<	Version = 1: LI-V6.3.0.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 = 351
2848	>	Pages Free = 62
2849	>	Server Memory = 19476112
2850		Forced Writes  = 1
2851	<	Max Memory  = 19630384
2851	>	Max Memory  = 19506944
2852		Num Buffers  = 2048
2853		Sweep Interval  = 20000
2854		Logged in Users: SYSDBA,
2855		Active Transaction Count = 0
2856	<	Fetches  = 1653
2857	<	Writes  = 8
2858	<	Reads  = 92
2859	<	Page Writes  = 4
2856	>	Fetches  = 1683
2857	>	Writes  = 6
2858	>	Reads  = 97
2859	>	Page Writes  = 3
2860		Record Version Removals Operation Counts
2861
2862		Deletes Operation Counts
#	Line 2871 | Line 2871 | Indexed Reads Count Operation Counts
2871		Table ID = 4
2872		Count = 63
2873		Table ID = 6
2874	<	Count = 23
2874	>	Count = 13
2875		Table ID = 9
2876	<	Count = 3
2876	>	Count = 1
2877		Table ID = 11
2878		Count = 2
2879		Table ID = 12
2880		Count = 24
2881		Table ID = 18
2882	<	Count = 821
2882	>	Count = 940
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
2896	>	Count = 14
2897
2898		Update Count Operation Counts
2899
#	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 2971 | Line 2971 | Local Backup
2971
2972
2973
2974	+
2975		Local Backup Complete
2976
2977		Local Restore
#	Line 3244 | Line 3245 | Écoute moi
3245		------------------------------------------------------
3246		Running Test 16: Error handling
3247		Invalid Database Name Test
3248	<	Error Handled: I/O error during "open" operation for file "Malformed Name"
3248	>	Error Handled: SQLCODE: -902
3249	>	Engine Code: 335544344 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3250	>	I/O error during "open" operation for file "Malformed Name"
3251		-Error while trying to open file
3252		-No such file or directory
3253		Invalid User Name Test
3254	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3254	>	Error Handled: SQLCODE: -902
3255	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3256	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3257		Invalid password Test
3258	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3258	>	Error Handled: SQLCODE: -902
3259	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3260	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3261		Invalid Prepare SQL Test
3262	<	Error Handled: Dynamic SQL Error
3262	>	Error Handled: SQLCODE: -206
3263	>	Engine Code: 335544569 Column does not belong to referenced table
3264	>	Dynamic SQL Error
3265		-SQL error code = -206
3266		-Column unknown
3267		-UNKNOWN_DATE
3268		-At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3269		Invalid Open Cursor SQL Test
3270	<	Error Handled: Dynamic SQL Error
3270	>	Error Handled: SQLCODE: -206
3271	>	Engine Code: 335544569 Column does not belong to referenced table
3272	>	Dynamic SQL Error
3273		-SQL error code = -206
3274		-Column unknown
3275		-X
#	Line 3285 | Line 3296 | New Transaction before Open Cursor
3296		COUNTER = 42
3297
3298		Invalid Server Name Test
3299	<	Error Handled: Unable to complete network request to host "unknown".
3299	>	Error Handled: SQLCODE: -902
3300	>	Engine Code: 335544721 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3301	>	Unable to complete network request to host "unknown".
3302		-Failed to locate host machine.
3303		-The specified name was not found in the hosts file or Domain Name Services
3304		Invalid User Name Test
3305	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3305	>	Error Handled: SQLCODE: -902
3306	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3307	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3308		Invalid password Test
3309	<	Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3309	>	Error Handled: SQLCODE: -902
3310	>	Engine Code: 335544472 Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3311	>	Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3312
3313
3314		------------------------------------------------------
3315		Running Test 17: Date/Time tests and Firebird 4 extensions
3316	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
3316	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
3317		Has Local TZ DB = TRUE
3318
3319		Testdata
#	Line 4058 | Line 4075 | TZ_MINUTE = 0
4075
4076		------------------------------------------------------
4077		Running Test 18: Firebird 4 Decfloat extensions
4078	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4078	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4079
4080		FB4 Testdata_DECFloat
4081
#	Line 4327 | Line 4344 | BigNumber Array: (0: 123456123400.123456
4344		Running Test 19: Batch Update and Insert Queries
4345		Opening inet://localhost/employee
4346		Database Open
4347	<	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4348	<	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4349	<	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4347	>	Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4348	>	Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
4349	>	Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
4350		on disk structure version 13.0
4351		Rows before update
4352		EMP_NO = 2
#	Line 4560 | Line 4577 | LANGUAGE_REQ = Array: (1: Eng) (2: Fra)
4577
4578
4579		Test Error Handling
4580	<	Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING
4580	>	Error reported (as expected) when changing param type: Param[0] "": Unable to change from a SQL_TIMESTAMP to a string type
4581		Test Error Handling - Update returning should fail
4582		Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched
4583		Error handling when Insert rows - duplicate key
4584	<	Error reported when inserting: Error Processing update/insert batch on row number 2 - violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4584	>	Error reported when inserting: Error Processing update/insert batch on row number 2 - SQLCODE: -803
4585	>	Engine Code: 335544665 Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values
4586	>	violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4587		-Problematic key value is ("EMP_NO" = 150)
4588		Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
4589		Batch Completion Info
#	Line 4577 | Line 4596 | Row 2 State = bcExecuteFailed Msg = viol
4596
4597		------------------------------------------------------
4598		Running Test 20: Stress Test IBatch interface
4599	<	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4599	>	FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4600		10000 rows added
4601		20000 rows added
4602		30000 rows added
#	Line 4631 | Line 4650 | Parsing of 1.2E1.2 failed
4650		Parsing of 1,000 failed
4651		Parsing of 1e1e1 failed
4652		Parsing of 1.2+3 failed
4653	+	Validating Numeric Interface - IFBNumeric
4654	+	Value from Currency = 9999.1235
4655	+	Raw Value = 99991235 Scale = -4
4656	+	Value from Currency(rescaled) = 9999.12
4657	+	Raw Value = 999912 Scale = -2
4658	+	Value from Double = 9999.12345678
4659	+	Raw Value = 999912345678 Scale = -8
4660	+	Value from Integer = 9223372036854775807
4661	+	Raw Value = 9223372036854775807 Scale = 0
4662	+	Value from string = 9223372036854775807
4663	+	Raw Value = 9223372036854775807 Scale = 0
4664	+	Value from string = 9999.12345678
4665	+	Raw Value = 999912345678 Scale = -8
4666	+	Value from string = -0.12
4667	+	Raw Value = -12 Scale = -3
4668	+	Value from BCD = 9999.12345678
4669	+	Raw Value = 999912345678 Scale = -8
4670	+	Value from Raw Data = 9999123.456780
4671	+	Raw Value = 9999123456780 Scale = -6
4672		SQL Params
4673		SQLType =SQL_LONG
4674		sub type = 0
#	Line 4691 | Line 4729 | Engine Code: 335544569 Incompatible colu
4729		Dynamic SQL Error
4730		-SQL error code = -303
4731		-conversion error from string "10.0.0"
4732	+	Test Numeric Type
4733		ROWID = 1
4734		ITYPE = 101
4735		I64TYPE = 9223372036854775807
#	Line 4715 | Line 4754 | I64TYPE = 10
4754		CURRTYPE = .02300000
4755		DTYPE = .00110000
4756		FIXEDPOINT = 233.45600000
4757	+	ROWID = 7
4758	+	ITYPE = 1
4759	+	I64TYPE = 1234567
4760	+	CURRTYPE = .02300000
4761	+	DTYPE = .00110000
4762	+	FIXEDPOINT = 1,234.25000000
4763
4764
4765
4766		------------------------------------------------------
4767		Running Test 22: Journalling
4768	<	Start Journaling. Session ID = 1
4768	>	Start Journaling. Session ID = 0
4769		1234.567 parsed to 1234567 scale = -3
4770		As Float =  1.2345670000000000E+003
4771		-765.4321 parsed to -7654321 scale = -4
#	Line 4878 | Line 4923 | MYARRAY = NULL
4923
4924		Journal Table
4925		IBX$SESSIONID = 1
4926	<	IBX$TRANSACTIONID = 9
4926	>	IBX$TRANSACTIONID = 8
4927		IBX$OLDTRANSACTIONID = NULL
4928		IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4929	<	IBX$CREATED = 2021/12/07 09:50:08.4430
4929	>	IBX$CREATED = 2022/01/09 15:24:09.1790
4930		IBX$SESSIONID = 1
4931	<	IBX$TRANSACTIONID = 11
4932	<	IBX$OLDTRANSACTIONID = 10
4931	>	IBX$TRANSACTIONID = 10
4932	>	IBX$OLDTRANSACTIONID = 9
4933		IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4934	<	IBX$CREATED = 2021/12/07 09:50:08.7940
4934	>	IBX$CREATED = 2022/01/09 15:24:09.5040
4935
4936		Journal Entries
4937		Journal Entry = jeTransStart(Transaction Start)
4938	<	Timestamp = 2021/12/07 09:50:08.4700
4938	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4939	>	Attachment ID = 4
4940		Session ID = 1
4941	<	Transaction ID = 9
4941	>	Transaction ID = 8
4942		Transaction Name = "Transaction_29_1"
4943		TPB: Item Count = 3
4944		isc_tpb_write
#	Line 4902 | Line 4948 | TPB: Item Count = 3
4948		Default Completion = TACommit
4949
4950		Journal Entry = jeQuery(Query)
4951	<	Timestamp = 2021/12/07 09:50:08.5300
4951	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4952	>	Attachment ID = 4
4953		Session ID = 1
4954	<	Transaction ID = 9
4954	>	Transaction ID = 8
4955		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
4956
4957		Journal Entry = jeQuery(Query)
4958	<	Timestamp = 2021/12/07 09:50:08.5510
4958	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4959	>	Attachment ID = 4
4960		Session ID = 1
4961	<	Transaction ID = 9
4961	>	Transaction ID = 8
4962		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
4963
4964		Journal Entry = jeTransCommitRet(Commit Retaining)
4965	<	Timestamp = 2021/12/07 09:50:08.6650
4965	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4966	>	Attachment ID = 4
4967		Session ID = 1
4968	<	Transaction ID = 10
4969	<	Old TransactionID = 9
4968	>	Transaction ID = 9
4969	>	Old TransactionID = 8
4970
4971		Journal Entry = jeQuery(Query)
4972	<	Timestamp = 2021/12/07 09:50:08.6870
4972	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4973	>	Attachment ID = 4
4974		Session ID = 1
4975	<	Transaction ID = 10
4975	>	Transaction ID = 9
4976		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
4977
4978		Journal Entry = jeTransRollbackRet(Rollback Retaining)
4979	<	Timestamp = 2021/12/07 09:50:08.7900
4979	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4980	>	Attachment ID = 4
4981		Session ID = 1
4982	<	Transaction ID = 11
4983	<	Old TransactionID = 10
4982	>	Transaction ID = 10
4983	>	Old TransactionID = 9
4984
4985		Journal Entry = jeQuery(Query)
4986	<	Timestamp = 2021/12/07 09:50:08.8140
4986	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4987	>	Attachment ID = 4
4988		Session ID = 1
4989	<	Transaction ID = 11
4989	>	Transaction ID = 10
4990		Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
4991
4992		Journal Entry = jeTransStart(Transaction Start)
4993	<	Timestamp = 2021/12/07 09:50:08.8260
4993	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4994	>	Attachment ID = 4
4995		Session ID = 1
4996	<	Transaction ID = 12
4996	>	Transaction ID = 11
4997		Transaction Name = "Transaction_29_2"
4998		TPB: Item Count = 3
4999		isc_tpb_write
#	Line 4950 | Line 5003 | TPB: Item Count = 3
5003		Default Completion = TARollback
5004
5005		Journal Entry = jeTransCommit(Commit)
5006	<	Timestamp = 2021/12/07 09:50:08.8860
5006	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5007	>	Attachment ID = 4
5008		Session ID = 1
5009	<	Transaction ID = 11
5009	>	Transaction ID = 10
5010
5011		Journal Entry = jeQuery(Query)
5012	<	Timestamp = 2021/12/07 09:50:08.9660
5012	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5013	>	Attachment ID = 4
5014		Session ID = 1
5015	<	Transaction ID = 12
5015	>	Transaction ID = 11
5016		Query = Insert into TestData(RowID, Str, TextBlob) Values(5,'It''s the quick brown fox jumps over the lazy dog','To be or not to be-that is the question:
5017		Whether ''tis nobler in the mind to suffer
5018		The slings and arrows of outrageous fortune,
#	Line 4996 | Line 5051 | Be all my sins remembered
5051		')
5052
5053		Journal Entry = jeQuery(Query)
5054	<	Timestamp = 2021/12/07 09:50:09.0130
5054	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5055	>	Attachment ID = 4
5056		Session ID = 1
5057	<	Transaction ID = 12
5057	>	Transaction ID = 11
5058		Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
5059		FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
5060		0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
#	Line 5007 | Line 5063 | FFD8FFE000104A46494600010101004800480000
5063		)
5064
5065		Journal Entry = jeQuery(Query)
5066	<	Timestamp = 2021/12/07 09:50:09.0380
5066	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5067	>	Attachment ID = 4
5068		Session ID = 1
5069	<	Transaction ID = 12
5069	>	Transaction ID = 11
5070		Query = Insert into TestData(RowID,MyArray) Values (7,<array dim = "1" sqltype = "496" length = "4" relation_name = "TESTDATA" column_name = "MYARRAY" scale = "0" bounds="0:16">
5071		<elt ix="0">100</elt>
5072		<elt ix="1">99</elt>
#	Line 5032 | Line 5089 | Query = Insert into TestData(RowID,MyArr
5089		)
5090
5091		Journal Entry = jeTransRollback(Rollback)
5092	<	Timestamp = 2021/12/07 09:50:09.1560
5092	>	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5093	>	Attachment ID = 4
5094		Session ID = 1
5095	<	Transaction ID = 12
5095	>	Transaction ID = 11
5096
5097
5098

Diff Legend

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