Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#8 The attribute "end_range" in integer generator doesn't work

closed
Michael
Bug (17)
5
2011-12-03
2011-10-02
Anonymous
No

The attribute "end_range" in integer generator should set the maximum of the integer that is generated. For example, if "end_range=10", the integer should be less than or equal to 10. However, some integers that are generated exceed the maximum when "end_range" is set.

Discussion

  • Nikita
    Nikita
    2011-10-03

    • assigned_to: nobody --> candy1989512
     
  • Nikita
    Nikita
    2011-10-08

    closed as not a bug.

     
  • Nikita
    Nikita
    2011-10-08

    • status: open --> closed
     
  • Michael
    Michael
    2011-10-23

    database config file with the mentioned settings

     
    Attachments
  • Michael
    Michael
    2011-10-23

    • assigned_to: candy1989512 --> bennettaur
    • status: closed --> open
     
  • Michael
    Michael
    2011-10-23

    Bug does exist and is proved under these conditions:
    6 generator threads
    table with integer field, producing 100 records
    integer generator end_range = 20 everything else left to default
    I've attached my config files
    DG output:
    db2inst1@ubuntu:~/dist$ java -jar DG.jar -d data/schemas/IGtest.xml
    0 [main] INFO com.ibm.dg.DataGenerator - Data Generator started. Version: 0.3 Revision: ec25540b763d tip
    App config file:
    /home/michael/UCOSP/DG/dist/config.xml
    DB config file:
    /home/michael/UCOSP/DG/dist/data/schemas/IGtest.xml
    270 [main] INFO com.ibm.dg.DataGenerator - Schema meta information:

    270 [main] INFO com.ibm.dg.DataGenerator - Running pre-run commands.
    270 [main] INFO com.ibm.dg.DataGenerator - Running "Create a database."
    1295 [main] INFO com.ibm.dg.DataGenerator - Command's output: create database dg_demoSQL1005N The database alias "dg_demo" already exists in either the local database directory or system database directory.
    1497 [main] INFO com.ibm.dg.DataGenerator - No datasources defined, proceeding
    1497 [main] INFO com.ibm.dg.DataGenerator - Starting the timer.
    1497 [main] INFO com.ibm.dg.DataGenerator - Starting loading data sources.
    =======
    1498 [main] INFO com.ibm.dg.DataGenerator - Starting to load data source files.
    1501 [main] INFO com.ibm.dg.DataGenerator - Completed in: 00:00:00
    1501 [main] INFO com.ibm.dg.DataGenerator - Starting loading tables.
    =======
    1804 [main] INFO com.ibm.dg.DataGenerator - Running pre-generation commands.
    1804 [main] INFO com.ibm.dg.DataGenerator - Running pre-generation commands completed in: 00:00:00
    1804 [main] INFO com.ibm.dg.DataGenerator - Generating data for 'int.test' table.
    This table will have 100 row(s).
    Threads: 6, with around 16 row(s) per thread.
    Comm. (stmts) Comm. (size) Commit Rate (stmts/s) Commit Rate (size/s)
    ======
    100 400.0 B -1 null
    100 400.0 B -1 null
    11885 [main] INFO com.ibm.dg.DataGenerator - Generating data for 'int.test' table completed in: 00:00:10
    11885 [main] INFO com.ibm.dg.DataGenerator - Running post-generation commands.
    11889 [main] INFO com.ibm.dg.DataGenerator - Running post-generation commands completed in: 00:00:00
    11889 [main] INFO com.ibm.dg.DataGenerator - Completed in: 00:00:10
    11889 [main] INFO com.ibm.dg.DataGenerator - Stopping the timer.
    11889 [main] INFO com.ibm.dg.DataGenerator - Finished generating data in: 00:00:00:10
    11890 [Thread-0] WARN com.ibm.dg.DataGenerator - Shutting down.
    db2inst1@ubuntu:~/dist$ db2 "select * from int.test order by vals"

    VALS
    -----------
    1
    1
    1
    2
    2
    2
    3
    3
    4
    4
    5
    5
    6
    6
    7
    7
    8
    8
    9
    9
    10
    10
    11
    11
    12
    12
    13
    14
    15
    16
    17
    18
    19
    20
    20
    20
    20
    20
    21
    21
    21
    21
    22
    22
    22
    22
    23
    23
    23
    23
    24
    24
    24
    24
    25
    25
    25
    25
    26
    26
    26
    26
    27
    27
    27
    27
    28
    28
    28
    28
    29
    29
    29
    29
    30
    30
    30
    30
    31
    31
    31
    31
    32
    32
    32
    32
    33
    33
    33
    33
    34
    34
    34
    35
    35
    35
    36
    37
    38
    39

    100 record(s) selected.

     
  • Michael
    Michael
    2011-10-23

    DG config file. Will most likely have the change port if you want to run

     
    Attachments
  • Michael
    Michael
    2011-12-03

    • status: open --> closed