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

DB2 Patch

Help
2014-05-30
2014-05-30
  • I created a working patch for DB2. I published in GitHub: https://github.com/angoca/BenchmarkSQL/tree/my-version

    The modified files /run/*_DB2

    There is only one issue: DB2 does not support the following grammar

    create table benchmarksql.history (
      hist_id  integer not null default nextval('hist_id_seq') primary key,
    

    The DB2 porting does not perform completely equally. It could be:

    • GENERATED BY DEFAULT but the counter should be reseted after loading the values.
    • GENERATED ALWAYS generate errors and the business logic should be changed
    • GENERATED BY DEFAULT but without Primary key.

    Best regards,