MySQL Bugs: #30997: #Deleted comes in MS Access linked table consisting of TINYTEXT field

Bug #30997	#Deleted comes in MS Access linked table consisting of TINYTEXT field
Submitted:	13 Sep 2007 13:15	Modified:	24 Apr 2008 12:43
Reporter:	Vladimir Dusa
Status:	Verified
Category:	Connector/ODBC	Severity:	S3 (Non-critical)
Version:	3.51.17, 5.1.3	OS:	Any
Assigned to:	Bogdan Degtyariov	Target Version:
Tags:	deleted, access, odbc_postga51
Triage:	D4 (Minor) / R3 (Medium) / E4 (High)

Description:
#DELETED comes in the newly added row in a table consisting of three columns: 
- INTEGER (AUTO_INCREMENT), 
- TINYTEXT 
- TIMESTAMP

We are using:
MyODBC 3.51.17
MySQL 5.0.45
Windows XP Professional (SP2)
MS Access 2003 (SP2) (German version)

How to repeat:
1) Create New Table
CREATE TABLE `mytable` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `MyText` tinytext NOT NULL,
  `tmstmp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB;

2) Link this table in MS Access. We are using options "Don't Optimize Column Width" and
"Return Matching Rows"

3) Try to create new row in this linked table by editing the column MyText.
=> #DELETED will appear.

Thank you for the bug report. Please test with the released version
3.51.20. Thanks in advance.

I have installed MyODBC 3.51.20, relinked the table in Access, but the problem still
occurs.

We couldn't use the version 3.51.20 anyway, because the bug
http://bugs.mysql.com/?id=30933 is not fixed in this version too.

Thank you

Vladimír Duša

Thank you for the feedback. Verified with Access 2003.

Verified in 5.1.3

Hello,

I would like to please You for solving this problem, because we still must use the MyODBC
3.51.17, which is quite old. Our application doesn't work with this problem and our new
customer must use at least MyODBC 3.51.20 because of his anohter applications - it is not
possible to have two MyODBC versions on one mashine. 

We will be very glad if You could help us by solving this Bug.

Thank you very much

Best regards

Vladimir Dusa
BSA Informatik AG

Sorry - this message should be added to another bug. Take it please as irrelevant.
Vladimir Dusa