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

--5d4f4a6d_0_8647f11f
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hiroshi,

Thank you for your response. I will definitely look into that.
Is there any resource which specifies what functions and flags are suppor=
ted via the current psqlODBC driver=3F 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=40dream.email.ne.jp> w=
rote:
> Hi Scott,
>
> Unfortunately neither TIMESTAMPADD() nor TIMESTAMPDI=46=46() is support=
ed now.
> Could you please try test drivers which would support them=3F
>
> regards,
> Hiroshi Inoue
>
> On 2019/08/09 0:00, Scott Goley wrote:
> >
> > Hi,
> > Platform / Version info:
> > Postgres 11.4
> > psqlODBC=5Fx64 v 11.01.0000
> >
> > I'm a developer working with PowerQuery / ODBC and I'm running into t=
he following issue.
> >
> > I'm developing a custom connector which is utilizing this driver. I'v=
e attached the logs as requested when making a bug report. It looks like =
the SQL=5FTSI=5FDAY operator is being =22interpreted=22 by the driver as =
a column reference rather than making the necessary conversion to the cor=
rect datetimeadd =22interval=22 .
> > I'm attaching the connector file - ODBCPostgresDirect simply because =
it contains all the flags that I'm setting for SQLCapabilities, ODBC func=
tion overrides etc.
> > Any input on this would be helpful.
> > Best,
> > Scott
> >
>
>
> =E3=82=A6=E3=82=A4=E3=83=AB=E3=82=B9 =E3=83=95=E3=83=AA=E3=83=BC=EF=BD=A1=
 www.avg.com (https://link.getmailspring.com/link/A8B8CEE7-2=466D-4AE4-BE=
2A-658777E043C1=40getmailspring.com/1=3Fredirect=3Dhttp%3A%2=46%2=46www.a=
vg.com%2=46email-signature%3=46utm=5Fmedium%3Demail%26utm=5Fsource%3Dlink=
%26utm=5Fcampaign%3Dsig-email%26utm=5Fcontent%3Demailclient&recipient=3Dc=
GdzcWwtb2RiY0Bwb3N0Z3Jlc3=46sLm9yZw%3D%3D)
--5d4f4a6d_0_8647f11f
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div>Hiroshi, </div><br><div>Thank you for your response. I will definite=
ly look into that. </div><br><div>Is there any resource which specifies w=
hat functions and flags are supported via the current psqlODBC driver=3F&=
nbsp; That would be extremely helpful to me if you were aware of one. </d=
iv><br><div>Best, </div><div>Scott G</div><br><br><br><div class=3D=22gma=
il=5Fquote=5Fattribution=22>On Aug 9 2019, at 8:56 pm, Inoue, Hiroshi &lt=
;h-inoue=40dream.email.ne.jp&gt; wrote:</div><blockquote><div><div> Hi Sc=
ott,</div><br><div>Unfortunately neither TIMESTAMPADD() nor TIMESTAMPDI=46=
=46() is supported now.</div><div>Could you please try test drivers which=
 would support them=3F</div><br><div>regards,</div><div>Hiroshi Inoue</di=
v><br><div class=3D=22moz-cite-prefix=22><div>On 2019/08/09 0:00, Scott G=
oley wrote:</div></div><blockquote><br><div>Hi,</div><br><div>Platform / =
Version info:</div><br><div>Postgres 11.4</div><div>psqlODBC=5Fx64 v 11.0=
1.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=3D=22=22 src=3D=
=22cid:part1.C0349=467A.49518715=40dream.email.ne.jp=22></div><br><div>I'=
m developing a custom connector which is utilizing this driver. I've atta=
ched the logs as requested when making a bug report. It looks like the SQ=
L=5FTSI=5FDAY operator is being =22interpreted=22 by the driver as a colu=
mn reference rather than making the necessary conversion to the correct d=
atetimeadd =22interval=22 .</div><br><div>I'm attaching the connector fil=
e - ODBCPostgresDirect simply because it contains all the flags that I'm =
setting for SQLCapabilities, ODBC function overrides etc.</div><br><div>A=
ny input on this would be helpful.</div><br><div>Best,</div><div><div>Sco=
tt</div></div></blockquote><div><br><div><table style=3D=22border-top: 1p=
x solid =23D3D4DE;=22><tbody><tr><td style=3D=22width: 55px; padding-top:=
 18px;=22><a href=3D=22https://link.getmailspring.com/link/A8B8CEE7-2=466=
D-4AE4-BE2A-658777E043C1=40getmailspring.com/0=3Fredirect=3Dhttp%3A%2=46%=
2=46www.avg.com%2=46email-signature%3=46utm=5Fmedium%3Demail%26utm=5Fsour=
ce%3Dlink%26utm=5Fcampaign%3Dsig-email%26utm=5Fcontent%3Demailclient&amp;=
recipient=3DcGdzcWwtb2RiY0Bwb3N0Z3Jlc3=46sLm9yZw%3D%3D=22 target=3D=22=5F=
blank=22><img src=3D=22https://ipmcdn.avast.com/images/icons/icon-envelop=
e-tick-green-avg-v1.png=22 alt=3D=22=22 width=3D=2246=22 height=3D=2229=22=
 style=3D=22width: 46px; height: 29px;=22></a></td> <td style=3D=22width:=
 470px; padding-top: 17px; color: =2341424e; font-size: 13px; font-family=
: Arial, Helvetica, sans-serif; line-height: 18px;=22>=E3=82=A6=E3=82=A4=E3=
=83=AB=E3=82=B9 =E3=83=95=E3=83=AA=E3=83=BC=EF=BD=A1 <a href=3D=22https:/=
/link.getmailspring.com/link/A8B8CEE7-2=466D-4AE4-BE2A-658777E043C1=40get=
mailspring.com/1=3Fredirect=3Dhttp%3A%2=46%2=46www.avg.com%2=46email-sign=
ature%3=46utm=5Fmedium%3Demail%26utm=5Fsource%3Dlink%26utm=5Fcampaign%3Ds=
ig-email%26utm=5Fcontent%3Demailclient&amp;recipient=3DcGdzcWwtb2RiY0Bwb3=
N0Z3Jlc3=46sLm9yZw%3D%3D=22 target=3D=22=5Fblank=22 style=3D=22color: =23=
4453ea;=22>www.avg.com</a> </td> </tr></tbody></table></div></div></div><=
/blockquote><img class=3D=22mailspring-open=22 alt=3D=22Sent from Mailspr=
ing=22 width=3D=220=22 height=3D=220=22 style=3D=22border:0; width:0; hei=
ght:0;=22 src=3D=22https://link.getmailspring.com/open/A8B8CEE7-2=466D-4A=
E4-BE2A-658777E043C1=40getmailspring.com=3Fme=3D98caf4ee&amp;recipient=3D=
cGdzcWwtb2RiY0Bwb3N0Z3Jlc3=46sLm9yZw%3D%3D=22>
--5d4f4a6d_0_8647f11f--