Docstoc

_optimizer_cost_based_transformation3

Document Sample
_optimizer_cost_based_transformation3 Powered By Docstoc
					        Bug 7374278 - Wrong Result (no rows) with CHAR/NCHAR Predicates [ID 7374278.8]
      Modified: May 12, 2011        Type: PATCH        Status: PUBLISHED       Priority: 3




      Bug 7374278 Wrong Result (no rows) with CHAR/NCHAR Predicates

       This note gives a brief overview of bug 7374278.
       The content was last updated on: 11-MAY-2011
       Click here for details of each of the sections below.

      Affects:

                Product (Component)                                         Oracle Server (Rdbms)
                Range of versions believed to be affected Versions >= 10.2.0.1 but BELOW 11.2

                                                                                     11.1.0.7
                                                                                     11.1.0.6
                Versions confirmed as being affected
                                                                                     10.2.0.4
                                                                                     10.2.0.3

                Platforms affected                                          Generic (all / most platforms affected)

                It is believed to be a regression in default behaviour thus:
                  Regression introduced in 10.2.0.4

      Fixed:


                                                     11.2.0.1 (Base Release)
                This issue is fixed in               10.2.0.5 (Server Patch Set)
                                                     11.1.0.7 Patch 17 on Windows Platforms




       Symptoms:                              Related To:


                                                       Optimizer
                                                       _OPTIMIZER_COST_BASED_TRANSFORMATION
                                                       _OPTIMIZER_PUSH_PRED_COST_BASED
                Wrong Results                          _OPTIMIZER_ENHANCED_FILTER_PUSH
                                                       Optimizer Cost-Based Query Transformation (CBQT)
                                                       Optimizer Filter Push Down (FPD)
                                                       Optimizer Generate Transitive Predicates (GTP)


      Description

                hs su a per s  ersin nrdcd n 0204 lhuh
               Ti isecnapa a argeso itoue i 1... atog
                h nelig rbe xss n ale eess lo u t s
               teudryn polmeit i erirrlae as,bti i
                xoe y h i o u 555
               epsdb tefxfrbg5017.

                 ur a rdc rn eut n os ne olwn odtos
               Aqeymypouewogrsls(orw)udrfloigcniin:

                . rdct novs sn   ie-egh tig e: hrNHR
               1-Peiaeivle uigafxdlnt srn (x Ca,CA)
                . B ds n xr rdcts s at f ihr
               2-COad a etaPeiae a pr o ete:

                .. itr uhon
               21-Fle Psdw
                .. rniie rdct eeain
               22-Tastv peiaegnrto


https://support.oracle.com/epmos/faces/ui/km/DocContentDisplay.jspx?_adf.ctrl-state=y68oz1yd5_332                     1/2
                okrud:
               WrAons
                . ialn otbsd rnfrain CQ) y OTMZRCS_AE_RNFRAINOF
                1-DsbigCs-ae Tasomto (BT b _PIIE_OTBSDTASOMTO=F
                . ialn s BT o uh rdct piiain y OTMZRPS_RDCS_AE=AS
                2-DsbigueCQ frPs peiaeotmzto b _PIIE_UHPE_OTBSDFLE
                . ialn uh itr eoe rig BT y OTMZREHNE_ITRPS=AS
                3-DsbigPs Flesbfr tyn CQ b _PIIE_NACDFLE_UHFLE

                ape et
               Sml Ts:
                rae al b0 cl hr9,o2 hr9,o3 hr9)
                cet tbetl1(o1ca()cl ca()cl ca();
                net no b0 aus '246''b''';
                isr it tl1vle (1357,ac,a)
                net no b0 aus '35,aa,b)
                isr it tl1vle (24''a''';
                net no b0 aus '4681''bdfh''d';
                isr it tl1vle (35790,acegi,ce)
                rae al b0 s eet   rm b0;
                cet tbetl2a slc *fo tl1

                EET b0.o1 b0.o2 a.o3 RM b0
                SLC tl1cl,tl1cl,aacl FO tl1
                  SLC
                ,(EET
                    usrcl|'
                   sbt(o1|       ,,) o1
                                '09 cl,
                    o2
                   cl,
                    o3
                   cl
                  RM b0
                 FO tl2
                NO L
                UINAL
                EET    rm b0) a
                SLC *fo tl1 aa
                HR b0.o1     1357
                WEEtl1cl ='246'
                n b0.o1     a.o1
                adtl1cl =aacl;

                RN eut: >   os
                WOGRsls = 0Rw
                 rdcts n tp   n hud' ae en eeae.
                Peiae i ses5ad6solnthv be gnrtd

                   d prto
                |I |Oeain           ae
                                  |Nm |
                 -------------------
                -------------------
                 *    AH ON
                | 1| HS JI
                 *     AL CES UL
                | 2| TBEACS FL |TL1|B0
                | 3| VEIW
                | 4|    NO-L
                       UINAL
                 *
                | 5|     AL CES UL B0
                        TBEACS FL|TL2|
                 *
                | 6|     AL CES UL B0
                        TBEACS FL|TL1|
                 -------------------
                -------------------

                   ces"B0""O1=AA.CL"
                1-acs(TL1.CL""A""O1)
                   itr"B0""O1=1357)
                2-fle(TL1.CL"'246'
                   itrSBT(CL"|
                5-fle(USR"O1|'    ,,)'246'
                                 '09=1357)
                   itr"B0""O1=1357)
                6-fle(TL1.CL"'246'

                ORC eut
               CRETRsl:

                O1
                CL    O2 O3
                     CL CL
                ---- -- --
                ---- -- --
                246   b
                1357 ac a
                246   b
                1357 ac a



                        Please note: The above is a summary description only. Actual symptoms can vary. Matching to any
                        symptoms here does not confirm that you are encountering this problem. Always consult with Oracle
                        Support for advice.

      References

               Bug:7374278 (This link will only work for PUBLISHED bugs)
               Note:245840.1 Information on the sections in this article




https://support.oracle.com/epmos/faces/ui/km/DocContentDisplay.jspx?_adf.ctrl-state=y68oz1yd5_332                           2/2

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:11
posted:8/8/2012
language:English
pages:2