cast int for offset and limit

ccovey · ccovey · commit f3370110b31a · 2013-10-30T01:26:03.000-05:00
diff --git a/laravel/database/query/grammars/sqlserver.php b/laravel/database/query/grammars/sqlserver.php
@@ -91,14 +91,14 @@ protected function ansi_offset(Query $query, $components)
 
 		unset($components['orderings']);
 
-		$start = $query->offset + 1;
+		$start = (int) $query->offset + 1;
 
 		// Next we need to calculate the constraint that should be placed on
 		// the row number to get the correct offset and limit on the query.
 		// If there is not a limit, we'll just handle the offset.
 		if ($query->limit > 0)
 		{
-			$finish = $query->offset + $query->limit;
+			$finish = (int) $query->offset + (int) $query->limit;
 
 			$constraint = "BETWEEN {$start} AND {$finish}";
 		}
@@ -137,4 +137,4 @@ protected function offset(Query $query)
 		return '';
 	}
 
-}
+}

Original file line number	Diff line number	Diff line change
`@@ -91,14 +91,14 @@ protected function ansi_offset(Query $query, $components)`
`91`	`91`
`92`	`92`	`unset($components['orderings']);`
`93`	`93`
`94`		`- $start = $query->offset + 1;`
	`94`	`+ $start = (int) $query->offset + 1;`
`95`	`95`
`96`	`96`	`// Next we need to calculate the constraint that should be placed on`
`97`	`97`	`// the row number to get the correct offset and limit on the query.`
`98`	`98`	`// If there is not a limit, we'll just handle the offset.`
`99`	`99`	`if ($query->limit > 0)`
`100`	`100`	`{`
`101`		`- $finish = $query->offset + $query->limit;`
	`101`	`+ $finish = (int) $query->offset + (int) $query->limit;`
`102`	`102`
`103`	`103`	`$constraint = "BETWEEN {$start} AND {$finish}";`
`104`	`104`	`}`
`@@ -137,4 +137,4 @@ protected function offset(Query $query)`
`137`	`137`	`return '';`
`138`	`138`	`}`
`139`	`139`
`140`		`-}`
	`140`	`+}`