Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver
"Inoue, Hiroshi" <[email protected]> Mon, 12 Aug 2019 19:44:43 +0900
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --------------AA2E69E3088BBCFC430E843A Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Hi Scott, Could you please try the test drivers 11.00.0200 on Windows at https://winpg.jp/~inoue/psqlodbc/index.html ? 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 <[email protected]> > 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 --------------AA2E69E3088BBCFC430E843A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> </head> <body text="#000000" bgcolor="#FFFFFF"> Hi Scott,<br> <br> Could you please try the test drivers 11.00.0200 on Windows at <br> <a class="moz-txt-link-freetext" href="https://winpg.jp/~inoue/psqlodbc/index.html">https://winpg.jp/~inoue/psqlodbc/index.html</a> <br> ? <br> <br> regards, <br> Hiroshi Inoue <br> <br> <div class="moz-cite-prefix">On 2019/08/11 7:51, Scott Goley wrote:<br> </div> <blockquote type="cite" cite="mid:[email protected]"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <div>Hiroshi, </div> <br> <div>Thank you for your response. I will definitely look into that. </div> <br> <div>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. </div> <br> <div>Best, </div> <div>Scott G</div> <br> <br> <br> <div class="gmail_quote_attribution">On Aug 9 2019, at 8:56 pm, Inoue, Hiroshi <a class="moz-txt-link-rfc2396E" href="mailto:[email protected]"><[email protected]></a> wrote:</div> <blockquote> <div> <div> Hi Scott,</div> <br> <div>Unfortunately neither TIMESTAMPADD() nor TIMESTAMPDIFF() is supported now.</div> <div>Could you please try test drivers which would support them?</div> <br> <div>regards,</div> <div>Hiroshi Inoue</div> <br> <div class="moz-cite-prefix"> <div>On 2019/08/09 0:00, Scott Goley wrote:</div> </div> <blockquote><br> <div>Hi,</div> <br> <div>Platform / Version info:</div> <br> <div>Postgres 11.4</div> <div>psqlODBC_x64 v 11.01.0000</div> <br> <div>I'm a developer working with PowerQuery / ODBC and I'm running into the following issue.</div> <br> <div><img alt="" src="cid:[email protected]" moz-do-not-send="true"></div> <br> <div>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" .</div> <br> <div>I'm attaching the connector file - ODBCPostgresDirect simply because it contains all the flags that I'm setting for SQLCapabilities, ODBC function overrides etc.</div> <br> <div>Any input on this would be helpful.</div> <br> <div>Best,</div> <div> <div>Scott<br> </div> </div> </blockquote> </div> </blockquote> </blockquote> <div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br /> <table style="border-top: 1px solid #D3D4DE;"> <tr> <td style="width: 55px; padding-top: 18px;"><a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" width="46" height="29" style="width: 46px; height: 29px;" /></a></td> <td style="width: 470px; padding-top: 17px; color: #41424e; font-size: 13px; font-family: Arial, Helvetica, sans-serif; line-height: 18px;">ウイルス フリー｡ <a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank" style="color: #4453ea;">www.avg.com</a> </td> </tr> </table> <a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></div></body> </html> --------------AA2E69E3088BBCFC430E843A--