public inbox for rhdb-explain@sourceware.org
 help / color / mirror / Atom feed
* Bug with large results
@ 2004-10-22  2:22 Jeffrey Melloy
  2004-10-22 13:55 ` Fernando Nasser
  0 siblings, 1 reply; 2+ messages in thread
From: Jeffrey Melloy @ 2004-10-22  2:22 UTC (permalink / raw)
  To: rhdb-explain

I downloaded RHDB-explain (CVS) and stumbled across a bug.

Small queries work fine, but a larger plan will fail with a null  
pointer exception.

Using PostgreSQL 7.4.5 on OS X.

Thanks,
Jeff

Error:
java.lang.NullPointerException
         at  
com.redhat.rhdb.explain.ExplainParserV73.addQual(ExplainParserV73.java: 
796)
         at  
com.redhat.rhdb.explain.ExplainParserV73.buildExplainTree(ExplainParserV 
73.java:343)
         at  
com.redhat.rhdb.explain.ExplainParserV73.explain(ExplainParserV73.java: 
187)
         at  
com.redhat.rhdb.explain.Explain$ExplainThread.run(Explain.java:298)


Query:
select * from message_v;

plan:
                                                 QUERY PLAN
------------------------------------------------------------------------ 
-----------------------------------
  Hash Join  (cost=34961.26..3454046.29 rows=155607 width=164)
    Hash Cond: ("outer".sender_id = "inner".user_id)
    Join Filter: (("inner".effdate <= "outer".message_date) AND (NOT  
(subplan)))
    ->  Hash Join  (cost=34923.29..2628055.36 rows=50978 width=115)
          Hash Cond: ("outer".recipient_id = "inner".user_id)
          Join Filter: (NOT (subplan))
          ->  Merge Join  (cost=34916.77..50555.99 rows=297841 width=105)
                Merge Cond: ("outer".user_id = "inner".recipient_id)
                Join Filter: ("outer".effdate <= "inner".message_date)
                ->  Sort  (cost=46.03..47.35 rows=526 width=39)
                      Sort Key: r_disp.user_id
                      ->  Seq Scan on user_display_name r_disp   
(cost=0.00..22.26 rows=526 width=39)
                ->  Sort  (cost=34870.74..35279.24 rows=163399 width=66)
                      Sort Key: m.recipient_id
                      ->  Seq Scan on messages m  (cost=0.00..6361.99  
rows=163399 width=66)
          ->  Hash  (cost=5.81..5.81 rows=281 width=26)
                ->  Seq Scan on users r  (cost=0.00..5.81 rows=281  
width=26)
          SubPlan
            ->  Index Scan using im_display_user on user_display_name  
udn  (cost=0.00..8.64 rows=1 width=0)
                  Index Cond: (user_id = $4)
                  Filter: ((effdate > $3) AND (effdate <= $2))
    ->  Hash  (cost=36.66..36.66 rows=526 width=65)
          ->  Hash Join  (cost=6.51..36.66 rows=526 width=65)
                Hash Cond: ("outer".user_id = "inner".user_id)
                ->  Seq Scan on user_display_name s_disp   
(cost=0.00..22.26 rows=526 width=39)
                ->  Hash  (cost=5.81..5.81 rows=281 width=26)
                      ->  Seq Scan on users s  (cost=0.00..5.81 rows=281  
width=26)
    SubPlan
      ->  Index Scan using im_display_user on user_display_name udn   
(cost=0.00..8.64 rows=1 width=0)
            Index Cond: (user_id = $1)
            Filter: ((effdate > $0) AND (effdate <= $2))
(31 rows)

^ permalink raw reply	[flat|nested] 2+ messages in thread

end of thread, other threads:[~2004-10-22 13:55 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2004-10-22  2:22 Bug with large results Jeffrey Melloy
2004-10-22 13:55 ` Fernando Nasser

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).