for sure, we have a bug open with Pivotal...the consultants we have are saying it's an Datadirect ODBC driver bug - WTF??? So when I SELECT from GP via ODBC, and by changing the log settings on the DB, I can get the DB to skip a record, and that's a bug with the calling function...??????
> Date: Tue, 10 Feb 2015 21:31:52 +1300
> From: mark(dot)kirkwood(at)catalyst(dot)net(dot)nz
> To: deanelliotdeloach(at)hotmail(dot)com; michael(dot)paquier(at)gmail(dot)com
> CC: pgsql-bugs(at)postgresql(dot)org
> Subject: Re: [BUGS] BUG #12749: WARNING: unrecognized node type: 701
>
> On 10/02/15 16:54, dean deloach wrote:
> > Thanks for the response guys, really appreciate it. Turns out, it has
> > something to do with the log_statement config parameter on the DB. The
> > DBA changed and no one knew...these are the results we get when we
> > attempt to pull data from the GP instance via Datadirect drivers, for
> > different log_statement config values:
> >
> >
> > log_statement=all - returns n records, no errors logged in Greenplum
> > log file
> >
> > log_statement=none - returns n records, no errors logged in Greenplum
> > log file
> >
> > log_statement=mod - returns n-1 records, "unknown node: 701" error
> > logged in Greenplum log file
> >
> > log_statement=ddl - returns n-1 records, "unknown node: 701" error
> > logged in Greenplum log file
> >
>
> That is pretty scary - I'd still recommend raising it with Pivotal -
> logging options changing the results of queries is ...*unexpected*...to
> put it mildly!
>
> Cheers
>
> Mark
>