mysql_bind_result does not support BLOB fields

am 29.07.2003 15:01:12 von Vladimir Zheleznyak

------=_NextPart_000_0368_01C355EA.A243DAD0
Content-Type: text/plain;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable

Hello,

On field binding (mysql_bind_result) it is necessary to allocate buffer =
with maximum field size. On the other hand, MEDIUMBLOB, LONGBLOB, =
MEDIUMTEXT, LONGTEXT maximum size is too large for that.

Originator: Vladimir Zheleznyak
Organization: CoreLab
MySQL support: none
Severity: serious
Priority: medium
Category: =F3
Class: sw-bug
Release: mysql-4.1.0

Exectutable: libmysql.dll
System: Win2000
Compiler: VC++ 6.0
Architecture: i

Best regards,
Vladimir Zheleznyak

------=_NextPart_000_0368_01C355EA.A243DAD0--

Re: mysql_bind_result does not support BLOB fields

am 29.07.2003 15:12:13 von Sinisa Milivojevic

Hello,

On field binding (mysql_bind_result) it is necessary to allocate buffer =
with maximum field size. On the other hand, MEDIUMBLOB, LONGBLOB, =
MEDIUMTEXT, LONGTEXT maximum size is too large for that.

Best regards,
Vladimir Zheleznyak

What alternative solution would you suggest ??

--

Regards,

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

--
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: mysql_bind_result does not support BLOB fields

am 29.07.2003 16:15:27 von Vladimir Zheleznyak

Hello,

> What alternative solution would you suggest ??

For example you can provide function to read BLOB-field value part-by-part.
Something like this:

unsigned int mysql_fetch_blob(MYSQL_STMT *stmt, unsigned int field_num, char
* Buf, unsigned int Count)

Accordingly, for getting whole value it is necessary to call
mysql_fetch_blob for each field in cycle.

Best regards,
Vladimir Zheleznyak

----- Original Message -----
From: "Sinisa Milivojevic"
To:
Cc:
Sent: Tuesday, July 29, 2003 4:12 PM
Subject: Re: mysql_bind_result does not support BLOB fields

>
> Hello,
>
> On field binding (mysql_bind_result) it is necessary to allocate buffer =
> with maximum field size. On the other hand, MEDIUMBLOB, LONGBLOB, =
> MEDIUMTEXT, LONGTEXT maximum size is too large for that.
>
>
> Best regards,
> Vladimir Zheleznyak
>
>
>
> What alternative solution would you suggest ??
>
> --
>
> Regards,
>
> --
> For technical support contracts, go to https://order.mysql.com/?ref=msmi
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB
> /_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
> <___/ www.mysql.com Larnaca, Cyprus
>
>
>

--
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: mysql_bind_result does not support BLOB fields

am 29.07.2003 18:17:10 von Sinisa Milivojevic

Vladimir Zheleznyak writes:
>
> Hello,
>
> > What alternative solution would you suggest ??
>
> For example you can provide function to read BLOB-field value part-by-part.
> Something like this:
>
> unsigned int mysql_fetch_blob(MYSQL_STMT *stmt, unsigned int field_num, char
> * Buf, unsigned int Count)
>
> Accordingly, for getting whole value it is necessary to call
> mysql_fetch_blob for each field in cycle.
>
> Best regards,
> Vladimir Zheleznyak
>

This is not yet doable.

Partial sending / receiving will not be in the works until 5.*

--

Regards,

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

--
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: mysql_bind_result does not support BLOB fields

am 30.07.2003 09:53:02 von Vladimir Zheleznyak

Hello,

I have in view copying portions of data from row-buffer on client, but not
receiving portions of data from server.

One more variant is publishing client internal row buffer. This variant is
more preferable considering performance.

Best regards,
Vladimir Zheleznyak

----- Original Message -----
From: "Sinisa Milivojevic"
To:
Cc:
Sent: Tuesday, July 29, 2003 7:17 PM
Subject: Re: mysql_bind_result does not support BLOB fields

> Vladimir Zheleznyak writes:
> >
> > Hello,
> >
> > > What alternative solution would you suggest ??
> >
> > For example you can provide function to read BLOB-field value
part-by-part.
> > Something like this:
> >
> > unsigned int mysql_fetch_blob(MYSQL_STMT *stmt, unsigned int field_num,
char
> > * Buf, unsigned int Count)
> >
> > Accordingly, for getting whole value it is necessary to call
> > mysql_fetch_blob for each field in cycle.
> >
> > Best regards,
> > Vladimir Zheleznyak
> >
>
> This is not yet doable.
>
> Partial sending / receiving will not be in the works until 5.*
>
> --
>
> Regards,
>
> --
> For technical support contracts, go to https://order.mysql.com/?ref=msmi
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB
> /_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
> <___/ www.mysql.com Larnaca, Cyprus
>
>
>

--
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: mysql_bind_result does not support BLOB fields

am 30.07.2003 10:49:15 von Venu

On Wed, 2003-07-30 at 00:53, Vladimir Zheleznyak wrote:
> Hello,

Hi !!

Using binary protocol, from 4.1.0 and above (preferably 4.1.1) you can
send blob/clob data in chunks to server using 'mysql_send_long_data()'.

Though the counter part is not yet ready; and we are in the discussion
process to support the counter part API in 5.0 (mysql_get_long_data()).

Coming to your mysql_bind_result for blobs, I couldn't able to reproduce
the behavior, as it worked for me. Can you please send your call
sequence ?

PS: From current BK source, you can get chunks(or any offset of desired
data from a particular column in the resultset) using
'mysql_fetch_column' (this API is not yet documented).

Thanks

>
> I have in view copying portions of data from row-buffer on client, but not
> receiving portions of data from server.
>
> One more variant is publishing client internal row buffer. This variant is
> more preferable considering performance.
>
> Best regards,
> Vladimir Zheleznyak
>
> ----- Original Message -----
> From: "Sinisa Milivojevic"
> To:
> Cc:
> Sent: Tuesday, July 29, 2003 7:17 PM
> Subject: Re: mysql_bind_result does not support BLOB fields
>
>
> > Vladimir Zheleznyak writes:
> > >
> > > Hello,
> > >
> > > > What alternative solution would you suggest ??
> > >
> > > For example you can provide function to read BLOB-field value
> part-by-part.
> > > Something like this:
> > >
> > > unsigned int mysql_fetch_blob(MYSQL_STMT *stmt, unsigned int field_num,
> char
> > > * Buf, unsigned int Count)
> > >
> > > Accordingly, for getting whole value it is necessary to call
> > > mysql_fetch_blob for each field in cycle.
> > >
> > > Best regards,
> > > Vladimir Zheleznyak
> > >
> >
> > This is not yet doable.
> >
> > Partial sending / receiving will not be in the works until 5.*
> >
> > --
> >
> > Regards,
> >
> > --
> > For technical support contracts, go to https://order.mysql.com/?ref=msmi
> > __ ___ ___ ____ __
> > / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB
> > /_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
> > <___/ www.mysql.com Larnaca, Cyprus
> >
> >
> >
--
Venu, Software Developer
Palo Alto, CA, USA
MySQL Inc, http://www.mysql.com

--
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: mysql_bind_result does not support BLOB fields

am 30.07.2003 14:16:14 von Vladimir Zheleznyak

Hello,

> PS: From current BK source, you can get chunks(or any offset of desired
> data from a particular column in the resultset) using
> 'mysql_fetch_column' (this API is not yet documented).

It will be a good solution for me. Will this function be exported/documented
in 4.1.1 build? When can I expect this version to be availlable?

Best regards,
Vladimir Zheleznyak

----- Original Message -----
From: "Venu"
To: "Vladimir Zheleznyak"
Cc: "Sinisa Milivojevic" ;
Sent: Wednesday, July 30, 2003 11:49 AM
Subject: Re: mysql_bind_result does not support BLOB fields

> On Wed, 2003-07-30 at 00:53, Vladimir Zheleznyak wrote:
> > Hello,
>
> Hi !!
>
> Using binary protocol, from 4.1.0 and above (preferably 4.1.1) you can
> send blob/clob data in chunks to server using 'mysql_send_long_data()'.
>
> Though the counter part is not yet ready; and we are in the discussion
> process to support the counter part API in 5.0 (mysql_get_long_data()).
>
> Coming to your mysql_bind_result for blobs, I couldn't able to reproduce
> the behavior, as it worked for me. Can you please send your call
> sequence ?
>
> PS: From current BK source, you can get chunks(or any offset of desired
> data from a particular column in the resultset) using
> 'mysql_fetch_column' (this API is not yet documented).
>
> Thanks
>
> >
> > I have in view copying portions of data from row-buffer on client, but
not
> > receiving portions of data from server.
> >
> > One more variant is publishing client internal row buffer. This variant
is
> > more preferable considering performance.
> >
> > Best regards,
> > Vladimir Zheleznyak
> >
> > ----- Original Message -----
> > From: "Sinisa Milivojevic"
> > To:
> > Cc:
> > Sent: Tuesday, July 29, 2003 7:17 PM
> > Subject: Re: mysql_bind_result does not support BLOB fields
> >
> >
> > > Vladimir Zheleznyak writes:
> > > >
> > > > Hello,
> > > >
> > > > > What alternative solution would you suggest ??
> > > >
> > > > For example you can provide function to read BLOB-field value
> > part-by-part.
> > > > Something like this:
> > > >
> > > > unsigned int mysql_fetch_blob(MYSQL_STMT *stmt, unsigned int
field_num,
> > char
> > > > * Buf, unsigned int Count)
> > > >
> > > > Accordingly, for getting whole value it is necessary to call
> > > > mysql_fetch_blob for each field in cycle.
> > > >
> > > > Best regards,
> > > > Vladimir Zheleznyak
> > > >
> > >
> > > This is not yet doable.
> > >
> > > Partial sending / receiving will not be in the works until 5.*
> > >
> > > --
> > >
> > > Regards,
> > >
> > > --
> > > For technical support contracts, go to
https://order.mysql.com/?ref=msmi
> > > __ ___ ___ ____ __
> > > / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic

> > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB
> > > /_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support
Coordinator
> > > <___/ www.mysql.com Larnaca, Cyprus
> > >
> > >
> > >
> --
> Venu, Software Developer
> Palo Alto, CA, USA
> MySQL Inc, http://www.mysql.com
>
>
>

--
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: mysql_bind_result does not support BLOB fields

am 30.07.2003 16:03:42 von Vladimir Zheleznyak

Re: mysql_bind_result does not support BLOB fields

am 30.07.2003 16:15:31 von Sinisa Milivojevic

Vladimir Zheleznyak writes:
>
> Hello,
>
>
> It will be a good solution for me. Will this function be exported/documented
> in 4.1.1 build? When can I expect this version to be availlable?
>
> Best regards,
> Vladimir Zheleznyak
>

Documentation is still work in progress.

4.1.1 will most probably be released in the next few months.

--

Regards,

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

--
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