randgen team mailing list archive

[Roel Van de Paar <838500@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

==============
# 2011-09-01T12:14:55 Query: SELECT DISTINCT * FROM `PP_E`  WHERE ( `col_varchar_10_key` IS  NULL OR `col_varchar_10_key` IS NOT NULL ) AND ( `col_varchar_10_key` IS  NULL OR `co
l_varchar_64_key` IS  NULL ) AND ( `col_smallint_key`  BETWEEN 5 AND 255 + 1 OR `col_bigint_key`  IN ( 8 , 154 ) ) AND ( `col_varchar_64_key`  IN ( 'emqmr' , 'Iowa' , 'temqmrnbue
' , 'at' ) OR `col_varchar_64_key`  BETWEEN 'sa' AND 'f' )  /*  */ failed: 1054 Unknown column '%s' in 'where clause'. Further errors of this kind will be suppressed.
Table 'vPP_B_0' in schema 'test' has no 'indexed' columns at lib/GenTest/Generator/FromGrammar.pm line 275  <---
# 2011-09-01T12:14:56 Killing periodic reporting process with pid 30882...
# 2011-09-01T12:14:56 Kill GenTest::ErrorFilter(30881)
# 2011-09-01T12:14:56 Test completed with failure status STATUS_PERL_FAILURE (255)
# 2011-09-01T12:14:56 gentest.pl exited with exit status STATUS_PERL_FAILURE (255)
2011-09-01T12:14:57 [28205] runall.pl will exit with exit status STATUS_PERL_FAILURE (255)
==============

Command line to reproduce:

perl runall.pl --queries=100000000 --seed=random --threads=1
--duration=300 --querytimeout=10 --engine=MEMORY
--mysqld=--max_heap_table_size=134217728 --views --Validator=Transformer
--grammar=/randgen/conf/optimizer/range_access2.yy
--gendata=/randgen/conf/partitioning/partition_pruning.zz --mask=50528
--basedir1=/mysql/mysql-5.6-linux-x86_64 --vardir1=/tmp/test3

** Affects: randgen
     Importance: Undecided
         Status: New

** Description changed:

  ==============
  # 2011-09-01T12:14:55 Query: SELECT DISTINCT * FROM `PP_E`  WHERE ( `col_varchar_10_key` IS  NULL OR `col_varchar_10_key` IS NOT NULL ) AND ( `col_varchar_10_key` IS  NULL OR `co
  l_varchar_64_key` IS  NULL ) AND ( `col_smallint_key`  BETWEEN 5 AND 255 + 1 OR `col_bigint_key`  IN ( 8 , 154 ) ) AND ( `col_varchar_64_key`  IN ( 'emqmr' , 'Iowa' , 'temqmrnbue
  ' , 'at' ) OR `col_varchar_64_key`  BETWEEN 'sa' AND 'f' )  /*  */ failed: 1054 Unknown column '%s' in 'where clause'. Further errors of this kind will be suppressed.
  Table 'vPP_B_0' in schema 'test' has no 'indexed' columns at lib/GenTest/Generator/FromGrammar.pm line 275  <---
  # 2011-09-01T12:14:56 Killing periodic reporting process with pid 30882...
  # 2011-09-01T12:14:56 Kill GenTest::ErrorFilter(30881)
  # 2011-09-01T12:14:56 Test completed with failure status STATUS_PERL_FAILURE (255)
  # 2011-09-01T12:14:56 gentest.pl exited with exit status STATUS_PERL_FAILURE (255)
  2011-09-01T12:14:57 [28205] runall.pl will exit with exit status STATUS_PERL_FAILURE (255)
  ==============
  
  Command line to reproduce:
  
  perl runall.pl --queries=100000000 --seed=random --threads=1
  --duration=300 --querytimeout=10 --engine=MEMORY
  --mysqld=--max_heap_table_size=134217728 --views --Validator=Transformer
  --grammar=/randgen/conf/optimizer/range_access2.yy
  --gendata=/randgen/conf/partitioning/partition_pruning.zz --mask=50528
- --basedir1=/mysql/mysql-5.6.3-m5-linux-x86_64-fuchsia
- --vardir1=/tmp/test3
+ --basedir1=/mysql/mysql-5.6-linux-x86_64 --vardir1=/tmp/test3

-- 
You received this bug notification because you are a member of Random
Query Generator Team, which is subscribed to Random Query Generator.
https://bugs.launchpad.net/bugs/838500

Title:
  Table <name> in schema 'test' has no 'indexed' columns at
  lib/GenTest/Generator/FromGrammar.pm line 275

Status in SQL Generator for testing SQL servers (MySQL, JavaDB, PostgreSQL):
  New

Bug description:
  ==============
  # 2011-09-01T12:14:55 Query: SELECT DISTINCT * FROM `PP_E`  WHERE ( `col_varchar_10_key` IS  NULL OR `col_varchar_10_key` IS NOT NULL ) AND ( `col_varchar_10_key` IS  NULL OR `co
  l_varchar_64_key` IS  NULL ) AND ( `col_smallint_key`  BETWEEN 5 AND 255 + 1 OR `col_bigint_key`  IN ( 8 , 154 ) ) AND ( `col_varchar_64_key`  IN ( 'emqmr' , 'Iowa' , 'temqmrnbue
  ' , 'at' ) OR `col_varchar_64_key`  BETWEEN 'sa' AND 'f' )  /*  */ failed: 1054 Unknown column '%s' in 'where clause'. Further errors of this kind will be suppressed.
  Table 'vPP_B_0' in schema 'test' has no 'indexed' columns at lib/GenTest/Generator/FromGrammar.pm line 275  <---
  # 2011-09-01T12:14:56 Killing periodic reporting process with pid 30882...
  # 2011-09-01T12:14:56 Kill GenTest::ErrorFilter(30881)
  # 2011-09-01T12:14:56 Test completed with failure status STATUS_PERL_FAILURE (255)
  # 2011-09-01T12:14:56 gentest.pl exited with exit status STATUS_PERL_FAILURE (255)
  2011-09-01T12:14:57 [28205] runall.pl will exit with exit status STATUS_PERL_FAILURE (255)
  ==============

  Command line to reproduce:

  perl runall.pl --queries=100000000 --seed=random --threads=1
  --duration=300 --querytimeout=10 --engine=MEMORY
  --mysqld=--max_heap_table_size=134217728 --views
  --Validator=Transformer
  --grammar=/randgen/conf/optimizer/range_access2.yy
  --gendata=/randgen/conf/partitioning/partition_pruning.zz --mask=50528
  --basedir1=/mysql/mysql-5.6-linux-x86_64 --vardir1=/tmp/test3

To manage notifications about this bug go to:
https://bugs.launchpad.net/randgen/+bug/838500/+subscriptions