View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004087 | SymmetricDS | Bug | public | 2019-09-09 16:01 | 2019-10-27 16:08 |
| Reporter | nkumarcm | Assigned To | |||
| Priority | urgent | ||||
| Status | new | Resolution | open | ||
| Product Version | 3.10.3 | ||||
| Summary | 0004087: Informix LOB support | ||||
| Description | Symmetric 3.10.3 informix 11.5 as master node. ----------------------------------------------------------------------- The trigger has replace function to escape comma, single, double quotes etc. This replace function won't work on TEXT data type of informix. ----------------------------------------------------------------------------- [tc-informix] - InformixSymmetricDialect - Creating SYM_ON_I_FOR_demotable trigger for informix .project_spec [tc-informix] - InformixSymmetricDialect - Failed to create trigger: create trigger SYM_ON_I_FOR_demotable insert on informix.project_spec referencing new as new for each row when (1=1 and not informix.sym_triggers_disabled()) ( insert into informix.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time) values( 'project_spec', 'I', 57, case when new.project_spec_id is null then '' else '"' || new.project_spec_id || '"' end||','|| case when new.project_id is null then '' else '"' || new.project_id || '"' end||','|| case when new.version is null then '' else '"' || new.version || '"' end||','|| rtrim(case when new.create_user is null then '' else '"' || replace(replace(new.create_user, '\', '\\'), '"', '\"') || '"' end)||','|| case when new.create_date is null then '' else '"' || new.create_date || '"' end||','|| rtrim(case when new.private_description is null then '' else '"' || replace(replace(new.description, '\', '\\'), '"', '\"') || '"' end)||','|| rtrim(case when new.detailed_requirements_text is null then '' else '"' || replace(replace(new.requirements_text, '\', '\\'), '"', '\"') || ----------------------------------------------------------------------------------------------------------------------- [tc-informix] - TriggerRouterService - Failed to create triggers for demotable org.jumpmind.db.sql.SqlException: Routine (replace) can not be resolved. at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291) at org.jumpmind.db.sql.JdbcSqlTransaction.executeCallback(JdbcSqlTransaction.java:398) at org.jumpmind.db.sql.JdbcSqlTransaction.execute(JdbcSqlTransaction.java:300) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createTrigger(AbstractSymmetricDialect.ja | ||||
| Steps To Reproduce | 1. Create a simple table "demotable" with "description" column TEXT datatype at informix 11.5 2. Insert relevant details at sym_channel, sym_trigger and sym_router details for newly created "demotable" table. 3. Start bin/sym. It tries to create insert trigger for "demotable" ( SYM_ON_I_FOR_<demotable> ) 4. The replace(replace line will fail because replace function won't work on "description" TEXT datatype. Any fix available for this please. | ||||
| Tags | dialect: informix, large objects | ||||
| related to | 0004107 | new | Support LOB data types like TEXT on Informix |
|
|
LOB data types like TEXT are not currently supported on Informix (documented under https://www.symmetricds.org/doc/3.10/html/user-guide.html#databases-compatibility). For unrecognized types, it tries to treat them like VARCHAR as a last attempt to try syncing them, which is why you get the strange error. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-09-09 16:01 | nkumarcm | New Issue | |
| 2019-10-09 15:30 | elong | Note Added: 0001612 | |
| 2019-10-09 15:32 | elong | Tag Attached: large objects | |
| 2019-10-09 15:32 | elong | Tag Attached: dialect: informix | |
| 2019-10-09 15:45 | elong | Summary | Trigger creation issue - Column with informix TEXT datatype is not supported ? => Informix LOB support |
| 2019-10-27 16:08 | elong | Relationship added | related to 0004107 |