By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| (No column name) |
|---|
| 2885746945 |
| Microsoft SQL Server 2005 XML Showplan |
|---|
| <ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4003.23"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT dbo.IpAddressToIntegerSafe('172.1.1.1')" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="1.257e-06" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x71D5D053F16A6EA7" QueryPlanHash="0xD927AC470CE8FDCC" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="56" CompileTime="15" CompileCPU="15" CompileMemory="384" ContainsInlineScalarTsqlUdfs="1"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="866008"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="15" EstimatedTotalSubtreeCost="1.257e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1006"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,[Expr1005],0)"><Convert DataType="bigint" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="1.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="CASE WHEN CASE WHEN CASE WHEN '172.1.1.1' like '%_.%_.%_.%_' AND NOT '172.1.1.1' like '%.%.%.%.%' AND NOT '172.1.1.1' like '%[^0-9.]%' AND NOT '172.1.1.1' like '%[0-9][0-9][0-9][0-9]%' AND NOT '172.1.1.1' like '%[3-9][0-9][0-9]%' AND NOT '172.1.1.1' like '%2[6-9][0-9]%' AND NOT '172.1.1.1' like '%25[6-9]%' THEN (1) ELSE (0) END = (1) THEN (1) ELSE (0) END = (0) THEN (-1) ELSE CASE WHEN CASE WHEN '172.1.1.1' like '%_.%_.%_.%_' AND NOT '172.1.1.1' like '%.%.%.%.%' AND NOT '172.1.1.1' like '%[^0-9.]%' AND NOT '172.1.1.1' like '%[0-9][0-9][0-9][0-9]%' AND NOT '172.1.1.1' like '%[3-9][0-9][0-9]%' AND NOT '172.1.1.1' like '%2[6-9][0-9]%' AND NOT '172.1.1.1' like '%25[6-9]%' THEN (1) ELSE (0) END = (1) THEN CONVERT(bigint,parsename(N'172.1.1.1',(1)),0)+CONVERT(bigint,parsename(N'172.1.1.1',(2)),0)*(256)+CONVERT(bigint,parsename(N'172.1.1.1',(3)),0)*(65536)+CONVERT(bigint,parsename(N'172.1.1.1',(4)),0)*(16777216) ELSE NULL END END"><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><IF><Condition><ScalarOperator><Logical Operation="AND"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%_.%_.%_.%_'"></Const></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%.%.%.%.%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%[^0-9.]%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%[0-9][0-9][0-9][0-9]%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%[3-9][0-9][0-9]%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%2[6-9][0-9]%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%25[6-9]%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(-1)"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><IF><Condition><ScalarOperator><Logical Operation="AND"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%_.%_.%_.%_'"></Const></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%.%.%.%.%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%[^0-9.]%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%[0-9][0-9][0-9][0-9]%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%[3-9][0-9][0-9]%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%2[6-9][0-9]%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator><ScalarOperator><Logical Operation="NOT"><ScalarOperator><Intrinsic FunctionName="like"><ScalarOperator><Const ConstValue="'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="'%25[6-9]%'"></Const></ScalarOperator></Intrinsic></ScalarOperator></Logical></ScalarOperator></Logical></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Convert DataType="bigint" Style="0" Implicit="0"><ScalarOperator><Intrinsic FunctionName="parsename"><ScalarOperator><Const ConstValue="N'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="bigint" Style="0" Implicit="0"><ScalarOperator><Intrinsic FunctionName="parsename"><ScalarOperator><Const ConstValue="N'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(256)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="bigint" Style="0" Implicit="0"><ScalarOperator><Intrinsic FunctionName="parsename"><ScalarOperator><Const ConstValue="N'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(3)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(65536)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="bigint" Style="0" Implicit="0"><ScalarOperator><Intrinsic FunctionName="parsename"><ScalarOperator><Const ConstValue="N'172.1.1.1'"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(16777216)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Row></Values></ConstantScan></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |