>>>>>>>>>>>> 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
