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

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 [at] m.gmane.org
Mario Neudeck [ Do, 26 Februar 2004 21:44 ] [ ID #83075 ]

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

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 <sinisa [at] mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ 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 [at] m.gmane.org
Sinisa Milivojevic [ Fr, 27 Februar 2004 13:12 ] [ ID #83078 ]

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

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 <sinisa [at] mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ 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 [at] m.gmane.org
Sinisa Milivojevic [ Fr, 27 Februar 2004 15:48 ] [ ID #83080 ]

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

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 [at] m.gmane.org
Mario Neudeck [ Fr, 27 Februar 2004 16:53 ] [ ID #83081 ]
Datenbanken » gmane.comp.db.mysql.bugs » return typ of count(*) in V4.0.18/V4.1 is different

Vorheriges Thema: Mandy
Nächstes Thema: wierd error message from mysqld