Hello community, here is the log from the commit of package sysbench for openSUSE:Factory checked in at 2020-06-18 10:24:30 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/sysbench (Old) and /work/SRC/openSUSE:Factory/.sysbench.new.3606 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "sysbench" Thu Jun 18 10:24:30 2020 rev:28 rq:815498 version:1.0.20 Changes: -------- --- /work/SRC/openSUSE:Factory/sysbench/sysbench.changes 2020-03-16 10:20:40.559644366 +0100 +++ /work/SRC/openSUSE:Factory/.sysbench.new.3606/sysbench.changes 2020-06-18 10:25:50.028408626 +0200 @@ -1,0 +2,11 @@ +Wed Jun 17 12:10:56 UTC 2020 - Martin Pluskal <[email protected]> + +- Update to version 1.0.20: + * build/CI/packaging: Add arm64 to Travis CI matrix (#358) + * build/CI/packaging: add Ubuntu Focal + * build/CI/packaging: remove Fedora Rawhide from CI matrix + * build/CI/packaging: fix regression tests to work with MySQL 8.0.19+ + * build/CI/packaging: fix macOS builds in Travis + * build/CI/packaging: remove Ubuntu Disco (EOL) + +------------------------------------------------------------------- Old: ---- sysbench-1.0.19.tar.gz New: ---- sysbench-1.0.20.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ sysbench.spec ++++++ --- /var/tmp/diff_new_pack.s9P7as/_old 2020-06-18 10:26:02.332445760 +0200 +++ /var/tmp/diff_new_pack.s9P7as/_new 2020-06-18 10:26:02.332445760 +0200 @@ -17,7 +17,7 @@ Name: sysbench -Version: 1.0.19 +Version: 1.0.20 Release: 0 Summary: A MySQL benchmarking tool License: GPL-2.0-only ++++++ sysbench-1.0.19.tar.gz -> sysbench-1.0.20.tar.gz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/sysbench-1.0.19/.travis.yml new/sysbench-1.0.20/.travis.yml --- old/sysbench-1.0.19/.travis.yml 2019-12-08 13:04:05.000000000 +0100 +++ new/sysbench-1.0.20/.travis.yml 2020-04-24 17:51:47.000000000 +0200 @@ -2,6 +2,10 @@ # # Travis CI configuration +arch: + - amd64 + - arm64 + dist: trusty sudo: required @@ -34,18 +38,16 @@ - OS=fedora DIST=29 - OS=fedora DIST=30 - OS=fedora DIST=31 - - OS=fedora DIST=rawhide - OS=ubuntu DIST=xenial - OS=ubuntu DIST=bionic - - OS=ubuntu DIST=disco - OS=ubuntu DIST=eoan + - OS=ubuntu DIST=focal - OS=debian DIST=jessie - OS=debian DIST=stretch - OS=debian DIST=buster - OS=debian DIST=sid - OS=ubuntu DIST=xenial ARCH=i386 - OS=ubuntu DIST=bionic ARCH=i386 - - OS=ubuntu DIST=disco ARCH=i386 - OS=ubuntu DIST=eoan ARCH=i386 - OS=debian DIST=jessie ARCH=i386 - OS=debian DIST=stretch ARCH=i386 @@ -66,8 +68,6 @@ compiler: clang - env: OS=fedora DIST=31 compiler: clang - - env: OS=fedora DIST=rawhide - compiler: clang - env: OS=ubuntu DIST=xenial compiler: clang - env: OS=ubuntu DIST=bionic @@ -76,6 +76,8 @@ compiler: clang - env: OS=ubuntu DIST=eoan compiler: clang + - env: OS=ubuntu DIST=focal + compiler: clang - env: OS=debian DIST=jessie compiler: clang - env: OS=debian DIST=stretch @@ -100,6 +102,24 @@ compiler: clang - env: OS=debian DIST=sid ARCH=i386 compiler: clang + - env: OS=ubuntu DIST=xenial ARCH=i386 + arch: arm64 + - env: OS=ubuntu DIST=bionic ARCH=i386 + arch: arm64 + - env: OS=ubuntu DIST=disco ARCH=i386 + arch: arm64 + - env: OS=ubuntu DIST=eoan ARCH=i386 + arch: arm64 + - env: OS=debian DIST=jessie ARCH=i386 + arch: arm64 + - env: OS=debian DIST=stretch ARCH=i386 + arch: arm64 + - env: OS=debian DIST=buster ARCH=i386 + arch: arm64 + - env: OS=debian DIST=sid ARCH=i386 + arch: arm64 + - env: OS=el DIST=6 + arch: arm64 - env: OS=el DIST=6 os: osx - env: OS=el DIST=7 @@ -112,8 +132,6 @@ os: osx - env: OS=fedora DIST=31 os: osx - - env: OS=fedora DIST=rawhide - os: osx - env: OS=ubuntu DIST=xenial os: osx - env: OS=ubuntu DIST=bionic @@ -122,6 +140,8 @@ os: osx - env: OS=ubuntu DIST=eoan os: osx + - env: OS=ubuntu DIST=focal + os: osx - env: OS=debian DIST=jessie os: osx - env: OS=debian DIST=stretch @@ -134,12 +154,22 @@ compiler: clang - env: TARGET=distcheck os: osx + - env: TARGET=distcheck + arch: arm64 - env: TARGET=coverage os: osx - env: TARGET=coverage compiler: clang + - env: TARGET=coverage + arch: arm64 - os: osx compiler: gcc + - os: osx + arch: arm64 + - arch: arm64 + compiler: clang + - env: OS=debian DIST=jessie + arch: arm64 addons: apt: @@ -166,15 +196,13 @@ case "${TRAVIS_OS_NAME:-linux}" in osx) brew update - brew install mysql + brew install mysql postgresql # OS X requires servers to be started explicitly brew services start mysql - # Avoid PostgreSQL upgrade woes, just reinstall the database - brew uninstall --ignore-dependencies postgresql - rm -rf /usr/local/var/postgres - brew install postgresql + brew postgresql-upgrade-database + brew services start postgresql echo "Starting PostgreSQL" pg_ctl -wD /usr/local/var/postgres start @@ -229,7 +257,7 @@ else # To avoid name conflicts, deploy source packages only for # "default", i.e. x86_64 architecture - if [[ -z "${ARCH}" ]]; then + if [[ -z "$ARCH" && "$TRAVIS_CPU_ARCH" == amd64 ]]; then PACKAGECLOUD_GLOB='build/*.{rpm,deb,dsc}' else # Exclude *.src.rpm and *.dsc diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/sysbench-1.0.19/ChangeLog new/sysbench-1.0.20/ChangeLog --- old/sysbench-1.0.19/ChangeLog 2019-12-08 13:04:05.000000000 +0100 +++ new/sysbench-1.0.20/ChangeLog 2020-04-24 17:51:47.000000000 +0200 @@ -1,6 +1,16 @@ +2020-04-24 Alexey Kopytov <[email protected]> + + * version 1.0.20 + * build/CI/packaging: Add arm64 to Travis CI matrix (#358) + * build/CI/packaging: add Ubuntu Focal + * build/CI/packaging: remove Fedora Rawhide from CI matrix + * build/CI/packaging: fix regression tests to work with MySQL 8.0.19+ + * build/CI/packaging: fix macOS builds in Travis + * build/CI/packaging: remove Ubuntu Disco (EOL) + 2019-12-08 Alexey Kopytov <[email protected]> - * version 1.0.18 + * version 1.0.19 * build/CI/packaging: fix Ubuntu packaging for Bionic and later versions * regression tests: compatibility fix for PostgreSQL 12 * build/CI/packaging: fix macOs builds in Travis diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/sysbench-1.0.19/configure.ac new/sysbench-1.0.20/configure.ac --- old/sysbench-1.0.19/configure.ac 2019-12-08 13:04:05.000000000 +0100 +++ new/sysbench-1.0.20/configure.ac 2020-04-24 17:51:47.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.19],[https://github.com/akopytov/sysbench/issues], +AC_INIT([sysbench],[1.0.20],[https://github.com/akopytov/sysbench/issues], [sysbench], [https://github.com/akopytov/sysbench]) AC_CONFIG_AUX_DIR([config]) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/sysbench-1.0.19/scripts/buildpack.sh new/sysbench-1.0.20/scripts/buildpack.sh --- old/sysbench-1.0.19/scripts/buildpack.sh 2019-12-08 13:04:05.000000000 +0100 +++ new/sysbench-1.0.20/scripts/buildpack.sh 2020-04-24 17:51:47.000000000 +0200 @@ -55,8 +55,8 @@ "fedora 31 x86_64" "ubuntu xenial x86_64" "ubuntu bionic x86_64" - "ubuntu disco x86_64" "ubuntu eoan x86_64" + "ubuntu focal x86_64" "debian jessie x86_64" "debian stretch x86_64" "debian buster x86_64" @@ -65,7 +65,6 @@ distros_i386=( "ubuntu xenial i386" "ubuntu bionic i386" - "ubuntu disco i386" "ubuntu eoan i386" "debian jessie i386" "debian stretch i386" @@ -78,8 +77,8 @@ "fedora 30 aarch64" "fedora 31 aarch64" "ubuntu bionic aarch64" - "ubuntu disco aarch64" "ubuntu eoan aarch64" + "ubuntu focal aarch64" "ubuntu xenial aarch64" "debian jessie aarch64" "debian stretch aarch64" diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/sysbench-1.0.19/tests/t/api_legacy_sql.t new/sysbench-1.0.20/tests/t/api_legacy_sql.t --- old/sysbench-1.0.19/tests/t/api_legacy_sql.t 2019-12-08 13:04:05.000000000 +0100 +++ new/sysbench-1.0.20/tests/t/api_legacy_sql.t 2020-04-24 17:51:47.000000000 +0200 @@ -50,7 +50,7 @@ *************************** 1. row *************************** t CREATE TABLE `t` ( - `a` int(11) DEFAULT NULL + `a` int* DEFAULT NULL (glob) ) * (glob) $ mysql -uroot sbtest -Nse "SELECT COUNT(DISTINCT a) FROM t" @@ -99,8 +99,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -109,8 +109,8 @@ *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -119,8 +119,8 @@ *************************** 1. row *************************** sbtest3 CREATE TABLE `sbtest3` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -129,8 +129,8 @@ *************************** 1. row *************************** sbtest4 CREATE TABLE `sbtest4` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -139,8 +139,8 @@ *************************** 1. row *************************** sbtest5 CREATE TABLE `sbtest5` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -149,8 +149,8 @@ *************************** 1. row *************************** sbtest6 CREATE TABLE `sbtest6` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -159,8 +159,8 @@ *************************** 1. row *************************** sbtest7 CREATE TABLE `sbtest7` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -169,8 +169,8 @@ *************************** 1. row *************************** sbtest8 CREATE TABLE `sbtest8` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -244,8 +244,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`) @@ -287,8 +287,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -297,8 +297,8 @@ *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -307,8 +307,8 @@ *************************** 1. row *************************** sbtest3 CREATE TABLE `sbtest3` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -317,8 +317,8 @@ *************************** 1. row *************************** sbtest4 CREATE TABLE `sbtest4` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -327,8 +327,8 @@ *************************** 1. row *************************** sbtest5 CREATE TABLE `sbtest5` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -337,8 +337,8 @@ *************************** 1. row *************************** sbtest6 CREATE TABLE `sbtest6` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -347,8 +347,8 @@ *************************** 1. row *************************** sbtest7 CREATE TABLE `sbtest7` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -357,8 +357,8 @@ *************************** 1. row *************************** sbtest8 CREATE TABLE `sbtest8` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -432,8 +432,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `k` int(10) unsigned NOT NULL DEFAULT '0', + `id` int* unsigned NOT NULL AUTO_INCREMENT, (glob) + `k` int* unsigned NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/sysbench-1.0.19/tests/t/script_bulk_insert_mysql.t new/sysbench-1.0.20/tests/t/script_bulk_insert_mysql.t --- old/sysbench-1.0.19/tests/t/script_bulk_insert_mysql.t 2019-12-08 13:04:05.000000000 +0100 +++ new/sysbench-1.0.20/tests/t/script_bulk_insert_mysql.t 2020-04-24 17:51:47.000000000 +0200 @@ -9,15 +9,15 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) PRIMARY KEY (`id`) ) ENGINE=InnoDB * (glob) *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(11) NOT NULL, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) PRIMARY KEY (`id`) ) ENGINE=InnoDB * (glob) ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest3' doesn't exist diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/sysbench-1.0.19/tests/t/script_oltp_delete_mysql.t new/sysbench-1.0.20/tests/t/script_oltp_delete_mysql.t --- old/sysbench-1.0.19/tests/t/script_oltp_delete_mysql.t 2019-12-08 13:04:05.000000000 +0100 +++ new/sysbench-1.0.20/tests/t/script_oltp_delete_mysql.t 2020-04-24 17:51:47.000000000 +0200 @@ -34,8 +34,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -44,8 +44,8 @@ *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -54,8 +54,8 @@ *************************** 1. row *************************** sbtest3 CREATE TABLE `sbtest3` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -64,8 +64,8 @@ *************************** 1. row *************************** sbtest4 CREATE TABLE `sbtest4` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -74,8 +74,8 @@ *************************** 1. row *************************** sbtest5 CREATE TABLE `sbtest5` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -84,8 +84,8 @@ *************************** 1. row *************************** sbtest6 CREATE TABLE `sbtest6` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -94,8 +94,8 @@ *************************** 1. row *************************** sbtest7 CREATE TABLE `sbtest7` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -104,8 +104,8 @@ *************************** 1. row *************************** sbtest8 CREATE TABLE `sbtest8` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -135,8 +135,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -145,8 +145,8 @@ *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -155,8 +155,8 @@ *************************** 1. row *************************** sbtest3 CREATE TABLE `sbtest3` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -165,8 +165,8 @@ *************************** 1. row *************************** sbtest4 CREATE TABLE `sbtest4` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -175,8 +175,8 @@ *************************** 1. row *************************** sbtest5 CREATE TABLE `sbtest5` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -185,8 +185,8 @@ *************************** 1. row *************************** sbtest6 CREATE TABLE `sbtest6` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -195,8 +195,8 @@ *************************** 1. row *************************** sbtest7 CREATE TABLE `sbtest7` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -205,8 +205,8 @@ *************************** 1. row *************************** sbtest8 CREATE TABLE `sbtest8` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -266,8 +266,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/sysbench-1.0.19/tests/t/script_oltp_insert_mysql.t new/sysbench-1.0.20/tests/t/script_oltp_insert_mysql.t --- old/sysbench-1.0.19/tests/t/script_oltp_insert_mysql.t 2019-12-08 13:04:05.000000000 +0100 +++ new/sysbench-1.0.20/tests/t/script_oltp_insert_mysql.t 2020-04-24 17:51:47.000000000 +0200 @@ -34,8 +34,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -44,8 +44,8 @@ *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -54,8 +54,8 @@ *************************** 1. row *************************** sbtest3 CREATE TABLE `sbtest3` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -64,8 +64,8 @@ *************************** 1. row *************************** sbtest4 CREATE TABLE `sbtest4` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -74,8 +74,8 @@ *************************** 1. row *************************** sbtest5 CREATE TABLE `sbtest5` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -84,8 +84,8 @@ *************************** 1. row *************************** sbtest6 CREATE TABLE `sbtest6` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -94,8 +94,8 @@ *************************** 1. row *************************** sbtest7 CREATE TABLE `sbtest7` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -104,8 +104,8 @@ *************************** 1. row *************************** sbtest8 CREATE TABLE `sbtest8` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -135,8 +135,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -145,8 +145,8 @@ *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -155,8 +155,8 @@ *************************** 1. row *************************** sbtest3 CREATE TABLE `sbtest3` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -165,8 +165,8 @@ *************************** 1. row *************************** sbtest4 CREATE TABLE `sbtest4` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -175,8 +175,8 @@ *************************** 1. row *************************** sbtest5 CREATE TABLE `sbtest5` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -185,8 +185,8 @@ *************************** 1. row *************************** sbtest6 CREATE TABLE `sbtest6` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -195,8 +195,8 @@ *************************** 1. row *************************** sbtest7 CREATE TABLE `sbtest7` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -205,8 +205,8 @@ *************************** 1. row *************************** sbtest8 CREATE TABLE `sbtest8` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -266,8 +266,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/sysbench-1.0.19/tests/t/script_oltp_point_select_mysql.t new/sysbench-1.0.20/tests/t/script_oltp_point_select_mysql.t --- old/sysbench-1.0.19/tests/t/script_oltp_point_select_mysql.t 2019-12-08 13:04:05.000000000 +0100 +++ new/sysbench-1.0.20/tests/t/script_oltp_point_select_mysql.t 2020-04-24 17:51:47.000000000 +0200 @@ -34,8 +34,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -44,8 +44,8 @@ *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -54,8 +54,8 @@ *************************** 1. row *************************** sbtest3 CREATE TABLE `sbtest3` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -64,8 +64,8 @@ *************************** 1. row *************************** sbtest4 CREATE TABLE `sbtest4` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -74,8 +74,8 @@ *************************** 1. row *************************** sbtest5 CREATE TABLE `sbtest5` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -84,8 +84,8 @@ *************************** 1. row *************************** sbtest6 CREATE TABLE `sbtest6` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -94,8 +94,8 @@ *************************** 1. row *************************** sbtest7 CREATE TABLE `sbtest7` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -104,8 +104,8 @@ *************************** 1. row *************************** sbtest8 CREATE TABLE `sbtest8` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -135,8 +135,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -145,8 +145,8 @@ *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -155,8 +155,8 @@ *************************** 1. row *************************** sbtest3 CREATE TABLE `sbtest3` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -165,8 +165,8 @@ *************************** 1. row *************************** sbtest4 CREATE TABLE `sbtest4` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -175,8 +175,8 @@ *************************** 1. row *************************** sbtest5 CREATE TABLE `sbtest5` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -185,8 +185,8 @@ *************************** 1. row *************************** sbtest6 CREATE TABLE `sbtest6` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -195,8 +195,8 @@ *************************** 1. row *************************** sbtest7 CREATE TABLE `sbtest7` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -205,8 +205,8 @@ *************************** 1. row *************************** sbtest8 CREATE TABLE `sbtest8` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -266,8 +266,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/sysbench-1.0.19/tests/t/script_oltp_read_write_mysql.t new/sysbench-1.0.20/tests/t/script_oltp_read_write_mysql.t --- old/sysbench-1.0.19/tests/t/script_oltp_read_write_mysql.t 2019-12-08 13:04:05.000000000 +0100 +++ new/sysbench-1.0.20/tests/t/script_oltp_read_write_mysql.t 2020-04-24 17:51:47.000000000 +0200 @@ -38,8 +38,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -48,8 +48,8 @@ *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -58,8 +58,8 @@ *************************** 1. row *************************** sbtest3 CREATE TABLE `sbtest3` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -68,8 +68,8 @@ *************************** 1. row *************************** sbtest4 CREATE TABLE `sbtest4` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -78,8 +78,8 @@ *************************** 1. row *************************** sbtest5 CREATE TABLE `sbtest5` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -88,8 +88,8 @@ *************************** 1. row *************************** sbtest6 CREATE TABLE `sbtest6` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -98,8 +98,8 @@ *************************** 1. row *************************** sbtest7 CREATE TABLE `sbtest7` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -108,8 +108,8 @@ *************************** 1. row *************************** sbtest8 CREATE TABLE `sbtest8` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -139,8 +139,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -149,8 +149,8 @@ *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -159,8 +159,8 @@ *************************** 1. row *************************** sbtest3 CREATE TABLE `sbtest3` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -169,8 +169,8 @@ *************************** 1. row *************************** sbtest4 CREATE TABLE `sbtest4` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -179,8 +179,8 @@ *************************** 1. row *************************** sbtest5 CREATE TABLE `sbtest5` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -189,8 +189,8 @@ *************************** 1. row *************************** sbtest6 CREATE TABLE `sbtest6` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -199,8 +199,8 @@ *************************** 1. row *************************** sbtest7 CREATE TABLE `sbtest7` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -209,8 +209,8 @@ *************************** 1. row *************************** sbtest8 CREATE TABLE `sbtest8` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -270,8 +270,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`) @@ -316,8 +316,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -326,8 +326,8 @@ *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -336,8 +336,8 @@ *************************** 1. row *************************** sbtest3 CREATE TABLE `sbtest3` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -346,8 +346,8 @@ *************************** 1. row *************************** sbtest4 CREATE TABLE `sbtest4` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -356,8 +356,8 @@ *************************** 1. row *************************** sbtest5 CREATE TABLE `sbtest5` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -366,8 +366,8 @@ *************************** 1. row *************************** sbtest6 CREATE TABLE `sbtest6` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -376,8 +376,8 @@ *************************** 1. row *************************** sbtest7 CREATE TABLE `sbtest7` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -386,8 +386,8 @@ *************************** 1. row *************************** sbtest8 CREATE TABLE `sbtest8` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -417,8 +417,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -427,8 +427,8 @@ *************************** 1. row *************************** sbtest2 CREATE TABLE `sbtest2` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -437,8 +437,8 @@ *************************** 1. row *************************** sbtest3 CREATE TABLE `sbtest3` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -447,8 +447,8 @@ *************************** 1. row *************************** sbtest4 CREATE TABLE `sbtest4` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -457,8 +457,8 @@ *************************** 1. row *************************** sbtest5 CREATE TABLE `sbtest5` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -467,8 +467,8 @@ *************************** 1. row *************************** sbtest6 CREATE TABLE `sbtest6` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -477,8 +477,8 @@ *************************** 1. row *************************** sbtest7 CREATE TABLE `sbtest7` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -487,8 +487,8 @@ *************************** 1. row *************************** sbtest8 CREATE TABLE `sbtest8` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -548,8 +548,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/sysbench-1.0.19/tests/t/script_select_random_mysql.t new/sysbench-1.0.20/tests/t/script_select_random_mysql.t --- old/sysbench-1.0.19/tests/t/script_select_random_mysql.t 2019-12-08 13:04:05.000000000 +0100 +++ new/sysbench-1.0.20/tests/t/script_select_random_mysql.t 2020-04-24 17:51:47.000000000 +0200 @@ -12,8 +12,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`), @@ -82,8 +82,8 @@ *************************** 1. row *************************** sbtest1 CREATE TABLE `sbtest1` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `k` int(11) NOT NULL DEFAULT '0', + `id` int* NOT NULL AUTO_INCREMENT, (glob) + `k` int* NOT NULL DEFAULT '0', (glob) `c` char(120)* NOT NULL DEFAULT '', (glob) `pad` char(60)* NOT NULL DEFAULT '', (glob) PRIMARY KEY (`id`),
