>>>>>>>>>>>> Euler Taveira de Oliveira wrote (2009-10-29 12:17:36): > Bernt Marius Johnsen escreveu: > > The below query generated by the Random Query Generator > > (https://launchpad.net/randgen) causes a segfault. It was caused running > >
Checkout the latest RQG from launchpad and run ./gentest.pl as shown above (The lastest tarball misses a feature you need). xx.yy is attached. Run like this: ./gentest.pl --dsn=dbi:Pg:user=xxxx --gendata --queries=100000 --threads=1 --grammar=/path/to/xx.yy > Could you get a core dump and post the gdb backtrace? > > $ ulimit -c unlimited > $ pg_ctl start > $ psql -c "<my query goes here>" mydb > $ gdb /path/to/postgres $PGDATA/core > (gdb) bt > . > . > . > (gdb) quit We'll see next week If I can spare some time. > > > -- > Euler Taveira de Oliveira > http://www.timbira.com/ -- Bernt Marius Johnsen, Staff Engineer Database Technology Group, Sun Microsystems, Trondheim, Norway
query: { $stack->push(); $global->set("alias",0) } SELECT * from join { $stack->pop(undef) } ; join: { $stack->push() } table_or_join { $stack->set("left",$stack->get("result")); } LEFT JOIN table_or_join ON { $prng->arrayElement($stack->get("left")).".`int_key` = ".$prng->arrayElement($stack->get("result")).".`int_key`" } { $stack->pop([keys %{{map {$_=>1} (@{$stack->get("left")},@{$stack->get("result")})}}]) } ; table_or_join: table | table | join ; table: { $stack->push() } tab AS { my $x = $global->get("alias"); $global->set("alias",$x+1); $stack->pop(["alias$x"]); "alias$x" } ; tab: A | B | AA | BB ;
signature.asc
Description: Digital signature