> Bruce Momjian <maillist@candle.pha.pa.us> writes:
> > SELECT * FROM test WHERE test IN (SELECT * FROM test) fails with strange error
>
> What is this one all about? I don't see a problem offhand:
>
> regression=> create table test (test int);
> CREATE
> regression=> SELECT * FROM test WHERE test IN (SELECT * FROM test);
> test
> ----
> (0 rows)
The issue is the issue:test=> drop table test;DROPtest=> create table test(x int);CREATEtest=> insert into test values
(3);INSERT72169 1test=> select * from test where test in (select x from test);NOTICE: unknown node tag 704 in
fireRIRonSubselect()NOTICE: Node is: { IDENT "test" }ERROR: ExecEvalExpr: unknown expression type 704test=>
> > Fix function pointer calls to take Datum args for char and int2 args(ecgs)
>
> I think the consensus is to leave this alone until we can get more info.
Yes. I will remove it.
>
> > Large Object memory problems
>
> As far as I can tell, lo_read/lo_write etc do not leak memory anymore
> (well, maybe they do within a transaction, but it's all cleaned up at
> xact end).
>
> There is a small leak every time a new LO is created, but I believe this
> is not specific to LOs --- I think it is the same leak in the relcache
> that occurs on the first reference to a relation of *any* kind. (See
> my message "Memory leaks in relcache" dated 5/15/99.)
>
> In short, I think this one can be closed out, or at least removed from
> the 6.5-release-stoppers list.
Removed.
> > refint problems
>
> What is the issue here?
I thought regression tests were showing a problem?
> > spinlock stuck problem
>
> I think this might be fixed... at least Vadim fixed one cause of it...
Anyone?
>
> > benchmark performance problem
>
> The only thing I have been able to find out here is that btree is fairly
> inefficient in the presence of *many* equal keys. I do not think this
> is a showstopper, although if I get time I might try to fix the easiest-
> to-fix aspect of it (linear search in bt_firsteq).
I will move it to TODO if it is not done for final.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026