Recent changes to bugs

Socket connection under Unix with FreePascal not working

2007-08-04T14:20:59Z

First of all I was surprised that Direct SQL compiled flawlessly in FreePascal! Then I noticed I couldn't connect to my server and traced the problem back to some obviously unfinished line of code.

Problem 1:
The problem you have is that 'errno' is defined in the ISO standard as an assignable l-value and can be either a MACRO or a variable. This is a bad starting point for any Pascal Linker.

Solution 1:
Looking through the web I found that the GNU implementation of the ISO standard exports the function '__errno_location()' which returns the address of that int. So I deleted your global variable 'errno: Integer' and added "function errno: PInteger; cdecl; external 'libc.so.6' name '__errno_location';". In addition all the references to "errno" have to be changed to "errno^".

Problem 2:
connect still didn't seem to work and if errno^ returned reliable values it was due to an 'invalid parameter'.

Solution 2:
As the socket wasn't -1 and the address length was 16 it had to be the address itself. Looking at the declaration of connect I got a bit nervous about the "const" keyword cause it can be used by the compiler to transfer values in registers while we explicitly need a pointer here. So I changed this to "var" and it seems to do the trick.

Thank you for this great library and making it as compatible as it can be. I'm looking forward to the next release.

Marco

MySQL 4.1.7 Bugs

2004-12-01T19:47:25Z

Hi,

DirectSQL causes lots of problems when trying to
connect to a stable MySQL 4.1.7 server. It seems it
does not obtain the field- and tablenames correctly from
the MySQL server.

Integer Overflow

2003-12-09T13:56:29Z

I get an Integer Overflow Error in the line
nr2:=nr2+((nr2 shl 8) xor nr);
in function hashPassword
in Module uMysqlClient.pas.
The Error happens not always but often.

What can I do ?

Possible Unneeded Data Fetch on Close ??

2003-07-18T10:52:13Z

I think that on this procedure

destructor TMysqlResult.destroy;

unit uMysqlClient.pas

destructor TMysqlResult.destroy;
....
while true do
begin //clear the buffer
pkt_len:=fhandle.fnet.net_safe_read;
if (pkt_len = packet_error) then break;
if (pkt_len = 1) and (pchar(fhandle.fnet.read_pos)[0]
= #254) then break;
end;
....

this loop is not needed and it causes the component to
fetch ALL records, while the only thing we really want to
do is close the dataset.

Connection Duplicates

2003-04-09T00:27:43Z

I don't know if it is a bug or not.

When I connect to the database (mysqlproc demo
program) when the connection is successfull if I press
the button multiple times, it will create multiple threads
without disconnect the previous one.

Another question, is it possible to help on the project ?

possible memory leak

2003-02-03T17:04:38Z

in net_real_write in the file uMysqlNet.pas, strDispose is
not always called on pac, which causes a memory leak.

I worked around it by adding a strdispose(pac); to the
end of the procedure

query error

2002-08-28T13:17:00Z

Very strange behavior.
I have long query (UPDATE CATDATA SET MYBLOB =
0x176128f123f3f12f123ff12312..... WHERE ID=1 )

When I post it to remote server it gives error if query
sent was > 16k. With libmysql everything ok.

Anton

mysql_query hangs

2001-09-19T08:04:51Z

Apparently a query like:
'update table column="1" where id=5' does hang .. need
to check.

Send file to server + compression = AV

2001-09-19T08:03:55Z

Need to find a fix in this case

Send file to server has problems

2001-09-19T08:03:24Z

I will check it today and definatelly fix it.