Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.




ID: 20483, dbExpress MySQL 4.0.x Beta driver

by Ramesh Theivendran Email: Anonymous


dbExpress driver Update for MySQL 4.0.x
Download Details
FTP  download also available
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For Delphi, Version 7.0  to 7.0 2448 downloads
Copyright: Commercial use requires permission


Terms of use: Embarcadero Public Beta Test Disclaimer


Size: 47,557 bytes
Updated on Tue, 02 Sep 2003 17:04:43 GMT
Originally uploaded on Fri, 15 Aug 2003 17:07:46 GMT
SHA1 Hash: 7B80F1E228AF4228FB3BD0C235BB59181C6CBA21
MD5 Hash: 8BF43CF11CD167474EC89CD0593484F3

    Explore the files in this upload

Description
The driver should work with MySQL version 4.0.x and the latest MySQL 4.0.14.

QC Bugs addressed:
1. 3731 - FIXED
2. MySQL Port - Support added

3.4504 - FIXED

4.1810 - Data truncation (Vendor issue)
MySQL Field.length=1024 for the second columns after describing the SQL "Show create table tablename"
and that's the reason for truncation.

5. 4689 - Workaround done.
Timestamp comes back as NOT NULL always.(Vendor issue)

Please read the MySQL API documentation

http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#C_API_functions

NOT_NULL_FLAG - Field can't be NULL and the flag is set in for all the following a SELECT is issued on the following 3 tables.

create table testtimestamp1( f1 char(10), fts timestamp)
create table testtimestamp2( f1 char(10), fts timestamp null)
create table testtimestamp3( f1 char(10), fts timestamp not null)

So, there is no distinction between whether a timestamp field is created as NOT NULL or NOT.
I consider this a MySQL bug. However, a hack has been added to fix this issue for the time being.


The following bugs are being investigated:

6. 1074 (dbExpress Components cloning connection and Rollback failure)
7.3782. (Issue with Quoting objects )
8.4130
9.4160.
10.3814.

Server Response from: ETNACDC03