Hello list There is another doubt... I have programmed a C++ object that connects to MySQL, it has encapsulated its own
MYSQL *mysql MYSQL_RES *result ... etc etc data, so it it possible to have several simultaneous connections to MySQL performing different jobs, but I have experienced a strange error... Let's supose (pseudocode) y have the class MY and have 2 instances my1 and my2 MY my1, my2; both are already connected to the server and both retrieve independently data by 'real_query' and 'use_result'... but the problem comes when I call 'free_results' for both connections, the program crashes with this message: *** glibc detected *** double free or corruption (!prev): 0x08053e68 *** Aborted The pseudocode I have is this: ------------------------------------------------------- my1.query + my1.store <--- UNIQUE QUERY (* where ...) while ( my1.fetch ) { my2.query + my2.store if ( my2.fetch ) { report = my1 + my2 results } else { report = my1 } my2.FreeResult <--- free for every my2.query inside loop } my1.FreeResult <--- free for unique my1.query ------------------------------------------------------- NOTE AGAIN: my1 and my2 are independent connections, have independent encapsulated handles and variables... What would happen if I don't free the resources inside the loop, would it leave unfreed memory resources? My tables are like this: TABLE1 ---------------------------------- | ID | FIELDX | ... | ---------------------------------- | 0 | x1 | ... | | 1 | x2 | ... | | 2 | x3 | ... | | 3 | x4 | ... | TABLE2 ------------------------- | ID | FIELDY | ------------------------- | 0 | y1 | | 3 | y4 | if I try a SELECT using condition "WHERE TABLE1.ID=TABLE2.ID" the results will return only x1-y1 and x4-y4 pairs, and in fact what I need is this the full pair of data when available, and the data from TABLE1 when there is no pair in TABLE2 x1-y1 x2 x3 x4-y4 I send a query to connection1---TABLE1 that retrieves all 'x#', and for every row returned, send a query to connection2---TABLE2 looking for a possible pair and build a report with both values, and if TABLE2 does not return nothing then use only value from TABLE1 SO... how should I manage 'mysql_free_results()' when I have multiple independent connections that make independent queries and free its own resources allocated? it appears that it affects globally calling this function, even if it is called in separate connections... Sorry, I extended too much, maybe is not very clear, but just concentrate on the question above... Thanks very much... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]