# 2010-08-10T13:43:21 Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. # 2010-08-10T13:43:21 Please see http://forge.mysql.com/wiki/Category:RandomQueryGenerator for more information on this test framework. # 2010-08-10T13:43:21 Starting # 2010-08-10T13:43:21 # runall-new.pl \ # 2010-08-10T13:43:21 # --grammar=conf/runtime/metadata_stability.yy \ # 2010-08-10T13:43:21 # --gendata=conf/runtime/metadata_stability.zz \ # 2010-08-10T13:43:21 # --validator=SelectStability,QueryProperties \ # 2010-08-10T13:43:21 # --engine=Innodb \ # 2010-08-10T13:43:21 # --mysqld=--innodb \ # 2010-08-10T13:43:21 # --mysqld=--default-storage-engine=Innodb \ # 2010-08-10T13:43:21 # --mysqld=--transaction-isolation=SERIALIZABLE \ # 2010-08-10T13:43:21 # --mysqld=--innodb-flush-log-at-trx-commit=2 \ # 2010-08-10T13:43:21 # --mysqld=--innodb-lock-wait-timeout=1 \ # 2010-08-10T13:43:21 # --mysqld=--loose-lock-wait-timeout=1 \ # 2010-08-10T13:43:21 # --mysqld=--log-output=file \ # 2010-08-10T13:43:21 # --mysqld=--general-log \ # 2010-08-10T13:43:21 # --mysqld=--loose-skip-safemalloc \ # 2010-08-10T13:43:21 # --queries=1M \ # 2010-08-10T13:43:21 # --duration=600 \ # 2010-08-10T13:43:21 # --reporters=Deadlock,ErrorLog,Backtrace \ # 2010-08-10T13:43:21 # --basedir=/export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-trunk-bugfixing/jbuild/install \ # 2010-08-10T13:43:21 # --vardir=/export/home/tmp/je159969/mysql-dev/bzr-randgen/randgen-testrun/var-mdl \ # 2010-08-10T13:43:21 # --testname=rqg_mdl_stability # 2010-08-10T13:43:21 master_port : 10020 slave_port : 10022 ports : 10020 10022 MTR_BUILD_THREAD : 2 # 2010-08-10T13:43:21 Creating MySQL 5.6.0-m4 database at /export/home/tmp/je159969/mysql-dev/bzr-randgen/randgen-testrun/var-mdl/data # 2010-08-10T13:43:22 Starting MySQL 5.6.0-m4: "/export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-trunk-bugfixing/jbuild/install/bin/mysqld" "--no-defaults" "--basedir=/export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-trunk-bugfixing/jbuild/install" "--datadir=/export/home/tmp/je159969/mysql-dev/bzr-randgen/randgen-testrun/var-mdl/data" "--lc-messages-dir=/export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-trunk-bugfixing/jbuild/install/share" "--character-sets-dir=/export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-trunk-bugfixing/jbuild/install/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=10020" "--socket=/tmp/RQGmysql.10020.sock" "--pid-file=/export/home/tmp/je159969/mysql-dev/bzr-randgen/randgen-testrun/var-mdl/mysql.pid" "--general-log-file=/export/home/tmp/je159969/mysql-dev/bzr-randgen/randgen-testrun/var-mdl/mysql.err" --innodb --sql-mode=no_engine_substitution --innodb --default-storage-engine=Innodb --transaction-isolation=SERIALIZABLE --innodb-flush-log-at-trx-commit=2 --innodb-lock-wait-timeout=1 --loose-lock-wait-timeout=1 --log-output=file --general-log --loose-skip-safemalloc # 2010-08-10T13:43:24 ------------------------------- # 2010-08-10T13:43:24 Configuration # 2010-08-10T13:43:24 dsn => ['dbi:mysql:host=127.0.0.1:port=10020:user=root:database=test'] # 2010-08-10T13:43:24 duration => 600 # 2010-08-10T13:43:24 engine => Innodb # 2010-08-10T13:43:24 gendata => conf/runtime/metadata_stability.zz # 2010-08-10T13:43:24 grammar => conf/runtime/metadata_stability.yy # 2010-08-10T13:43:24 queries => 1M # 2010-08-10T13:43:24 reporters => ['Deadlock', 'ErrorLog', 'Backtrace'] # 2010-08-10T13:43:24 testname => rqg_mdl_stability # 2010-08-10T13:43:24 threads => 10 # 2010-08-10T13:43:24 validators => ['SelectStability', 'QueryProperties'] # 2010-08-10T13:43:24 Executor initialized, id # 2010-08-10T13:43:24 Default schema: test # 2010-08-10T13:43:24 # Creating MySQL table: test.table10_innodb; engine: innodb; rows: 10 . # 2010-08-10T13:43:24 # Creating MySQL table: test.table11_innodb; engine: innodb; rows: 11 . # 2010-08-10T13:43:24 Reporters: Deadlock, ErrorLog, Backtrace # 2010-08-10T13:43:24 Validators: SelectStability, QueryProperties # 2010-08-10T13:43:24 Starting 10 processes, 1M queries each, duration 600 seconds. # 2010-08-10T13:43:24 GenTest::ErrorFilter(24717) started # 2010-08-10T13:43:24 Executor initialized, id 1 # 2010-08-10T13:43:24 Default schema: test # 2010-08-10T13:43:24 Caching metadata for dbi:mysql:host=127.0.0.1:port=10020:user=root:database=test # 2010-08-10T13:43:24 Query: SELECT /* QUERY_ID: 6174976 */ CONNECTION_ID(), /* 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-08-10T13:43:24 Query: SELECT /* QUERY_ID: 14594816 */ CONNECTION_ID(), /* 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-08-10T13:43:24 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-08-10T13:43:24 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 8002048 */ CONNECTION_ID(), /* 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-08-10T13:43:24 Executor initialized, id 1 # 2010-08-10T13:43:24 Default schema: test # 2010-08-10T13:43:24 Caching metadata for dbi:mysql:host=127.0.0.1:port=10020:user=root:database=test # 2010-08-10T13:43:24 Executor initialized, id 1 # 2010-08-10T13:43:24 Default schema: test # 2010-08-10T13:43:24 Caching metadata for dbi:mysql:host=127.0.0.1:port=10020:user=root:database=test # 2010-08-10T13:43:24 Executor initialized, id 1 # 2010-08-10T13:43:24 Default schema: test # 2010-08-10T13:43:24 Caching metadata for dbi:mysql:host=127.0.0.1:port=10020:user=root:database=test # 2010-08-10T13:43:24 Executor initialized, id 1 # 2010-08-10T13:43:24 Default schema: test # 2010-08-10T13:43:24 Caching metadata for dbi:mysql:host=127.0.0.1:port=10020:user=root:database=test # 2010-08-10T13:43:25 Executor initialized, id 1 # 2010-08-10T13:43:25 Default schema: test # 2010-08-10T13:43:25 Caching metadata for dbi:mysql:host=127.0.0.1:port=10020:user=root:database=test # 2010-08-10T13:43:25 Executor initialized, id 1 # 2010-08-10T13:43:25 Default schema: test # 2010-08-10T13:43:25 Caching metadata for dbi:mysql:host=127.0.0.1:port=10020:user=root:database=test # 2010-08-10T13:43:25 Executor initialized, id 1 # 2010-08-10T13:43:25 Default schema: test # 2010-08-10T13:43:25 Caching metadata for dbi:mysql:host=127.0.0.1:port=10020:user=root:database=test # 2010-08-10T13:43:25 Executor initialized, id 1 # 2010-08-10T13:43:25 Default schema: test # 2010-08-10T13:43:25 Caching metadata for dbi:mysql:host=127.0.0.1:port=10020:user=root:database=test # 2010-08-10T13:43:25 Executor initialized, id 1 # 2010-08-10T13:43:25 Default schema: test # 2010-08-10T13:43:25 Caching metadata for dbi:mysql:host=127.0.0.1:port=10020:user=root:database=test # 2010-08-10T13:43:25 Started periodic reporting process... # 2010-08-10T13:43:25 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-08-10T13:43:25 Query: DROP TRIGGER trigger_2 failed: 1360 Trigger does not exist. Further errors of this kind will be suppressed. # 2010-08-10T13:43:25 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-08-10T13:43:25 Query: ALTER TABLE table11_innodb CHANGE COLUMN `default` `default` INTEGER DEFAULT 0 failed: 1054 Unknown column '%s' in 'table%d_innodb'. Further errors of this kind will be suppressed. # 2010-08-10T13:43:26 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-08-10T13:43:26 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-08-10T13:43:26 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-08-10T13:43:26 Query: CREATE TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 3422464 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM `table10_innodb` failed: 1050 Table '%s' already exists. Further errors of this kind will be suppressed. # 2010-08-10T13:43:28 Query: CREATE TEMPORARY TABLE table11_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10410240 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 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-08-10T13:43:28 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-08-10T13:43:31 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-08-10T13:43:32 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9336064 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 7 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:43:32 Query: CREATE ALGORITHM = UNDEFINED VIEW view_2 AS SELECT /* QUERY_ID: 597504 */ CONNECTION_ID(), /* 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-08-10T13:43:37 Query: ALTER TABLE table_1 CHANGE COLUMN `default` `default` INTEGER DEFAULT 5 failed: 1054 Unknown column '%s' in 'table_%d'. Further errors of this kind will be suppressed. # 2010-08-10T13:43:40 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 7765248 */ CONNECTION_ID(), /* 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-08-10T13:43:43 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 15758336 */ CONNECTION_ID(), /* 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-08-10T13:43:50 Query: CREATE ALGORITHM = TEMPTABLE VIEW view_2 AS SELECT /* QUERY_ID: 12952320 */ CONNECTION_ID(), /* 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-08-10T13:44:01 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 6257664 */ CONNECTION_ID(), /* 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-08-10T13:44:04 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 12961280 */ CONNECTION_ID(), /* 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-08-10T13:44:24 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 995840 */ CONNECTION_ID(), /* 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-08-10T13:44:24 Query: SELECT /* QUERY_ID: 11372544 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 8 AS `col_int_key` FROM table_3 WHERE `col_int_key` < 6; returns different result when executed after a delay of 0.01 seconds. # 2010-08-10T13:44:24 --- /tmp//randgen24720-1281440664-server0.dump 2010-08-10 13:44:24.748691888 +0200 # 2010-08-10T13:44:24 +++ /tmp//randgen24720-1281440664-server1.dump 2010-08-10 13:44:24.748773306 +0200 # 2010-08-10T13:44:24 @@ -0,0 +1,10 @@ # 2010-08-10T13:44:24 +8 8 # 2010-08-10T13:44:24 +8 8 # 2010-08-10T13:44:24 +8 8 # 2010-08-10T13:44:24 +8 8 # 2010-08-10T13:44:24 +8 8 # 2010-08-10T13:44:24 +8 8 # 2010-08-10T13:44:24 +8 8 # 2010-08-10T13:44:24 +8 8 # 2010-08-10T13:44:24 +8 8 # 2010-08-10T13:44:24 +8 8 # 2010-08-10T13:44:35 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 9109760 */ CONNECTION_ID(), /* 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-08-10T13:44:42 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15964416 */ CONNECTION_ID(), /* 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-08-10T13:44:46 Query: SELECT /* QUERY_ID: 12160768 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM table_2 WHERE 5 < `col_int_key`; returns different result when executed after a delay of 0.01 seconds. # 2010-08-10T13:44:46 --- /tmp//randgen24720-1281440686-server0.dump 2010-08-10 13:44:46.648241813 +0200 # 2010-08-10T13:44:46 +++ /tmp//randgen24720-1281440686-server1.dump 2010-08-10 13:44:46.648315126 +0200 # 2010-08-10T13:44:46 @@ -0,0 +1,11 @@ # 2010-08-10T13:44:46 +8 3 # 2010-08-10T13:44:46 +8 3 # 2010-08-10T13:44:46 +8 3 # 2010-08-10T13:44:46 +8 3 # 2010-08-10T13:44:46 +8 3 # 2010-08-10T13:44:46 +8 3 # 2010-08-10T13:44:46 +8 3 # 2010-08-10T13:44:46 +8 3 # 2010-08-10T13:44:46 +8 3 # 2010-08-10T13:44:46 +8 3 # 2010-08-10T13:44:46 +8 3 # 2010-08-10T13:44:49 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 4948736 */ CONNECTION_ID(), /* 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-08-10T13:44:53 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 11395840 */ CONNECTION_ID(), /* 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-08-10T13:44:54 Query: SELECT /* QUERY_ID: 9227520 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 1 AS `col_int_key` FROM table_2 WHERE 3 < `col_int_key`; returns different result when executed after a delay of 0 seconds. # 2010-08-10T13:44:54 --- /tmp//randgen24724-1281440694-server0.dump 2010-08-10 13:44:54.771932630 +0200 # 2010-08-10T13:44:54 +++ /tmp//randgen24724-1281440694-server1.dump 2010-08-10 13:44:54.771954419 +0200 # 2010-08-10T13:44:54 @@ -1,11 +0,0 @@ # 2010-08-10T13:44:54 -12 1 # 2010-08-10T13:44:54 -12 1 # 2010-08-10T13:44:54 -12 1 # 2010-08-10T13:44:54 -12 1 # 2010-08-10T13:44:54 -12 1 # 2010-08-10T13:44:54 -12 1 # 2010-08-10T13:44:54 -12 1 # 2010-08-10T13:44:54 -12 1 # 2010-08-10T13:44:54 -12 1 # 2010-08-10T13:44:54 -12 1 # 2010-08-10T13:44:54 -12 1 # 2010-08-10T13:45:13 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 16248064 */ CONNECTION_ID(), /* 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-08-10T13:45:14 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 7958784 */ CONNECTION_ID(), /* 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-08-10T13:45:14 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9741824 */ CONNECTION_ID(), /* 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-08-10T13:45:18 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1300224 */ CONNECTION_ID(), /* 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-08-10T13:45:32 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 8104448 */ CONNECTION_ID(), /* 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-08-10T13:45:39 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 10707968 */ CONNECTION_ID(), /* 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-08-10T13:45:46 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 8486656 */ CONNECTION_ID(), /* 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-08-10T13:45:48 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 4115968 */ CONNECTION_ID(), /* 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-08-10T13:45:51 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9079808 */ CONNECTION_ID(), /* 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-08-10T13:45:52 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 2931968 */ CONNECTION_ID(), /* 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-08-10T13:45:57 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 5771008 */ CONNECTION_ID(), /* 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-08-10T13:46:05 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 8370944 */ CONNECTION_ID(), /* 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-08-10T13:46:09 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 7393280 */ CONNECTION_ID(), /* 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-08-10T13:46:13 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 6409728 */ CONNECTION_ID(), /* 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-08-10T13:46:18 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 6573568 */ CONNECTION_ID(), /* 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-08-10T13:46:19 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 6669312 */ CONNECTION_ID(), /* 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-08-10T13:46:21 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10321152 */ CONNECTION_ID(), /* 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-08-10T13:46:22 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 16742144 */ CONNECTION_ID(), /* 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-08-10T13:46:25 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 7987200 */ CONNECTION_ID(), /* 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-08-10T13:46:27 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 719360 */ CONNECTION_ID(), /* 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-08-10T13:46:29 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 254208 */ CONNECTION_ID(), /* 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-08-10T13:46:31 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 10337536 */ CONNECTION_ID(), /* 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-08-10T13:46:34 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 3677440 */ CONNECTION_ID(), /* 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-08-10T13:46:39 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 4916736 */ CONNECTION_ID(), /* 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-08-10T13:46:45 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 5942528 */ CONNECTION_ID(), /* 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-08-10T13:46:50 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11727360 */ CONNECTION_ID(), /* 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-08-10T13:46:55 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 8018176 */ CONNECTION_ID(), /* 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-08-10T13:47:00 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 12995328 */ CONNECTION_ID(), /* 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-08-10T13:47:02 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 5221888 */ CONNECTION_ID(), /* 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-08-10T13:47:03 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15284224 */ CONNECTION_ID(), /* 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-08-10T13:47:04 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 14805760 */ CONNECTION_ID(), /* 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-08-10T13:47:06 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 4101376 */ CONNECTION_ID(), /* 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-08-10T13:47:11 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 3533824 */ CONNECTION_ID(), /* 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-08-10T13:47:13 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15187712 */ CONNECTION_ID(), /* 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-08-10T13:47:18 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 7688960 */ CONNECTION_ID(), /* 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-08-10T13:47:19 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 5515008 */ CONNECTION_ID(), /* 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-08-10T13:47:22 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 9386240 */ CONNECTION_ID(), /* 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-08-10T13:47:30 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 15654144 */ CONNECTION_ID(), /* 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-08-10T13:47:33 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 4710144 */ CONNECTION_ID(), /* 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-08-10T13:47:34 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 10980096 */ CONNECTION_ID(), /* 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-08-10T13:47:40 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 5811456 */ CONNECTION_ID(), /* 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-08-10T13:47:41 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 15079424 */ CONNECTION_ID(), /* 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-08-10T13:47:41 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 9152000 */ CONNECTION_ID(), /* 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-08-10T13:47:42 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9203200 */ CONNECTION_ID(), /* 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-08-10T13:47:43 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 6477824 */ CONNECTION_ID(), /* 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-08-10T13:47:43 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11526144 */ CONNECTION_ID(), /* 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-08-10T13:47:45 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 3342592 */ CONNECTION_ID(), /* 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-08-10T13:47:52 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 16523520 */ CONNECTION_ID(), /* 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-08-10T13:47:53 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 1795072 */ CONNECTION_ID(), /* 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-08-10T13:47:53 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 6364160 */ CONNECTION_ID(), /* 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-08-10T13:48:03 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1188096 */ CONNECTION_ID(), /* 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-08-10T13:48:03 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 16329216 */ CONNECTION_ID(), /* 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-08-10T13:48:08 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 2754304 */ CONNECTION_ID(), /* 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-08-10T13:48:09 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9206528 */ CONNECTION_ID(), /* 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-08-10T13:48:10 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 1911040 */ CONNECTION_ID(), /* 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-08-10T13:48:12 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9449472 */ CONNECTION_ID(), /* 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-08-10T13:48:15 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 15881472 */ CONNECTION_ID(), /* 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-08-10T13:48:25 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1093632 */ CONNECTION_ID(), /* 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-08-10T13:48:26 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 8404992 */ CONNECTION_ID(), /* 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-08-10T13:48:27 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9053952 */ CONNECTION_ID(), /* 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-08-10T13:48:27 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15707136 */ CONNECTION_ID(), /* 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-08-10T13:48:28 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 15564288 */ CONNECTION_ID(), /* 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-08-10T13:48:30 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15625984 */ CONNECTION_ID(), /* 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-08-10T13:48:35 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 3177472 */ CONNECTION_ID(), /* 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-08-10T13:48:46 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10573056 */ CONNECTION_ID(), /* 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-08-10T13:48:49 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 5522688 */ CONNECTION_ID(), /* 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-08-10T13:48:51 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 6601728 */ CONNECTION_ID(), /* 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-08-10T13:48:55 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 14274304 */ CONNECTION_ID(), /* 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-08-10T13:49:01 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11625216 */ CONNECTION_ID(), /* 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-08-10T13:49:04 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11376896 */ CONNECTION_ID(), /* 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-08-10T13:49:13 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 6566656 */ CONNECTION_ID(), /* 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-08-10T13:49:13 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 13804544 */ CONNECTION_ID(), /* 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-08-10T13:49:27 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 9400832 */ CONNECTION_ID(), /* 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-08-10T13:49:28 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 2236416 */ CONNECTION_ID(), /* 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-08-10T13:49:40 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 10364416 */ CONNECTION_ID(), /* 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-08-10T13:49:41 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 2193920 */ CONNECTION_ID(), /* 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-08-10T13:49:46 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 13625088 */ CONNECTION_ID(), /* 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-08-10T13:49:48 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 2003712 */ CONNECTION_ID(), /* 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-08-10T13:49:55 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 8125696 */ CONNECTION_ID(), /* 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-08-10T13:50:00 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 6375168 */ CONNECTION_ID(), /* 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-08-10T13:50:07 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 11284992 */ CONNECTION_ID(), /* 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-08-10T13:50:11 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 5624320 */ CONNECTION_ID(), /* 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-08-10T13:50:13 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9061120 */ CONNECTION_ID(), /* 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-08-10T13:50:16 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 13830912 */ CONNECTION_ID(), /* 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-08-10T13:50:19 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 12145152 */ CONNECTION_ID(), /* 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-08-10T13:50:19 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 16631296 */ CONNECTION_ID(), /* 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-08-10T13:50:22 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 16472320 */ CONNECTION_ID(), /* 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-08-10T13:50:27 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10921216 */ CONNECTION_ID(), /* 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-08-10T13:50:27 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 14812416 */ CONNECTION_ID(), /* 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-08-10T13:50:35 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 353536 */ CONNECTION_ID(), /* 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-08-10T13:50:38 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 11807488 */ CONNECTION_ID(), /* 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-08-10T13:50:39 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 4013824 */ CONNECTION_ID(), /* 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-08-10T13:50:40 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 4104448 */ CONNECTION_ID(), /* 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-08-10T13:50:40 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 12994816 */ CONNECTION_ID(), /* 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-08-10T13:50:41 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 14329600 */ CONNECTION_ID(), /* 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-08-10T13:50:43 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 887296 */ CONNECTION_ID(), /* 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-08-10T13:51:02 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 8334592 */ CONNECTION_ID(), /* 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-08-10T13:51:03 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 8509952 */ CONNECTION_ID(), /* 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-08-10T13:51:04 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10285056 */ CONNECTION_ID(), /* 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-08-10T13:51:09 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9255168 */ CONNECTION_ID(), /* 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-08-10T13:51:12 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1634560 */ CONNECTION_ID(), /* 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-08-10T13:51:15 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 1457408 */ CONNECTION_ID(), /* 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-08-10T13:51:21 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 14090496 */ CONNECTION_ID(), /* 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-08-10T13:51:24 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 1862144 */ CONNECTION_ID(), /* 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-08-10T13:51:31 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 384768 */ CONNECTION_ID(), /* 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-08-10T13:51:31 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 4637952 */ CONNECTION_ID(), /* 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-08-10T13:51:37 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 9016576 */ CONNECTION_ID(), /* 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-08-10T13:51:40 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 6558976 */ CONNECTION_ID(), /* 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-08-10T13:51:43 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 10062336 */ CONNECTION_ID(), /* 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-08-10T13:51:43 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 16478208 */ CONNECTION_ID(), /* 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-08-10T13:51:44 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 13341184 */ CONNECTION_ID(), /* 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-08-10T13:51:47 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 7443968 */ CONNECTION_ID(), /* 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-08-10T13:51:52 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 16425472 */ CONNECTION_ID(), /* 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-08-10T13:51:56 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 3328512 */ CONNECTION_ID(), /* 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-08-10T13:52:01 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 1378816 */ CONNECTION_ID(), /* 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-08-10T13:52:02 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 12231424 */ CONNECTION_ID(), /* 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-08-10T13:52:05 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 12900864 */ CONNECTION_ID(), /* 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-08-10T13:52:11 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 5527552 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE func_1 ( 9 ) < `col_int_key` failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:52:14 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 5020416 */ CONNECTION_ID(), /* 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-08-10T13:52:17 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 8315136 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 2 ) AS `col_int_key` FROM view_1 WHERE 2 <> func_1 ( func_3 ( 2 ) ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:52:18 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 838912 */ CONNECTION_ID(), /* 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-08-10T13:52:26 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 2697472 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE `col_int_key` < func_2 ( 3 ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:52:28 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 6140672 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 8 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:52:30 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 3283712 */ CONNECTION_ID(), /* 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-08-10T13:52:32 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1922048 */ CONNECTION_ID(), /* 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-08-10T13:52:32 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 3321344 */ CONNECTION_ID(), /* 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-08-10T13:52:34 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 7423232 */ CONNECTION_ID(), /* 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-08-10T13:52:36 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 12263680 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 1 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:52:40 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 200960 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE 6 <> 7 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:52:40 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 16603648 */ CONNECTION_ID(), /* 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-08-10T13:52:43 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 14170368 */ CONNECTION_ID(), /* 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-08-10T13:52:46 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 3257856 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM view_1 WHERE func_2 ( `col_int_key` ) < func_3 ( func_2 ( `col_int_key` ) ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:52:49 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 1222400 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( `col_int_key` ) AS `col_int_key` FROM view_1 WHERE 1 < 9 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:52:50 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 12447232 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 6 AS `col_int_key` FROM view_1 WHERE func_3 ( 4 ) < func_1 ( func_3 ( `col_int_key` ) ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:52:51 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 15460096 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 4 ) AS `col_int_key` FROM view_1 WHERE 7 < 6 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:52:52 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 15329792 */ CONNECTION_ID(), /* 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-08-10T13:52:55 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 3917312 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 4 ) AS `col_int_key` FROM view_1 WHERE func_3 ( func_3 ( 5 ) ) < func_3 ( 7 ) failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:52:58 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 6603264 */ CONNECTION_ID(), /* 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-08-10T13:53:01 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 13218816 */ CONNECTION_ID(), /* 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-08-10T13:53:02 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 10840832 */ CONNECTION_ID(), /* 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-08-10T13:53:06 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= InnoDB SELECT /* QUERY_ID: 13029120 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM view_1 WHERE `col_int_key` < 9 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:53:10 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MEMORY SELECT /* QUERY_ID: 11157504 */ CONNECTION_ID(), /* 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-08-10T13:53:13 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 9227776 */ CONNECTION_ID(), /* 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-08-10T13:53:14 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 11703552 */ CONNECTION_ID(), /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 2 ) AS `col_int_key` FROM view_1 failed: 1443 The definition of table 'view_1' prevents operation CREATE on table 'table10_innodb'. # 2010-08-10T13:53:16 Query: CREATE TABLE table10_innodb ( `col_int_key` INTEGER, KEY (`col_int_key`) ) ENGINE= MyISAM SELECT /* QUERY_ID: 96000 */ CONNECTION_ID(), /* 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-08-10T13:53:25 Child process completed with error code 32. # 2010-08-10T13:53:25 Child process completed with error code 32. # 2010-08-10T13:53:25 Child process completed successfully. # 2010-08-10T13:53:25 Child process completed successfully. # 2010-08-10T13:53:25 Child process completed successfully. # 2010-08-10T13:53:25 Child process completed successfully. # 2010-08-10T13:53:25 Child process completed successfully. # 2010-08-10T13:53:25 Child process completed successfully. # 2010-08-10T13:53:25 Child process completed successfully. # 2010-08-10T13:53:25 Child process completed successfully. # 2010-08-10T13:53:26 Killing periodic reporting process with pid 24718... # 2010-08-10T13:53:26 Kill GenTest::ErrorFilter(24717) # 2010-08-10T13:53:26 Test completed with failure status 32. # 2010-08-10T13:53:26 GenTest exited with exit status 32 # 2010-08-10T13:53:26 Stopping server on port 10020 # 2010-08-10T13:53:30 [24620] runall-new.pl will exit with exit status 32