View Issue Details

IDProjectCategoryView StatusLast Update
0001199SymmetricDSImprovementpublic2014-02-03 01:53
Reporterjosema Assigned Tochenson  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.3.5 
Target Version3.5.0Fixed in Version3.5.0 
Summary0001199: EXCLUDED COLUMNS in triggers can't participate in lookuptable router expressions
DescriptionIf you create a lookuptable expression using key_column with excluded columns, data extractor service ignore rows and donĀ“t route data to client. Is a mystery to find the reason nothing found in log files.
Additional InformationI think that org.jumpmind.symmetric.route.LookupTableDataRouter must be warn about this problem when looking value for KEY_COLUMN in method routeToNodes.
TagsNo tags attached.

Activities

chenson

2013-05-05 17:57

administrator   ~0000250

I'll log an error in the log file in this scenario.

On a side note, you can use a transform to exclude the column and it would still be available during routing.

chenson

2013-07-22 21:52

administrator   ~0000346

prepare for release

Related Changesets

SymmetricDS: master 4390a2f4

2013-05-05 13:58:23

chenson

Details Diff
0001199: EXCLUDED COLUMNS in triggers can't participate in lookuptable router expressions Affected Issues
0001199
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/LookupTableDataRouter.java Diff File

Issue History

Date Modified Username Field Change
2013-05-03 12:00 josema New Issue
2013-05-05 17:57 chenson Note Added: 0000250
2013-05-05 17:57 chenson Status new => resolved
2013-05-05 17:57 chenson Fixed in Version => 3.5.0
2013-05-05 17:57 chenson Resolution open => fixed
2013-05-05 17:57 chenson Assigned To => chenson
2013-05-05 17:58 chenson Target Version => 3.5.0
2013-07-22 21:52 chenson Note Added: 0000346
2013-07-22 21:52 chenson Status resolved => closed
2014-02-03 01:53 Changeset attached => SymmetricDS trunk r7153
2015-07-31 01:49 chenson Changeset attached => SymmetricDS master 4390a2f4