View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001699 | SymmetricDS | Bug | public | 2014-04-29 08:06 | 2014-06-17 00:27 |
Reporter | yitzi | Assigned To | chenson | ||
Priority | high | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.5.21 | ||||
Target Version | 3.6.0 | Fixed in Version | 3.6.0 | ||
Summary | 0001699: Changing Trigger results in Error om Tables with an uppercase letter | ||||
Description | Any Table that has an uppercase letter in its name, that has one of its triggers changed. Results in the following error. drop trigger SYM_ON_D_FOR_NTFYNT_SB4 on NotifyUnit and failed because: ERROR: relation "notifyunit" does not exist It appears that SQL statement it is using is drop trigger SYM_ON_D_FOR_NTFYNT_SB4 on NotifyUnit; instead it should be drop trigger SYM_ON_D_FOR_NTFYNT_SB4 on "NotifyUnit"; | ||||
Steps To Reproduce | Create a table in postgres with a capital letter Add a trigger in sym_triggers for that table Add a router in sym_router and sym_trigger_router Start up symmetricDS. It will successfully create the trigger Now add a second router in sym_router and sym_trigger_router (to replicate to a 3rd database) Restart SymmetricDS, the error should appear. We tested on 3.5.10 and 3.5.21 | ||||
Additional Information | Although we would like to rename all tables to lowercase, its a legacy system and we are unable to. | ||||
Tags | No tags attached. | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2014-04-29 08:06 | yitzi | New Issue | |
2014-04-29 13:07 | chenson | Assigned To | => chenson |
2014-04-29 13:07 | chenson | Status | new => assigned |
2014-04-29 13:07 | chenson | Target Version | => 3.6.0 |
2014-04-29 15:48 | chenson | Status | assigned => resolved |
2014-04-29 15:48 | chenson | Fixed in Version | => 3.6.0 |
2014-04-29 15:48 | chenson | Resolution | open => fixed |
2014-04-29 16:00 | Changeset attached | => SymmetricDS trunk r8211 | |
2014-06-17 00:27 | chenson | Status | resolved => closed |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master 32165c7f |