MySQL Bugs: #72910: use isnull(date)

Bug #72910	use isnull(date)
Submitted:	8 Jun 2014 7:02	Modified:	28 Feb 2015 12:57
Reporter:	Allen Briceño	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	5.3.2	OS:	Windows (7)
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	date, isnull

Description:
        Set rs4 = New Recordset
        rs4.Open "SELECT IF(ISNULL(campFin" & n3 & "),0,campFin" & n3 & ") AS campFin" & n3 & " FROM campanas WHERE vacacod='" & codigo.Text & "'", cn, adOpenDynamic, adLockOptimistic
        If rs4.Fields(0) = "0" Then

i use in visual basic 6.0 

in line isnull(campFin) error 13
in mysql field campFIn is DATE

i change field campFin to type varchar work, well if change to type date not work
i test line in workbench and work perfectly

How to repeat:
for repeat create table for fields type in date
and use mysql connector 5.3 or 5.2 in visual basic 6.0

create query for use if(isnull()

and view error 13

Hello Allen Briceño,

Thank you for the bug report.
I tried to reproduce the issue at my end using  visual basic 6.0,MySQL Connector/ODBC 5.3.4 but couldn't trace out any issue in IF(ISNULL(campFin),0,campFin)
Could you please list out the steps you tried out at your end? Please provide repeatable test case in order for us to confirm this issue at our end.

Thanks,
Chiranjeevi.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".