return typ of count(*) in V4.0.18/V4.1 is different

am 26.02.2004 21:44:41 von Mario Neudeck

Hi,

I have a strange problem in the return types of the query:

select count(*) from table gives in MySQL Version 4.0.18 an return
type of long. In Version 4.1.1 its an char ("0").
The query goes vi MyODBC to MySQL. I checked the ODBC Trace to see
the different return types.

Does anyone know about this problem?
I already checked the manual/bug/changes section.
But I did get any ideas.

I hope somebody can help me.
Thanks in advance.

Mario

--

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: return typ of count(*) in V4.0.18/V4.1 is different

am 27.02.2004 13:12:22 von Sinisa Milivojevic

Mario Neudeck writes:
> Hi,
>
> I have a strange problem in the return types of the query:
>
> select count(*) from table gives in MySQL Version 4.0.18 an return
> type of long. In Version 4.1.1 its an char ("0").
> The query goes vi MyODBC to MySQL. I checked the ODBC Trace to see
> the different return types.
>
> Does anyone know about this problem?
> I already checked the manual/bug/changes section.
> But I did get any ideas.
>
> I hope somebody can help me.
> Thanks in advance.
>
> Mario
>
>

What MyODBC version did you use ??

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus

Meet the MySQL at User Conference ! (April 14-16, 2004)
http://www.mysql.com/uc2004/

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: return typ of count(*) in V4.0.18/V4.1 is different

am 27.02.2004 15:48:02 von Sinisa Milivojevic

Sinisa Milivojevic writes:
> Mario Neudeck writes:
> > Hi,
> >
> > I have a strange problem in the return types of the query:
> >
> > select count(*) from table gives in MySQL Version 4.0.18 an return
> > type of long. In Version 4.1.1 its an char ("0").
> > The query goes vi MyODBC to MySQL. I checked the ODBC Trace to see
> > the different return types.
> >
> > Does anyone know about this problem?
> > I already checked the manual/bug/changes section.
> > But I did get any ideas.
> >
> > I hope somebody can help me.
> > Thanks in advance.
> >
> > Mario
> >
> >
>

BTW. With 4.1, you should use MyODBC 3.52.

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus

Meet the MySQL at User Conference ! (April 14-16, 2004)
http://www.mysql.com/uc2004/

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: return typ of count(*) in V4.0.18/V4.1 is different

am 27.02.2004 16:53:59 von Mario Neudeck

On Fri, Feb 27, 2004 at 02:12:22PM +0200, Sinisa Milivojevic wrote:
>
> What MyODBC version did you use ??
>

MyODBC Version 3.51.06

If i connect to MySQL 4.0.18 it's ok, the Problem is only in Version
4.1.1

Maybe it's only a mistake of configuration?

Next I will try MyODBC 3.52.

Thanks,

Mario
--

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org