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

Hiroshi,

I'm happy to say that this has reflected a massive improvement in performance for this connector / driver.
Thank you very much!
I can tell there are some edge cases which are not working as expected but in general this meets my very high level requirements.
Let me take a few days to isolate these particular issues remaining with reproducible conditions before sending you further logs.

I am most grateful.
Scott
On Aug 14 2019, at 10:24 am, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> wrote:
>
> Oops sorry,
> The error was caused by changes about another problem.
>
> Could you please try the test drivers on Windows 11.00.0320 at
> https://winpg.jp/~inoue/psqlodbc/index.html (https://link.getmailspring.com/link/827528D4-F338-402D-B793-8695C80712C1(at)getmailspring(dot)com/0?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F59D870E8-5ACB-407C-9724-BFF629FF2DD7%40getmailspring.com%2F1%3Fredirect%3Dhttps%253A%252F%252Fwinpg.jp%252F~inoue%252Fpsqlodbc%252Findex.html%26recipient%3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%253D%253D&recipient=aC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D)
> ?
>
> regards,
> Hiroshi Inoue
>
>
> On 2019/08/14 22:22, Scott Goley wrote:
> >
> > Hiroshi,
> > I'm afraid this version has broken my ability to make a connection so I am unable to verify the rest of the changes. This is after verifying the driver updated correctly and is showing on the logs as "11.01.0310"
> >
> >
> > Best regards,
> > Scott
> >
> > On Aug 14 2019, at 6:49 am, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> (mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp) wrote:
> > > Hi Scott,
> > >
> > > Could you please try the test drivers on Windows 11.00.0310 at
> > > https://winpg.jp/~inoue/psqlodbc/index.html (https://link.getmailspring.com/link/827528D4-F338-402D-B793-8695C80712C1(at)getmailspring(dot)com/0?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F59D870E8-5ACB-407C-9724-BFF629FF2DD7%40getmailspring.com%2F1%3Fredirect%3Dhttps%253A%252F%252Fwinpg.jp%252F~inoue%252Fpsqlodbc%252Findex.html%26recipient%3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%253D%253D&recipient=aC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D)
> > > ?
> > >
> > > regards,
> > > Hiroshi Inoue
> > >
> > > On 2019/08/13 23:27, Scott Goley wrote:
> > > >
> > > > 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/827528D4-F338-402D-B793-8695C80712C1(at)getmailspring(dot)com/1?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F59D870E8-5ACB-407C-9724-BFF629FF2DD7%40getmailspring.com%2F0%3Fredirect%3Dhttps%253A%252F%252Fwww.dropbox.com%252Fs%252Fiwff1b3dl36forr%252Fmylog_Microsoft_22916.log%253Fdl%253D0%26recipient%3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%253D%253D&recipient=aC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%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> (https://link.getmailspring.com/link/827528D4-F338-402D-B793-8695C80712C1(at)getmailspring(dot)com/2?redirect=mailto%3Ascottmgoley%40gmail.com&recipient=aC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D) 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> (https://link.getmailspring.com/link/827528D4-F338-402D-B793-8695C80712C1(at)getmailspring(dot)com/3?redirect=mailto%3Ah-inoue%40dream.email.ne.jp&recipient=aC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%3D%3D) 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/827528D4-F338-402D-B793-8695C80712C1(at)getmailspring(dot)com/4?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F59D870E8-5ACB-407C-9724-BFF629FF2DD7%40getmailspring.com%2F1%3Fredirect%3Dhttps%253A%252F%252Fwinpg.jp%252F~inoue%252Fpsqlodbc%252Findex.html%26recipient%3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%253D%253D&recipient=aC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%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/827528D4-F338-402D-B793-8695C80712C1(at)getmailspring(dot)com/5?redirect=https%3A%2F%2Flink.getmailspring.com%2Flink%2F59D870E8-5ACB-407C-9724-BFF629FF2DD7%40getmailspring.com%2F2%3Fredirect%3Dmailto%253Ah-inoue%2540dream.email.ne.jp%26recipient%3DaC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%253D%253D&recipient=aC1pbm91ZUBkcmVhbS5lbWFpbC5uZS5qcA%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 (http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient)