Linux nanna21 2.6.18-92.1.10.el5 #1 SMP Wed Jul 23 03:55:54 EDT 2008 i686 athlon i386 GNU/Linux Sat Jul 31 01:54:47 CEST 2010 + cd /export/home/pb2/test/sb_1-2097958-1280534082.95 + SOURCE=mysql-5.5.6-m3-linux-i686.tar.gz + export SOURCE + SOURCENAME=mysql-5.5.6-m3-linux-i686 + export SOURCENAME + TMPDIR=/export/home/pb2/test/sb_1-2097958-1280534082.95/tmp + export TMPDIR + PB2WORKDIR=/export/home/pb2/test/sb_1-2097958-1280534082.95 + export PB2WORKDIR + BRANCH_ID=146 + export BRANCH_ID + PRODUCT_ID=test-sysqa_rqg_mdl_stability-linux-x86 + export PRODUCT_ID + BRANCH_NAME=mysql-trunk-bugfixing + export BRANCH_NAME + SOURCE2NAME=unittest + export SOURCE2NAME + SOURCE2=unittest.tar.gz + export SOURCE2 + PARENT_ID=2097958 + export PARENT_ID + SOURCE1=Makefile + export SOURCE1 + SOURCE1NAME=Makefile + export SOURCE1NAME + PUSH_REVISION=davi.arnaut@oracle.com-20100730212954-rz2jdms37ne20ams + export PUSH_REVISION + PUSH_ID=1452930 + export PUSH_ID + BRANCH_SOURCE=http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-bugfixing/ + export BRANCH_SOURCE + echo '[SOURCEBUILDER] POLICY mysql-5.5.6-m3-linux-i686-test/vardirs' [SOURCEBUILDER] POLICY mysql-5.5.6-m3-linux-i686-test/vardirs + RESULT=0 + grep 'no gnutar' which: no gnutar in (/usr/local/bin:/bin:/usr/bin) + echo no gnutar no gnutar + gunzip -c mysql-5.5.6-m3-linux-i686.tar.gz + tar xf - tar: Read 5632 bytes from - + true + mv mysql-5.5.6-m3-linux-i686 mysql-5.5.6-m3-linux-i686-test + cd mysql-5.5.6-m3-linux-i686-test + mkdir vardirs ++ pwd + DIR=/export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test + cd /export/home/pb2/scripts + perl pb2gentest-new.pl /export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test /export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test/vardirs http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-bugfixing/ rqg_mdl_stability ==================== Starting pb2gentest-new.pl ==================== ############################################################################## # rqg_mdl_stability ############################################################################## # 2010-07-31T01:54:51 Gathering info from the environment... # 2010-07-31T01:54:56 ===== Information on the host system: ===== # 2010-07-31T01:54:56 - Local time : Sat Jul 31 01:54:56 2010 # 2010-07-31T01:54:56 - Hostname : nanna21 # 2010-07-31T01:54:56 - Username : bteam # 2010-07-31T01:54:56 - PID : 25691 # 2010-07-31T01:54:56 - Working dir : /export/home/pb2/scripts/http_randgen # 2010-07-31T01:54:56 - PATH : /usr/local/bin:/bin:/usr/bin # 2010-07-31T01:54:56 - Script arguments: # 2010-07-31T01:54:56 basedir = /export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test # 2010-07-31T01:54:56 vardir = /export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test/vardirs # 2010-07-31T01:54:56 tree = http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-bugfixing/ # 2010-07-31T01:54:56 test = rqg_mdl_stability # 2010-07-31T01:54:56 ===== Information on the tested binaries (PB2): ===== # 2010-07-31T01:54:56 - Branch URL : http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-bugfixing/ # 2010-07-31T01:54:56 - Branch name : mysql-trunk-bugfixing # 2010-07-31T01:54:56 - Revision : davi.arnaut@oracle.com-20100730212954-rz2jdms37ne20ams # 2010-07-31T01:54:56 - Source : mysql-5.5.6-m3-linux-i686.tar.gz # 2010-07-31T01:54:56 ===== Information on Random Query Generator version (bzr): ===== # 2010-07-31T01:54:56 - Date (rev) : 2010-07-15 11:37:13 +0200 # 2010-07-31T01:54:56 - Revno : 481 # 2010-07-31T01:54:56 - Revision ID : john.embretsen@sun.com-20100715093713-rrbtthuhfkkctudc # 2010-07-31T01:54:56 - Branch nick : http_randgen # 2010-07-31T01:54:56 - Clean copy? : Yes # 2010-07-31T01:54:56 Configuring test... # 2010-07-31T01:54:56 XML reporting to TestTool automatically enabled based on hostname. # 2010-07-31T01:54:56 Running runall-new.pl... # 2010-07-31T01:54:56 Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2010-07-31T01:54:56 Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2010-07-31T01:54:56 Starting # 2010-07-31T01:54:56 # runall-new.pl \ # 2010-07-31T01:54:56 # --mysqld=--loose-skip-safemalloc \ # 2010-07-31T01:54:56 # --grammar=conf/runtime/metadata_stability.yy \ # 2010-07-31T01:54:56 # --gendata=conf/runtime/metadata_stability.zz \ # 2010-07-31T01:54:56 # --validator=SelectStability,QueryProperties \ # 2010-07-31T01:54:56 # --engine=Innodb \ # 2010-07-31T01:54:56 # --mysqld=--innodb \ # 2010-07-31T01:54:56 # --mysqld=--default-storage-engine=Innodb \ # 2010-07-31T01:54:56 # --mysqld=--transaction-isolation=SERIALIZABLE \ # 2010-07-31T01:54:56 # --mysqld=--innodb-flush-log-at-trx-commit=2 \ # 2010-07-31T01:54:56 # --mysqld=--loose-table-lock-wait-timeout=1 \ # 2010-07-31T01:54:56 # --mysqld=--innodb-lock-wait-timeout=1 \ # 2010-07-31T01:54:56 # --mysqld=--log-output=file \ # 2010-07-31T01:54:56 # --queries=1M \ # 2010-07-31T01:54:56 # --duration=600 \ # 2010-07-31T01:54:56 # --reporters=Deadlock,ErrorLog,Backtrace \ # 2010-07-31T01:54:56 # --basedir=/export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test \ # 2010-07-31T01:54:56 # --vardir=/export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test/vardirs \ # 2010-07-31T01:54:56 # --mysqld=--loose-lock-wait-timeout=1 \ # 2010-07-31T01:54:56 # --testname=rqg_mdl_stability \ # 2010-07-31T01:54:56 # --xml-output=/export/home/pb2/test/sb_1-2097958-1280534082.95/tmp/rqg_mdl_stability.xml \ # 2010-07-31T01:54:56 # --report-xml-tt \ # 2010-07-31T01:54:56 # --report-xml-tt-type=scp \ # 2010-07-31T01:54:56 # --report-xml-tt-dest=regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-07-31T01:54:56 master_port : 19300 slave_port : 19302 ports : 19300 19302 MTR_BUILD_THREAD : 930 # 2010-07-31T01:54:56 Creating MySQL 5.5.6-m3 database at /export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test/vardirs/data # 2010-07-31T01:54:59 Starting MySQL 5.5.6-m3: "/export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test/bin/mysqld" "--no-defaults" "--basedir=/export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test" "--datadir=/export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test/vardirs/data" "--lc-messages-dir=/export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test/share" "--character-sets-dir=/export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test/share/charsets" "--default-storage-engine=myisam" "--log-warnings=0" "--core-file" "--loose-new" "--relay-log=slave-relay-bin" "--loose-innodb" "--max-allowed-packet=16Mb" "--loose-innodb-status-file=1" "--master-retry-count=65535" "--port=19300" "--socket=/tmp/RQGmysql.19300.sock" "--pid-file=/export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test/vardirs/mysql.pid" "--general-log-file=/export/home/pb2/test/sb_1-2097958-1280534082.95/mysql-5.5.6-m3-linux-i686-test/vardirs/mysql.err" --innodb --sql-mode=no_engine_substitution --loose-skip-safemalloc --innodb --default-storage-engine=Innodb --transaction-isolation=SERIALIZABLE --innodb-flush-log-at-trx-commit=2 --loose-table-lock-wait-timeout=1 --innodb-lock-wait-timeout=1 --log-output=file --loose-lock-wait-timeout=1 # 2010-07-31T01:55:00 ------------------------------- # 2010-07-31T01:55:00 Configuration # 2010-07-31T01:55:00 dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test'] # 2010-07-31T01:55:00 duration => 600 # 2010-07-31T01:55:00 engine => Innodb # 2010-07-31T01:55:00 gendata => conf/runtime/metadata_stability.zz # 2010-07-31T01:55:00 grammar => conf/runtime/metadata_stability.yy # 2010-07-31T01:55:00 queries => 1M # 2010-07-31T01:55:00 report-xml-tt => 1 # 2010-07-31T01:55:00 report-xml-tt-dest => regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-07-31T01:55:00 report-xml-tt-type => scp # 2010-07-31T01:55:00 reporters => ['Deadlock', 'ErrorLog', 'Backtrace'] # 2010-07-31T01:55:00 testname => rqg_mdl_stability # 2010-07-31T01:55:00 threads => 10 # 2010-07-31T01:55:00 validators => ['SelectStability', 'QueryProperties'] # 2010-07-31T01:55:00 xml-output => /export/home/pb2/test/sb_1-2097958-1280534082.95/tmp/rqg_mdl_stability.xml # 2010-07-31T01:55:00 Default schema: test # 2010-07-31T01:55:00 # Creating MySQL table: test.table10_innodb; engine: innodb; rows: 10 . # 2010-07-31T01:55:00 # Creating MySQL table: test.table11_innodb; engine: innodb; rows: 11 . # 2010-07-31T01:55:00 Reporters: Deadlock, ErrorLog, Backtrace # 2010-07-31T01:55:00 Validators: SelectStability, QueryProperties # 2010-07-31T01:55:00 Starting 10 processes, 1M queries each, duration 600 seconds. # 2010-07-31T01:55:05 GenTest::ErrorFilter(25875) started # 2010-07-31T01:55:05 Default schema: test # 2010-07-31T01:55:05 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-31T01:55:05 Default schema: test # 2010-07-31T01:55:05 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-31T01:55:05 Query: SELECT /* QUERY_ID: 6174976 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM table_2 WHERE 9 <> func_2 ( `col_int_key` ) failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-31T01:55:05 Query: SELECT /* QUERY_ID: 14594816 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 5 ) AS `col_int_key` FROM table10_innodb WHERE `col_int_key` < func_2 ( 9 ) failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-31T01:55:05 Query: CALL /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ proc_2 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-31T01:55:05 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 8002048 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM `table10_innodb` failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2010-07-31T01:55:05 Default schema: test # 2010-07-31T01:55:05 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-31T01:55:05 Default schema: test # 2010-07-31T01:55:05 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-31T01:55:05 Default schema: test # 2010-07-31T01:55:05 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-31T01:55:06 Default schema: test # 2010-07-31T01:55:06 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-31T01:55:06 Query: UPDATE table11_innodb SET `col_int_key` = 9 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-31T01:55:06 Default schema: test # 2010-07-31T01:55:06 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-31T01:55:06 Default schema: test # 2010-07-31T01:55:06 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-31T01:55:06 Default schema: test # 2010-07-31T01:55:06 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-31T01:55:06 Default schema: test # 2010-07-31T01:55:06 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-31T01:55:06 Started periodic reporting process... # 2010-07-31T01:55:07 Query: UPDATE table11_innodb SET `col_int_key` = 5 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-31T01:55:07 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 9 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-31T01:55:08 Query: ALTER TABLE table10_innodb ADD COLUMN `default` INTEGER DEFAULT 6 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-31T01:55:08 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 0 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-31T01:55:09 Query: CREATE PROCEDURE proc_2 (INOUT inout1 INT) BEGIN SELECT func_3 ( 6 ) FROM table11_innodb ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-31T01:55:09 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 3422464 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM `table10_innodb` failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-31T01:55:12 Query: INSERT INTO table10_innodb SELECT * FROM table10_innodb LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-31T01:55:12 Query: DROP TRIGGER trigger_2 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-31T01:55:12 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9336064 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 7 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:55:12 Query: ALTER TABLE table11_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 2 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-31T01:55:12 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table11_innodb FOR EACH ROW UPDATE table_3 SET `col_int_key` = 4 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-31T01:55:17 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 127232 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 1 ) AS `col_int_key` FROM `table11_innodb` WHERE func_1 ( func_1 ( func_3 ( 3 ) ) ) < 8 failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-31T01:55:39 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_1 AS SELECT /* QUERY_ID: 10183936 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM table_3 failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-31T01:55:40 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 6257664 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:55:51 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 12961280 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_1 WHERE 1 <> `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:55:59 Query: ALTER TABLE table_1 CHANGE COLUMN `default` `default` INTEGER DEFAULT 2 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-31T01:56:09 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 995840 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 6 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:56:21 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15964416 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:56:22 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 9109760 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 9 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:56:33 Query: SELECT /* QUERY_ID: 9227520 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM table_2 WHERE 3 < `col_int_key`; returns different result when executed after a delay of 0 seconds. # 2010-07-31T01:56:33 --- /export/home/pb2/test/sb_1-2097958-1280534082.95/tmp//randgen25887-1280534193-server0.dump 2010-07-31 01:56:33.000000000 +0200 # 2010-07-31T01:56:33 +++ /export/home/pb2/test/sb_1-2097958-1280534082.95/tmp//randgen25887-1280534193-server1.dump 2010-07-31 01:56:33.000000000 +0200 # 2010-07-31T01:56:33 @@ -1,11 +0,0 @@ # 2010-07-31T01:56:33 -1 # 2010-07-31T01:56:33 -1 # 2010-07-31T01:56:33 -1 # 2010-07-31T01:56:33 -1 # 2010-07-31T01:56:33 -1 # 2010-07-31T01:56:33 -1 # 2010-07-31T01:56:33 -1 # 2010-07-31T01:56:33 -1 # 2010-07-31T01:56:33 -1 # 2010-07-31T01:56:33 -1 # 2010-07-31T01:56:33 -1 # 2010-07-31T01:56:35 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 11395840 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 4 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:56:35 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 4948736 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 4 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:56:55 Query: SELECT /* QUERY_ID: 12369664 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM table_2 WHERE `col_int_key` <> 3; returns different result when executed after a delay of 0.1 seconds. # 2010-07-31T01:56:55 --- /export/home/pb2/test/sb_1-2097958-1280534082.95/tmp//randgen25893-1280534215-server0.dump 2010-07-31 01:56:55.000000000 +0200 # 2010-07-31T01:56:55 +++ /export/home/pb2/test/sb_1-2097958-1280534082.95/tmp//randgen25893-1280534215-server1.dump 2010-07-31 01:56:55.000000000 +0200 # 2010-07-31T01:56:55 @@ -1,11 +0,0 @@ # 2010-07-31T01:56:55 -2 # 2010-07-31T01:56:55 -2 # 2010-07-31T01:56:55 -2 # 2010-07-31T01:56:55 -2 # 2010-07-31T01:56:55 -2 # 2010-07-31T01:56:55 -2 # 2010-07-31T01:56:55 -2 # 2010-07-31T01:56:55 -2 # 2010-07-31T01:56:55 -2 # 2010-07-31T01:56:55 -2 # 2010-07-31T01:56:55 -2 # 2010-07-31T01:57:03 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 16248064 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_1 WHERE 9 < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:57:03 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9741824 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_1 WHERE func_1 ( 7 ) <> func_2 ( `col_int_key` ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:57:04 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 7958784 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE 2 < func_3 ( 0 ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:57:05 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1300224 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 3 ) AS `col_int_key` FROM view_1 WHERE `col_int_key` <> 5 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:57:19 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 8104448 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM view_1 WHERE 8 < 7 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:57:31 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 10707968 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 5 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:57:36 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 8486656 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 8 ) AS `col_int_key` FROM view_1 WHERE func_2 ( 7 ) <> 1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:57:39 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 4115968 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 8 ) AS `col_int_key` FROM view_1 WHERE `col_int_key` < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:57:42 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9079808 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:57:48 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 2931968 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 0 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:57:50 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 5771008 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE `col_int_key` <> func_1 ( `col_int_key` ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:57:59 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 8370944 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:02 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 7393280 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_1 WHERE `col_int_key` < func_1 ( `col_int_key` ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:05 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 6409728 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 1 ) AS `col_int_key` FROM view_1 WHERE 4 <> 6 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:06 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 6573568 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 8 ) AS `col_int_key` FROM view_1 WHERE func_2 ( `col_int_key` ) <> func_2 ( 0 ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:09 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 16742144 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 2 ) AS `col_int_key` FROM view_1 WHERE 1 <> func_3 ( 4 ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:12 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10321152 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:14 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 6669312 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 6 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:16 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 7987200 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM view_1 WHERE 0 < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:17 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 254208 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 8 ) AS `col_int_key` FROM view_1 WHERE func_1 ( 2 ) <> 1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:19 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 719360 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 1 ) AS `col_int_key` FROM view_1 WHERE 5 < 0 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:23 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 10337536 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 8 ) AS `col_int_key` FROM view_1 WHERE func_2 ( func_1 ( func_1 ( 7 ) ) ) <> func_1 ( 2 ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:23 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 3677440 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:35 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 5942528 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 6 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:42 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11727360 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE func_1 ( 8 ) <> `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:43 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 4916736 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 7 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:58 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 8018176 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE 3 < func_3 ( `col_int_key` ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:58:58 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 12995328 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE 9 < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:03 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15284224 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_1 WHERE 6 <> func_3 ( 6 ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:03 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 5221888 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 2 ) AS `col_int_key` FROM view_1 WHERE func_2 ( func_1 ( func_2 ( func_3 ( `col_int_key` ) ) ) ) < 7 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:06 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 14805760 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 4 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:08 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 4101376 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 6 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:13 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15187712 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE func_1 ( 6 ) <> `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:14 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 5515008 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:14 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 3533824 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 0 ) AS `col_int_key` FROM view_1 WHERE func_3 ( 6 ) < 6 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:15 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 7688960 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 6 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:21 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 9386240 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 4 ) AS `col_int_key` FROM view_1 WHERE `col_int_key` <> 7 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:25 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 15654144 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 5 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:31 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 10980096 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 7 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:35 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 4710144 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE 0 < 2 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:37 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 5811456 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 3 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:40 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 6477824 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:44 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 3342592 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:46 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11526144 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:46 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 15079424 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:46 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 9152000 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:47 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9203200 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM view_1 WHERE func_3 ( func_3 ( `col_int_key` ) ) <> 0 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:51 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 1795072 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 4 ) AS `col_int_key` FROM view_1 WHERE func_1 ( `col_int_key` ) < 8 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:57 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 16523520 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE func_3 ( `col_int_key` ) < 1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T01:59:58 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 6364160 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM view_1 WHERE `col_int_key` < func_3 ( `col_int_key` ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:03 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 16329216 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE `col_int_key` < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:06 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1188096 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:09 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9206528 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE 1 <> 1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:11 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 2754304 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM view_1 WHERE func_1 ( 5 ) < 5 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:14 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 1911040 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 4 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:15 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9449472 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 3 ) AS `col_int_key` FROM view_1 WHERE func_3 ( func_1 ( `col_int_key` ) ) < 2 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:20 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 15881472 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:27 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9053952 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 1 ) AS `col_int_key` FROM view_1 WHERE func_3 ( `col_int_key` ) <> `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:32 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 8404992 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE func_2 ( 4 ) <> `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:33 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1093632 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM view_1 WHERE `col_int_key` < func_1 ( func_2 ( 2 ) ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:36 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15707136 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE 3 <> `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:36 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 3177472 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:37 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 15564288 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_1 WHERE func_1 ( 0 ) < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:39 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15625984 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM view_1 WHERE 8 <> `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:46 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10573056 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE func_1 ( 8 ) <> func_3 ( func_2 ( func_1 ( 7 ) ) ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:51 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 5522688 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 0 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:00:52 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 6601728 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE 3 < func_3 ( `col_int_key` ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:01:11 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 14274304 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 4 ) AS `col_int_key` FROM view_1 WHERE func_3 ( func_3 ( func_3 ( 1 ) ) ) < 7 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:01:13 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11625216 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:01:14 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 6566656 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_1 WHERE func_3 ( `col_int_key` ) < 4 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:01:14 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11376896 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_1 WHERE 2 < 6 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:01:31 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 13804544 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM view_1 WHERE 0 < func_2 ( 0 ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:01:34 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9400832 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 9 ) AS `col_int_key` FROM view_1 WHERE `col_int_key` < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:01:37 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 2236416 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:01:49 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 2193920 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:01:51 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 2003712 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 6 AS `col_int_key` FROM view_1 WHERE `col_int_key` < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:01:52 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 13625088 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:01:56 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 10364416 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM view_1 WHERE func_1 ( `col_int_key` ) <> func_3 ( func_2 ( 0 ) ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:05 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 8125696 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 7 ) AS `col_int_key` FROM view_1 WHERE 6 <> `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:11 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 6375168 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:18 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 5624320 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 5 ) AS `col_int_key` FROM view_1 WHERE 2 <> func_1 ( 6 ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:18 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 11284992 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:20 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 13830912 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 5 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:25 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 16472320 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE `col_int_key` < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:27 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9061120 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 8 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:32 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 12145152 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE 6 < 1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:33 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 16631296 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 1 ) AS `col_int_key` FROM view_1 WHERE func_1 ( 6 ) < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:38 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 14812416 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 5 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:43 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 12994816 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 6 AS `col_int_key` FROM view_1 WHERE func_3 ( func_2 ( 1 ) ) < 3 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:43 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10921216 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM view_1 WHERE 7 <> `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:50 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 353536 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:51 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 4104448 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE func_1 ( func_1 ( func_2 ( func_2 ( 9 ) ) ) ) < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:54 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 4013824 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:57 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 14329600 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:02:58 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11807488 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM view_1 WHERE 0 < func_3 ( func_2 ( 0 ) ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:00 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 887296 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE 3 < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:05 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 8334592 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:21 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 8509952 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE func_1 ( 0 ) <> func_3 ( `col_int_key` ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:23 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10285056 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 3 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:23 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9255168 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 3 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:27 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 1862144 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 4 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:30 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 1457408 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:31 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1634560 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 7 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:39 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 14090496 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:48 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 4637952 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 3 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:51 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 384768 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:54 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9016576 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_1 WHERE func_3 ( func_3 ( 6 ) ) < 3 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:55 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 6558976 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 6 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:03:59 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 16478208 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 9 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:03 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 7443968 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 9 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:04 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 13341184 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 3 ) AS `col_int_key` FROM view_1 WHERE `col_int_key` <> 5 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:07 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10062336 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:08 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 16425472 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 7 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:12 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 1378816 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_1 WHERE 9 < func_3 ( `col_int_key` ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:16 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 12231424 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:23 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 5527552 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE func_1 ( 9 ) < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:24 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 3328512 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:28 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 8315136 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 2 ) AS `col_int_key` FROM view_1 WHERE 2 <> func_1 ( func_3 ( 2 ) ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:28 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 12900864 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 6 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:36 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 2697472 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE `col_int_key` < func_2 ( 3 ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:40 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 5020416 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:42 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1922048 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:43 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 838912 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:49 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 16603648 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:04:58 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 3321344 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:05:01 Child process completed successfully. # 2010-07-31T02:05:01 Child process completed successfully. # 2010-07-31T02:05:01 Child process completed successfully. # 2010-07-31T02:05:01 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 3283712 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-31T02:05:01 Child process completed successfully. # 2010-07-31T02:05:01 Child process completed successfully. # 2010-07-31T02:05:01 Child process completed with error code 32. # 2010-07-31T02:05:01 Child process completed with error code 32. # 2010-07-31T02:05:01 Child process completed successfully. # 2010-07-31T02:05:01 Child process completed successfully. # 2010-07-31T02:05:01 Child process completed successfully. # 2010-07-31T02:05:02 Killing periodic reporting process with pid 25876... # 2010-07-31T02:05:02 Kill GenTest::ErrorFilter(25875) # 2010-07-31T02:05:05 XML report written to /export/home/pb2/test/sb_1-2097958-1280534082.95/tmp/rqg_mdl_stability.xml # 2010-07-31T02:05:05 XML Transport type: SCP # 2010-07-31T02:05:05 SCP command is: scp /export/home/pb2/test/sb_1-2097958-1280534082.95/tmp/rqg_mdl_stability.xml regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-07-31T02:05:05 Test completed with failure status 32. # 2010-07-31T02:05:05 GenTest exited with exit status 32 # 2010-07-31T02:05:05 Stopping server on port 19300 # 2010-07-31T02:05:10 [25701] runall-new.pl will exit with exit status 32 serverqa.rqg_mdl_stability [ fail ] # 2010-07-31T02:05:10 runall.pl failed with exit code 32 # 2010-07-31T02:05:10 Look above this message in the test log for failure details. # 2010-07-31T02:05:10 Checking for remaining mysqld processes... # 2010-07-31T02:05:10 None found. # 2010-07-31T02:05:10 [25691] pb2gentest-new.pl will exit with exit status 32 + grep 'no gnutar' which: no gnutar in (/usr/local/bin:/bin:/usr/bin) + echo no gnutar no gnutar + tar cf mysql-5.5.6-m3-linux-i686-test.tar mysql-5.5.6-m3-linux-i686-test/vardirs + true + gzip mysql-5.5.6-m3-linux-i686-test.tar + true + ls -l mysql-5.5.6-m3-linux-i686-test.tar.gz -rw-r--r-- 1 bteam wheel 3565226 Jul 31 02:05 mysql-5.5.6-m3-linux-i686-test.tar.gz + test x0 = x1 + echo '[SOURCEBUILDER] FAIL mysql-5.5.6-m3-linux-i686-test.tar.gz' [SOURCEBUILDER] FAIL mysql-5.5.6-m3-linux-i686-test.tar.gz + exit