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 350 by tony, Wed Oct 20 14:58:56 2021 UTC vs.
ibx/branches/udr/testsuite/FB4reference.log (file contents), Revision 381 by tony, Sat Jan 15 00:06: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 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/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 77 | Line 78 | Dropping Database
78
79		------------------------------------------------------
80		Running Test 2: Open the employee database and run a query
81	+	Open Database fails Engine Code: 335544472 Your user name and password are not defined. Ask your database administrator to set up a Firebird login
82		Opening inet://localhost/employee
83		Database Open, SQL Dialect = 3
84		TPB: Item Count = 3
#	Line 306 | Line 308 | JOB_COUNTRY = USA
308		SALARY = 64,635.00
309		FULL_NAME = Johnson, Leslie
310
311	+	Scollable Cursors
312	+	DB Connect String = inet://localhost/employee
313	+	DB Charset ID = 4
314	+	DB SQL Dialect = 3
315	+	DB Remote Protocol = TCPv4
316	+	DB ODS Major Version = 13
317	+	DB ODS Minor Version = 0
318	+	User Authentication Method = Srp256
319	+	Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so
320	+	DB Client Implementation Version = 4.0
321	+	Do Fetch Next:
322	+	EMP_NO = 2
323	+	FIRST_NAME = Robert
324	+	LAST_NAME = Nelson
325	+	PHONE_EXT = 250
326	+	HIRE_DATE = 1988/12/28 00:00:00.0000
327	+	DEPT_NO = 600
328	+	JOB_CODE = VP
329	+	JOB_GRADE = 2
330	+	JOB_COUNTRY = USA
331	+	SALARY = 105,900.00
332	+	FULL_NAME = Nelson, Robert
333	+	Do Fetch Last:
334	+	Remote Scrollable cursors test fails Engine Code: 335544378 feature is not supported
335		Now open the employee database as a local database
336		TPB: Item Count = 3
337		isc_tpb_read
#	Line 535 | Line 561 | SALARY = 64,635.00
561		FULL_NAME = Johnson, Leslie
562
563		Scollable Cursors
564	+	DB Connect String = employee
565	+	DB Charset ID = 4
566	+	DB SQL Dialect = 3
567	+	DB Remote Protocol =
568	+	DB ODS Major Version = 13
569	+	DB ODS Minor Version = 0
570	+	User Authentication Method = User name in DPB
571	+	Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so
572	+	DB Client Implementation Version = 4.0
573		Do Fetch Next:
574		EMP_NO = 2
575		FIRST_NAME = Robert
#	Line 616 | Line 651 | Running Test 3: ad hoc queries
651		Opening inet://localhost/employee
652		Database Open
653		Employee Count = 42
654	+	Transaction ID = 8337
655	+	Transaction is Read/Write
656	+	Transaction Database Path = inet://localhost/employee
657	+	Transaction ID = 8337
658	+	Oldest Interesting = 8335
659	+	Oldest Action = 8336
660	+	Oldest Snapshot = 8336
661	+	Oldest Snapshot Number = 1
662	+	Lock Timeout = 0
663	+	Transaction Access = isc_info_tra_readwrite
664	+	Isolation Type = isc_info_tra_concurrency
665		Employee Count = 41
666		Employee Count = 42
667		Employee Count = 41
#	Line 629 | 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 646 | 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,400
696		Delta memory = 4,464
697	<	Max memory = 19,813,568
698	<	Elapsed time= 0.000 sec
697	>	Max memory = 19,807,728
698	>	Elapsed time= 0.003 sec
699		Cpu = 0.000 sec
700		Buffers = 2048
701		Reads = 0
702	<	Writes = 0
702	>	Writes = 1
703		Fetches = 3
704		Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
705		Relation Name = EMPLOYEE
#	Line 2687 | 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.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)
2737
2738
2739		Shrink to 2:10
#	Line 2703 | 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.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)
2753
2754
2755
#	Line 2787 | 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 = 352
2848	>	Pages Free = 61
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  = 1648
2857	<	Writes  = 8
2858	<	Reads  = 92
2859	<	Page Writes  = 4
2856	>	Fetches  = 1698
2857	>	Writes  = 6
2858	>	Reads  = 97
2859	>	Page Writes  = 3
2860		Record Version Removals Operation Counts
2861
2862		Deletes Operation Counts
#	Line 2825 | 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 = 816
2882	>	Count = 952
2883		Table ID = 20
2884		Count = 5
2885		Table ID = 28
#	Line 2845 | 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 2861 | Line 2907 | Async Wait Called
2907		Event Signalled
2908		First Event - usually ignored
2909		Signal Event
2910	+	Event Signalled
2911		Event Counts: TESTEVENT, Count = 1
2912		Two more events
2913		Call Async Wait
2914		Async Wait Called
2915		Event Signalled
2869	–	Event Signalled
2916		Deferred Events Caught
2917		Event Counts: TESTEVENT, Count = 2
2918		Signal Event
#	Line 2888 | 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 2908 | 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 3198 | 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 3239 | 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 4012 | 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 4281 | 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 4514 | 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 4531 | 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 4561 | Line 4625 | Test Completed Successfully
4625
4626		------------------------------------------------------
4627		Running Test 21: Exercise setting and getting of numeric data types
4628	+	1234.567 parsed to 1234567 scale = -3
4629	+	As Float =  1.2345670000000000E+003
4630	+	-765.4321 parsed to -7654321 scale = -4
4631	+	As Float = -7.6543209999999999E+002
4632	+	0.1 parsed to 1 scale = -1
4633	+	As Float =  1.0000000000000001E-001
4634	+	0.01 parsed to 1 scale = -2
4635	+	As Float =  1.0000000000000000E-002
4636	+	+123 parsed to 123 scale = 0
4637	+	As Float =  1.2300000000000000E+002
4638	+	1.23456E308 parsed to 123456 scale = 303
4639	+	As Float =  1.2345600000000001E+308
4640	+	-1.2e-02 parsed to -12 scale = -3
4641	+	As Float = -1.2000000000000000E-002
4642	+	10. parsed to 10 scale = 0
4643	+	As Float =  1.0000000000000000E+001
4644	+	.12 parsed to 12 scale = -2
4645	+	As Float =  1.2000000000000000E-001
4646	+	0.12 parsed to 12 scale = -2
4647	+	As Float =  1.2000000000000000E-001
4648	+	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	+	Numeric Operations
4672	+	Add 2.23 + 24.12345 = 26.35345
4673	+	Add Double 2.23 + 24.12645 = 26.35645
4674	+	Add integer 2.23 + 2412345 = 2412347.23
4675	+	Subtract 2.23 - 24.12345 = -21.89345
4676	+	Subtract Double 24.12645 - 2.23 = -21.89645
4677	+	Subtract integer 24123.45 - 223 = -23900.45
4678	+	Multiply 2.23 * 24.12345 = 53.7952935
4679	+	Multiply Double 24.12645 * 2.23 = 53.8019835
4680	+	Multiply integer 241.2345 * 223 = 53795.2935
4681	+	Divide 24.12345 / 2.23 = 10.81769
4682	+	Divide Double 2.23 / 24.12645 = 0.09
4683	+	Divide integer 241.2345 / 223 = 1.0818
4684	+	Compare 2.23, -24.12345 = 1
4685	+	Compare integer 2.23, 3 = -1
4686	+	Compare Double 2.23, 2.23 = 0
4687	+	Negate 24.12345 = -24.12345
4688		SQL Params
4689		SQLType =SQL_LONG
4690		sub type = 0
#	Line 4621 | Line 4745 | Engine Code: 335544569 Incompatible colu
4745		Dynamic SQL Error
4746		-SQL error code = -303
4747		-conversion error from string "10.0.0"
4748	+	Test Numeric Type
4749		ROWID = 1
4750		ITYPE = 101
4751		I64TYPE = 9223372036854775807
#	Line 4643 | Line 4768 | ROWID = 4
4768		ITYPE = 1
4769		I64TYPE = 10
4770		CURRTYPE = .02300000
4771	<	DTYPE = .00000000
4771	>	DTYPE = .00110000
4772	>	FIXEDPOINT = 233.45600000
4773	>	ROWID = 7
4774	>	ITYPE = 1
4775	>	I64TYPE = 1234567
4776	>	CURRTYPE = .02300000
4777	>	DTYPE = .00110000
4778	>	FIXEDPOINT = 1,234.25000000
4779	>
4780	>
4781	>
4782	>	------------------------------------------------------
4783	>	Running Test 22: Journalling
4784	>	Start Journaling. Session ID = 0
4785	>	1234.567 parsed to 1234567 scale = -3
4786	>	As Float =  1.2345670000000000E+003
4787	>	-765.4321 parsed to -7654321 scale = -4
4788	>	As Float = -7.6543209999999999E+002
4789	>	0.1 parsed to 1 scale = -1
4790	>	As Float =  1.0000000000000001E-001
4791	>	0.01 parsed to 1 scale = -2
4792	>	As Float =  1.0000000000000000E-002
4793	>	+123 parsed to 123 scale = 0
4794	>	As Float =  1.2300000000000000E+002
4795	>	1.23456E308 parsed to 123456 scale = 303
4796	>	As Float =  1.2345600000000001E+308
4797	>	-1.2e-02 parsed to -12 scale = -3
4798	>	As Float = -1.2000000000000000E-002
4799	>	10. parsed to 10 scale = 0
4800	>	As Float =  1.0000000000000000E+001
4801	>	.12 parsed to 12 scale = -2
4802	>	As Float =  1.2000000000000000E-001
4803	>	0.12 parsed to 12 scale = -2
4804	>	As Float =  1.2000000000000000E-001
4805	>	Parsing of 1.2E1.2 failed
4806	>	Parsing of 1,000 failed
4807	>	Parsing of 1e1e1 failed
4808	>	Parsing of 1.2+3 failed
4809	>	SQL Params
4810	>	SQLType =SQL_LONG
4811	>	sub type = 0
4812	>	Field Name =
4813	>	Scale = 0
4814	>	Charset id = 0
4815	>	Not Null
4816	>	Size = 4
4817	>	Value = 0
4818	>
4819	>	SQLType =SQL_LONG
4820	>	sub type = 0
4821	>	Field Name =
4822	>	Scale = 0
4823	>	Charset id = 0
4824	>	Nullable
4825	>	Size = 4
4826	>
4827	>	SQLType =SQL_INT64
4828	>	sub type = 0
4829	>	Field Name =
4830	>	Scale = 0
4831	>	Charset id = 0
4832	>	Nullable
4833	>	Size = 8
4834	>
4835	>	SQLType =SQL_INT64
4836	>	sub type = 0
4837	>	Field Name =
4838	>	Scale = -4
4839	>	Charset id = 0
4840	>	Nullable
4841	>	Size = 8
4842	>
4843	>	SQLType =SQL_DOUBLE
4844	>	sub type = 0
4845	>	Field Name =
4846	>	Scale = 0
4847	>	Charset id = 0
4848	>	Nullable
4849	>	Size = 8
4850	>
4851	>	SQLType =SQL_INT64
4852	>	sub type = 0
4853	>	Field Name =
4854	>	Scale = -6
4855	>	Charset id = 0
4856	>	Nullable
4857	>	Size = 8
4858	>
4859	>
4860	>	Text Tests
4861	>	SQL Params
4862	>	SQLType =SQL_LONG
4863	>	sub type = 0
4864	>	Field Name =
4865	>	Scale = 0
4866	>	Charset id = 0
4867	>	Not Null
4868	>	Size = 4
4869	>	Value = 0
4870	>
4871	>	SQLType =SQL_VARYING
4872	>	sub type = 0
4873	>	Field Name =
4874	>	Scale = 0
4875	>	Charset id = 4
4876	>	Nullable
4877	>	Size = 1024
4878	>
4879	>	SQLType =SQL_BLOB
4880	>	sub type = 1
4881	>	Field Name =
4882	>	Scale = 0
4883	>	Charset id = 4
4884	>	Nullable
4885	>	Size = 8
4886	>
4887	>
4888	>	Binary Blob Tests
4889	>
4890	>	Array Test
4891	>	SQL Params
4892	>	SQLType =SQL_LONG
4893	>	sub type = 0
4894	>	Field Name =
4895	>	Scale = 0
4896	>	Charset id = 0
4897	>	Not Null
4898	>	Size = 4
4899	>	Value = 0
4900	>
4901	>	SQLType =SQL_ARRAY
4902	>	sub type = 0
4903	>	Field Name =
4904	>	Scale = 0
4905	>	Charset id = 0
4906	>	Nullable
4907	>	Size = 8
4908	>
4909	>	ROWID = 1
4910	>	ITYPE = 101
4911	>	I64TYPE = 9223372036854775807
4912	>	CURRTYPE = 10,000.12340000
4913	>	DTYPE = 9,999.12345678
4914	>	FIXEDPOINT = 1,234,567,890.12345700
4915	>	STR = NULL
4916	>	TEXTBLOB = NULL
4917	>	OTHERBLOB = NULL
4918	>	MYARRAY = NULL
4919	>	ROWID = 2
4920	>	ITYPE = -32457
4921	>	I64TYPE = -9223372036854775808
4922	>	CURRTYPE = 1,000,001.12000000
4923	>	DTYPE = 1.7E308
4924	>	FIXEDPOINT = -1,234,567,890.12345700
4925	>	STR = NULL
4926	>	TEXTBLOB = NULL
4927	>	OTHERBLOB = NULL
4928	>	MYARRAY = NULL
4929	>	ROWID = 4
4930	>	ITYPE = 1
4931	>	I64TYPE = 10
4932	>	CURRTYPE = .02300000
4933	>	DTYPE = .00110000
4934		FIXEDPOINT = 233.45600000
4935	+	STR = NULL
4936	+	TEXTBLOB = NULL
4937	+	OTHERBLOB = NULL
4938	+	MYARRAY = NULL
4939	+
4940	+	Journal Table
4941	+	IBX$SESSIONID = 1
4942	+	IBX$TRANSACTIONID = 8
4943	+	IBX$OLDTRANSACTIONID = NULL
4944	+	IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4945	+	IBX$CREATED = 2022/01/14 22:58:12.7560
4946	+	IBX$SESSIONID = 1
4947	+	IBX$TRANSACTIONID = 10
4948	+	IBX$OLDTRANSACTIONID = 9
4949	+	IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4950	+	IBX$CREATED = 2022/01/14 22:58:13.0520
4951	+
4952	+	Journal Entries
4953	+	Journal Entry = jeTransStart(Transaction Start)
4954	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4955	+	Attachment ID = 4
4956	+	Session ID = 1
4957	+	Transaction ID = 8
4958	+	Transaction Name = "Transaction_29_1"
4959	+	TPB: Item Count = 3
4960	+	isc_tpb_write
4961	+	isc_tpb_nowait
4962	+	isc_tpb_concurrency
4963	+
4964	+	Default Completion = TACommit
4965	+
4966	+	Journal Entry = jeQuery(Query)
4967	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4968	+	Attachment ID = 4
4969	+	Session ID = 1
4970	+	Transaction ID = 8
4971	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
4972	+
4973	+	Journal Entry = jeQuery(Query)
4974	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4975	+	Attachment ID = 4
4976	+	Session ID = 1
4977	+	Transaction ID = 8
4978	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
4979	+
4980	+	Journal Entry = jeTransCommitRet(Commit Retaining)
4981	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4982	+	Attachment ID = 4
4983	+	Session ID = 1
4984	+	Transaction ID = 9
4985	+	Old TransactionID = 8
4986	+
4987	+	Journal Entry = jeQuery(Query)
4988	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4989	+	Attachment ID = 4
4990	+	Session ID = 1
4991	+	Transaction ID = 9
4992	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(3,0,0,0,0,0)
4993	+
4994	+	Journal Entry = jeTransRollbackRet(Rollback Retaining)
4995	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4996	+	Attachment ID = 4
4997	+	Session ID = 1
4998	+	Transaction ID = 10
4999	+	Old TransactionID = 9
5000	+
5001	+	Journal Entry = jeQuery(Query)
5002	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5003	+	Attachment ID = 4
5004	+	Session ID = 1
5005	+	Transaction ID = 10
5006	+	Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
5007	+
5008	+	Journal Entry = jeTransStart(Transaction Start)
5009	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5010	+	Attachment ID = 4
5011	+	Session ID = 1
5012	+	Transaction ID = 11
5013	+	Transaction Name = "Transaction_29_2"
5014	+	TPB: Item Count = 3
5015	+	isc_tpb_write
5016	+	isc_tpb_nowait
5017	+	isc_tpb_concurrency
5018	+
5019	+	Default Completion = TARollback
5020	+
5021	+	Journal Entry = jeTransCommit(Commit)
5022	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5023	+	Attachment ID = 4
5024	+	Session ID = 1
5025	+	Transaction ID = 10
5026	+
5027	+	Journal Entry = jeQuery(Query)
5028	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5029	+	Attachment ID = 4
5030	+	Session ID = 1
5031	+	Transaction ID = 11
5032	+	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:
5033	+	Whether ''tis nobler in the mind to suffer
5034	+	The slings and arrows of outrageous fortune,
5035	+	Or to take arms against a sea of troubles,
5036	+	And, by opposing, end them. To die, to sleep-
5037	+	No more-and by a sleep to say we end
5038	+	The heartache and the thousand natural shocks
5039	+	That flesh is heir to-''tis a consummation
5040	+	Devoutly to be wished. To die, to sleep-
5041	+	To sleep, perchance to dream. Aye, there''s the rub,
5042	+	For in that sleep of death what dreams may come,
5043	+	When we have shuffled off this mortal coil,
5044	+	Must give us pause. There''s the respect
5045	+	That makes calamity of so long life.
5046	+	For who would bear the whips and scorns of time,
5047	+	Th'' oppressor''s wrong, the proud man''s contumely,
5048	+	The pangs of despised love, the law’s delay,
5049	+	The insolence of office, and the spurns
5050	+	That patient merit of the unworthy takes,
5051	+	When he himself might his quietus make
5052	+	With a bare bodkin? Who would fardels bear,
5053	+	To grunt and sweat under a weary life,
5054	+	But that the dread of something after death,
5055	+	The undiscovered country from whose bourn
5056	+	No traveler returns, puzzles the will
5057	+	And makes us rather bear those ills we have
5058	+	Than fly to others that we know not of?
5059	+	Thus conscience does make cowards of us all,
5060	+	And thus the native hue of resolution
5061	+	Is sicklied o''er with the pale cast of thought,
5062	+	And enterprises of great pitch and moment,
5063	+	With this regard their currents turn awry,
5064	+	And lose the name of action.-Soft you now,
5065	+	The fair Ophelia.-Nymph, in thy orisons
5066	+	Be all my sins remembered
5067	+	')
5068	+
5069	+	Journal Entry = jeQuery(Query)
5070	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5071	+	Attachment ID = 4
5072	+	Session ID = 1
5073	+	Transaction ID = 11
5074	+	Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
5075	+	FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
5076	+	0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
5077	+	01000000010000001A01050001000000DA000000
5078	+	</blob>
5079	+	)
5080	+
5081	+	Journal Entry = jeQuery(Query)
5082	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5083	+	Attachment ID = 4
5084	+	Session ID = 1
5085	+	Transaction ID = 11
5086	+	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">
5087	+	<elt ix="0">100</elt>
5088	+	<elt ix="1">99</elt>
5089	+	<elt ix="2">98</elt>
5090	+	<elt ix="3">97</elt>
5091	+	<elt ix="4">96</elt>
5092	+	<elt ix="5">95</elt>
5093	+	<elt ix="6">94</elt>
5094	+	<elt ix="7">93</elt>
5095	+	<elt ix="8">92</elt>
5096	+	<elt ix="9">91</elt>
5097	+	<elt ix="10">90</elt>
5098	+	<elt ix="11">89</elt>
5099	+	<elt ix="12">88</elt>
5100	+	<elt ix="13">87</elt>
5101	+	<elt ix="14">86</elt>
5102	+	<elt ix="15">85</elt>
5103	+	<elt ix="16">84</elt>
5104	+	</array>
5105	+	)
5106	+
5107	+	Journal Entry = jeTransRollback(Rollback)
5108	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5109	+	Attachment ID = 4
5110	+	Session ID = 1
5111	+	Transaction ID = 11
5112
5113
5114

Diff Legend

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