Excpetion on Update

Excpetion on Update

Postby denkhe » Mon 24 Jan 2011 14:15

I got the following table:

Code: Select all
CREATE TABLE IF NOT EXISTS SST_Probleme (
Id     INTEGER         PRIMARY KEY     AUTO_INCREMENT,
ProjektId     INTEGER         NOT NULL,
LfdNr         INTEGER         NOT NULL,
EFL           INTEGER         NOT NULL,
Beschreibung  VARCHAR(4000)   NULL,
Bemerkung     VARCHAR(4000)   NULL,
Erfasst       DATETIME        NOT NULL,
SETeam        VARCHAR(20 )    NULL,
Timestamp     TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
CONSTRAINT UNIQUE KEY keyProjektIdLfdNr (ProjektId,LfdNr),
CONSTRAINT UNIQUE KEY keyProjektIdEFL (ProjektId,EFL),
FOREIGN KEY(ProjektId) REFERENCES Anlaufmanagement.SST_Projekte(Id) ON DELETE CASCADE)


If i try to update a record the following SQL is executed in the database

Code: Select all
5 Query BEGIN
5 Query update anlaufmanagement.sst_probleme
   set SETeam = 'HAllo'
where ((Id = 1) and (`Timestamp` = '2011-01-24 14:47:14'))
;select `Timestamp`
from anlaufmanagement.sst_probleme
where Id = p1
5 Query ROLLBACK


The problem is the select with the invalid where clause. The field p1 does not exist.

SSDL:

Code: Select all



Any ideas?

Best regards
Heiko Denk
denkhe
 
Posts: 14
Joined: Mon 03 Jan 2011 15:33

Postby denkhe » Mon 24 Jan 2011 14:30

Update:

It is working, if I change the SSDL to

Code: Select all

denkhe
 
Posts: 14
Joined: Mon 03 Jan 2011 15:33

Postby AndreyR » Tue 25 Jan 2011 14:49

Could you please provide the code you were using for the update?
If possible, please send us (support * devart * com, subject "EF Computed Timestamp problem") a small test project reproducing the problem?
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby denkhe » Thu 27 Jan 2011 07:43

I sent the requested test-project to suppor@devart.com.
denkhe
 
Posts: 14
Joined: Mon 03 Jan 2011 15:33

Postby AndreyR » Fri 28 Jan 2011 10:36

Thank you for the project, I have reproduced the problem.
I will let you know about the results of our investigation.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby denkhe » Wed 16 Feb 2011 08:36

Any news to this one?
denkhe
 
Posts: 14
Joined: Mon 03 Jan 2011 15:33

Postby AndreyR » Wed 16 Feb 2011 14:49

We have fixed the issue and in the process of testing at the moment.
The fix will be available in one of the nearest builds.
I will let you know as soon as it is available.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Thu 07 Apr 2011 11:50

We have released the new 6.10.135 build of dotConnect for MySQL. It fixes the issue.
The build can be downloaded from Download Page (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to this announcement.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for MySQL