View Issue Details

IDProjectCategoryView StatusLast Update
0004217SymmetricDSBugpublic2022-08-30 13:04
Reporterfatihbulut Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.5 
Target Version3.14.1Fixed in Version3.14.1 
Summary0004217: Does not replicate index with upper function on PostgreSQL
DescriptionI've created a test table and created normal index. Then I've send changes to other node .

But when I add second index with upper function SymmetricDS could not send this index to other node.
Steps To Reproduce
Test scenario is below.

1. CREATE TABLE public.basket_b (
    id int4 NOT NULL,
    fruit varchar(100) NOT NULL,
    CONSTRAINT basket_b_pkey PRIMARY KEY (id)
);

2. CREATE INDEX basket_b_idx01 ON basket_b USING btree (fruit);

3. bin/symadmin sync-triggers

4. bin/symadmin send-schema -n SCC2 basket_b
  Log file on SCC2 node
  2019-12-31 10:08:15,674 INFO [SCC2] [PostgreSql95DatabasePlatform] [scc2-dataloader-15801] Running alter sql:
  CREATE INDEX "basket_b_idx01" ON "public"."basket_b" ("fruit");

Index with upper function
-------------------------------------------------------------------------------
1. CREATE INDEX basket_b_idx02 ON basket_b USING btree (upper(fruit));


2. bin/symadmin sync-triggers

3. bin/symadmin send-schema -n SCC2 basket_b

  Log file on SCC2 node
  2019-12-31 10:09:16,663 INFO [SCC2] [PostgreSql95DatabasePlatform] [scc2-dataloader-15806] Tables up to date. No
  alters found for public.basket_b
Tagsddl/schema

Activities

fatihbulut

2020-01-03 08:05

reporter   ~0001670

MAybe it can be related with " character. Probably SymmetricDS generates create script with " character and PpostgreSQL can not execute it.

i.e : CREATE INDEX "basket_b_idx02" ON "basket_b" ("upper((fruit)::text)"); gives an error :
   SQL Error [42703]: ERROR: column "upper((fruit)::text)" does not exist

Related Changesets

SymmetricDS: 3.14 f144997b

2022-08-22 17:41:22

evan-miller-jumpmind

Details Diff
0004217: Added support for Postgres and Oracle functional indexes Affected Issues
0004217
mod - symmetric-db/src/main/java/org/jumpmind/db/model/Table.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlReader.java Diff File

Issue History

Date Modified Username Field Change
2019-12-31 07:20 fatihbulut New Issue
2020-01-03 08:05 fatihbulut Note Added: 0001670
2022-08-02 15:00 elong Tag Attached: ddl/schema
2022-08-22 17:42 emiller Assigned To => emiller
2022-08-22 17:42 emiller Status new => resolved
2022-08-22 17:42 emiller Resolution open => fixed
2022-08-22 17:42 emiller Fixed in Version => 3.14.1
2022-08-22 18:00 Changeset attached => SymmetricDS 3.14 f144997b
2022-08-30 13:04 admin Status resolved => closed