#49 Cosmetic issue with functioon-based indexes

[Jeroen Tulp]

Application database uses case-sensitive names and therefore everything is in double quotes.
I created an index with a function and therefore it is created as a function-based normal index:
CREATE UNIQUE INDEX "cupIkm_cef_tsflow"
ON "cef_tsflow" (
"tsflcd",
"tsflsn",
"status",
SYS_EXTRACT_UTC("tsexdz"),
"dosvlg",
"tstsnr"
);

However within SQLTools the DDL is shown without double-quotes on some fields:
PROMPT CREATE INDEX "cupIkm_cef_tsflow"
CREATE UNIQUE INDEX "cupIkm_cef_tsflow"
ON "cef_tsflow" (
tsflcd,
tsflsn,
status,
SYS_EXTRACT_UTC("tsexdz"),
dosvlg,
tstsnr
)
STORAGE (
NEXT 1024 K
)
/

When I retrieve the index by:
select dbms_metadata.get_ddl('INDEX','cupIkm_cef_tsflow','LIFECWP') from dual;

It appears does appear with all fields between double-quotes:
CREATE UNIQUE INDEX "LIFECWP"."cupIkm_cef_tsflow" ON "LIFECWP"."cef_tsflow" ("tsflcd", "tsflsn", "status", SYS_EXTRACT_UTC("tsexdz"), "dosvlg", "tstsnr")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DATSPACE"

[Aleksey Kochetov]

confirmed, the fix will be done by tommorow

[Aleksey Kochetov]

fixed, will be available in the next 1.8 build by the end of week

[Jeroen Tulp]

Hello,

Thanks for the quick support, I will verify that it has been resolved.

Met vriendelijke groet,

Jeroen Tulp

• Verstuurd vanaf mijn iPhone

Op 16 dec. 2016 om 04:16 heeft Aleksey Kochetov akochetov@users.sf.net het volgende geschreven:

fixed, will be available in the next 1.8 build by the end of week

[bugs:#49] Cosmetic issue with functioon-based indexes

Status: open
Group: Future
Created: Wed Dec 14, 2016 12:15 PM UTC by Jeroen Tulp
Last Updated: Wed Dec 14, 2016 02:38 PM UTC
Owner: nobody

Application database uses case-sensitive names and therefore everything is in double quotes.
I created an index with a function and therefore it is created as a function-based normal index:
CREATE UNIQUE INDEX "cupIkm_cef_tsflow"
ON "cef_tsflow" (
"tsflcd",
"tsflsn",
"status",
SYS_EXTRACT_UTC("tsexdz"),
"dosvlg",
"tstsnr"
);

However within SQLTools the DDL is shown without double-quotes on some fields:
PROMPT CREATE INDEX "cupIkm_cef_tsflow"
CREATE UNIQUE INDEX "cupIkm_cef_tsflow"
ON "cef_tsflow" (
tsflcd,
tsflsn,
status,
SYS_EXTRACT_UTC("tsexdz"),
dosvlg,
tstsnr
)
STORAGE (
NEXT 1024 K
)
/

When I retrieve the index by:
select dbms_metadata.get_ddl('INDEX','cupIkm_cef_tsflow','LIFECWP') from dual;

It appears does appear with all fields between double-quotes:
CREATE UNIQUE INDEX "LIFECWP"."cupIkm_cef_tsflow" ON "LIFECWP"."cef_tsflow" ("tsflcd", "tsflsn", "status", SYS_EXTRACT_UTC("tsexdz"), "dosvlg", "tstsnr")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DATSPACE"

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/sqlt/bugs/49/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

[Jeroen Tulp]

I can confirm it has been resolved.