Viewing Issue Advanced Details Jump to Notes ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0010432 [Talend Data Quality] Java components minor always 2009-12-03 11:00 2009-12-29 06:42
Reporter mlelandais View Status public  
Assigned To xhyu
Priority normal Resolution fixed Platform
Status closed   OS
Projection none   OS Version
ETA none Fixed in Version 3.2.3 Product Version 3.2.2
  Target Version Product Build 3.2.2.r33000
Summary 0010432: tMap output links cannot be named output, update, delete, delete
Description The tMap output links cannot be named:
-output
-update
-delete
-insert
(Name is invalid message in the tMap Output dialog box)
But we can rename them as mentioned before after their creation.
Is it possible to fix it and allow us to name them output, update, etc. directly when we create them?
Steps To Reproduce
Additional Information
Tags No tags attached.
workload (in half days)
Attached Files

- Relationships

-  Notes
User avatar (0032728)
mhirt (administrator)
2009-12-03 13:57

either these name are allowed, either they are not allowed at all (I.e rename should not be possible)
User avatar (0033183)
nrousseau (administrator)
2009-12-10 02:16

Need to review why these names are not allowed.
If it's for ELT mode (since it seems SQL name), maybe we can forbid those name only on ELT mode !
(0034206)
svn (reporter)
2009-12-22 06:52

This is an automatic note from Subversion commit
    
r34531 by zli

trunk [Subversion, tos] r34531

-----[Subversion commit log]----------------------------------------------------
bug 0010432 fixed: tMap output links cannot be named output, update, delete, delete .
(0034207)
svn (reporter)
2009-12-22 06:52

This is an automatic note from Subversion commit
    
r34532 by zli

branch 3.2 [Subversion, tos] r34532

-----[Subversion commit log]----------------------------------------------------
bug 0010432 fixed: tMap output links cannot be named output, update, delete, delete .
User avatar (0034547)
zli (developer)
2009-12-28 08:52

If we use these sql keyword as output links name , then run the job, there will be error messages as follows:

 Exception in component tELTMysqlOutput_1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update (SELECT aa.id , aa.name FROM aa)' at line 1
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
Inserting with :
INSERT INTO update (SELECT aa.id , aa.name FROM aa)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
        ......


If we use "output" as output links name , there will be error messages:

   Exception in component tELTMysqlOutput_1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test_tos.output' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
    at com.mysql.jdbc.Util.getInstance(Util.java:336)
Inserting with :
INSERT INTO output (SELECT aa.id , aa.name FROM aa)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)
        .......
(0034553)
svn (reporter)
2009-12-28 09:16

This is an automatic note from Subversion commit
    
r34756 by zli

trunk [Subversion, tos] r34756

-----[Subversion commit log]----------------------------------------------------
bug 0010432 fixed: tMap output links cannot be named output, update, delete, delete .
(0034555)
svn (reporter)
2009-12-28 09:17

This is an automatic note from Subversion commit
    
r34757 by zli

branch 3.2 [Subversion, tos] r34757

-----[Subversion commit log]----------------------------------------------------
bug 0010432 fixed: tMap output links cannot be named output, update, delete, delete .
(0034628)
svn (reporter)
2009-12-29 04:00

This is an automatic note from Subversion commit
    
r34785 by zli

trunk [Subversion, tos] r34785

-----[Subversion commit log]----------------------------------------------------
bug 0010432 fixed: tMap output links cannot be named output, update, delete, delete .
(0034629)
svn (reporter)
2009-12-29 04:01

This is an automatic note from Subversion commit
    
r34786 by zli

branch 3.2 [Subversion, tos] r34786

-----[Subversion commit log]----------------------------------------------------
bug 0010432 fixed: tMap output links cannot be named output, update, delete, delete .
User avatar (0034649)
xhyu (developer)
2009-12-29 06:42

tMap support these name, for ELT mode not support these name

- Issue History
Date Modified Username Field Change
2009-12-03 11:00 mlelandais New Issue
2009-12-03 13:57 mhirt Note Added: 0032728
2009-12-03 13:57 mhirt Assigned To => nrousseau
2009-12-03 13:57 mhirt Status new => feedback from Talend
2009-12-10 02:14 nrousseau Assigned To nrousseau => cli
2009-12-10 02:16 nrousseau Note Added: 0033183
2009-12-21 11:46 cli Assigned To cli => zli
2009-12-22 04:42 zli Status feedback from Talend => assigned
2009-12-22 06:52 svn Checkin
2009-12-22 06:52 svn Note Added: 0034206
2009-12-22 06:52 svn Checkin
2009-12-22 06:52 svn Note Added: 0034207
2009-12-22 06:53 zli Assigned To zli => qwei
2009-12-22 06:53 zli Status assigned => toVerify
2009-12-28 02:58 qwei Assigned To qwei => xhyu
2009-12-28 07:42 xhyu Assigned To xhyu => zli
2009-12-28 07:42 xhyu Status toVerify => feedback from Talend
2009-12-28 08:02 zli Status feedback from Talend => assigned
2009-12-28 08:52 zli Note Added: 0034547
2009-12-28 09:16 svn Checkin
2009-12-28 09:16 svn Note Added: 0034553
2009-12-28 09:17 svn Checkin
2009-12-28 09:17 svn Note Added: 0034555
2009-12-28 09:17 zli Assigned To zli => xhyu
2009-12-28 09:17 zli Status assigned => toVerify
2009-12-29 04:00 svn Checkin
2009-12-29 04:00 svn Note Added: 0034628
2009-12-29 04:01 svn Checkin
2009-12-29 04:01 svn Note Added: 0034629
2009-12-29 06:42 xhyu Note Added: 0034649
2009-12-29 06:42 xhyu Status toVerify => closed
2009-12-29 06:42 xhyu Resolution open => fixed
2009-12-29 06:42 xhyu Fixed in Version => 3.2.3


Mantis 1.1.6[^]
Copyright © 2000 - 2007 Mantis Group
Powered by Mantis Bugtracker
Copyright © 2006 - 2010 Talend. All rights reserved. Talend Contributor Agreement