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

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/59D870E8-5ACB-407C-9724-BFF629FF2DD7(at)getmailspring(dot)com/1?redirect=https%3A%2F%2Fwinpg.jp%2F~inoue%2Fpsqlodbc%2Findex.html&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/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=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> 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=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/59D870E8-5ACB-407C-9724-BFF629FF2DD7(at)getmailspring(dot)com/2?redirect=mailto%3Ah-inoue%40dream.email.ne.jp&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
>

---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com