Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver

Hiroshi - my apologies. I believe that I did not appropriately remove the old version prior to adding this one to my system:

This is the correct result for that version of the driver:

The other mylog file is over 25mb. As a result, I'm sharing with you via a dropbox link:
https://www.dropbox.com/s/iwff1b3dl36forr/mylog_Microsoft_22916.log?dl=0 (https://link.getmailspring.com/link/59D870E8-5ACB-407C-9724-BFF629FF2DD7(at)getmailspring(dot)com/0?redirect=https%3A%2F%2Fwww.dropbox.com%2Fs%2Fiwff1b3dl36forr%2Fmylog_Microsoft_22916.log%3Fdl%3D0&recipient=cGdzcWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZw%3D%3D)
Thank you very much for your quick assistance - I now see the driver attempting to cast via an interval on date fields.
Best,
Scott

On Aug 13 2019, at 8:46 am, Scott Goley <scottmgoley(at)gmail(dot)com> wrote:
> Hi Hiroshi,
>
> Thank you for your response. I am not currently observing any change between this version and the previous version used. Please see the attached.
> Best,
> Scott
>
> On Aug 12 2019, at 6:44 am, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> wrote:
> > Hi Scott,
> >
> > Could you please try the test drivers 11.00.0200 on Windows at
> > https://winpg.jp/~inoue/psqlodbc/index.html (https://link.getmailspring.com/link/59D870E8-5ACB-407C-9724-BFF629FF2DD7(at)getmailspring(dot)com/1?redirect=https%3A%2F%2Fwinpg.jp%2F~inoue%2Fpsqlodbc%2Findex.html&recipient=cGdzcWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZw%3D%3D)
> > ?
> >
> > regards,
> > Hiroshi Inoue
> >
> > On 2019/08/11 7:51, Scott Goley wrote:
> > >
> > > Hiroshi,
> > > Thank you for your response. I will definitely look into that.
> > > Is there any resource which specifies what functions and flags are supported via the current psqlODBC driver? That would be extremely helpful to me if you were aware of one.
> > > Best,
> > > Scott G
> > >
> > >
> > >
> > > On Aug 9 2019, at 8:56 pm, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> (https://link.getmailspring.com/link/59D870E8-5ACB-407C-9724-BFF629FF2DD7(at)getmailspring(dot)com/2?redirect=mailto%3Ah-inoue%40dream.email.ne.jp&recipient=cGdzcWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZw%3D%3D) wrote:
> > > > Hi Scott,
> > > >
> > > > Unfortunately neither TIMESTAMPADD() nor TIMESTAMPDIFF() is supported now.
> > > > Could you please try test drivers which would support them?
> > > >
> > > > regards,
> > > > Hiroshi Inoue
> > > >
> > > > On 2019/08/09 0:00, Scott Goley wrote:
> > > > >
> > > > > Hi,
> > > > > Platform / Version info:
> > > > > Postgres 11.4
> > > > > psqlODBC_x64 v 11.01.0000
> > > > >
> > > > > I'm a developer working with PowerQuery / ODBC and I'm running into the following issue.
> > > > >
> > > > > I'm developing a custom connector which is utilizing this driver. I've attached the logs as requested when making a bug report. It looks like the SQL_TSI_DAY operator is being "interpreted" by the driver as a column reference rather than making the necessary conversion to the correct datetimeadd "interval" .
> > > > > I'm attaching the connector file - ODBCPostgresDirect simply because it contains all the flags that I'm setting for SQLCapabilities, ODBC function overrides etc.
> > > > > Any input on this would be helpful.
> > > > > Best,
> > > > > Scott
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
> > ウイルス フリー｡ www.avg.com (https://link.getmailspring.com/link/59D870E8-5ACB-407C-9724-BFF629FF2DD7(at)getmailspring(dot)com/4?redirect=http%3A%2F%2Fwww.avg.com%2Femail-signature%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient&recipient=cGdzcWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZw%3D%3D)