View Issue Details

IDProjectCategoryView StatusLast Update
0004173SymmetricDSBugpublic2019-12-02 20:12
Reportermlevental Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.11.1 
Target Version3.11.1Fixed in Version3.11.1 
Summary0004173: In a sql code example the number of columns doesn't match the number of values
DescriptionUnder 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'
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 1e182bf3

2019-12-02 09:46:27

admin

Details Diff
0004173: In a sql code example the number of columns doesn't match the
number of values
Affected Issues
0004173
mod - symmetric-assemble/src/asciidoc/configuration/transforms/virtual-columns.ad Diff File

Issue History

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