On 12:27 Thu 31 Aug , Duncan Hill wrote:
> On Thursday 31 August 2006 12:21, Renald Buter wrote:
>
> > The problem is that a simple 1-table query shows different answers
> > depending on whether you select 1 or 2 columns.
*blush*
Of course. I see. How stupid.
Thanks
On 11:34 Thu 31 Aug , Renato Golin wrote:
> Renald Buter wrote:
> >Odd, eh? But what's worse, the JOIN between this column and other
> >columns *also* uses this truncated values and the result is bogus.
>
> I wouldn't say odd, as you didn't specified any o
Hello list,
I've found this strange select bug in retrieving rows from a table. I
can best illustrate this with an output of two queries:
mysql> select id,jn from paper_2001 limit 10;
+--+---+
| id | jn|
+--+---+
| 19360350 | 6165 |
| 19360351 | 6165 |
|
On 01:55 Tue 11 Jan , Karam Chand wrote:
> Yup.
>
> This is a normal behaviour. mysql_free_result() will
> result in bringing each unasked rows to the client and
> freeing it up row by row.
>
This sounds to me as a useless "feature". What could be the reason for
such wasting behaviour?
> BT
Hello list,
I am having this issue with mysql_use_result: it seems it will iterate
over all unused results if I call 'mysql_free_result'. The following
code illustrates this:
mysql_query(&mysql,"SELECT * FROM a_very_large_table");
res = mysql_use_result(&mysql);
i = 0;
while (row = mysql_fetc
Hello list,
I am having this issue with mysql_use_result: it seems it will iterate
over all unused results if I call 'mysql_free_result'. The following
code illustrates this:
mysql_query(&mysql,"SELECT * FROM a_very_large_table");
res = mysql_use_result(&mysql);
i = 0;
while (row = mysql_fetc
n't know about the string
type; but you guessed as much me-thinks. You might want to change some
of the -fXX stuff, like removing them altogether. I actually stole them
from the mysql example provided in the manual :)
> and the other errors are dependent of that ones (undefined
> Usage,e
Hai there,
I have created a concat_grouped implementation as a mysql function. And
I thought it might interest other users too. No guarantees here, but you
might learn from it.
Find it at www.cwts.nl/buter/misc.html
Regards,
Renald
--
