View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004173 | SymmetricDS | Bug | public | 2019-12-02 11:27 | 2019-12-02 20:12 |
| Reporter | mlevental | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.1 | ||||
| Target Version | 3.11.1 | Fixed in Version | 3.11.1 | ||
| Summary | 0004173: In a sql code example the number of columns doesn't match the number of values | ||||
| Description | Under https://www.symmetricds.org/doc/3.11/html/user-guide.html#_virtual_columns the following sql queries the number of columns doesn't match the number of values: insert into SYM_TRANSFORM_TABLE ( transform_id, source_node_group_id, target_node_group_id, transform_point, source_table_name, target_table_name, update_action, delete_action, transform_order, column_policy, update_first, last_update_by, last_update_time, create_time ) values ( 'extractStoreItemSellingPriceTransform', 'store', 'corp', 'EXTRACT', 'ITEM_SELLING_PRICE', 'ITEM_SELLING_PRICE', 'DEL_ROW', 1, 'IMPLIED', 0, 'Documentation', current_timestamp, current_timestamp ); insert into SYM_TRANSFORM_TABLE ( transform_id, source_node_group_id, target_node_group_id, transform_point, source_table_name, target_table_name, update_action, delete_action, transform_order, column_policy, update_first, last_update_by, last_update_time, create_time ) values ( 'loadCorpItemSellingPriceTransform', 'corp', 'store', 'LOAD', 'ITEM_SELLING_PRICE', 'ITEM_SELLING_PRICE', 'DEL_ROW', 1, 'IMPLIED', 0, 'Documentation', current_timestamp, current_timestamp ); In both queries one of the following can be done to solve the problem: - 'update action' column can be removed, then the default value 'UPDATE_COL' will be used OR - a value for the 'update action' column can be added, e.g. 'UPDATE_COL' | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-12-02 11:27 | mlevental | New Issue | |
| 2019-12-02 14:47 | elong | Assigned To | => elong |
| 2019-12-02 14:47 | elong | Status | new => resolved |
| 2019-12-02 14:47 | elong | Resolution | open => fixed |
| 2019-12-02 14:47 | elong | Product Version | => 3.11.1 |
| 2019-12-02 14:47 | elong | Fixed in Version | => 3.11.1 |
| 2019-12-02 14:47 | elong | Target Version | => 3.11.1 |
| 2019-12-02 15:00 | admin | Changeset attached | => SymmetricDS 3.11 1e182bf3 |
| 2019-12-02 20:12 | admin | Status | resolved => closed |