Bug 6393125 - $P CONTAINS WRONG TOKENS AFTER ...

Logged in as BINLIU   |     |     |     |     |     |     |     |
BUG 6393125 - $P CONTAINS WRONG TOKENS AFTER EXCHANGE
|
Edit this bug Bug No: 6393125Bug Tree Base Bug No: Filed By:YMATSUDA  Filed: 04-SEP-2007 17:04:49 PST
Updated By:ARU  Updated: 04-JAN-2009 23:17:07 PST
Sup Rep:YMATSUDA  Assigned:WCLIN 
Customer: INTERNAL Mail: -
Status: 80 - Development to Q/A
Broken: Confirmed: No
Fix By: Fixed Ver: 11.1.0.7
Fix ETA:
Severity: 2 - Severe Loss of Service Dev Pri: 2 - By next distributed version
Product: 211 - Oracle Text Rel Status: B - Beta
Component: INDEX - indexing Comp Ver: 11.1
Sub Comp: WORDLIST RDBMS Ver: 11.1
Found In (Label): Fixed in (Label):
Test Name: Test Case Status: -
Test Pri: - NLS Kit Ver:
Gen/Prt: G - Generic Port Excep: No
O/S: 46 - Linux x86 Version:
Publish: No Error: - -
Security Vulnerability: No Third Party
/ QA Eng:
Releases Affected: NO RELEASE
Tags:
Related SRs:2-2199792,2-2945546,2-4027043,2-4093730,2-4099964,2-4215993,2-4223317,2-4287134,2-4763163,2-5001595,2-5281560,2-5675394,3-1163324461,
Related bugs:66874606678708667456766186046748720678424173685777684527   |
***YMATSUDA 09/04/07 05:04 pm ***
$P contains wrong tokens after exchange.
Do the following.
1. create a text index with defautl setting
2. create a shadow index with MIXED_CASE and SUBSTRING_INDEX
3. do some DML (insert lower case words) and sync
4. exchange the shadow index
The resulting $P contains upper cased patterns which should be in lower case.
-- script ---
create table test(c varchar2(100));
insert into test(c) values('test');
commit;
create index tidx on test(c) indextype is context;
exec ctx_ddl.create_preference('NEWLEX','BASIC_LEXER');
exec ctx_ddl.set_attribute('NEWLEX','MIXED_CASE', '1');
exec ctx_ddl.create_preference('NEWWL','BASIC_WORDLIST');
exec ctx_ddl.set_attribute('NEWWL','SUBSTRING_INDEX','TRUE');
exec ctx_ddl.create_shadow_index('TIDX','replace lexer NEWLEX wordlist
NEWWL');
insert into test(c) values('token');
exec ctx_ddl.sync_index('TIDX');
exec ctx_ddl.exchange_shadow_index('TIDX');
-- end of script --
***YMATSUDA 09/04/07 05:06 pm *** (CHG: Asg->YMATSUDA)
***YMATSUDA 09/04/07 05:06 pm ***
@ Assigned to the development as this bug has a dependency to the enhancement
@bug 4663444.
***WCLIN 09/05/07 10:07 am *** (CHG: DevPri->2)
***ADEBUG 09/17/07 11:57 am ***
@[Bug updated by YMATSUDA]
@ADE Transaction Id: ymatsuda_bug-6393125
@FILES:
@ctx_src_2/src/dr/admin/drixmd.pkh@@/main/46
@ctx_src_2/src/dr/admin/drv0ddl.pkb@@/main/3
@ctx_src_2/src/dr/admin/drv0ddl.pkh@@/main/6
@ctx_src_2/src/dr/admin/drvddl.pkb@@/main/84
@ctx_src_2/src/dr/admin/drvrio.pkb@@/main/5
@ctx_src_2/src/dr/admin/drvxtab.pkb@@/main/16
@ctx_src_2/src/dr/admin/drvxtab.pkh@@/main/8
@ctx_test_1/test/drblp/tdrblpl2.lst@@/main/3
@ctx_test_1/test/drblp/tdrblpl2.sql@@/main/3
@
RELEASE NOTES:
]]$P index table may contain invalid tokens when a shadow index with substring
]]indexing enabled and with a different lexer preference.
@
@INTERNAL PROBLEM DESCRIPTION:
@A $P maintenance trigger is created on the original $I when a shadow index
@is being created. This trigger inserts substring tokens from the original $I
@into new $P. If the lexer preference is different, generated tokens are
@incorrect.
@
@INTERNAL FIX DESCRIPTION:
@Trigger creation is deferred to the end of indexing. Substring tokens are
@generated in a bach manner without the trigger.
@
@BACKPORT FEASIBLE:
@Yes
@
@FORWARD MERGE REQUIRED:
@No (merged to main branch)
@
REDISCOVERY INFORMATION:
If DML during a shadow index creation inserts wrong substring tokens into $P,
a customer may be hitting this bug.
@
WORKAROUND:
None
@
***ADEBUG 09/17/07 12:06 pm *** (CHG: Fixed->11.2)
***ADEBUG 09/17/07 12:06 pm *** (CHG: Sta->80)
***ADEBUG 09/18/07 03:29 am ***
@CTX_MAIN_LINUX_070917 contains changes from ymatsuda_bug-6393125
***ADEBUG 09/19/07 09:57 pm ***
@CTX_MAIN_NT_070917 contains changes from ymatsuda_bug-6393125
***BUGPATCH 11/08/07 10:11 am ***
@ PATCHSET REQUEST #67369 CREATED INBUG 6618604 FOR FIX IN 10.2.0.5.0
***ADEBUG 11/12/07 07:16 pm ***
@CTX_MAIN_LINUX.X64_071011 contains changes from ymatsuda_bug-6393125
***WCLIN 12/03/07 10:37 am *** (CHG: Sta->11 Asg->WCLIN)
***WCLIN 12/03/07 10:37 am ***
@ Re-opening this txn for:
@ 1. bug for create unusable index.
@ 2. further performance improvement (using CTAS on $P).
***BPADMWW 12/06/07 09:09 am ***
@Esc reqESC:6393125.481638 received and is under BDE review.
@Update provided by LYNNE.RAGAZZINI
@[Bug updated by WCLIN]
@ADE Transaction Id: ymatsuda_bug-6393125
@FILES:
@ctx_src_2/src/dr/admin/drixmd.pkh@@/main/47
@ctx_src_2/src/dr/admin/drv0ddl.pkb@@/main/4
@ctx_src_2/src/dr/admin/drv0ddl.pkh@@/main/7
@ctx_src_2/src/dr/admin/drvddl.pkb@@/main/85
@ctx_src_2/src/dr/admin/drvrio.pkb@@/main/6
@ctx_src_2/src/dr/admin/drvxtab.pkb@@/main/17
@ctx_src_2/src/dr/admin/drvxtab.pkh@@/main/9
@ctx_test_1/test/drblp/tdrblpl2.lst@@/main/4
@ctx_test_1/test/drblp/tdrblpl2.sql@@/main/4
@
RELEASE NOTES:
]]$P index table may contain invalid tokens when a shadow index with substring
]]indexing enabled and with a different lexer preference.
@
@INTERNAL PROBLEM DESCRIPTION:
@A $P maintenance trigger is created on the original $I when a shadow index
@is being created. This trigger inserts substring tokens from the original $I
@into new $P. If the lexer preference is different, generated tokens are
@incorrect.
@
@INTERNAL FIX DESCRIPTION:
@Trigger creation is deferred to the end of indexing. Substring tokens are
@generated in a batch manner without the trigger. Also use CTAS on
@table function to speed up $P population.
@
@BACKPORT FEASIBLE:
@Yes
@
@FORWARD MERGE REQUIRED:
@No (merged to main branch)
@
REDISCOVERY INFORMATION:
If DML during a shadow index creation inserts wrong substring tokens into $P,
a customer may be hitting this bug.
@
WORKAROUND:
None
@
***ADEBUG 12/06/07 10:41 am *** (CHG: Asg->CTXREP SubComp->WORDLIST)
***ADEBUG 12/06/07 10:41 am *** (CHG: Fixed->11.1.0.7)
***ADEBUG 12/06/07 10:41 am *** (CHG: Sta->80)
***BPADMWW 12/06/07 11:53 am ***
@OneOff/Backport Req RECEIVED for review by BDE.
@Request Id:OOB:6393125.522721
@Update provided by JORGE.BARBA
***BPADMWW 12/06/07 01:36 pm ***
@OOB:6393125.522721 created for version 10.2.0.3.0 on Solaris Operating
@System (SPARC 64-bit)
@Update provided by ANDY.HOLLAND
***BUGPATCH 12/06/07 01:36 pm ***
@ BASE LABEL REQUEST #69290 CREATED INBUG 6674567 for 10.2.0.3.0
***ADEBUG 12/06/07 02:41 pm ***
@[Bug updated by WCLIN]
@ADE Transaction Id: wclin_bug-6393125_11.1.0.7.0
@FILES:
@ctx_src_2/src/dr/admin/drixmd.pkh@@/main/48
@ctx_src_2/src/dr/admin/drv0ddl.pkb@@/main/5
@ctx_src_2/src/dr/admin/drv0ddl.pkh@@/main/8
@ctx_src_2/src/dr/admin/drvddl.pkb@@/main/86
@ctx_src_2/src/dr/admin/drvrio.pkb@@/main/7
@ctx_src_2/src/dr/admin/drvxtab.pkb@@/main/18
@ctx_src_2/src/dr/admin/drvxtab.pkh@@/main/10
@ctx_test_1/test/drblp/tdrblpl2.lst@@/main/5
@ctx_test_1/test/drblp/tdrblpl2.sql@@/main/5
@
***WCLIN 12/06/07 02:42 pm ***
@ 2nd fix xbranchmerged into 11.1.0.7.
***WCLIN 12/06/07 02:42 pm *** (CHG: Asg->WCLIN)
***ADEBUG 12/07/07 03:29 am ***
@CTX_MAIN_LINUX_071206 contains changes from wclin_bug-6393125_11.1.0.7.0
@CTX_MAIN_LINUX_071206 contains changes from ymatsuda_bug-6393125
***ADEBUG 12/07/07 04:23 pm ***
@[Bug updated by WCLIN]
@ADE Transaction Id: wclin_bug-6393125_11.1.0.7.0_1
@FILES:
@ctx_src_2/src/dr/admin/drixmd.pkh@@/st_ctx_11.1.0/1
@ctx_src_2/src/dr/admin/drv0ddl.pkb@@/st_ctx_11.1.0/1
@ctx_src_2/src/dr/admin/drv0ddl.pkh@@/st_ctx_11.1.0/1
@ctx_src_2/src/dr/admin/drvddl.pkb@@/st_ctx_11.1.0/1
@ctx_src_2/src/dr/admin/drvrio.pkb@@/st_ctx_11.1.0/1
@ctx_src_2/src/dr/admin/drvxtab.pkb@@/st_ctx_11.1.0/1
@ctx_src_2/src/dr/admin/drvxtab.pkh@@/st_ctx_11.1.0/1
@ctx_test_1/test/drblp/tdrblpl2.lst@@/st_ctx_11.1.0/1
@ctx_test_1/test/drblp/tdrblpl2.sql@@/st_ctx_11.1.0/1
@
***ADEBUG 12/08/07 11:54 am ***
@[Bug updated by WCLIN]
@ADE Transaction Id: wclin_blr_backport_6393125_10.2.0.3.0
@[BLR backport]
@BACKPORT LABEL: ST_CTX_BLR_6393125_BACKPORT_10.2.0.3.0
@FILES:
@ctx/notes/backport.txt@@/main/st_ctx_10.2/st_ctx_wclin_blr_backport_6393125_10
@.2.0.3.0/2
@ctx_src_2/src/dr/admin/drixmd.pkh@@/main/st_ctx_10.2/st_ctx_wclin_blr_backport
@_6393125_10.2.0.3.0/1
@ctx_src_2/src/dr/admin/drv0ddl.pkb@@/main/st_ctx_10.2/st_ctx_wclin_blr_backpor
@t_6393125_10.2.0.3.0/1
@ctx_src_2/src/dr/admin/drv0ddl.pkh@@/main/st_ctx_10.2/st_ctx_wclin_blr_backpor
@t_6393125_10.2.0.3.0/1
@ctx_src_2/src/dr/admin/drvddl.pkb@@/main/st_ctx_10.2/st_ctx_wclin_blr_backport
@_6393125_10.2.0.3.0/1
@ctx_src_2/src/dr/admin/drvxtab.pkb@@/main/st_ctx_10.2/st_ctx_wclin_blr_backpor
@t_6393125_10.2.0.3.0/1
@ctx_src_2/src/dr/admin/drvxtab.pkh@@/main/st_ctx_10.2/st_ctx_wclin_blr_backpor
@t_6393125_10.2.0.3.0/1
@ctx_test_1/test/drblp/tdrblpl2.lst@@main/st_ctx_10.2/st_ctx_wclin_blr_backport
@_6393125_10.2.0.3.0/1
@ctx_test_1/test/drblp/tdrblpl2.sql@@main/st_ctx_10.2/st_ctx_wclin_blr_backport
@_6393125_10.2.0.3.0/1
@
***ADEBUG 12/10/07 02:21 pm ***
@[Bug updated by WCLIN]
@ADE Transaction Id: wclin_blr_backport_6393125_10.2.0.3.0
@[BLR backport]
@BACKPORT LABEL: ST_CTX_BLR_6393125_BACKPORT_10.2.0.3.0
@FILES:
@ctx/notes/backport.txt@@/main/st_ctx_10.2/st_ctx_wclin_blr_backport_6393125_10
@.2.0.3.0/2
@ctx_src_2/src/dr/admin/drixmd.pkh@@/main/st_ctx_10.2/st_ctx_wclin_blr_backport
@_6393125_10.2.0.3.0/1
@ctx_src_2/src/dr/admin/drv0ddl.pkb@@/main/st_ctx_10.2/st_ctx_wclin_blr_backpor
@t_6393125_10.2.0.3.0/1
@ctx_src_2/src/dr/admin/drv0ddl.pkh@@/main/st_ctx_10.2/st_ctx_wclin_blr_backpor
@t_6393125_10.2.0.3.0/1
@ctx_src_2/src/dr/admin/drvddl.pkb@@/main/st_ctx_10.2/st_ctx_wclin_blr_backport
@_6393125_10.2.0.3.0/1
@ctx_src_2/src/dr/admin/drvxtab.pkb@@/main/st_ctx_10.2/st_ctx_wclin_blr_backpor
@t_6393125_10.2.0.3.0/1
@ctx_src_2/src/dr/admin/drvxtab.pkh@@/main/st_ctx_10.2/st_ctx_wclin_blr_backpor
@t_6393125_10.2.0.3.0/1
@ctx_test_1/test/drblp/tdrblpl2.lst@@main/st_ctx_10.2/st_ctx_wclin_blr_backport
@_6393125_10.2.0.3.0/1
@ctx_test_1/test/drblp/tdrblpl2.sql@@main/st_ctx_10.2/st_ctx_wclin_blr_backport
@_6393125_10.2.0.3.0/1
@
***ADEBUG 12/10/07 10:54 pm ***
@CTX_MAIN_NT_071206 contains changes from wclin_bug-6393125_11.1.0.7.0
@CTX_MAIN_NT_071206 contains changes from ymatsuda_bug-6393125
***ADEBUG 12/11/07 02:29 am ***
@CTX_11.1.0.7.0_LINUX_071210 contains changes from wclin_bug-6393125_11.1.0.7.0
@_1
***ADEBUG 12/11/07 08:28 pm ***
@CTX_11.1.0.7.0_NT_071209.1 contains changes from wclin_bug-6393125_11.1.0.7.0_
@1
***BPADMWW 12/12/07 12:33 pm ***
@OOB:6393125.526188 created for version 10.2.0.3 on AIX5L Based Systems
@(64-bit)
@Update provided by ANITA.BARDEEN
***ARU 12/18/07 10:03 am ***
@@@ARU: 10.2.0.3 ARU 9753459 completed for Solaris Operating System (SPARC 64-b
***ADEBUG 12/21/07 06:12 am ***
@CTX_11.1.0.7.0_LINUX.X64_071210 contains changes from wclin_bug-6393125_11.1.0
@.7.0_1
***ARU 12/27/07 08:56 pm ***
@@@ARU: 10.2.0.3 ARU 9782052 completed for AIX5L Based Systems (64-bit)
***BPADMWW 01/14/08 01:23 pm ***
@OOB:6393125.546007 created for version 10.2.0.3.0 on IBM Power Based Linux
@Update provided by ANDY.HOLLAND
***BPADMWW 01/30/08 02:34 am ***
@OOB:6393125.559048 created for version 10.2.0.3.0 on Linux x86-64
@Update provided by RICHARD.PITTS
***ARU 01/30/08 04:19 am ***
@@@ARU: 10.2.0.3 ARU 9890284 completed for Linux x86-64 (AMD64/EM64T)
***ARU 01/30/08 07:18 am ***
@@@ARU: 10.2.0.3 StandaloneCheckin Obsoleted by SPRICOPE
***ARU 01/30/08 07:20 am ***
@@@ARU: 10.2.0.3 StandaloneCheckin Released by SPRICOPE
***ARU 01/30/08 07:21 am ***
@@@ARU: 10.2.0.3 ARU 9891110 completed for Generic Platform
***ARU 01/31/08 05:48 am ***
@@@ARU: 10.2.0.3 ARU 9891110 completed for Generic Platform
***ARU 02/14/08 03:58 pm ***
@@@ARU: 10.2.0.3 ARU 9891110 completed for Generic Platform
***ADEBUG 02/27/08 10:18 am ***
@CTX_MAIN_LINUX.X64_080218 contains changes from wclin_bug-6393125_11.1.0.7.0
***ADEBUG 02/27/08 10:18 am ***
@CTX_MAIN_LINUX.X64_080218 contains changes from ymatsuda_bug-6393125
***ADEBUG 04/23/08 01:29 am ***
@CTX_MAIN_HPUX.PARISC64_080410 contains changes from wclin_bug-6393125_11.1.0.7
@.0
***ADEBUG 04/23/08 01:29 am ***
@CTX_MAIN_HPUX.PARISC64_080410 contains changes from ymatsuda_bug-6393125
***ADEBUG 04/28/08 01:27 pm ***
@CTX_MAIN_HPUX.IA64_080420.0001 contains changes from wclin_bug-6393125_11.1.0.
@7.0
***ADEBUG 04/28/08 01:27 pm ***
@CTX_MAIN_HPUX.IA64_080420.0001 contains changes from ymatsuda_bug-6393125
***BPADMWW 09/01/08 12:35 am ***
@OOB:6393125.745589 created for version 10.2.0.4.0 on Solaris Operating
@System (SPARC 64-bit)
@Update provided by RUGGERO.CITTON
***BUGPATCH 09/01/08 12:35 am ***
@ BASE LABEL REQUEST #93086 CREATED INBUG 7368577 for 10.2.0.4.0
***BPADMWW 09/01/08 12:36 am ***
@OOB:6393125.745647 created for version 10.2.0.4.0 on AIX5L Based Systems
@(64-bit)
@Update provided by RUGGERO.CITTON
***ARU 09/15/08 10:15 am ***
@@@ARU: 11.1.0.6.0 ARU 10483161 available on Generic Platform for base bug
@@@ 6726207
***ARU 09/16/08 08:44 am ***
@@@ARU: 11.1.0.6.0 ARU 10488102 available on Sun Solaris SPARC (64-bit) for
@@@ basebug 6926207
***ADEBUG 10/23/08 08:58 pm ***
@[Bug updated by WCLIN]
@ADE Transaction Id: wclin_rfi_backport_6393125_10.2.0.5.0
@[RFI backport]
@FILES:
@ctx_src_2/src/dr/admin/drixmd.pkh@@/st_ctx_10.2/5
@ctx_src_2/src/dr/admin/drv0ddl.pkb@@/st_ctx_10.2/1
@ctx_src_2/src/dr/admin/drv0ddl.pkh@@/st_ctx_10.2/2
@ctx_src_2/src/dr/admin/drvddl.pkb@@/st_ctx_10.2/10
@ctx_src_2/src/dr/admin/drvxtab.pkb@@/st_ctx_10.2/3
@ctx_src_2/src/dr/admin/drvxtab.pkh@@/st_ctx_10.2/1
@ctx_test_1/test/drblp/tdrblpl2.lst@@/st_ctx_10.2/1
@ctx_test_1/test/drblp/tdrblpl2.sql@@/st_ctx_10.2/1
@
***BPADMWW 12/18/08 08:48 pm ***
@OOB:6393125.835995 created for version 10.2.0.4 on Linux x86-64
@Update provided by JONGHA.KIM
***ADEBUG 01/04/09 12:33 pm ***
@[Bug updated by WCLIN]
@ADE Transaction Id: wclin_blr_backport_6393125_10.2.0.4.0
@[BLR backport]
@BACKPORT LABEL: ST_CTX_BLR_6393125_BACKPORT_10.2.0.4.0
@FILES:
@ctx/notes/backport.txt@@
@   /main/st_ctx_10.2/st_ctx_wclin_blr_backport_6393125_10.2.0.4.0/2
@ctx_src_2/src/dr/admin/drixmd.pkh@@
@   /main/st_ctx_10.2/st_ctx_wclin_blr_backport_6393125_10.2.0.4.0/1
@ctx_src_2/src/dr/admin/drv0ddl.pkb@@
@   /main/st_ctx_10.2/st_ctx_wclin_blr_backport_6393125_10.2.0.4.0/1
@ctx_src_2/src/dr/admin/drv0ddl.pkh@@
@   /main/st_ctx_10.2/st_ctx_wclin_blr_backport_6393125_10.2.0.4.0/1
@ctx_src_2/src/dr/admin/drvddl.pkb@@
@   /main/st_ctx_10.2/st_ctx_wclin_blr_backport_6393125_10.2.0.4.0/1
@ctx_src_2/src/dr/admin/drvxtab.pkb@@
@   /main/st_ctx_10.2/st_ctx_wclin_blr_backport_6393125_10.2.0.4.0/2
@ctx_src_2/src/dr/admin/drvxtab.pkh@@
@   /main/st_ctx_10.2/st_ctx_wclin_blr_backport_6393125_10.2.0.4.0/2
@
***ARU 01/04/09 11:17 pm ***
@@@ARU: 10.2.0.4 ARU 10877814 completed for Generic Platform
|
This Information is Company Confidential