ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/testsuite/FB4reference.log
(Generate patch)

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

# Line 3 | Line 3 | Copyright MWA Software 2016-2021
3  
4   Starting Tests
5   Client API Version = 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/firebird/4.0.1
7 > Firebird Bin Directory = /opt/firebird/4.0.1/bin
8 > Firebird Conf Directory = /opt/firebird/4.0.1/
9 > Firebird Client Library Path = /opt/firebird/4.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
13 > I/O error during "open O_CREAT" operation for file ""
14   -Error while trying to create file
15   -No such file or directory
16   Creating a Database using an SQL Statement
# Line 22 | Line 23 | DB Remote Protocol = TCPv4
23   DB ODS Major Version = 13
24   DB ODS Minor Version = 0
25   User Authentication Method = Srp256
26 < Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
26 > Firebird Library Path = /opt/firebird/4.0.1/lib/libfbclient.so
27   DB Client Implementation Version = 4.0
28   DPB: Item Count = 3
29    isc_dpb_user_name = SYSDBA
# Line 30 | Line 31 | DPB: Item Count = 3
31    isc_dpb_set_db_sql_dialect = 3
32  
33   Firebird Server Version Info
34 < Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
35 < Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C"
36 < Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:C"
34 > Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
35 > Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:C"
36 > Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:C"
37   on disk structure version 13.0
38  
39   Dropping Database
# Line 44 | Line 45 | DB Remote Protocol = TCPv4
45   DB ODS Major Version = 13
46   DB ODS Minor Version = 0
47   User Authentication Method = Srp256
48 < Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
48 > Firebird Library Path = /opt/firebird/4.0.1/lib/libfbclient.so
49   DB Client Implementation Version = 4.0
50   Dropping Database
51   DPB: Item Count = 4
# Line 57 | Line 58 | Creating a Database with a DPD
58   Database ID = 4 FB = /tmp/fbintf-testsuite/testsuite1.fdb SN = zeus
59   ODS major = 13
60   ODS minor = 0
61 + Attachment ID = 4
62   DB Connect String = inet://localhost//tmp/fbintf-testsuite/testsuite1.fdb
63   DB Charset ID = 4
64   DB SQL Dialect = 3
# Line 64 | Line 66 | DB Remote Protocol = TCPv4
66   DB ODS Major Version = 13
67   DB ODS Minor Version = 0
68   User Authentication Method = Srp256
69 < Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
69 > Firebird Library Path = /opt/firebird/4.0.1/lib/libfbclient.so
70   DB Client Implementation Version = 4.0
71   RDB$DESCRIPTION =
72   RDB$RELATION_ID = 128
# Line 77 | Line 79 | Dropping Database
79  
80   ------------------------------------------------------
81   Running Test 2: Open the employee database and run a query
82 < Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login
82 > Open Database fails Engine Code: 335544472
83 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
84   Opening inet://localhost/employee
85   Database Open, SQL Dialect = 3
86   TPB: Item Count = 3
# Line 307 | Line 310 | JOB_COUNTRY = USA
310   SALARY = 64,635.00
311   FULL_NAME = Johnson, Leslie
312  
313 + Scollable Cursors
314 + DB Connect String = inet://localhost/employee
315 + DB Charset ID = 4
316 + DB SQL Dialect = 3
317 + DB Remote Protocol = TCPv4
318 + DB ODS Major Version = 13
319 + DB ODS Minor Version = 0
320 + User Authentication Method = Srp256
321 + Firebird Library Path = /opt/firebird/4.0.1/lib/libfbclient.so
322 + DB Client Implementation Version = 4.0
323 + Do Fetch Next:
324 + EMP_NO = 2
325 + FIRST_NAME = Robert
326 + LAST_NAME = Nelson
327 + PHONE_EXT = 250
328 + HIRE_DATE = 1988/12/28 00:00:00.0000
329 + DEPT_NO = 600
330 + JOB_CODE = VP
331 + JOB_GRADE = 2
332 + JOB_COUNTRY = USA
333 + SALARY = 105,900.00
334 + FULL_NAME = Nelson, Robert
335 + Do Fetch Last:
336 + Remote Scrollable cursors test fails Engine Code: 335544378
337 + feature is not supported
338   Now open the employee database as a local database
339   TPB: Item Count = 3
340    isc_tpb_read
# Line 543 | Line 571 | DB Remote Protocol =
571   DB ODS Major Version = 13
572   DB ODS Minor Version = 0
573   User Authentication Method = User name in DPB
574 < Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so
574 > Firebird Library Path = /opt/firebird/4.0.1/lib/libfbclient.so
575   DB Client Implementation Version = 4.0
576   Do Fetch Next:
577   EMP_NO = 2
# Line 626 | Line 654 | Running Test 3: ad hoc queries
654   Opening inet://localhost/employee
655   Database Open
656   Employee Count = 42
657 + Transaction ID = 3369
658 + Transaction is Read/Write
659 + Transaction Database Path = inet://localhost/employee
660 + Transaction ID = 3369
661 + Oldest Interesting = 3367
662 + Oldest Action = 3368
663 + Oldest Snapshot = 3368
664 + Oldest Snapshot Number = 1
665 + Lock Timeout = 0
666 + Transaction Access = isc_info_tra_readwrite
667 + Isolation Type = isc_info_tra_concurrency
668   Employee Count = 41
669   Employee Count = 42
670   Employee Count = 41
# Line 639 | Line 678 | Constrained Employee Count = 3
678   Running Test 4: Update, Insert and Delete Queries
679   Opening inet://localhost/employee
680   Database Open
681 < Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
682 < Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
683 < Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
681 > Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
682 > Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
683 > Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
684   on disk structure version 13.0
685   Select Count = 1 InsertCount = 0 UpdateCount = 1 DeleteCount = 0
686   EMP_NO = 8
# Line 656 | Line 695 | JOB_COUNTRY = USA
695   SALARY = 64,635.00
696   FULL_NAME = Johnson, Leslie
697  
698 < Current memory = 19,764,272
698 > Current memory = 19,763,968
699   Delta memory = 4,464
700 < Max memory = 19,809,888
700 > Max memory = 19,809,296
701   Elapsed time= 0.002 sec
702   Cpu = 0.000 sec
703   Buffers = 2048
# Line 2697 | Line 2736 | MYARRAY = Array: (0: 100) (1: 99) (2: 98
2736  
2737   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)
2738  
2739 < 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)
2739 > 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)
2740  
2741  
2742   Shrink to 2:10
# Line 2713 | Line 2752 | MYARRAY = Array: (0: 100) (1: 99) (2: 10
2752  
2753   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)
2754  
2755 < 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)
2755 > 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)
2756  
2757  
2758  
# Line 2797 | Line 2836 | MYARRAY = Array: (0,-1: A50) (0,0: A51)
2836  
2837   ------------------------------------------------------
2838   Running Test 9: Database Information tests
2839 < Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus
2840 < Pages =1075
2839 > Database ID = 4 FB = /opt/firebird/4.0.1/examples/empbuild/employee.fdb SN = zeus
2840 > Pages =389
2841   Base Level = 13,4,0,3,
2842   Implementation = 11,7,0,3,66,1,66,
2843   Reserved = 0
2844   ODS minor = 0
2845   ODS major = 13
2846   Page Size = 8192
2847 < Version = 1: LI-V6.3.0.2496 Firebird 4.0
2847 > Version = 1: LI-V6.3.1.2692 Firebird 4.0
2848   Database is Read/Write
2849 < Database Created: 29/5/2021 16:47:30
2850 < Pages Used = 310
2851 < Pages Free = 765
2852 < Server Memory = 19482272
2849 > Database Created: 21/12/2021 10:52:59
2850 > Pages Used = 334
2851 > Pages Free = 55
2852 > Server Memory = 19477952
2853   Forced Writes  = 1
2854 < Max Memory  = 19628544
2854 > Max Memory  = 19508784
2855   Num Buffers  = 2048
2856   Sweep Interval  = 20000
2857   Logged in Users: SYSDBA,
2858   Active Transaction Count = 0
2859 < Fetches  = 1641
2860 < Writes  = 8
2861 < Reads  = 92
2862 < Page Writes  = 4
2859 > Fetches  = 1597
2860 > Writes  = 5
2861 > Reads  = 96
2862 > Page Writes  = 2
2863   Record Version Removals Operation Counts
2864  
2865   Deletes Operation Counts
# Line 2835 | Line 2874 | Indexed Reads Count Operation Counts
2874   Table ID = 4
2875   Count = 63
2876   Table ID = 6
2877 < Count = 23
2877 > Count = 13
2878   Table ID = 9
2879 < Count = 3
2879 > Count = 1
2880   Table ID = 11
2881   Count = 2
2882   Table ID = 12
2883   Count = 24
2884   Table ID = 18
2885 < Count = 811
2885 > Count = 854
2886   Table ID = 20
2887   Count = 5
2888   Table ID = 28
# Line 2855 | Line 2894 | Count = 1
2894  
2895   Sequential Table Scans Operation Counts
2896   Table ID = 0
2897 < Count = 98
2897 > Count = 100
2898   Table ID = 1
2899 < Count = 24
2899 > Count = 14
2900  
2901   Update Count Operation Counts
2902  
# Line 2876 | Line 2915 | Two more events
2915   Call Async Wait
2916   Async Wait Called
2917   Event Signalled
2879 – Event Signalled
2880 – Deferred Events Caught
2881 – Event Counts: TESTEVENT, Count = 2
2918   Signal Event
2919 < Event Counts: TESTEVENT, Count = 1
2919 > Event Counts: TESTEVENT, Count = 2
2920   Async Wait: Test Cancel
2921   Event Signalled
2922   Async Wait Called
# Line 2888 | Line 2924 | Event Cancelled
2924   Time Out - Cancel Worked!
2925   Sync wait
2926   Event Signalled
2927 < Event Counts: TESTEVENT, Count = 1
2927 > Event Counts: TESTEVENT, Count = 2
2928  
2929  
2930   ------------------------------------------------------
# Line 2898 | 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/firebird/4.0.1/
2942 > Security File = /opt/firebird/4.0.1/security4.fdb
2943  
2944   DB Attachments
2945   No. of Attachments = 0
# Line 2918 | Line 2954 | User ID = 0
2954   Group ID = 0
2955  
2956  
2957 < Licence Info: feature is not supported
2957 > Licence Info: Engine Code: 335544378
2958 > feature is not supported
2959   -feature is not supported
2960  
2961 < Licence Mask Info: feature is not supported
2961 > Licence Mask Info: Engine Code: 335544378
2962 > feature is not supported
2963  
2964   Capabilities = 6
2965  
# Line 2935 | Line 2973 | Local Backup
2973  
2974  
2975  
2976 +
2977   Local Backup Complete
2978  
2979   Local Restore
# Line 3208 | Line 3247 | Écoute moi
3247   ------------------------------------------------------
3248   Running Test 16: Error handling
3249   Invalid Database Name Test
3250 < Error Handled: I/O error during "open" operation for file "Malformed Name"
3250 > Error Handled: SQLCODE: -902
3251 > Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3252 > Engine Code: 335544344
3253 > I/O error during "open" operation for file "Malformed Name"
3254   -Error while trying to open file
3255   -No such file or directory
3256   Invalid User Name 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 > Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3259 > Engine Code: 335544472
3260 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3261   Invalid password Test
3262 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3262 > Error Handled: SQLCODE: -902
3263 > Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3264 > Engine Code: 335544472
3265 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3266   Invalid Prepare SQL Test
3267 < Error Handled: Dynamic SQL Error
3267 > Error Handled: SQLCODE: -206
3268 > Column does not belong to referenced table
3269 > Engine Code: 335544569
3270 > Dynamic SQL Error
3271   -SQL error code = -206
3272   -Column unknown
3273   -UNKNOWN_DATE
3274   -At line 1, column 21 When Executing: Update Employee Set Unknown_Date = ? Where EMP_NO = ?
3275   Invalid Open Cursor SQL Test
3276 < Error Handled: Dynamic SQL Error
3276 > Error Handled: SQLCODE: -206
3277 > Column does not belong to referenced table
3278 > Engine Code: 335544569
3279 > Dynamic SQL Error
3280   -SQL error code = -206
3281   -Column unknown
3282   -X
# Line 3249 | Line 3303 | New Transaction before Open Cursor
3303   COUNTER = 42
3304  
3305   Invalid Server Name Test
3306 < Error Handled: Unable to complete network request to host "unknown".
3306 > Error Handled: SQLCODE: -902
3307 > Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3308 > Engine Code: 335544721
3309 > Unable to complete network request to host "unknown".
3310   -Failed to locate host machine.
3311   -The specified name was not found in the hosts file or Domain Name Services
3312   Invalid User Name Test
3313 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3313 > Error Handled: SQLCODE: -902
3314 > Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3315 > Engine Code: 335544472
3316 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3317   Invalid password Test
3318 < Error Handled: Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3318 > Error Handled: SQLCODE: -902
3319 > Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
3320 > Engine Code: 335544472
3321 > Your user name and password are not defined. Ask your database administrator to set up a Firebird login
3322  
3323  
3324   ------------------------------------------------------
3325   Running Test 17: Date/Time tests and Firebird 4 extensions
3326 < FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
3326 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
3327   Has Local TZ DB = TRUE
3328  
3329   Testdata
# Line 4022 | Line 4085 | TZ_MINUTE = 0
4085  
4086   ------------------------------------------------------
4087   Running Test 18: Firebird 4 Decfloat extensions
4088 < FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4088 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4089  
4090   FB4 Testdata_DECFloat
4091  
# Line 4291 | Line 4354 | BigNumber Array: (0: 123456123400.123456
4354   Running Test 19: Batch Update and Insert Queries
4355   Opening inet://localhost/employee
4356   Database Open
4357 < Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4358 < Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4359 < Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4357 > Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4358 > Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
4359 > Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2692 Firebird 4.0/tcp (zeus)/P17:CZ"
4360   on disk structure version 13.0
4361   Rows before update
4362   EMP_NO = 2
# Line 4524 | Line 4587 | LANGUAGE_REQ = Array: (1: Eng) (2: Fra)
4587  
4588  
4589   Test Error Handling
4590 < Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING
4590 > Error reported (as expected) when changing param type: Param[0] "": Unable to change from a SQL_TIMESTAMP to a string type
4591   Test Error Handling - Update returning should fail
4592   Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched
4593   Error handling when Insert rows - duplicate key
4594 < 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"
4594 > Error reported when inserting: SQLCODE: -803
4595 > Invalid insert or update value(s): object columns are constrained - no 2 table rows can have duplicate column values
4596 > Engine Code: 335544665
4597 > violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4598   -Problematic key value is ("EMP_NO" = 150)
4599   Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
4600   Batch Completion Info
# Line 4541 | Line 4607 | Row 2 State = bcExecuteFailed Msg = viol
4607  
4608   ------------------------------------------------------
4609   Running Test 20: Stress Test IBatch interface
4610 < FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4610 > FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2692 Firebird 4.0"
4611   10000 rows added
4612   20000 rows added
4613   30000 rows added
# Line 4595 | Line 4661 | Parsing of 1.2E1.2 failed
4661   Parsing of 1,000 failed
4662   Parsing of 1e1e1 failed
4663   Parsing of 1.2+3 failed
4664 + Validating Numeric Interface - IFBNumeric
4665 + Value from Currency = 9999.1235
4666 + Raw Value = 99991235 Scale = -4
4667 + Value from Currency(rescaled) = 9999.12
4668 + Raw Value = 999912 Scale = -2
4669 + Value from Double = 9999.12345678
4670 + Raw Value = 999912345678 Scale = -8
4671 + Value from Integer = 9223372036854775807
4672 + Raw Value = 9223372036854775807 Scale = 0
4673 + Value from string = 9223372036854775807
4674 + Raw Value = 9223372036854775807 Scale = 0
4675 + Value from string = 9999.12345678
4676 + Raw Value = 999912345678 Scale = -8
4677 + Value from string = -0.12
4678 + Raw Value = -12 Scale = -3
4679 + Value from BCD = 9999.12345678
4680 + Raw Value = 999912345678 Scale = -8
4681 + Value from Raw Data = 9999123.456780
4682 + Raw Value = 9999123456780 Scale = -6
4683 + Numeric Operations
4684 + Add 2.23 + 24.12345 = 26.35345
4685 + Add Double 2.23 + 24.12645 = 26.35645
4686 + Add integer 2.23 + 2412345 = 2412347.23
4687 + Subtract 2.23 - 24.12345 = -21.89345
4688 + Subtract Double 24.12645 - 2.23 = -21.89645
4689 + Subtract integer 24123.45 - 223 = -23900.45
4690 + Multiply 2.23 * 24.12345 = 53.7952935
4691 + Multiply Double 24.12645 * 2.23 = 53.8019835
4692 + Multiply integer 241.2345 * 223 = 53795.2935
4693 + Divide 24.12345 / 2.23 = 10.81769
4694 + Divide Double 2.23 / 24.12645 = 0.09
4695 + Divide integer 241.2345 / 223 = 1.0818
4696 + Compare 2.23, -24.12345 = 1
4697 + Compare integer 2.23, 3 = -1
4698 + Compare Double 2.23, 2.23 = 0
4699 + Negate 24.12345 = -24.12345
4700   SQL Params
4701   SQLType =SQL_LONG
4702   sub type = 0
# Line 4646 | Line 4748 | Nullable
4748   Size = 8
4749  
4750   Expected Error - SQLCODE: -303
4751 < Engine Code: 335544569 Incompatible column/host variable data type
4751 > Incompatible column/host variable data type
4752 > Engine Code: 335544569
4753   Dynamic SQL Error
4754   -SQL error code = -303
4755   -conversion error from string "1,000"
4756   Expected Error - SQLCODE: -303
4757 < Engine Code: 335544569 Incompatible column/host variable data type
4757 > Incompatible column/host variable data type
4758 > Engine Code: 335544569
4759   Dynamic SQL Error
4760   -SQL error code = -303
4761   -conversion error from string "10.0.0"
4762 + Test Numeric Type
4763   ROWID = 1
4764   ITYPE = 101
4765   I64TYPE = 9223372036854775807
# Line 4679 | Line 4784 | I64TYPE = 10
4784   CURRTYPE = .02300000
4785   DTYPE = .00110000
4786   FIXEDPOINT = 233.45600000
4787 + ROWID = 7
4788 + ITYPE = 1
4789 + I64TYPE = 1234567
4790 + CURRTYPE = .02300000
4791 + DTYPE = .00110000
4792 + FIXEDPOINT = 1,234.25000000
4793 +
4794 +
4795 +
4796 + ------------------------------------------------------
4797 + Running Test 22: Journalling
4798 + Start Journaling. Session ID = 0
4799 + 1234.567 parsed to 1234567 scale = -3
4800 + As Float =  1.2345670000000000E+003
4801 + -765.4321 parsed to -7654321 scale = -4
4802 + As Float = -7.6543209999999999E+002
4803 + 0.1 parsed to 1 scale = -1
4804 + As Float =  1.0000000000000001E-001
4805 + 0.01 parsed to 1 scale = -2
4806 + As Float =  1.0000000000000000E-002
4807 + +123 parsed to 123 scale = 0
4808 + As Float =  1.2300000000000000E+002
4809 + 1.23456E308 parsed to 123456 scale = 303
4810 + As Float =  1.2345600000000001E+308
4811 + -1.2e-02 parsed to -12 scale = -3
4812 + As Float = -1.2000000000000000E-002
4813 + 10. parsed to 10 scale = 0
4814 + As Float =  1.0000000000000000E+001
4815 + .12 parsed to 12 scale = -2
4816 + As Float =  1.2000000000000000E-001
4817 + 0.12 parsed to 12 scale = -2
4818 + As Float =  1.2000000000000000E-001
4819 + Parsing of 1.2E1.2 failed
4820 + Parsing of 1,000 failed
4821 + Parsing of 1e1e1 failed
4822 + Parsing of 1.2+3 failed
4823 + SQL Params
4824 + SQLType =SQL_LONG
4825 + sub type = 0
4826 + Field Name =
4827 + Scale = 0
4828 + Charset id = 0
4829 + Not Null
4830 + Size = 4
4831 + Value = 0
4832 +
4833 + SQLType =SQL_LONG
4834 + sub type = 0
4835 + Field Name =
4836 + Scale = 0
4837 + Charset id = 0
4838 + Nullable
4839 + Size = 4
4840 +
4841 + SQLType =SQL_INT64
4842 + sub type = 0
4843 + Field Name =
4844 + Scale = 0
4845 + Charset id = 0
4846 + Nullable
4847 + Size = 8
4848 +
4849 + SQLType =SQL_INT64
4850 + sub type = 0
4851 + Field Name =
4852 + Scale = -4
4853 + Charset id = 0
4854 + Nullable
4855 + Size = 8
4856 +
4857 + SQLType =SQL_DOUBLE
4858 + sub type = 0
4859 + Field Name =
4860 + Scale = 0
4861 + Charset id = 0
4862 + Nullable
4863 + Size = 8
4864 +
4865 + SQLType =SQL_INT64
4866 + sub type = 0
4867 + Field Name =
4868 + Scale = -6
4869 + Charset id = 0
4870 + Nullable
4871 + Size = 8
4872 +
4873 +
4874 + Text Tests
4875 + SQL Params
4876 + SQLType =SQL_LONG
4877 + sub type = 0
4878 + Field Name =
4879 + Scale = 0
4880 + Charset id = 0
4881 + Not Null
4882 + Size = 4
4883 + Value = 0
4884 +
4885 + SQLType =SQL_VARYING
4886 + sub type = 0
4887 + Field Name =
4888 + Scale = 0
4889 + Charset id = 4
4890 + Nullable
4891 + Size = 1024
4892 +
4893 + SQLType =SQL_BLOB
4894 + sub type = 1
4895 + Field Name =
4896 + Scale = 0
4897 + Charset id = 4
4898 + Nullable
4899 + Size = 8
4900 +
4901 +
4902 + Binary Blob Tests
4903 +
4904 + Array Test
4905 + SQL Params
4906 + SQLType =SQL_LONG
4907 + sub type = 0
4908 + Field Name =
4909 + Scale = 0
4910 + Charset id = 0
4911 + Not Null
4912 + Size = 4
4913 + Value = 0
4914 +
4915 + SQLType =SQL_ARRAY
4916 + sub type = 0
4917 + Field Name = MYARRAY
4918 + Scale = 0
4919 + Charset id = 0
4920 + Nullable
4921 + Size = 8
4922 +
4923 + ROWID = 1
4924 + ITYPE = 101
4925 + I64TYPE = 9223372036854775807
4926 + CURRTYPE = 10,000.12340000
4927 + DTYPE = 9,999.12345678
4928 + FIXEDPOINT = 1,234,567,890.12345700
4929 + STR = NULL
4930 + TEXTBLOB = NULL
4931 + OTHERBLOB = NULL
4932 + MYARRAY = NULL
4933 + ROWID = 2
4934 + ITYPE = -32457
4935 + I64TYPE = -9223372036854775808
4936 + CURRTYPE = 1,000,001.12000000
4937 + DTYPE = 1.7E308
4938 + FIXEDPOINT = -1,234,567,890.12345700
4939 + STR = NULL
4940 + TEXTBLOB = NULL
4941 + OTHERBLOB = NULL
4942 + MYARRAY = NULL
4943 + ROWID = 4
4944 + ITYPE = 1
4945 + I64TYPE = 10
4946 + CURRTYPE = .02300000
4947 + DTYPE = .00110000
4948 + FIXEDPOINT = 233.45600000
4949 + STR = NULL
4950 + TEXTBLOB = NULL
4951 + OTHERBLOB = NULL
4952 + MYARRAY = NULL
4953 +
4954 + Journal Table
4955 + IBX$SESSIONID = 1
4956 + IBX$TRANSACTIONID = 9
4957 + IBX$OLDTRANSACTIONID = NULL
4958 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4959 + IBX$CREATED = 2022/07/18 14:38:49.8050
4960 + IBX$SESSIONID = 1
4961 + IBX$TRANSACTIONID = 11
4962 + IBX$OLDTRANSACTIONID = 10
4963 + IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001)
4964 + IBX$CREATED = 2022/07/18 14:38:49.8830
4965 +
4966 + Journal Entries
4967 + Journal Entry = jeTransStart(Transaction Start)
4968 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4969 + Attachment ID = 4
4970 + Session ID = 1
4971 + Transaction ID = 9
4972 + Transaction Name = "Transaction_29_1"
4973 + TPB: Item Count = 3
4974 +  isc_tpb_write
4975 +  isc_tpb_nowait
4976 +  isc_tpb_concurrency
4977 +
4978 + Default Completion = TACommit
4979 +
4980 + Journal Entry = jeQuery(Query)
4981 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
4982 + Attachment ID = 4
4983 + Session ID = 1
4984 + Transaction ID = 9
4985 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(1,101,9223372036854775807,10000.1234,9999.12345678,1234567890.12346)
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(2,-32457,-9223372036854775808,1000001.12,1.7E308,-1234567890.12346)
4993 +
4994 + Journal Entry = jeTransCommitRet(Commit 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(3,0,0,0,0,0)
5007 +
5008 + Journal Entry = jeTransRollbackRet(Rollback Retaining)
5009 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5010 + Attachment ID = 4
5011 + Session ID = 1
5012 + Transaction ID = 11
5013 + Old TransactionID = 10
5014 +
5015 + Journal Entry = jeQuery(Query)
5016 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5017 + Attachment ID = 4
5018 + Session ID = 1
5019 + Transaction ID = 11
5020 + Query = Insert into TestData(RowID,iType,i64Type,CurrType,dType,FixedPoint) Values(4,1,10,0.023,0.0011,233.456)
5021 +
5022 + Journal Entry = jeTransStart(Transaction Start)
5023 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5024 + Attachment ID = 4
5025 + Session ID = 1
5026 + Transaction ID = 12
5027 + Transaction Name = "Transaction_29_2"
5028 + TPB: Item Count = 3
5029 +  isc_tpb_write
5030 +  isc_tpb_nowait
5031 +  isc_tpb_concurrency
5032 +
5033 + Default Completion = TARollback
5034 +
5035 + Journal Entry = jeTransCommit(Commit)
5036 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5037 + Attachment ID = 4
5038 + Session ID = 1
5039 + Transaction ID = 11
5040 +
5041 + Journal Entry = jeQuery(Query)
5042 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5043 + Attachment ID = 4
5044 + Session ID = 1
5045 + Transaction ID = 12
5046 + 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:
5047 + Whether ''tis nobler in the mind to suffer
5048 + The slings and arrows of outrageous fortune,
5049 + Or to take arms against a sea of troubles,
5050 + And, by opposing, end them. To die, to sleep-
5051 + No more-and by a sleep to say we end
5052 + The heartache and the thousand natural shocks
5053 + That flesh is heir to-''tis a consummation
5054 + Devoutly to be wished. To die, to sleep-
5055 + To sleep, perchance to dream. Aye, there''s the rub,
5056 + For in that sleep of death what dreams may come,
5057 + When we have shuffled off this mortal coil,
5058 + Must give us pause. There''s the respect
5059 + That makes calamity of so long life.
5060 + For who would bear the whips and scorns of time,
5061 + Th'' oppressor''s wrong, the proud man''s contumely,
5062 + The pangs of despised love, the law’s delay,
5063 + The insolence of office, and the spurns
5064 + That patient merit of the unworthy takes,
5065 + When he himself might his quietus make
5066 + With a bare bodkin? Who would fardels bear,
5067 + To grunt and sweat under a weary life,
5068 + But that the dread of something after death,
5069 + The undiscovered country from whose bourn
5070 + No traveler returns, puzzles the will
5071 + And makes us rather bear those ills we have
5072 + Than fly to others that we know not of?
5073 + Thus conscience does make cowards of us all,
5074 + And thus the native hue of resolution
5075 + Is sicklied o''er with the pale cast of thought,
5076 + And enterprises of great pitch and moment,
5077 + With this regard their currents turn awry,
5078 + And lose the name of action.-Soft you now,
5079 + The fair Ophelia.-Nymph, in thy orisons
5080 + Be all my sins remembered
5081 + ')
5082 +
5083 + Journal Entry = jeQuery(Query)
5084 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5085 + Attachment ID = 4
5086 + Session ID = 1
5087 + Transaction ID = 12
5088 + Query = Insert into TestData(RowID,OtherBlob) Values (6,<blob subtype="0">
5089 + FFD8FFE000104A46494600010101004800480000FFE11E0545786966000049492A00080000000C00
5090 + 0E010200200000009E0000000F01020014000000BE0000001001020008000000D200000012010300
5091 + 01000000010000001A01050001000000DA000000
5092 + </blob>
5093 + )
5094 +
5095 + Journal Entry = jeQuery(Query)
5096 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5097 + Attachment ID = 4
5098 + Session ID = 1
5099 + Transaction ID = 12
5100 + 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">
5101 + <elt ix="0">100</elt>
5102 + <elt ix="1">99</elt>
5103 + <elt ix="2">98</elt>
5104 + <elt ix="3">97</elt>
5105 + <elt ix="4">96</elt>
5106 + <elt ix="5">95</elt>
5107 + <elt ix="6">94</elt>
5108 + <elt ix="7">93</elt>
5109 + <elt ix="8">92</elt>
5110 + <elt ix="9">91</elt>
5111 + <elt ix="10">90</elt>
5112 + <elt ix="11">89</elt>
5113 + <elt ix="12">88</elt>
5114 + <elt ix="13">87</elt>
5115 + <elt ix="14">86</elt>
5116 + <elt ix="15">85</elt>
5117 + <elt ix="16">84</elt>
5118 + </array>
5119 + )
5120 +
5121 + Journal Entry = jeTransRollback(Rollback)
5122 + Timestamp = yyyy/mm/dd hh:mm:ss.zzzz
5123 + Attachment ID = 4
5124 + Session ID = 1
5125 + Transaction ID = 12
5126  
5127  
5128  

Diff Legend

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