compatibility with version mysql 5.1.35-communauty

[Alex17000]

Hi,

After my problem with old version of mysql, I have decided to make a new server with a last version of mysql (5.1.35-communauty).

So, I get the dll for this version, I put them in my application test directory.

I launch my program:

Code: Select all

  if not connect_MYSQL then exit;
  ZReadOnlyQuery1.sql.text := 'select * from mytable';
  ZReadOnlyQuery1.open; <- HERE exception ErangeError...
  ZReadOnlyQuery1.close;

And I got a beautifull error "ErangeError", so, is it incompatible with mysql 5.1.35?

I have tested my program with mysql 4.0.15 and 5.0.45 without any ErangeError exceptions.

Anyone can help me?

Thanks a lot,

edit: For information with mysql Workbench 5.2 there is no error

[Alex17000]

New:
Another version, mysql 5.1.52 it's ok.
Very strange that not ok with 5.1.35 and 5.1.48 and ok with 4.0.15, 5.0.45 and 5.1.48

If a developper want more information, I have available.

Have a good day

[Alex17000]

New: The problem come from too much columns return by the select.
I haven't test exactly the same base on all the version.

Cf : http://zeos.firmos.at/viewtopic.php?p=12520#12520

[mdaems]

See my answer in that post.

Mark