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 347 by tony, Mon Sep 20 22:08:20 2021 UTC vs.
ibx/branches/udr/testsuite/FB4reference.log (file contents), 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 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 293 | Line 295 | Not Null
295		Size = 2
296		Value = 0
297
298	+	Results for Cursor: Test Cursor
299		EMP_NO = 8
300		FIRST_NAME = Leslie
301		LAST_NAME = Johnson
#	Line 305 | 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 520 | Line 547 | Not Null
547		Size = 2
548		Value = 0
549
550	+	Results for Cursor: Test Cursor
551		EMP_NO = 8
552		FIRST_NAME = Leslie
553		LAST_NAME = Johnson
#	Line 532 | Line 560 | JOB_COUNTRY = USA
560		SALARY = 64,635.00
561		FULL_NAME = Johnson, Leslie
562
563	+	Scollable Cursors
564	+	DB Connect String = employee
565	+	DB Charset ID = 4
566	+	DB SQL Dialect = 3
567	+	DB Remote Protocol =
568	+	DB ODS Major Version = 13
569	+	DB ODS Minor Version = 0
570	+	User Authentication Method = User name in DPB
571	+	Firebird Library Path = /opt/firebird4.0.1/lib/libfbclient.so
572	+	DB Client Implementation Version = 4.0
573	+	Do Fetch Next:
574	+	EMP_NO = 2
575	+	FIRST_NAME = Robert
576	+	LAST_NAME = Nelson
577	+	PHONE_EXT = 250
578	+	HIRE_DATE = 1988/12/28 00:00:00.0000
579	+	DEPT_NO = 600
580	+	JOB_CODE = VP
581	+	JOB_GRADE = 2
582	+	JOB_COUNTRY = USA
583	+	SALARY = 105,900.00
584	+	FULL_NAME = Nelson, Robert
585	+	Do Fetch Last:
586	+	EMP_NO = 145
587	+	FIRST_NAME = Mark
588	+	LAST_NAME = Guckenheimer
589	+	PHONE_EXT = 221
590	+	HIRE_DATE = 1994/05/02 00:00:00.0000
591	+	DEPT_NO = 622
592	+	JOB_CODE = Eng
593	+	JOB_GRADE = 5
594	+	JOB_COUNTRY = USA
595	+	SALARY = 32,000.00
596	+	FULL_NAME = Guckenheimer, Mark
597	+	Do Fetch Prior:
598	+	EMP_NO = 144
599	+	FIRST_NAME = John
600	+	LAST_NAME = Montgomery
601	+	PHONE_EXT = 820
602	+	HIRE_DATE = 1994/03/30 00:00:00.0000
603	+	DEPT_NO = 672
604	+	JOB_CODE = Eng
605	+	JOB_GRADE = 5
606	+	JOB_COUNTRY = USA
607	+	SALARY = 35,000.00
608	+	FULL_NAME = Montgomery, John
609	+	Do Fetch First:
610	+	EMP_NO = 2
611	+	FIRST_NAME = Robert
612	+	LAST_NAME = Nelson
613	+	PHONE_EXT = 250
614	+	HIRE_DATE = 1988/12/28 00:00:00.0000
615	+	DEPT_NO = 600
616	+	JOB_CODE = VP
617	+	JOB_GRADE = 2
618	+	JOB_COUNTRY = USA
619	+	SALARY = 105,900.00
620	+	FULL_NAME = Nelson, Robert
621	+	Do Fetch Abs 8 :
622	+	EMP_NO = 14
623	+	FIRST_NAME = Stewart
624	+	LAST_NAME = Hall
625	+	PHONE_EXT = 227
626	+	HIRE_DATE = 1990/06/04 00:00:00.0000
627	+	DEPT_NO = 900
628	+	JOB_CODE = Finan
629	+	JOB_GRADE = 3
630	+	JOB_COUNTRY = USA
631	+	SALARY = 69,482.63
632	+	FULL_NAME = Hall, Stewart
633	+	Do Fetch Relative -2 :
634	+	EMP_NO = 11
635	+	FIRST_NAME = K. J.
636	+	LAST_NAME = Weston
637	+	PHONE_EXT = 34
638	+	HIRE_DATE = 1990/01/17 00:00:00.0000
639	+	DEPT_NO = 130
640	+	JOB_CODE = SRep
641	+	JOB_GRADE = 4
642	+	JOB_COUNTRY = USA
643	+	SALARY = 86,292.94
644	+	FULL_NAME = Weston, K. J.
645	+	Do Fetch beyond EOF :
646	+	Fetch returned false
647
648
649		------------------------------------------------------
#	Line 539 | Line 651 | Running Test 3: ad hoc queries
651		Opening inet://localhost/employee
652		Database Open
653		Employee Count = 42
654	+	Transaction ID = 173
655	+	Transaction is Read/Write
656	+	Transaction Database Path = inet://localhost/employee
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
664	+	Isolation Type = isc_info_tra_concurrency
665		Employee Count = 41
666		Employee Count = 42
667		Employee Count = 41
#	Line 552 | 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 569 | Line 692 | JOB_COUNTRY = USA
692		SALARY = 64,635.00
693		FULL_NAME = Johnson, Leslie
694
695	<	Current memory = 19,767,232
695	>	Current memory = 19,767,936
696		Delta memory = 4,464
697	<	Max memory = 19,813,104
697	>	Max memory = 19,813,552
698		Elapsed time= 0.002 sec
699	<	Cpu = 0.010 sec
699	>	Cpu = 0.000 sec
700		Buffers = 2048
701		Reads = 0
702		Writes = 0
#	Line 2610 | Line 2733 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2733
2734		MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00)
2735
2736	<	MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 14.69) (15: 15.75) (16: 16.79)
2736	>	MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.46) (16: 4269)
2737
2738
2739		Shrink to 2:10
#	Line 2626 | Line 2749 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2749
2750		MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00)
2751
2752	<	MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 14.69) (15: 15.75) (16: 16.79)
2752	>	MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.46) (16: 4269)
2753
2754
2755
#	Line 2710 | 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 = 19483648
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  = 19629664
2851	>	Max Memory  = 19629552
2852		Num Buffers  = 2048
2853		Sweep Interval  = 20000
2854		Logged in Users: SYSDBA,
2855		Active Transaction Count = 0
2856	<	Fetches  = 1648
2856	>	Fetches  = 1634
2857		Writes  = 8
2858	<	Reads  = 92
2858	>	Reads  = 91
2859		Page Writes  = 4
2860		Record Version Removals Operation Counts
2861
#	Line 2756 | Line 2879 | Count = 2
2879		Table ID = 12
2880		Count = 24
2881		Table ID = 18
2882	<	Count = 816
2882	>	Count = 805
2883		Table ID = 20
2884		Count = 5
2885		Table ID = 28
#	Line 2768 | 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 2811 | 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 2831 | 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 3121 | 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 3162 | 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 3935 | 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 4204 | 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 4437 | 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 4454 | 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 4483 | Line 4624 | Test Completed Successfully
4624
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	+	SQL Params
4672	+	SQLType =SQL_LONG
4673	+	sub type = 0
4674	+	Field Name =
4675	+	Scale = 0
4676	+	Charset id = 0
4677	+	Not Null
4678	+	Size = 4
4679	+	Value = 0
4680	+
4681	+	SQLType =SQL_LONG
4682	+	sub type = 0
4683	+	Field Name =
4684	+	Scale = 0
4685	+	Charset id = 0
4686	+	Nullable
4687	+	Size = 4
4688	+
4689	+	SQLType =SQL_INT64
4690	+	sub type = 0
4691	+	Field Name =
4692	+	Scale = 0
4693	+	Charset id = 0
4694	+	Nullable
4695	+	Size = 8
4696	+
4697	+	SQLType =SQL_INT64
4698	+	sub type = 0
4699	+	Field Name =
4700	+	Scale = -4
4701	+	Charset id = 0
4702	+	Nullable
4703	+	Size = 8
4704	+
4705	+	SQLType =SQL_DOUBLE
4706	+	sub type = 0
4707	+	Field Name =
4708	+	Scale = 0
4709	+	Charset id = 0
4710	+	Nullable
4711	+	Size = 8
4712	+
4713	+	SQLType =SQL_INT64
4714	+	sub type = 0
4715	+	Field Name =
4716	+	Scale = -6
4717	+	Charset id = 0
4718	+	Nullable
4719	+	Size = 8
4720	+
4721	+	Expected Error - SQLCODE: -303
4722	+	Engine Code: 335544569 Incompatible column/host variable data type
4723	+	Dynamic SQL Error
4724	+	-SQL error code = -303
4725	+	-conversion error from string "1,000"
4726	+	Expected Error - SQLCODE: -303
4727	+	Engine Code: 335544569 Incompatible column/host variable data type
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
4735	+	CURRTYPE = 10,000.12340000
4736	+	DTYPE = 9,999.12345678
4737	+	FIXEDPOINT = 1,234,567,890.12345700
4738	+	ROWID = 2
4739	+	ITYPE = -32457
4740	+	I64TYPE = -9223372036854775808
4741	+	CURRTYPE = 1,000,001.12000000
4742	+	DTYPE = 1.7E308
4743	+	FIXEDPOINT = -1,234,567,890.12345700
4744	+	ROWID = 3
4745	+	ITYPE = 0
4746	+	I64TYPE = 0
4747	+	CURRTYPE = .00000000
4748	+	DTYPE = .00000000
4749	+	FIXEDPOINT = .00000000
4750	+	ROWID = 4
4751	+	ITYPE = 1
4752	+	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 = 0
4768	+	1234.567 parsed to 1234567 scale = -3
4769	+	As Float =  1.2345670000000000E+003
4770	+	-765.4321 parsed to -7654321 scale = -4
4771	+	As Float = -7.6543209999999999E+002
4772	+	0.1 parsed to 1 scale = -1
4773	+	As Float =  1.0000000000000001E-001
4774	+	0.01 parsed to 1 scale = -2
4775	+	As Float =  1.0000000000000000E-002
4776	+	+123 parsed to 123 scale = 0
4777	+	As Float =  1.2300000000000000E+002
4778	+	1.23456E308 parsed to 123456 scale = 303
4779	+	As Float =  1.2345600000000001E+308
4780	+	-1.2e-02 parsed to -12 scale = -3
4781	+	As Float = -1.2000000000000000E-002
4782	+	10. parsed to 10 scale = 0
4783	+	As Float =  1.0000000000000000E+001
4784	+	.12 parsed to 12 scale = -2
4785	+	As Float =  1.2000000000000000E-001
4786	+	0.12 parsed to 12 scale = -2
4787	+	As Float =  1.2000000000000000E-001
4788	+	Parsing of 1.2E1.2 failed
4789	+	Parsing of 1,000 failed
4790	+	Parsing of 1e1e1 failed
4791	+	Parsing of 1.2+3 failed
4792	+	SQL Params
4793	+	SQLType =SQL_LONG
4794	+	sub type = 0
4795	+	Field Name =
4796	+	Scale = 0
4797	+	Charset id = 0
4798	+	Not Null
4799	+	Size = 4
4800	+	Value = 0
4801	+
4802	+	SQLType =SQL_LONG
4803	+	sub type = 0
4804	+	Field Name =
4805	+	Scale = 0
4806	+	Charset id = 0
4807	+	Nullable
4808	+	Size = 4
4809	+
4810	+	SQLType =SQL_INT64
4811	+	sub type = 0
4812	+	Field Name =
4813	+	Scale = 0
4814	+	Charset id = 0
4815	+	Nullable
4816	+	Size = 8
4817	+
4818	+	SQLType =SQL_INT64
4819	+	sub type = 0
4820	+	Field Name =
4821	+	Scale = -4
4822	+	Charset id = 0
4823	+	Nullable
4824	+	Size = 8
4825	+
4826	+	SQLType =SQL_DOUBLE
4827	+	sub type = 0
4828	+	Field Name =
4829	+	Scale = 0
4830	+	Charset id = 0
4831	+	Nullable
4832	+	Size = 8
4833	+
4834	+	SQLType =SQL_INT64
4835	+	sub type = 0
4836	+	Field Name =
4837	+	Scale = -6
4838	+	Charset id = 0
4839	+	Nullable
4840	+	Size = 8
4841	+
4842	+
4843	+	Text Tests
4844	+	SQL Params
4845	+	SQLType =SQL_LONG
4846	+	sub type = 0
4847	+	Field Name =
4848	+	Scale = 0
4849	+	Charset id = 0
4850	+	Not Null
4851	+	Size = 4
4852	+	Value = 0
4853	+
4854	+	SQLType =SQL_VARYING
4855	+	sub type = 0
4856	+	Field Name =
4857	+	Scale = 0
4858	+	Charset id = 4
4859	+	Nullable
4860	+	Size = 1024
4861	+
4862	+	SQLType =SQL_BLOB
4863	+	sub type = 1
4864	+	Field Name =
4865	+	Scale = 0
4866	+	Charset id = 4
4867	+	Nullable
4868	+	Size = 8
4869	+
4870	+
4871	+	Binary Blob Tests
4872	+
4873	+	Array Test
4874	+	SQL Params
4875	+	SQLType =SQL_LONG
4876	+	sub type = 0
4877	+	Field Name =
4878	+	Scale = 0
4879	+	Charset id = 0
4880	+	Not Null
4881	+	Size = 4
4882	+	Value = 0
4883	+
4884	+	SQLType =SQL_ARRAY
4885	+	sub type = 0
4886	+	Field Name =
4887	+	Scale = 0
4888	+	Charset id = 0
4889	+	Nullable
4890	+	Size = 8
4891	+
4892	+	ROWID = 1
4893	+	ITYPE = 101
4894	+	I64TYPE = 9223372036854775807
4895	+	CURRTYPE = 10,000.12340000
4896	+	DTYPE = 9,999.12345678
4897	+	FIXEDPOINT = 1,234,567,890.12345700
4898	+	STR = NULL
4899	+	TEXTBLOB = NULL
4900	+	OTHERBLOB = NULL
4901	+	MYARRAY = NULL
4902	+	ROWID = 2
4903	+	ITYPE = -32457
4904	+	I64TYPE = -9223372036854775808
4905	+	CURRTYPE = 1,000,001.12000000
4906	+	DTYPE = 1.7E308
4907	+	FIXEDPOINT = -1,234,567,890.12345700
4908	+	STR = NULL
4909	+	TEXTBLOB = NULL
4910	+	OTHERBLOB = NULL
4911	+	MYARRAY = NULL
4912	+	ROWID = 4
4913	+	ITYPE = 1
4914	+	I64TYPE = 10
4915	+	CURRTYPE = .02300000
4916	+	DTYPE = .00110000
4917	+	FIXEDPOINT = 233.45600000
4918	+	STR = NULL
4919	+	TEXTBLOB = NULL
4920	+	OTHERBLOB = NULL
4921	+	MYARRAY = NULL
4922	+
4923	+	Journal Table
4924	+	IBX$SESSIONID = 1
4925	+	IBX$TRANSACTIONID = 9
4926	+	IBX$OLDTRANSACTIONID = NULL
4927	+	IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
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 = 2022/01/02 14:16:56.9850
4934	+
4935	+	Journal Entries
4936	+	Journal Entry = jeTransStart(Transaction Start)
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"
4942	+	TPB: Item Count = 3
4943	+	isc_tpb_write
4944	+	isc_tpb_nowait
4945	+	isc_tpb_concurrency
4946	+
4947	+	Default Completion = TACommit
4948	+
4949	+	Journal Entry = jeQuery(Query)
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 = 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 = 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 = 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 = 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 = 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 = 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"
4997	+	TPB: Item Count = 3
4998	+	isc_tpb_write
4999	+	isc_tpb_nowait
5000	+	isc_tpb_concurrency
5001	+
5002	+	Default Completion = TARollback
5003	+
5004	+	Journal Entry = jeTransCommit(Commit)
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 = 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:
5016	+	Whether ''tis nobler in the mind to suffer
5017	+	The slings and arrows of outrageous fortune,
5018	+	Or to take arms against a sea of troubles,
5019	+	And, by opposing, end them. To die, to sleep-
5020	+	No more-and by a sleep to say we end
5021	+	The heartache and the thousand natural shocks
5022	+	That flesh is heir to-''tis a consummation
5023	+	Devoutly to be wished. To die, to sleep-
5024	+	To sleep, perchance to dream. Aye, there''s the rub,
5025	+	For in that sleep of death what dreams may come,
5026	+	When we have shuffled off this mortal coil,
5027	+	Must give us pause. There''s the respect
5028	+	That makes calamity of so long life.
5029	+	For who would bear the whips and scorns of time,
5030	+	Th'' oppressor''s wrong, the proud man''s contumely,
5031	+	The pangs of despised love, the law’s delay,
5032	+	The insolence of office, and the spurns
5033	+	That patient merit of the unworthy takes,
5034	+	When he himself might his quietus make
5035	+	With a bare bodkin? Who would fardels bear,
5036	+	To grunt and sweat under a weary life,
5037	+	But that the dread of something after death,
5038	+	The undiscovered country from whose bourn
5039	+	No traveler returns, puzzles the will
5040	+	And makes us rather bear those ills we have
5041	+	Than fly to others that we know not of?
5042	+	Thus conscience does make cowards of us all,
5043	+	And thus the native hue of resolution
5044	+	Is sicklied o''er with the pale cast of thought,
5045	+	And enterprises of great pitch and moment,
5046	+	With this regard their currents turn awry,
5047	+	And lose the name of action.-Soft you now,
5048	+	The fair Ophelia.-Nymph, in thy orisons
5049	+	Be all my sins remembered
5050	+	')
5051	+
5052	+	Journal Entry = jeQuery(Query)
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">
5058	+	FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
5059	+	0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
5060	+	01000000010000001A01050001000000DA000000
5061	+	</blob>
5062	+	)
5063	+
5064	+	Journal Entry = jeQuery(Query)
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">
5070	+	<elt ix="0">100</elt>
5071	+	<elt ix="1">99</elt>
5072	+	<elt ix="2">98</elt>
5073	+	<elt ix="3">97</elt>
5074	+	<elt ix="4">96</elt>
5075	+	<elt ix="5">95</elt>
5076	+	<elt ix="6">94</elt>
5077	+	<elt ix="7">93</elt>
5078	+	<elt ix="8">92</elt>
5079	+	<elt ix="9">91</elt>
5080	+	<elt ix="10">90</elt>
5081	+	<elt ix="11">89</elt>
5082	+	<elt ix="12">88</elt>
5083	+	<elt ix="13">87</elt>
5084	+	<elt ix="14">86</elt>
5085	+	<elt ix="15">85</elt>
5086	+	<elt ix="16">84</elt>
5087	+	</array>
5088	+	)
5089	+
5090	+	Journal Entry = jeTransRollback(Rollback)
5091	+	Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5092	+	Attachment ID = 4
5093	+	Session ID = 1
5094	+	Transaction ID = 12
5095	+
5096	+
5097	+
5098	+	------------------------------------------------------
5099		Test Suite Ends

Diff Legend

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