View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004217 | SymmetricDS | Bug | public | 2019-12-31 07:20 | 2022-08-30 13:04 |
| Reporter | fatihbulut | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.5 | ||||
| Target Version | 3.14.1 | Fixed in Version | 3.14.1 | ||
| Summary | 0004217: Does not replicate index with upper function on PostgreSQL | ||||
| Description | I'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 | ||||
| Tags | ddl/schema | ||||
|
|
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 |
|
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 | ||
| 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 |