Hello community,

here is the log from the commit of package sysbench for openSUSE:Factory 
checked in at 2017-09-12 19:57:51
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Comparing /work/SRC/openSUSE:Factory/sysbench (Old)
 and      /work/SRC/openSUSE:Factory/.sysbench.new (New)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Package is "sysbench"

Tue Sep 12 19:57:51 2017 rev:15 rq:523612 version:1.0.9

Changes:
--------
--- /work/SRC/openSUSE:Factory/sysbench/sysbench.changes        2017-08-18 
15:05:52.213764182 +0200
+++ /work/SRC/openSUSE:Factory/.sysbench.new/sysbench.changes   2017-09-12 
19:57:52.226192364 +0200
@@ -1,0 +2,12 @@
+Tue Sep 12 08:57:53 UTC 2017 - [email protected]
+
+- Update to version 1.0.9:
+  * fixed oltp_delete.lua to not use INSERT statements for
+    consistency with other oltp_* benchmarks (GH-168)
+  * added a workaround for MySQL bug #87337 "8.0.2 reintroduces
+    my_bool to client API"
+  * fixed building on on Debian GNU/kFreeBSD (GH-161)
+  * fixed building against MariaDB 10.2 (thanks to Xavier Bachelot
+    for the patch, GH-160)
+
+-------------------------------------------------------------------

Old:
----
  sysbench-1.0.8.tar.gz

New:
----
  sysbench-1.0.9.tar.gz

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Other differences:
------------------
++++++ sysbench.spec ++++++
--- /var/tmp/diff_new_pack.N5BYF5/_old  2017-09-12 19:57:52.866102387 +0200
+++ /var/tmp/diff_new_pack.N5BYF5/_new  2017-09-12 19:57:52.870101824 +0200
@@ -17,7 +17,7 @@
 
 
 Name:           sysbench
-Version:        1.0.8
+Version:        1.0.9
 Release:        0
 Summary:        A MySQL benchmarking tool
 License:        GPL-2.0

++++++ sysbench-1.0.8.tar.gz -> sysbench-1.0.9.tar.gz ++++++
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/sysbench-1.0.8/ChangeLog new/sysbench-1.0.9/ChangeLog
--- old/sysbench-1.0.8/ChangeLog        2017-07-04 20:55:46.000000000 +0200
+++ new/sysbench-1.0.9/ChangeLog        2017-09-05 19:26:28.000000000 +0200
@@ -1,3 +1,14 @@
+2017-09-05  Alexey Kopytov  <[email protected]>
+
+       * version 1.0.9
+       * fixed oltp_delete.lua to not use INSERT statements for
+       consistency with other oltp_* benchmarks (GH-168)
+       * added a workaround for MySQL bug #87337 "8.0.2 reintroduces
+       my_bool to client API"
+       * fixed building on on Debian GNU/kFreeBSD (GH-161)
+       * fixed building against MariaDB 10.2 (thanks to Xavier Bachelot
+       for the patch, GH-160)
+
 2017-07-04  Alexey Kopytov  <[email protected]>
 
        * version 1.0.8
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/sysbench-1.0.8/configure.ac 
new/sysbench-1.0.9/configure.ac
--- old/sysbench-1.0.8/configure.ac     2017-07-04 20:55:46.000000000 +0200
+++ new/sysbench-1.0.9/configure.ac     2017-09-05 19:26:28.000000000 +0200
@@ -1,7 +1,7 @@
 # Process this file with autoconf to produce a configure script.
 
 AC_PREREQ(2.63)
-AC_INIT([sysbench],[1.0.8],[https://github.com/akopytov/sysbench/issues],
+AC_INIT([sysbench],[1.0.9],[https://github.com/akopytov/sysbench/issues],
         [sysbench], [https://github.com/akopytov/sysbench])
 AC_CONFIG_AUX_DIR([config])
 # Setting CFLAGS here prevents AC_CANONICAL_TARGET from injecting them
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/sysbench-1.0.8/src/drivers/mysql/drv_mysql.c 
new/sysbench-1.0.9/src/drivers/mysql/drv_mysql.c
--- old/sysbench-1.0.8/src/drivers/mysql/drv_mysql.c    2017-07-04 
20:55:46.000000000 +0200
+++ new/sysbench-1.0.9/src/drivers/mysql/drv_mysql.c    2017-09-05 
19:26:28.000000000 +0200
@@ -35,6 +35,7 @@
 #include <stdio.h>
 
 #include <mysql.h>
+#include <mysql_version.h>
 #include <mysqld_error.h>
 #include <errmsg.h>
 
@@ -49,7 +50,8 @@
 
 #define SAFESTR(s) ((s != NULL) ? (s) : "(null)")
 
-#if !defined(MARIADB_BASE_VERSION) && MYSQL_VERSION_ID >= 80001
+#if !defined(MARIADB_BASE_VERSION) && MYSQL_VERSION_ID >= 80001 && \
+  MYSQL_VERSION_ID != 80002 /* see https://bugs.mysql.com/?id=87337 */
 typedef bool my_bool;
 #endif
 
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/sysbench-1.0.8/src/lua/oltp_delete.lua 
new/sysbench-1.0.9/src/lua/oltp_delete.lua
--- old/sysbench-1.0.8/src/lua/oltp_delete.lua  2017-07-04 20:55:46.000000000 
+0200
+++ new/sysbench-1.0.9/src/lua/oltp_delete.lua  2017-09-05 19:26:28.000000000 
+0200
@@ -22,9 +22,13 @@
 require("oltp_common")
 
 function prepare_statements()
-   prepare_delete_inserts()
+   prepare_for_each_table("deletes")
 end
 
 function event()
-   execute_delete_inserts()
+   local tnum = sysbench.rand.uniform(1, sysbench.opt.tables)
+   local id = sysbench.rand.default(1, sysbench.opt.table_size)
+
+   param[tnum].deletes[1]:set(id)
+   stmt[tnum].deletes:execute()
 end
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/sysbench-1.0.8/src/sb_util.h 
new/sysbench-1.0.9/src/sb_util.h
--- old/sysbench-1.0.8/src/sb_util.h    2017-07-04 20:55:46.000000000 +0200
+++ new/sysbench-1.0.9/src/sb_util.h    2017-09-05 19:26:28.000000000 +0200
@@ -46,14 +46,10 @@
 # define SB_ATTRIBUTE_UNUSED
 #endif
 
-#ifdef __linux__
-# define DLEXT ".so"
-#elif defined(__MACH__)
+#if defined(__MACH__)
 # define DLEXT ".dylib"
-#elif defined(__sun)
-# define DLEXT ".so"
 #else
-# error Cannot detect the dynamic library suffix for this platform
+# define DLEXT ".so"
 #endif
 
 /*
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/sysbench-1.0.8/tests/t/script_oltp_delete_mysql.t 
new/sysbench-1.0.9/tests/t/script_oltp_delete_mysql.t
--- old/sysbench-1.0.8/tests/t/script_oltp_delete_mysql.t       1970-01-01 
01:00:00.000000000 +0100
+++ new/sysbench-1.0.9/tests/t/script_oltp_delete_mysql.t       2017-09-05 
19:26:28.000000000 +0200
@@ -0,0 +1,201 @@
+########################################################################
+oltp_delete.lua + MySQL tests 
+########################################################################
+
+  $ . $SBTEST_INCDIR/mysql_common.sh
+  $ OLTP_SCRIPT_PATH=${SBTEST_SCRIPTDIR}/oltp_delete.lua
+  $ . $SBTEST_INCDIR/script_oltp_common.sh
+  sysbench *.* * (glob)
+  
+  Creating table 'sbtest1'...
+  Inserting 10000 records into 'sbtest1'
+  Creating a secondary index on 'sbtest1'...
+  Creating table 'sbtest2'...
+  Inserting 10000 records into 'sbtest2'
+  Creating a secondary index on 'sbtest2'...
+  Creating table 'sbtest3'...
+  Inserting 10000 records into 'sbtest3'
+  Creating a secondary index on 'sbtest3'...
+  Creating table 'sbtest4'...
+  Inserting 10000 records into 'sbtest4'
+  Creating a secondary index on 'sbtest4'...
+  Creating table 'sbtest5'...
+  Inserting 10000 records into 'sbtest5'
+  Creating a secondary index on 'sbtest5'...
+  Creating table 'sbtest6'...
+  Inserting 10000 records into 'sbtest6'
+  Creating a secondary index on 'sbtest6'...
+  Creating table 'sbtest7'...
+  Inserting 10000 records into 'sbtest7'
+  Creating a secondary index on 'sbtest7'...
+  Creating table 'sbtest8'...
+  Inserting 10000 records into 'sbtest8'
+  Creating a secondary index on 'sbtest8'...
+  *************************** 1. row ***************************
+  sbtest1
+  CREATE TABLE `sbtest1` (
+    `id` int(11) NOT NULL AUTO_INCREMENT,
+    `k` int(11) NOT NULL DEFAULT '0',
+    `c` char(120)* NOT NULL DEFAULT '', (glob)
+    `pad` char(60)* NOT NULL DEFAULT '', (glob)
+    PRIMARY KEY (`id`),
+    KEY `k_1` (`k`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=* (glob)
+  *************************** 1. row ***************************
+  sbtest2
+  CREATE TABLE `sbtest2` (
+    `id` int(11) NOT NULL AUTO_INCREMENT,
+    `k` int(11) NOT NULL DEFAULT '0',
+    `c` char(120)* NOT NULL DEFAULT '', (glob)
+    `pad` char(60)* NOT NULL DEFAULT '', (glob)
+    PRIMARY KEY (`id`),
+    KEY `k_2` (`k`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=* (glob)
+  *************************** 1. row ***************************
+  sbtest3
+  CREATE TABLE `sbtest3` (
+    `id` int(11) NOT NULL AUTO_INCREMENT,
+    `k` int(11) NOT NULL DEFAULT '0',
+    `c` char(120)* NOT NULL DEFAULT '', (glob)
+    `pad` char(60)* NOT NULL DEFAULT '', (glob)
+    PRIMARY KEY (`id`),
+    KEY `k_3` (`k`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=* (glob)
+  *************************** 1. row ***************************
+  sbtest4
+  CREATE TABLE `sbtest4` (
+    `id` int(11) NOT NULL AUTO_INCREMENT,
+    `k` int(11) NOT NULL DEFAULT '0',
+    `c` char(120)* NOT NULL DEFAULT '', (glob)
+    `pad` char(60)* NOT NULL DEFAULT '', (glob)
+    PRIMARY KEY (`id`),
+    KEY `k_4` (`k`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=* (glob)
+  *************************** 1. row ***************************
+  sbtest5
+  CREATE TABLE `sbtest5` (
+    `id` int(11) NOT NULL AUTO_INCREMENT,
+    `k` int(11) NOT NULL DEFAULT '0',
+    `c` char(120)* NOT NULL DEFAULT '', (glob)
+    `pad` char(60)* NOT NULL DEFAULT '', (glob)
+    PRIMARY KEY (`id`),
+    KEY `k_5` (`k`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=* (glob)
+  *************************** 1. row ***************************
+  sbtest6
+  CREATE TABLE `sbtest6` (
+    `id` int(11) NOT NULL AUTO_INCREMENT,
+    `k` int(11) NOT NULL DEFAULT '0',
+    `c` char(120)* NOT NULL DEFAULT '', (glob)
+    `pad` char(60)* NOT NULL DEFAULT '', (glob)
+    PRIMARY KEY (`id`),
+    KEY `k_6` (`k`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=* (glob)
+  *************************** 1. row ***************************
+  sbtest7
+  CREATE TABLE `sbtest7` (
+    `id` int(11) NOT NULL AUTO_INCREMENT,
+    `k` int(11) NOT NULL DEFAULT '0',
+    `c` char(120)* NOT NULL DEFAULT '', (glob)
+    `pad` char(60)* NOT NULL DEFAULT '', (glob)
+    PRIMARY KEY (`id`),
+    KEY `k_7` (`k`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=* (glob)
+  *************************** 1. row ***************************
+  sbtest8
+  CREATE TABLE `sbtest8` (
+    `id` int(11) NOT NULL AUTO_INCREMENT,
+    `k` int(11) NOT NULL DEFAULT '0',
+    `c` char(120)* NOT NULL DEFAULT '', (glob)
+    `pad` char(60)* NOT NULL DEFAULT '', (glob)
+    PRIMARY KEY (`id`),
+    KEY `k_8` (`k`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=* (glob)
+  ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest9' doesn't exist
+  sysbench * (glob)
+  
+  Prewarming table sbtest1
+  Prewarming table sbtest2
+  Prewarming table sbtest3
+  Prewarming table sbtest4
+  Prewarming table sbtest5
+  Prewarming table sbtest6
+  Prewarming table sbtest7
+  Prewarming table sbtest8
+  sysbench *.* * (glob)
+  
+  Running the test with following options:
+  Number of threads: 2
+  Initializing random number generator from current time
+  
+  
+  Initializing worker threads...
+  
+  Threads started!
+  
+  SQL statistics:
+      queries performed:
+          read:                            0
+          write:                           * (glob)
+          other:                           * (glob)
+          total:                           100
+      transactions:                        100    (* per sec.) (glob)
+      queries:                             100    (* per sec.) (glob)
+      ignored errors:                      0      (* per sec.) (glob)
+      reconnects:                          0      (* per sec.) (glob)
+  
+  General statistics:
+      total time:                          *s (glob)
+      total number of events:              100
+  
+  Latency (ms):
+           min:                              *.* (glob)
+           avg:                              *.* (glob)
+           max:                              *.* (glob)
+           95th percentile:         *.* (glob)
+           sum: *.* (glob)
+  
+  Threads fairness:
+      events (avg/stddev):           */* (glob)
+      execution time (avg/stddev):   */* (glob)
+  
+  sysbench *.* * (glob)
+  
+  Dropping table 'sbtest1'...
+  Dropping table 'sbtest2'...
+  Dropping table 'sbtest3'...
+  Dropping table 'sbtest4'...
+  Dropping table 'sbtest5'...
+  Dropping table 'sbtest6'...
+  Dropping table 'sbtest7'...
+  Dropping table 'sbtest8'...
+  ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest1' doesn't exist
+  ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest2' doesn't exist
+  ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest3' doesn't exist
+  ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest4' doesn't exist
+  ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest5' doesn't exist
+  ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest6' doesn't exist
+  ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest7' doesn't exist
+  ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest8' doesn't exist
+  # Test --create-secondary=off
+  sysbench * (glob)
+  
+  Creating table 'sbtest1'...
+  Inserting 10000 records into 'sbtest1'
+  *************************** 1. row ***************************
+  sbtest1
+  CREATE TABLE `sbtest1` (
+    `id` int(11) NOT NULL AUTO_INCREMENT,
+    `k` int(11) NOT NULL DEFAULT '0',
+    `c` char(120)* NOT NULL DEFAULT '', (glob)
+    `pad` char(60)* NOT NULL DEFAULT '', (glob)
+    PRIMARY KEY (`id`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=* (glob)
+  sysbench * (glob)
+  
+  Dropping table 'sbtest1'...
+  # Test --auto-inc=off
+  Creating table 'sbtest1'...
+  Inserting 10000 records into 'sbtest1'
+  Creating a secondary index on 'sbtest1'...
+  Dropping table 'sbtest1'...
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/sysbench-1.0.8/tests/t/script_oltp_delete_pgsql.t 
new/sysbench-1.0.9/tests/t/script_oltp_delete_pgsql.t
--- old/sysbench-1.0.8/tests/t/script_oltp_delete_pgsql.t       1970-01-01 
01:00:00.000000000 +0100
+++ new/sysbench-1.0.9/tests/t/script_oltp_delete_pgsql.t       2017-09-05 
19:26:28.000000000 +0200
@@ -0,0 +1,203 @@
+########################################################################
+oltp_delete.lua + PostgreSQL tests 
+########################################################################
+
+  $ . $SBTEST_INCDIR/pgsql_common.sh
+  $ OLTP_SCRIPT_PATH=${SBTEST_SCRIPTDIR}/oltp_delete.lua
+  $ . $SBTEST_INCDIR/script_oltp_common.sh
+  sysbench *.* * (glob)
+  
+  Creating table 'sbtest1'...
+  Inserting 10000 records into 'sbtest1'
+  Creating a secondary index on 'sbtest1'...
+  Creating table 'sbtest2'...
+  Inserting 10000 records into 'sbtest2'
+  Creating a secondary index on 'sbtest2'...
+  Creating table 'sbtest3'...
+  Inserting 10000 records into 'sbtest3'
+  Creating a secondary index on 'sbtest3'...
+  Creating table 'sbtest4'...
+  Inserting 10000 records into 'sbtest4'
+  Creating a secondary index on 'sbtest4'...
+  Creating table 'sbtest5'...
+  Inserting 10000 records into 'sbtest5'
+  Creating a secondary index on 'sbtest5'...
+  Creating table 'sbtest6'...
+  Inserting 10000 records into 'sbtest6'
+  Creating a secondary index on 'sbtest6'...
+  Creating table 'sbtest7'...
+  Inserting 10000 records into 'sbtest7'
+  Creating a secondary index on 'sbtest7'...
+  Creating table 'sbtest8'...
+  Inserting 10000 records into 'sbtest8'
+  Creating a secondary index on 'sbtest8'...
+                                                   Table "public.sbtest1"
+   Column |      Type      |                      Modifiers                    
   | Storage  | Stats target | Description 
+  
--------+----------------+------------------------------------------------------+----------+--------------+-------------
+   id     | integer        | not null default 
nextval('sbtest1_id_seq'::regclass) | plain    |              | 
+   k      | integer        | not null default 0                                
   | plain    |              | 
+   c      | character(120) | not null default ''::bpchar                       
   | extended |              | 
+   pad    | character(60)  | not null default ''::bpchar                       
   | extended |              | 
+  Indexes:
+      "sbtest1_pkey" PRIMARY KEY, btree (id)
+      "k_1" btree (k)
+  
+                                                   Table "public.sbtest2"
+   Column |      Type      |                      Modifiers                    
   | Storage  | Stats target | Description 
+  
--------+----------------+------------------------------------------------------+----------+--------------+-------------
+   id     | integer        | not null default 
nextval('sbtest2_id_seq'::regclass) | plain    |              | 
+   k      | integer        | not null default 0                                
   | plain    |              | 
+   c      | character(120) | not null default ''::bpchar                       
   | extended |              | 
+   pad    | character(60)  | not null default ''::bpchar                       
   | extended |              | 
+  Indexes:
+      "sbtest2_pkey" PRIMARY KEY, btree (id)
+      "k_2" btree (k)
+  
+                                                   Table "public.sbtest3"
+   Column |      Type      |                      Modifiers                    
   | Storage  | Stats target | Description 
+  
--------+----------------+------------------------------------------------------+----------+--------------+-------------
+   id     | integer        | not null default 
nextval('sbtest3_id_seq'::regclass) | plain    |              | 
+   k      | integer        | not null default 0                                
   | plain    |              | 
+   c      | character(120) | not null default ''::bpchar                       
   | extended |              | 
+   pad    | character(60)  | not null default ''::bpchar                       
   | extended |              | 
+  Indexes:
+      "sbtest3_pkey" PRIMARY KEY, btree (id)
+      "k_3" btree (k)
+  
+                                                   Table "public.sbtest4"
+   Column |      Type      |                      Modifiers                    
   | Storage  | Stats target | Description 
+  
--------+----------------+------------------------------------------------------+----------+--------------+-------------
+   id     | integer        | not null default 
nextval('sbtest4_id_seq'::regclass) | plain    |              | 
+   k      | integer        | not null default 0                                
   | plain    |              | 
+   c      | character(120) | not null default ''::bpchar                       
   | extended |              | 
+   pad    | character(60)  | not null default ''::bpchar                       
   | extended |              | 
+  Indexes:
+      "sbtest4_pkey" PRIMARY KEY, btree (id)
+      "k_4" btree (k)
+  
+                                                   Table "public.sbtest5"
+   Column |      Type      |                      Modifiers                    
   | Storage  | Stats target | Description 
+  
--------+----------------+------------------------------------------------------+----------+--------------+-------------
+   id     | integer        | not null default 
nextval('sbtest5_id_seq'::regclass) | plain    |              | 
+   k      | integer        | not null default 0                                
   | plain    |              | 
+   c      | character(120) | not null default ''::bpchar                       
   | extended |              | 
+   pad    | character(60)  | not null default ''::bpchar                       
   | extended |              | 
+  Indexes:
+      "sbtest5_pkey" PRIMARY KEY, btree (id)
+      "k_5" btree (k)
+  
+                                                   Table "public.sbtest6"
+   Column |      Type      |                      Modifiers                    
   | Storage  | Stats target | Description 
+  
--------+----------------+------------------------------------------------------+----------+--------------+-------------
+   id     | integer        | not null default 
nextval('sbtest6_id_seq'::regclass) | plain    |              | 
+   k      | integer        | not null default 0                                
   | plain    |              | 
+   c      | character(120) | not null default ''::bpchar                       
   | extended |              | 
+   pad    | character(60)  | not null default ''::bpchar                       
   | extended |              | 
+  Indexes:
+      "sbtest6_pkey" PRIMARY KEY, btree (id)
+      "k_6" btree (k)
+  
+                                                   Table "public.sbtest7"
+   Column |      Type      |                      Modifiers                    
   | Storage  | Stats target | Description 
+  
--------+----------------+------------------------------------------------------+----------+--------------+-------------
+   id     | integer        | not null default 
nextval('sbtest7_id_seq'::regclass) | plain    |              | 
+   k      | integer        | not null default 0                                
   | plain    |              | 
+   c      | character(120) | not null default ''::bpchar                       
   | extended |              | 
+   pad    | character(60)  | not null default ''::bpchar                       
   | extended |              | 
+  Indexes:
+      "sbtest7_pkey" PRIMARY KEY, btree (id)
+      "k_7" btree (k)
+  
+                                                   Table "public.sbtest8"
+   Column |      Type      |                      Modifiers                    
   | Storage  | Stats target | Description 
+  
--------+----------------+------------------------------------------------------+----------+--------------+-------------
+   id     | integer        | not null default 
nextval('sbtest8_id_seq'::regclass) | plain    |              | 
+   k      | integer        | not null default 0                                
   | plain    |              | 
+   c      | character(120) | not null default ''::bpchar                       
   | extended |              | 
+   pad    | character(60)  | not null default ''::bpchar                       
   | extended |              | 
+  Indexes:
+      "sbtest8_pkey" PRIMARY KEY, btree (id)
+      "k_8" btree (k)
+  
+  Did not find any relation named "sbtest9".
+  sysbench *.* * (glob)
+  
+  FATAL: *: prewarm is currently MySQL only (glob)
+  sysbench *.* * (glob)
+  
+  Running the test with following options:
+  Number of threads: 2
+  Initializing random number generator from current time
+  
+  
+  Initializing worker threads...
+  
+  Threads started!
+  
+  SQL statistics:
+      queries performed:
+          read:                            0
+          write:                           * (glob)
+          other:                           * (glob)
+          total:                           100
+      transactions:                        100    (* per sec.) (glob)
+      queries:                             100    (* per sec.) (glob)
+      ignored errors:                      0      (* per sec.) (glob)
+      reconnects:                          0      (* per sec.) (glob)
+  
+  General statistics:
+      total time:                          *s (glob)
+      total number of events:              100
+  
+  Latency (ms):
+           min:                              *.* (glob)
+           avg:                              *.* (glob)
+           max:                              *.* (glob)
+           95th percentile:         *.* (glob)
+           sum: *.* (glob)
+  
+  Threads fairness:
+      events (avg/stddev):           */* (glob)
+      execution time (avg/stddev):   */* (glob)
+  
+  sysbench *.* * (glob)
+  
+  Dropping table 'sbtest1'...
+  Dropping table 'sbtest2'...
+  Dropping table 'sbtest3'...
+  Dropping table 'sbtest4'...
+  Dropping table 'sbtest5'...
+  Dropping table 'sbtest6'...
+  Dropping table 'sbtest7'...
+  Dropping table 'sbtest8'...
+  Did not find any relation named "sbtest1".
+  Did not find any relation named "sbtest2".
+  Did not find any relation named "sbtest3".
+  Did not find any relation named "sbtest4".
+  Did not find any relation named "sbtest5".
+  Did not find any relation named "sbtest6".
+  Did not find any relation named "sbtest7".
+  Did not find any relation named "sbtest8".
+  # Test --create-secondary=off
+  sysbench * (glob)
+  
+  Creating table 'sbtest1'...
+  Inserting 10000 records into 'sbtest1'
+                                                   Table "public.sbtest1"
+   Column |      Type      |                      Modifiers                    
   | Storage  | Stats target | Description 
+  
--------+----------------+------------------------------------------------------+----------+--------------+-------------
+   id     | integer        | not null default 
nextval('sbtest1_id_seq'::regclass) | plain    |              | 
+   k      | integer        | not null default 0                                
   | plain    |              | 
+   c      | character(120) | not null default ''::bpchar                       
   | extended |              | 
+   pad    | character(60)  | not null default ''::bpchar                       
   | extended |              | 
+  Indexes:
+      "sbtest1_pkey" PRIMARY KEY, btree (id)
+  
+  sysbench * (glob)
+  
+  Dropping table 'sbtest1'...
+  # Test --auto-inc=off
+  Creating table 'sbtest1'...
+  Inserting 10000 records into 'sbtest1'
+  Creating a secondary index on 'sbtest1'...
+  Dropping table 'sbtest1'...
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/sysbench-1.0.8/tests/t/script_oltp_insert_mysql.t 
new/sysbench-1.0.9/tests/t/script_oltp_insert_mysql.t
--- old/sysbench-1.0.8/tests/t/script_oltp_insert_mysql.t       2017-07-04 
20:55:46.000000000 +0200
+++ new/sysbench-1.0.9/tests/t/script_oltp_insert_mysql.t       2017-09-05 
19:26:28.000000000 +0200
@@ -1,5 +1,5 @@
 ########################################################################
-oltp_point_select.lua + MySQL tests 
+oltp_insert.lua + MySQL tests
 ########################################################################
 
   $ . $SBTEST_INCDIR/mysql_common.sh
diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' 
'--exclude=.svnignore' old/sysbench-1.0.8/tests/t/script_oltp_insert_pgsql.t 
new/sysbench-1.0.9/tests/t/script_oltp_insert_pgsql.t
--- old/sysbench-1.0.8/tests/t/script_oltp_insert_pgsql.t       2017-07-04 
20:55:46.000000000 +0200
+++ new/sysbench-1.0.9/tests/t/script_oltp_insert_pgsql.t       2017-09-05 
19:26:28.000000000 +0200
@@ -1,5 +1,5 @@
 ########################################################################
-oltp_point_select.lua + PostgreSQL tests 
+oltp_insert.lua + PostgreSQL tests
 ########################################################################
 
   $ . $SBTEST_INCDIR/pgsql_common.sh


Reply via email to