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

Comparing ibx/trunk/fbintf/testsuite/FB4reference.log (file contents):
Revision 338 by tony, Wed Jun 9 12:07:56 2021 UTC vs.
Revision 345 by tony, Mon Aug 23 14:22:29 2021 UTC

# Line 267 | Line 267 | Scale = 0
267   Charset id = 0
268   Not Null
269   Size = 2
270 + Value = 0
271  
272   EMP_NO = 8
273   FIRST_NAME = Leslie
# Line 290 | Line 291 | Scale = 0
291   Charset id = 0
292   Not Null
293   Size = 2
294 + Value = 0
295  
296   EMP_NO = 8
297   FIRST_NAME = Leslie
# Line 492 | Line 494 | Scale = 0
494   Charset id = 0
495   Not Null
496   Size = 2
497 + Value = 0
498  
499   EMP_NO = 8
500   FIRST_NAME = Leslie
# Line 515 | Line 518 | Scale = 0
518   Charset id = 0
519   Not Null
520   Size = 2
521 + Value = 0
522  
523   EMP_NO = 8
524   FIRST_NAME = Leslie
# Line 565 | Line 569 | JOB_COUNTRY = USA
569   SALARY = 64,635.00
570   FULL_NAME = Johnson, Leslie
571  
572 < Current memory = 19,763,536
572 > Current memory = 19,767,232
573   Delta memory = 4,464
574 < Max memory = 19,809,408
575 < Elapsed time= 0.002 sec
574 > Max memory = 19,813,104
575 > Elapsed time= 0.001 sec
576   Cpu = 0.000 sec
577   Buffers = 2048
578   Reads = 0
# Line 1067 | Line 1071 | Scale = 0
1071   Charset id = 0
1072   Not Null
1073   Size = 4
1074 + Value = 0
1075  
1076   SQLType =SQL_VARYING
1077   sub type = 0
# Line 1114 | Line 1119 | Scale = 0
1119   Charset id = 0
1120   Not Null
1121   Size = 4
1122 + Value = 0
1123  
1124   ROWID = 1
1125   FIXEDPOINT = 20.28
# Line 1166 | Line 1172 | Scale = 0
1172   Charset id = 0
1173   Not Null
1174   Size = 4
1175 + Value = 0
1176  
1177   SQLType =SQL_VARYING
1178   sub type = 0
# Line 1543 | Line 1550 | Scale = 0
1550   Charset id = 0
1551   Not Null
1552   Size = 4
1553 + Value = 0
1554  
1555   SQLType =SQL_VARYING
1556   sub type = 0
# Line 1590 | Line 1598 | Scale = 0
1598   Charset id = 0
1599   Not Null
1600   Size = 4
1601 + Value = 0
1602  
1603   ROWID = 1
1604   FIXEDPOINT = 20.28
# Line 1642 | Line 1651 | Scale = 0
1651   Charset id = 0
1652   Not Null
1653   Size = 4
1654 + Value = 0
1655  
1656   SQLType =SQL_VARYING
1657   sub type = 0
# Line 2019 | Line 2029 | Scale = 0
2029   Charset id = 0
2030   Not Null
2031   Size = 4
2032 + Value = 0
2033  
2034   SQLType =SQL_VARYING
2035   sub type = 0
# Line 2066 | Line 2077 | Scale = 0
2077   Charset id = 0
2078   Not Null
2079   Size = 4
2080 + Value = 0
2081  
2082   ROWID = 1
2083   FIXEDPOINT = 20.28
# Line 2118 | Line 2130 | Scale = 0
2130   Charset id = 0
2131   Not Null
2132   Size = 4
2133 + Value = 0
2134  
2135   SQLType =SQL_VARYING
2136   sub type = 0
# Line 2412 | Line 2425 | Scale = 0
2425   Charset id = 0
2426   Not Null
2427   Size = 4
2428 + Value = 0
2429  
2430   SQLType =SQL_VARYING
2431   sub type = 0
# Line 2673 | Line 2687 | Scale = 0
2687   Charset id = 0
2688   Not Null
2689   Size = 4
2690 + Value = 0
2691  
2692   SQLType =SQL_VARYING
2693   sub type = 0
# Line 2696 | Line 2711 | MYARRAY = Array: (0,-1: A50) (0,0: A51)
2711   ------------------------------------------------------
2712   Running Test 9: Database Information tests
2713   Database ID = 4 FB = /opt/firebird4.0.0/examples/empbuild/employee.fdb SN = zeus
2714 < Pages =346
2714 > Pages =1075
2715   Base Level = 13,4,0,3,
2716   Implementation = 11,7,0,3,66,1,66,
2717   Reserved = 0
# Line 2706 | Line 2721 | Page Size = 8192
2721   Version = 1: LI-V6.3.0.2496 Firebird 4.0
2722   Database is Read/Write
2723   Database Created: 29/5/2021 16:47:30
2724 < Pages Used = 310
2725 < Pages Free = 36
2726 < Server Memory = 19481792
2724 > Pages Used = 313
2725 > Pages Free = 762
2726 > Server Memory = 19483648
2727   Forced Writes  = 1
2728 < Max Memory  = 19627808
2728 > Max Memory  = 19629664
2729   Num Buffers  = 2048
2730   Sweep Interval  = 20000
2731   Logged in Users: SYSDBA,
2732   Active Transaction Count = 0
2733 < Fetches  = 1634
2733 > Fetches  = 1648
2734   Writes  = 8
2735 < Reads  = 91
2735 > Reads  = 92
2736   Page Writes  = 4
2737   Record Version Removals Operation Counts
2738  
# Line 2741 | Line 2756 | Count = 2
2756   Table ID = 12
2757   Count = 24
2758   Table ID = 18
2759 < Count = 805
2759 > Count = 816
2760   Table ID = 20
2761   Count = 5
2762   Table ID = 28
# Line 2753 | Line 2768 | Count = 1
2768  
2769   Sequential Table Scans Operation Counts
2770   Table ID = 0
2771 < Count = 98
2771 > Count = 100
2772   Table ID = 1
2773   Count = 24
2774  
# Line 2859 | Line 2874 | Scale = 0
2874   Charset id = 0
2875   Not Null
2876   Size = 4
2877 + Value = 0
2878  
2879   SQLType =SQL_VARYING
2880   sub type = 0
# Line 2908 | Line 2924 | Charset id = 4
2924   Nullable
2925   Size = 16
2926  
2927 + Show Param Values
2928 + SQL Params
2929 + SQLType =SQL_LONG
2930 + sub type = 0
2931 + Field Name = ROWID
2932 + Scale = 0
2933 + Charset id = 0
2934 + Not Null
2935 + Size = 4
2936 + Value = 1
2937 +
2938 + SQLType =SQL_VARYING
2939 + sub type = 0
2940 + Field Name = TITLE
2941 + Scale = 0
2942 + Charset id = 4
2943 + Nullable
2944 + Size = 128
2945 + Value = Blob Test ©€
2946 +
2947 + SQLType =SQL_VARYING
2948 + sub type = 0
2949 + Field Name = NOTES
2950 + Scale = 0
2951 + Charset id = 4
2952 + Nullable
2953 + Size = 256
2954 + Value = Écoute moi
2955 +
2956 + SQLType =SQL_VARYING
2957 + sub type = 1
2958 + Field Name = BLOBDATA
2959 + Scale = 0
2960 + Charset id = 4
2961 + Nullable
2962 + Size = 8192
2963 + Value = Some German Special Characters like ÖÄÜöäüß
2964 +
2965 + SQLType =SQL_BLOB
2966 + sub type = 1
2967 + Field Name = BLOBDATA2
2968 + Scale = 0
2969 + Charset id = 4
2970 + Nullable
2971 + Size = 8
2972 + Value = Some German Special Characters like ÖÄÜöäüß
2973 +
2974 + SQLType =SQL_VARYING
2975 + sub type = 0
2976 + Field Name = INCLEAR
2977 + Scale = 0
2978 + Charset id = 1
2979 + Nullable
2980 + Size = 16
2981 + Value = &Test
2982  
2983 +
2984 + SQLType =SQL_VARYING
2985 + sub type = 0
2986 + Field Name = FIXEDWIDTH
2987 + Scale = 0
2988 + Charset id = 4
2989 + Nullable
2990 + Size = 16
2991 + Value = É
2992 +
2993   Connection Character Set UTF8
2994   ROWID = 1
2995   TITLE = 42 6C 6F 62 20 54 65 73 74 20 C2 A9 E2 82 AC  (Charset Id = 4 Codepage = 65001)
# Line 3022 | Line 3103 | ROWID = 1
3103   TITLE = Blob Test (Charset Id = 4 Codepage = 65001)
3104   BLOBDATA = (blob), Length = 92514
3105  
3106 + ROWID = 2
3107 + TITLE = Blob Test with binary string (Charset Id = 4 Codepage = 65001)
3108 + BLOBDATA = (blob), Length = 13
3109 + 0 9 A C9 63 6F 75 74 65 20 6D 6F 69
3110  
3111   Testdata 2
3112  
# Line 3937 | Line 4022 | BigInteger = 123456789123456789
4022    Special = 0
4023    Places = 0
4024    Digits = 12 34 56 78 91 23 45 67 89
4025 +
4026   RowID = 2
4027   Float16 = -64000000000.01
4028    Precision = 13
# Line 3957 | Line 4043 | BigNumber = -123456123456.123456
4043    Places = 6
4044    Digits = 12 34 56 12 34 56 12 34 56
4045   BigInteger = Null
4046 +
4047   RowID = 3
4048   Float16 = 64100000000.011
4049    Precision = 14
# Line 3983 | Line 4070 | BiggerNumber = 1112345612345612345612345
4070    Places = 4
4071    Digits = 11 12 34 56 12 34 56 12 34 56 12 34 56 12 34 56 12 35
4072   BigInteger = Null
4073 +
4074   RowID = 4
4075   Float16 = 0
4076    Precision = 0
# Line 4009 | Line 4097 | BiggerNumber = 0.0000
4097    Places = 0
4098    Digits =
4099   BigInteger = Null
4100 +
4101   Metadata
4102   SQLType =SQL_LONG
4103   sub type = 0
# Line 4097 | Line 4186 | BigNumber Array: (0: 123456123400.123456
4186  
4187  
4188   ------------------------------------------------------
4189 + Running Test 19: Batch Update and Insert Queries
4190 + Opening inet://localhost/employee
4191 + Database Open
4192 + Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4193 + Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4194 + Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2496 Firebird 4.0/tcp (zeus)/P16:CZ"
4195 + on disk structure version 13.0
4196 + Rows before update
4197 + EMP_NO = 2
4198 + FIRST_NAME = Robert
4199 + LAST_NAME = Nelson
4200 + PHONE_EXT = 250
4201 + HIRE_DATE = 1988/12/28 00:00:00.0000
4202 + DEPT_NO = 600
4203 + JOB_CODE = VP
4204 + JOB_GRADE = 2
4205 + JOB_COUNTRY = USA
4206 + SALARY = 105,900.00
4207 + FULL_NAME = Nelson, Robert
4208 + EMP_NO = 8
4209 + FIRST_NAME = Leslie
4210 + LAST_NAME = Johnson
4211 + PHONE_EXT = 410
4212 + HIRE_DATE = 1989/04/05 00:00:00.0000
4213 + DEPT_NO = 180
4214 + JOB_CODE = Mktg
4215 + JOB_GRADE = 3
4216 + JOB_COUNTRY = USA
4217 + SALARY = 64,635.00
4218 + FULL_NAME = Johnson, Leslie
4219 +
4220 + Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4221 + Batch Completion Info
4222 + Total rows processed = 2
4223 + Updated Records = 2
4224 + Row 1 State = bcNoMoreErrors Msg =
4225 + Row 2 State = bcNoMoreErrors Msg =
4226 + Rows after update
4227 + EMP_NO = 2
4228 + FIRST_NAME = Robert
4229 + LAST_NAME = Nelson
4230 + PHONE_EXT = 250
4231 + HIRE_DATE = 2018/05/28 00:00:00.0000
4232 + DEPT_NO = 600
4233 + JOB_CODE = VP
4234 + JOB_GRADE = 2
4235 + JOB_COUNTRY = USA
4236 + SALARY = 105,900.00
4237 + FULL_NAME = Nelson, Robert
4238 + EMP_NO = 8
4239 + FIRST_NAME = Leslie
4240 + LAST_NAME = Johnson
4241 + PHONE_EXT = 410
4242 + HIRE_DATE = 2016/01/31 00:00:00.0000
4243 + DEPT_NO = 180
4244 + JOB_CODE = Mktg
4245 + JOB_GRADE = 3
4246 + JOB_COUNTRY = USA
4247 + SALARY = 64,635.00
4248 + FULL_NAME = Johnson, Leslie
4249 +
4250 +
4251 + Repeat but with a last dummy row that is ignored
4252 + Select Count = 2 InsertCount = 0 UpdateCount = 2 DeleteCount = 0
4253 + Batch Completion Info
4254 + Total rows processed = 2
4255 + Updated Records = 2
4256 + Row 1 State = bcNoMoreErrors Msg =
4257 + Row 2 State = bcNoMoreErrors Msg =
4258 + Rows after update
4259 + EMP_NO = 2
4260 + FIRST_NAME = Robert
4261 + LAST_NAME = Nelson
4262 + PHONE_EXT = 250
4263 + HIRE_DATE = 2018/05/28 00:00:00.0000
4264 + DEPT_NO = 600
4265 + JOB_CODE = VP
4266 + JOB_GRADE = 2
4267 + JOB_COUNTRY = USA
4268 + SALARY = 105,900.00
4269 + FULL_NAME = Nelson, Robert
4270 + EMP_NO = 8
4271 + FIRST_NAME = Leslie
4272 + LAST_NAME = Johnson
4273 + PHONE_EXT = 410
4274 + HIRE_DATE = 2016/01/31 00:00:00.0000
4275 + DEPT_NO = 180
4276 + JOB_CODE = Mktg
4277 + JOB_GRADE = 3
4278 + JOB_COUNTRY = USA
4279 + SALARY = 64,635.00
4280 + FULL_NAME = Johnson, Leslie
4281 +
4282 +
4283 + Insert rows
4284 + Select Count = 0 InsertCount = 3 UpdateCount = 0 DeleteCount = 0
4285 + Batch Completion Info
4286 + Total rows processed = 3
4287 + Updated Records = 3
4288 + Row 1 State = bcNoMoreErrors Msg =
4289 + Row 2 State = bcNoMoreErrors Msg =
4290 + Row 3 State = bcNoMoreErrors Msg =
4291 + Rows after insert
4292 + EMP_NO = 150
4293 + FIRST_NAME = John
4294 + LAST_NAME = Doe
4295 + PHONE_EXT =
4296 + HIRE_DATE = 2015/04/01 00:00:00.0000
4297 + DEPT_NO = 600
4298 + JOB_CODE = Eng
4299 + JOB_GRADE = 4
4300 + JOB_COUNTRY = England
4301 + SALARY = 41,000.89
4302 + FULL_NAME = Doe, John
4303 + EMP_NO = 151
4304 + FIRST_NAME = Jane
4305 + LAST_NAME = Doe
4306 + PHONE_EXT =
4307 + HIRE_DATE = 2015/04/02 00:00:00.0000
4308 + DEPT_NO = 600
4309 + JOB_CODE = Eng
4310 + JOB_GRADE = 4
4311 + JOB_COUNTRY = England
4312 + SALARY = 42,000.89
4313 + FULL_NAME = Doe, Jane
4314 + EMP_NO = 152
4315 + FIRST_NAME = John
4316 + LAST_NAME = SmithAndJonesFamily1
4317 + PHONE_EXT =
4318 + HIRE_DATE = 2015/04/03 00:00:00.0000
4319 + DEPT_NO = 600
4320 + JOB_CODE = Eng
4321 + JOB_GRADE = 4
4322 + JOB_COUNTRY = England
4323 + SALARY = 41,000.99
4324 + FULL_NAME = SmithAndJonesFamily1, John
4325 +
4326 +
4327 + Insert rows - and then cancel
4328 + Cancel Batch - note - next step will fail with a duplicate key if cancel fails
4329 +
4330 + Insert rows - ignore last row
4331 + Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4332 + Batch Completion Info
4333 + Total rows processed = 2
4334 + Updated Records = 2
4335 + Row 1 State = bcNoMoreErrors Msg =
4336 + Row 2 State = bcNoMoreErrors Msg =
4337 + Rows after insert
4338 + EMP_NO = 150
4339 + FIRST_NAME = John
4340 + LAST_NAME = Doe
4341 + PHONE_EXT =
4342 + HIRE_DATE = 2015/04/01 00:00:00.0000
4343 + DEPT_NO = 600
4344 + JOB_CODE = Eng
4345 + JOB_GRADE = 4
4346 + JOB_COUNTRY = England
4347 + SALARY = 41,000.89
4348 + FULL_NAME = Doe, John
4349 + EMP_NO = 151
4350 + FIRST_NAME = Jane
4351 + LAST_NAME = Doe
4352 + PHONE_EXT =
4353 + HIRE_DATE = 2015/04/02 00:00:00.0000
4354 + DEPT_NO = 600
4355 + JOB_CODE = Eng
4356 + JOB_GRADE = 4
4357 + JOB_COUNTRY = England
4358 + SALARY = 42,000.89
4359 + FULL_NAME = Doe, Jane
4360 +
4361 + Insert with inline blob
4362 + Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4363 + Batch Completion Info
4364 + Total rows processed = 2
4365 + Updated Records = 2
4366 + Row 1 State = bcNoMoreErrors Msg =
4367 + Row 2 State = bcNoMoreErrors Msg =
4368 + Rows after insert
4369 + JOB_CODE = ABC
4370 + JOB_GRADE = 3
4371 + JOB_COUNTRY = England
4372 + JOB_TITLE = Chief Tester
4373 + MIN_SALARY = 21,000.00
4374 + MAX_SALARY = 24,000.99
4375 + JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4376 +
4377 + The quick brown fox jumped over the lazy dog
4378 + LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4379 +
4380 + JOB_CODE = DEF
4381 + JOB_GRADE = 3
4382 + JOB_COUNTRY = England
4383 + JOB_TITLE = Deputy Tester
4384 + MIN_SALARY = 21,000.00
4385 + MAX_SALARY = 24,000.99
4386 + JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4387 +
4388 + The quick brown fox jumped over the running dog
4389 + LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4390 +
4391 +
4392 +
4393 + Insert with explicit blob
4394 + Select Count = 0 InsertCount = 2 UpdateCount = 0 DeleteCount = 0
4395 + Batch Completion Info
4396 + Total rows processed = 2
4397 + Updated Records = 2
4398 + Row 1 State = bcNoMoreErrors Msg =
4399 + Row 2 State = bcNoMoreErrors Msg =
4400 + Rows after insert
4401 + JOB_CODE = ABC
4402 + JOB_GRADE = 3
4403 + JOB_COUNTRY = England
4404 + JOB_TITLE = Chief Tester
4405 + MIN_SALARY = 21,000.00
4406 + MAX_SALARY = 24,000.99
4407 + JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4408 +
4409 + The quick brown fox jumped over the lazy dog
4410 + LANGUAGE_REQ = Array: (1: Eng) (2: ) (3: ) (4: ) (5: )
4411 +
4412 + JOB_CODE = DEF
4413 + JOB_GRADE = 3
4414 + JOB_COUNTRY = England
4415 + JOB_TITLE = Deputy Tester
4416 + MIN_SALARY = 21,000.00
4417 + MAX_SALARY = 24,000.99
4418 + JOB_REQUIREMENT (Charset Id = 0 Codepage = 0)
4419 +
4420 + The quick brown fox jumped over the running dog
4421 + LANGUAGE_REQ = Array: (1: Eng) (2: Fra) (3: ) (4: ) (5: )
4422 +
4423 +
4424 + Test Error Handling
4425 + Error reported (as expected) when changing param type: Cannot change SQL Type from SQL_TIMESTAMP to SQL_VARYING
4426 + Test Error Handling - Update returning should fail
4427 + Error reported (as expected) when defering update returning query: This query type (SQL_ExecProcedure) cannot be batched
4428 + Error handling when Insert rows - duplicate key
4429 + 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"
4430 + -Problematic key value is ("EMP_NO" = 150)
4431 + Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0
4432 + Batch Completion Info
4433 + Total rows processed = 2
4434 + Updated Records = 1
4435 + Row 1 State = bcNoMoreErrors Msg =
4436 + Row 2 State = bcExecuteFailed Msg = violation of PRIMARY or UNIQUE KEY constraint "INTEG_27" on table "EMPLOYEE"
4437 + -Problematic key value is ("EMP_NO" = 150)
4438 +
4439 +
4440 + ------------------------------------------------------
4441 + Running Test 20: Stress Test IBatch interface
4442 + FBVersion = Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2496 Firebird 4.0"
4443 + 10000 rows added
4444 + 20000 rows added
4445 + 30000 rows added
4446 + 40000 rows added
4447 + 50000 rows added
4448 + Batch Execute
4449 + Intermediate Apply Batch on row 50001
4450 + Batch Completion Info
4451 + Total rows processed = 50000
4452 + Updated Rows = 50000
4453 + Row 50000 State = bcNoMoreErrors Msg =
4454 + 60000 rows added
4455 + 70000 rows added
4456 + 80000 rows added
4457 + 90000 rows added
4458 + 100000 rows added
4459 + Batch Execute
4460 + Batch Completion Info
4461 + Total rows processed = 50000
4462 + Updated Rows = 50000
4463 + Row 50000 State = bcNoMoreErrors Msg =
4464 + Rows in Dataset = 100000
4465 + Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4466 + Message Hash = 2014887b8ad27fbb20893a22d6e39f26
4467 + Test Completed Successfully
4468 +
4469 +
4470 + ------------------------------------------------------
4471   Test Suite Ends

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines