Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. P:\>G: G:\>cd "G:\pb2\test\sb_1-2056679-1279532946.85" G:\pb2\test\sb_1-2056679-1279532946.85>set SOURCE=mysql-5.5.6-m3-win-x86.zip G:\pb2\test\sb_1-2056679-1279532946.85>set SOURCENAME=mysql-5.5.6-m3-win-x86 G:\pb2\test\sb_1-2056679-1279532946.85>set PB2WORKDIR=G:\pb2\test\sb_1-2056679-1279532946.85 G:\pb2\test\sb_1-2056679-1279532946.85>set BRANCH_ID=226 G:\pb2\test\sb_1-2056679-1279532946.85>set PRODUCT_ID=test-sysqa_rqg_mdl_stability-win-x86 G:\pb2\test\sb_1-2056679-1279532946.85>set BRANCH_NAME=mysql-trunk-runtime G:\pb2\test\sb_1-2056679-1279532946.85>set PARENT_ID=2056679 G:\pb2\test\sb_1-2056679-1279532946.85>set PUSH_REVISION=jon.hauglid@oracle.com-20100719082753-xn93j8pwxa1lvca5 G:\pb2\test\sb_1-2056679-1279532946.85>set PUSH_ID=1424881 G:\pb2\test\sb_1-2056679-1279532946.85>set BRANCH_SOURCE=http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-runtime/ G:\pb2\test\sb_1-2056679-1279532946.85> G:\pb2\test\sb_1-2056679-1279532946.85>set PATH=%PATH%;C:\Program Files\GnuWin32\bin G:\pb2\test\sb_1-2056679-1279532946.85>perl perl pb2gentest-new.pl G:/pb2/test/sb_1-2056679-1279532946.85/mysql-5.5.6-m3-win-x86-test G:/pb2/test/sb_1-2056679-1279532946.85/mysql-5.5.6-m3-win-x86-test/vardirs http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-runtime/ rqg_mdl_stability ==================== Starting pb2gentest-new.pl ==================== ############################################################################## # rqg_mdl_stability ############################################################################## # 2010-07-19T11:50:53 Gathering info from the environment... # 2010-07-19T11:50:53 ===== Information on the host system: ===== # 2010-07-19T11:50:53 - Local time : Mon Jul 19 11:50:53 2010 # 2010-07-19T11:50:53 - Hostname : loki06 # 2010-07-19T11:50:53 - Username : qauser # 2010-07-19T11:50:53 - PID : 5828 # 2010-07-19T11:50:53 - Working dir : G:/pb2/scripts/randgen # 2010-07-19T11:50:53 - PATH : G:\pb2\scripts\randgen\bin;G:\pb2\scripts\bin;C:\Program Files\Debugging Tools for Windows (x86);C:\Perl\site\bin;C:\Perl\bin;C:\Perl\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\SFU\common\;C:\Program Files\NTP\bin;C:\Program Files\Bazaar;C:\Program Files\GnuWin32\bin;C:\Program Files\GnuWin32\bin # 2010-07-19T11:50:53 - Script arguments: # 2010-07-19T11:50:53 basedir = G:/pb2/test/sb_1-2056679-1279532946.85/mysql-5.5.6-m3-win-x86-test # 2010-07-19T11:50:53 vardir = G:/pb2/test/sb_1-2056679-1279532946.85/mysql-5.5.6-m3-win-x86-test/vardirs # 2010-07-19T11:50:53 tree = http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-runtime/ # 2010-07-19T11:50:53 test = rqg_mdl_stability # 2010-07-19T11:50:53 ===== Information on the tested binaries (PB2): ===== # 2010-07-19T11:50:53 - Branch URL : http://bk-internal.mysql.com/bzr-mysql/mysql-trunk-runtime/ # 2010-07-19T11:50:53 - Branch name : mysql-trunk-runtime # 2010-07-19T11:50:53 - Revision : jon.hauglid@oracle.com-20100719082753-xn93j8pwxa1lvca5 # 2010-07-19T11:50:53 - Source : mysql-5.5.6-m3-win-x86.zip # 2010-07-19T11:50:53 ===== Information on Random Query Generator version (bzr): ===== # 2010-07-19T11:50:53 - Date (rev) : 2010-07-15 11:37:13 +0200 # 2010-07-19T11:50:53 - Revno : 481 # 2010-07-19T11:50:53 - Revision ID : john.embretsen@sun.com-20100715093713-rrbtthuhfkkctudc # 2010-07-19T11:50:53 - Branch nick : randgen # 2010-07-19T11:50:53 - Clean copy? : Yes # 2010-07-19T11:50:53 Configuring test... # 2010-07-19T11:50:53 XML reporting to TestTool automatically enabled based on hostname. # 2010-07-19T11:50:53 Running runall-new.pl... # 2010-07-19T11:50:54 Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2010-07-19T11:50:54 Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2010-07-19T11:50:54 Starting # 2010-07-19T11:50:54 # runall-new.pl \ # 2010-07-19T11:50:54 # --mysqld=--loose-skip-safemalloc \ # 2010-07-19T11:50:54 # --grammar=conf/runtime/metadata_stability.yy \ # 2010-07-19T11:50:54 # --gendata=conf/runtime/metadata_stability.zz \ # 2010-07-19T11:50:54 # --validator=SelectStability,QueryProperties \ # 2010-07-19T11:50:54 # --engine=Innodb \ # 2010-07-19T11:50:54 # --mysqld=--innodb \ # 2010-07-19T11:50:54 # --mysqld=--default-storage-engine=Innodb \ # 2010-07-19T11:50:54 # --mysqld=--transaction-isolation=SERIALIZABLE \ # 2010-07-19T11:50:54 # --mysqld=--innodb-flush-log-at-trx-commit=2 \ # 2010-07-19T11:50:54 # --mysqld=--loose-table-lock-wait-timeout=1 \ # 2010-07-19T11:50:54 # --mysqld=--innodb-lock-wait-timeout=1 \ # 2010-07-19T11:50:54 # --mysqld=--log-output=file \ # 2010-07-19T11:50:54 # --queries=1M \ # 2010-07-19T11:50:54 # --duration=600 \ # 2010-07-19T11:50:54 # --reporters=Deadlock,ErrorLog,Backtrace \ # 2010-07-19T11:50:54 # --basedir=G:/pb2/test/sb_1-2056679-1279532946.85/mysql-5.5.6-m3-win-x86-test \ # 2010-07-19T11:50:54 # --vardir=G:/pb2/test/sb_1-2056679-1279532946.85/mysql-5.5.6-m3-win-x86-test/vardirs \ # 2010-07-19T11:50:54 # --mysqld=--loose-lock-wait-timeout=1 \ # 2010-07-19T11:50:54 # --testname=rqg_mdl_stability \ # 2010-07-19T11:50:54 # --xml-output=C:\DOCUME~1\qauser\LOCALS~1\Temp\1\rqg_mdl_stability.xml \ # 2010-07-19T11:50:54 # --report-xml-tt \ # 2010-07-19T11:50:54 # --report-xml-tt-type=scp \ # 2010-07-19T11:50:54 # --report-xml-tt-dest=regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-07-19T11:50:54 master_port : 19300 slave_port : 19302 ports : 19300 19302 MTR_BUILD_THREAD : 930 # 2010-07-19T11:50:54 Found source directory at G:/pb2/build/sb_0-2056603-1279530015.62/mysql-5.5.6-m3-win-x86 # 2010-07-19T11:50:54 Creating MySQL 5.5.6-m3 database at G:/pb2/test/sb_1-2056679-1279532946.85/mysql-5.5.6-m3-win-x86-test/vardirs/data rmdir: `/s': No such file or directory rmdir: `/q': No such file or directory # 2010-07-19T11:51:01 Starting MySQL 5.5.6-m3: G:\pb2\test\sb_1-2056679-1279532946.85\mysql-5.5.6-m3-win-x86-test\sql\Debug\mysqld.exe as "G:\pb2\test\sb_1-2056679-1279532946.85\mysql-5.5.6-m3-win-x86-test\sql\Debug\mysqld.exe" "--no-defaults" "--basedir=G:\pb2\test\sb_1-2056679-1279532946.85\mysql-5.5.6-m3-win-x86-test" "--datadir=G:\pb2\test\sb_1-2056679-1279532946.85\mysql-5.5.6-m3-win-x86-test\vardirs\data" "--lc-messages-dir=G:\pb2\test\sb_1-2056679-1279532946.85\mysql-5.5.6-m3-win-x86-test\sql\share" "--character-sets-dir=G:\pb2\test\sb_1-2056679-1279532946.85\mysql-5.5.6-m3-win-x86-test\sql\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=G:\pb2\test\sb_1-2056679-1279532946.85\mysql-5.5.6-m3-win-x86-test\vardirs\mysql.pid" "--general-log-file=G:\pb2\test\sb_1-2056679-1279532946.85\mysql-5.5.6-m3-win-x86-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 on G:\pb2\test\sb_1-2056679-1279532946.85\mysql-5.5.6-m3-win-x86-test\vardirs # 2010-07-19T11:51:02 ------------------------------- # 2010-07-19T11:51:02 Configuration # 2010-07-19T11:51:02 dsn => ['dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test'] # 2010-07-19T11:51:02 duration => 600 # 2010-07-19T11:51:02 engine => Innodb # 2010-07-19T11:51:02 gendata => conf/runtime/metadata_stability.zz # 2010-07-19T11:51:02 grammar => conf/runtime/metadata_stability.yy # 2010-07-19T11:51:02 queries => 1M # 2010-07-19T11:51:02 report-xml-tt => 1 # 2010-07-19T11:51:02 report-xml-tt-dest => regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-07-19T11:51:02 report-xml-tt-type => scp # 2010-07-19T11:51:02 reporters => ['Deadlock', 'ErrorLog', 'Backtrace'] # 2010-07-19T11:51:02 testname => rqg_mdl_stability # 2010-07-19T11:51:02 threads => 10 # 2010-07-19T11:51:02 validators => ['SelectStability', 'QueryProperties'] # 2010-07-19T11:51:02 xml-output => C:\DOCUME~1\qauser\LOCALS~1\Temp\1\rqg_mdl_stability.xml # 2010-07-19T11:51:02 Default schema: test # 2010-07-19T11:51:02 # Creating MySQL table: test.table10_innodb; engine: innodb; rows: 10 . # 2010-07-19T11:51:02 # Creating MySQL table: test.table11_innodb; engine: innodb; rows: 11 . # 2010-07-19T11:51:02 Reporters: Deadlock, ErrorLog, Backtrace # 2010-07-19T11:51:02 Validators: SelectStability, QueryProperties # 2010-07-19T11:51:02 Starting 10 processes, 1M queries each, duration 600 seconds. # 2010-07-19T11:51:03 Default schema: test # 2010-07-19T11:51:03 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-19T11:51:03 Default schema: test # 2010-07-19T11:51:03 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-19T11:51:03 Default schema: test # 2010-07-19T11:51:03 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-19T11:51:03 Default schema: test # 2010-07-19T11:51:03 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-19T11:51:03 Default schema: test # 2010-07-19T11:51:03 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-19T11:51:04 Default schema: test # 2010-07-19T11:51:04 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-19T11:51:04 Default schema: test # 2010-07-19T11:51:04 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-19T11:51:04 Started periodic reporting process... # 2010-07-19T11:51:04 Default schema: test # 2010-07-19T11:51:04 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-19T11:51:04 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-19T11:51:04 Query: CALL proc_2 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:04 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-19T11:51:04 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-19T11:51:04 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-19T11:51:04 Default schema: test # 2010-07-19T11:51:04 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-19T11:51:04 Query: UPDATE table_1 SET `col_int_key` = 9 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:04 Default schema: test # 2010-07-19T11:51:04 Caching metadata for dbi:mysql:host=127.0.0.1:port=19300:user=root:database=test # 2010-07-19T11:51:04 Query: INSERT INTO table11_innodb SELECT * FROM table11_innodb LIMIT 0 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:04 GenTest::ErrorFilter(3) started # 2010-07-19T11:51:04 Query: SELECT /* QUERY_ID: 15604992 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM view_2 WHERE func_3 ( `col_int_key` ) < 1 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: UPDATE table_3 SET `col_int_key` = 5 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: CALL proc_3 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: SELECT /* QUERY_ID: 10268416 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM `table10_innodb` WHERE `col_int_key` <> `col_int_key` failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: SELECT /* QUERY_ID: 16419072 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM table11_innodb WHERE `col_int_key` < func_3 ( func_1 ( func_3 ( `col_int_key` ) ) ) failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: SELECT /* QUERY_ID: 11213056 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 4 ) AS `col_int_key` FROM table11_innodb failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: CALL proc_1 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: INSERT INTO table_3 SELECT * FROM table_3 LIMIT 0 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: CALL /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ proc_3 ( @inout1 ) failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 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-19T11:51:05 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table10_innodb FOR EACH ROW UPDATE table_1 SET `col_int_key` = 0 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: UPDATE table11_innodb SET `col_int_key` = 7 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: SELECT /* QUERY_ID: 16652800 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM `table10_innodb` failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: SELECT /* QUERY_ID: 10342656 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 9 ) AS `col_int_key` FROM `table11_innodb` WHERE 6 < 5 failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: SELECT /* QUERY_ID: 7953664 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 9 ) AS `col_int_key` FROM `table10_innodb` failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: SELECT /* QUERY_ID: 11888128 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM `table11_innodb` WHERE 4 <> func_2 ( `col_int_key` ) failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: INSERT INTO table_3 SELECT * FROM table_3 LIMIT 0 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51: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-19T11:51:05 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table_2 FOR EACH ROW UPDATE table_3 SET `col_int_key` = 3 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:05 Query: UPDATE table_3 SET `col_int_key` = 9 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:06 Query: CREATE PROCEDURE proc_1 (INOUT inout1 INT) BEGIN SELECT COUNT(DISTINCT func_3 ( `col_int_key` ) ) INTO inout1 FROM `table10_innodb` WHERE `col_int_key` <> func_3 ( `col_int_key` ) ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:06 Query: SELECT /* QUERY_ID: 10993664 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 3 ) AS `col_int_key` FROM `table11_innodb` failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 Query: CALL /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ proc_2 ( @inout1 ) failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 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: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 Query: CREATE TABLE table_2 ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 1484800 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 7 ) AS `col_int_key` FROM view_1 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 Query: CREATE TABLE table_2 ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 8451584 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM `table11_innodb` WHERE 1 < 7 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 Query: UPDATE table_2 SET `col_int_key` = 2 failed: 1146 Table '%s' doesn't exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 Query: SELECT /* QUERY_ID: 3436288 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM view_1 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 Query: SELECT /* QUERY_ID: 8050432 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM table10_innodb failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 Query: INSERT INTO table_2 SELECT * FROM table_2 LIMIT 0 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 Query: DROP TRIGGER trigger_2 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 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-19T11:51:07 Query: INSERT INTO table11_innodb SELECT * FROM table11_innodb LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 Query: SELECT /* QUERY_ID: 2156288 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM `table10_innodb` WHERE func_2 ( 4 ) < 0 failed: 1305 FUNCTION %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 12133120 */ /* 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-19T11:51:07 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 0 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:07 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-19T11:51:08 Query: CREATE PROCEDURE proc_1 (INOUT inout1 INT) BEGIN SELECT COUNT(DISTINCT func_1 ( 2 ) ) INTO inout1 FROM table11_innodb WHERE 7 <> func_2 ( `col_int_key` ) ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:09 Query: CREATE TABLE table_2 ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 10914304 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 8 ) AS `col_int_key` FROM table_1 WHERE 1 <> 2 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:09 Query: CREATE PROCEDURE proc_1 (INOUT inout1 INT) BEGIN SELECT COUNT(DISTINCT 6 ) INTO inout1 FROM `table11_innodb` ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:10 Query: CREATE PROCEDURE proc_2 (INOUT inout1 INT) BEGIN SELECT func_2 ( 6 ) FROM table11_innodb ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:10 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table_1 SET `col_int_key` = 5 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:10 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:11 Query: INSERT INTO table_1 SELECT * FROM table_1 LIMIT 0 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:11 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:11 Query: CREATE PROCEDURE proc_1 (INOUT inout1 INT) BEGIN SELECT func_3 ( 7 ) FROM view_1 WHERE func_1 ( func_1 ( func_1 ( 2 ) ) ) <> 8 ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:11 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:11 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table_1 SET `col_int_key` = 2 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:11 Query: INSERT INTO table10_innodb SELECT * FROM table10_innodb LIMIT 0 failed: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:11 Query: CREATE PROCEDURE proc_2 (INOUT inout1 INT) BEGIN SELECT COUNT(DISTINCT 6 ) INTO inout1 FROM `table10_innodb` WHERE func_2 ( func_2 ( func_3 ( func_1 ( func_3 ( 2 ) ) ) ) ) <> 1 ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:12 Query: CREATE PROCEDURE proc_2 (INOUT inout1 INT) BEGIN SELECT func_2 ( 3 ) FROM table_1 WHERE func_3 ( `col_int_key` ) <> func_3 ( 9 ) ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:12 Query: CREATE PROCEDURE proc_2 (INOUT inout1 INT) BEGIN SELECT COUNT(DISTINCT 2 ) INTO inout1 FROM view_1 ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:12 Query: INSERT INTO table_3 SELECT * FROM table_3 LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:12 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table_3 FOR EACH ROW UPDATE table_3 SET `col_int_key` = 8 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-19T11:51:13 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: 1205 Lock wait timeout exceeded; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:13 Query: CREATE ALGORITHM = MERGE VIEW view_2 AS SELECT /* QUERY_ID: 10078464 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM table10_innodb failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:18 Query: ALTER TABLE table11_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 3 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:18 Query: UPDATE table10_innodb SET `col_int_key` = 8 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:19 Query: CREATE PROCEDURE proc_2 (INOUT inout1 INT) BEGIN SELECT COUNT(DISTINCT func_3 ( `col_int_key` ) ) INTO inout1 FROM `table10_innodb` WHERE 0 < `col_int_key` ; END failed: 1304 PROCEDURE %s already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:19 Query: INSERT INTO table11_innodb SELECT * FROM table11_innodb LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:19 Query: INSERT INTO table11_innodb SELECT * FROM table11_innodb LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:20 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-19T11:51:20 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-19T11:51:21 Query: UPDATE table10_innodb SET `col_int_key` = 2 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:21 Query: CREATE ALGORITHM = MERGE VIEW view_2 AS SELECT /* QUERY_ID: 12413952 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 2 AS `col_int_key` FROM `table11_innodb` WHERE `col_int_key` < 2 failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:21 Query: DROP TRIGGER trigger_2 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:21 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 6 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-19T11:51:22 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 9454080 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 7 ) AS `col_int_key` FROM table11_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-19T11:51:23 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table_3 FOR EACH ROW UPDATE table_3 SET `col_int_key` = 7 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:23 Query: UPDATE table10_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-19T11:51:24 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 8 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:24 Query: CREATE ALGORITHM = UNDEFINED VIEW view_1 AS SELECT /* QUERY_ID: 16019712 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM `table10_innodb` WHERE `col_int_key` < `col_int_key` failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:24 Query: CREATE ALGORITHM = UNDEFINED VIEW view_2 AS SELECT /* QUERY_ID: 5248000 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM view_1 WHERE `col_int_key` < 7 failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:25 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table_1 SET `col_int_key` = 3 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:25 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table_2 FOR EACH ROW UPDATE table_2 SET `col_int_key` = 5 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:25 Query: CREATE TRIGGER trigger_1 AFTER INSERT ON table_2 FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 8 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:25 Query: CREATE TRIGGER trigger_1 AFTER INSERT ON table_3 FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 9 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:25 Query: INSERT INTO table_1 SELECT * FROM table_1 LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:25 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table_2 FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 0 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-19T11:51:25 Query: CREATE ALGORITHM = UNDEFINED VIEW view_2 AS SELECT /* QUERY_ID: 1193984 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM `table11_innodb` failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:25 Query: CREATE ALGORITHM = UNDEFINED VIEW view_2 AS SELECT /* QUERY_ID: 597504 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM table11_innodb WHERE func_1 ( func_1 ( func_2 ( 9 ) ) ) <> `col_int_key` failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:25 Query: INSERT INTO table_2 SELECT * FROM table_2 LIMIT 0 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:28 Query: INSERT INTO table11_innodb SELECT * FROM table11_innodb LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:28 Query: DROP TRIGGER trigger_2 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:29 Query: ALTER TABLE table_2 CHANGE COLUMN `default` `default` INTEGER DEFAULT 4 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:29 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table_3 FOR EACH ROW UPDATE table_1 SET `col_int_key` = 3 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:29 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 13669120 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 7 ) AS `col_int_key` FROM table11_innodb failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:30 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table_2 FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 9 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:31 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-19T11:51:31 Query: ALTER TABLE table10_innodb ADD COLUMN `default` INTEGER DEFAULT 7 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:33 Query: UPDATE table11_innodb SET `col_int_key` = 0 failed: 1213 Deadlock found when trying to get lock; try restarting transaction. Further errors of this kind will be suppressed. # 2010-07-19T11:51:33 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 7765248 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 4 ) 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-19T11:51:33 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table_3 SET `col_int_key` = 7 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:33 Query: ALTER TABLE table10_innodb ADD COLUMN `default` INTEGER DEFAULT 8 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:34 Query: ALTER TABLE table10_innodb ADD COLUMN `default` INTEGER DEFAULT 3 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:34 Query: CREATE TEMPORARY TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 3320320 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 7 AS `col_int_key` FROM view_1 failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:34 Query: INSERT INTO table_2 SELECT * FROM table_2 LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:36 Query: DROP TRIGGER trigger_2 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:51:37 Query: CREATE TRIGGER trigger_1 AFTER INSERT ON table_1 FOR EACH ROW UPDATE table10_innodb 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-19T11:51:38 Query: INSERT INTO table_1 SELECT * FROM table_1 LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:40 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table10_innodb FOR EACH ROW UPDATE table_2 SET `col_int_key` = 2 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:40 Query: ALTER TABLE table10_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 6 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:42 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_1 AS SELECT /* QUERY_ID: 1198336 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM `table10_innodb` failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:42 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table_2 FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 2 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-19T11:51:43 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-19T11:51:43 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 15758336 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 7 AS `col_int_key` FROM view_1 WHERE func_3 ( 4 ) < func_3 ( `col_int_key` ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-07-19T11:51:46 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table11_innodb FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 2 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-19T11:51:46 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 8646400 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 4 ) AS `col_int_key` FROM table11_innodb WHERE `col_int_key` < func_3 ( func_2 ( `col_int_key` ) ) failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:47 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 3389952 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM `table11_innodb` WHERE `col_int_key` <> 0 failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:48 Query: ALTER TABLE table_2 CHANGE COLUMN `default` `default` INTEGER DEFAULT 3 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:48 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-19T11:51:49 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-19T11:51:52 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10370816 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 6 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-19T11:51:52 Query: INSERT INTO table_2 SELECT * FROM table_2 LIMIT 0 failed: 1137 Can't reopen table: '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:52 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 10744064 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 7 AS `col_int_key` FROM `table10_innodb` WHERE func_3 ( `col_int_key` ) < 4 failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2010-07-19T11:51:53 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 175616 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM `table10_innodb` failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:51:56 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table11_innodb FOR EACH ROW UPDATE table_2 SET `col_int_key` = 1 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-19T11:51:57 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 12952320 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 2 ) AS `col_int_key` FROM table_2 failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:58 Query: ALTER TABLE table_1 ADD COLUMN `default` INTEGER DEFAULT 9 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:51:59 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 8712192 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 7 AS `col_int_key` FROM `table11_innodb` WHERE `col_int_key` <> 8 failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:52:03 Query: CREATE TABLE table_1 ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 4281856 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM view_2 WHERE 1 <> `col_int_key` failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:52:03 Query: CALL proc_2 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:52:04 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-19T11:52:05 Query: CREATE TRIGGER trigger_1 AFTER INSERT ON table_1 FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 9 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-19T11:52:05 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 7825920 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 4 ) AS `col_int_key` FROM `table11_innodb` failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:06 Query: ALTER TABLE table10_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 6 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:08 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table_2 FOR EACH ROW UPDATE table10_innodb SET `col_int_key` = 7 failed: 1361 Trigger's '%s' is view or temporary table. Further errors of this kind will be suppressed. # 2010-07-19T11:52:08 Query: ALTER TABLE table11_innodb ADD COLUMN `default` INTEGER DEFAULT 0 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:08 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table11_innodb FOR EACH ROW UPDATE table_1 SET `col_int_key` = 3 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:08 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 9586432 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 9 AS `col_int_key` FROM table_1 WHERE 2 < `col_int_key` failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:52:08 Query: SELECT /* QUERY_ID: 8367104 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM table_2 WHERE `col_int_key` < 2; returns different result when executed after a delay of 0.01 seconds. # 2010-07-19T11:52:08 --- C:\DOCUME~1\qauser\LOCALS~1\Temp\1\/randgen-4900-1279533128-server0.dump 2010-07-19 11:52:08.756438600 +0200 # 2010-07-19T11:52:08 +++ C:\DOCUME~1\qauser\LOCALS~1\Temp\1\/randgen-4900-1279533128-server1.dump 2010-07-19 11:52:08.756438600 +0200 # 2010-07-19T11:52:08 @@ -1,10 +0,0 @@ # 2010-07-19T11:52:08 -3 # 2010-07-19T11:52:08 -3 # 2010-07-19T11:52:08 -3 # 2010-07-19T11:52:08 -3 # 2010-07-19T11:52:08 -3 # 2010-07-19T11:52:08 -3 # 2010-07-19T11:52:08 -3 # 2010-07-19T11:52:08 -3 # 2010-07-19T11:52:08 -3 # 2010-07-19T11:52:08 -3 # 2010-07-19T11:52:10 Query: ALTER TABLE table11_innodb ADD COLUMN `default` INTEGER DEFAULT 7 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:10 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table_3 FOR EACH ROW UPDATE table_2 SET `col_int_key` = 2 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:11 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table_3 FOR EACH ROW UPDATE table_2 SET `col_int_key` = 0 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:11 Query: ALTER TABLE table_2 ADD COLUMN `default` INTEGER DEFAULT 4 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:13 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:52:13 Query: CREATE ALGORITHM = MERGE VIEW view_2 AS SELECT /* QUERY_ID: 9912064 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM table_2 failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:13 Query: ALTER TABLE table_1 CHANGE COLUMN `default` `default` INTEGER DEFAULT 4 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:13 Query: ALTER TABLE table_2 ADD COLUMN `default` INTEGER DEFAULT 6 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:18 Query: CREATE ALGORITHM = MERGE VIEW view_1 AS SELECT /* QUERY_ID: 6760448 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM `table10_innodb` failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:19 Query: DROP TRIGGER trigger_2 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:52:21 Query: CALL /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ proc_1 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:52:22 Query: ALTER TABLE table10_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 5 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:22 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-19T11:52:23 Query: CREATE TRIGGER trigger_1 BEFORE INSERT ON table_3 FOR EACH ROW UPDATE table_3 SET `col_int_key` = 0 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:24 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-19T11:52:26 Query: CREATE TRIGGER trigger_2 BEFORE INSERT ON table_2 FOR EACH ROW UPDATE table11_innodb SET `col_int_key` = 9 failed: 1359 Trigger already exists. Further errors of this kind will be suppressed. # 2010-07-19T11:52:29 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-19T11:52:30 Query: CREATE TRIGGER trigger_2 AFTER INSERT ON table_3 FOR EACH ROW UPDATE table_3 SET `col_int_key` = 5 failed: 1235 This version of MySQL doesn't yet support '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:34 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 425216 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM `table11_innodb` WHERE 2 <> `col_int_key` failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed. # 2010-07-19T11:52:39 Query: CALL /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ proc_3 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:52:41 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-19T11:52:46 Query: ALTER TABLE table_3 ADD COLUMN `default` INTEGER DEFAULT 4 failed: 1060 Duplicate column name '%s'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:47 Query: CREATE ALGORITHM = UNDEFINED VIEW view_2 AS SELECT /* QUERY_ID: 9383424 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 7 ) AS `col_int_key` FROM table_1 WHERE `col_int_key` < `col_int_key` failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:47 Query: CREATE ALGORITHM = UNDEFINED VIEW view_1 AS SELECT /* QUERY_ID: 12139520 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) 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-19T11:52:48 Query: ALTER TABLE table_2 CHANGE COLUMN `default` `default` INTEGER DEFAULT 9 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:50 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_1 AS SELECT /* QUERY_ID: 11907584 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM `table10_innodb` failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:53 Query: CREATE ALGORITHM = UNDEFINED VIEW view_2 AS SELECT /* QUERY_ID: 12155904 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 8 ) AS `col_int_key` FROM table_2 failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:53 Query: DROP TRIGGER trigger_1 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:52:55 Query: CREATE ALGORITHM = MERGE VIEW view_2 AS SELECT /* QUERY_ID: 13504000 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 5 AS `col_int_key` FROM table11_innodb WHERE 3 < `col_int_key` failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:55 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 4456960 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 4 AS `col_int_key` FROM table_3 WHERE func_3 ( func_2 ( `col_int_key` ) ) <> 9 failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:58 Query: ALTER TABLE table_3 CHANGE COLUMN `default` `default` INTEGER DEFAULT 7 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:52:59 Query: ALTER TABLE table11_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 6 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:53:00 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10840576 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 9 ) 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-19T11:53:02 Query: CREATE ALGORITHM = MERGE VIEW view_2 AS SELECT /* QUERY_ID: 6723584 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 3 ) AS `col_int_key` FROM table_1 WHERE func_2 ( func_3 ( 6 ) ) < func_3 ( func_2 ( `col_int_key` ) ) failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:53:06 Query: ALTER TABLE table10_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 7 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:53:10 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-19T11:53:11 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 9097472 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM table_3 WHERE 5 <> func_1 ( 0 ) failed: 1352 View's SELECT refers to a temporary table 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:53:16 Query: ALTER TABLE table_3 CHANGE COLUMN `default` `default` INTEGER DEFAULT 3 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:53:17 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-19T11:53:20 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-19T11:53:21 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-19T11:53:23 Query: CREATE ALGORITHM = UNDEFINED VIEW view_2 AS SELECT /* QUERY_ID: 11360256 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 7 AS `col_int_key` FROM table10_innodb WHERE `col_int_key` <> 1 failed: 1352 View's SELECT refers to a temporary table 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:53:24 Query: CREATE ALGORITHM = UNDEFINED VIEW view_2 AS SELECT /* QUERY_ID: 2800896 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) 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-19T11:53:30 Query: ALTER TABLE table_1 CHANGE COLUMN `default` `default` INTEGER DEFAULT 7 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:53:34 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-19T11:53:36 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-19T11:53:37 Query: ALTER TABLE table11_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 9 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:53:39 Query: ALTER TABLE table_3 CHANGE COLUMN `default` `default` INTEGER DEFAULT 7 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-07-19T11:53:44 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-19T11:53:51 Query: ALTER TABLE table10_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 8 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-07-19T11:53:55 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-19T11:53:55 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-19T11:53:56 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-19T11:54:07 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-19T11:54:12 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-19T11:54:12 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-19T11:54:14 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-19T11:54:15 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-19T11:54:18 Query: CALL proc_1 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:54:21 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-19T11:54:22 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-19T11:54:23 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-19T11:54:24 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-19T11:54:24 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-19T11:54:26 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-19T11:54:28 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-19T11:54:29 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-19T11:54:36 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-19T11:54:49 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-19T11:54:53 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-19T11:55:01 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-19T11:55:06 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-19T11:55:15 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-19T11:55:17 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-19T11:55:18 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-19T11:55:19 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-19T11:55:20 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-19T11:55: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-19T11:55:23 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-19T11:55:28 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-19T11:55:29 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-19T11:55:36 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-19T11:55:39 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-19T11:55:41 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-19T11:55:51 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-19T11:55:52 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-19T11:55:57 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-19T11:55:58 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-19T11:55:58 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-19T11:55:59 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-19T11:56:02 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-19T11:56:04 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-19T11:56:17 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-19T11:56:18 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-19T11:56:21 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-19T11:56:23 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-19T11:56:26 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-19T11:56:29 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-19T11:56:32 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-19T11:56:34 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-19T11:56:35 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-19T11:56:35 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-19T11:56:37 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-19T11:56:44 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-19T11:56:46 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-19T11:56:46 Query: CALL proc_3 ( @inout1 ) failed: 1305 PROCEDURE %s does not exist. Further errors of this kind will be suppressed. # 2010-07-19T11:56:50 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-19T11:56:50 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-19T11:56:51 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-19T11:57:06 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-19T11:57:11 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-19T11:57:13 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-19T11:57:29 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-19T11:57:38 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-19T11:57:42 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-19T11:57:52 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-19T11:58:15 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-19T11:58:15 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-19T11:58:17 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-19T11:58:19 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-19T11:58:19 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-19T11:58:20 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-19T11:58:26 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-19T11:58:33 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-19T11:58:40 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-19T11:58:43 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-19T11:58:47 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-19T11:58:47 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-19T11:58:53 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-19T11:58:56 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-19T11:58:56 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-19T11:59:04 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-19T11:59:07 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-19T11:59:13 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-19T11:59:20 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-19T11:59:23 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-19T11:59:23 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-19T11:59:25 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-19T11:59:31 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-19T11:59:33 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-19T11:59:39 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-19T11:59:45 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-19T11:59:48 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-19T11:59:49 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-19T11:59:54 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-19T11:59:58 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-19T12:00:10 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-19T12:00:16 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-19T12:00:18 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-19T12:00:19 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-19T12:00:19 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-19T12:00:19 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-19T12:00:27 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-19T12:00:31 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-19T12:00:38 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-19T12:00:43 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-19T12:00:45 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-19T12:00:50 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-19T12:00:51 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-19T12:00:57 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-19T12:01:03 Child process completed successfully. # 2010-07-19T12:01:03 Child process completed successfully. # 2010-07-19T12:01:03 Child process completed successfully. # 2010-07-19T12:01:03 Child process completed successfully. # 2010-07-19T12:01:03 Child process completed successfully. # 2010-07-19T12:01:03 Child process completed successfully. # 2010-07-19T12:01:03 Child process completed successfully. # 2010-07-19T12:01:03 Child process completed with error code 32. # 2010-07-19T12:01:03 Child process completed successfully. # 2010-07-19T12:01:03 Child process completed successfully. # 2010-07-19T12:01:04 Killing periodic reporting process with pid -3712... # 2010-07-19T12:01:08 XML report written to C:\DOCUME~1\qauser\LOCALS~1\Temp\1\rqg_mdl_stability.xml # 2010-07-19T12:01:08 XML Transport type: SCP # 2010-07-19T12:01:08 SCP command is: pscp.exe -q C:\DOCUME~1\qauser\LOCALS~1\Temp\1\rqg_mdl_stability.xml regin.norway.sun.com:/raid/xml_results/TestTool/xml/ # 2010-07-19T12:01:09 Test completed with failure status 32. # 2010-07-19T12:01:09 GenTest exited with exit status 32 # 2010-07-19T12:01:09 Stopping server on port 19300 # 2010-07-19T12:01:12 [5688] runall-new.pl will exit with exit status 32 serverqa.rqg_mdl_stability [ fail ] # 2010-07-19T12:01:12 runall.pl failed with exit code 32 # 2010-07-19T12:01:12 Look above this message in the test log for failure details. # 2010-07-19T12:01:12 Checking for remaining mysqld processes... PsList 1.26 - Process Information Lister Copyright (C) 1999-2004 Mark Russinovich Sysinternals - www.sysinternals.com Process information for LOKI06: process mysqld was not found on LOKI06 # 2010-07-19T12:01:12 None found. # 2010-07-19T12:01:12 [5828] pb2gentest-new.pl will exit with exit status 32 exit code: 32 [SOURCEBUILDER] FAIL mysql-5.5.6-m3-win-x86-test/vardirs.zip G:\pb2\test\sb_1-2056679-1279532946.85>