Attachment 157325 Details for Bug 244736 – PHP test case.

PHP test case.

dbnulltest.php (text/plain), 1.16 KB, created by Edward Rudd on 2007-06-18 20:28:12 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Edward Rudd

Created: 2007-06-18 20:28:12 UTC

Size: 1.16 KB

patch

obsolete

><?php
>
>// $Id: null.php,v 1.1 2006/10/19 12:08:36 freddy77 Exp $
>
>$server = 'myserver';
>$user = 'myuser';
>$pass = 'mypass';
>
>$conn = mssql_connect($server,$user,$pass) or die("opps\n");
>
>mssql_select_db('tempdb',$conn);
>
>mssql_query("CREATE TABLE #MyTable (
>   myfield VARCHAR(10) NULL,
>   n INT
>)", $conn) or die("error querying");
>
>
>mssql_query("INSERT INTO #MyTable VALUES('',1)
>INSERT INTO #MyTable VALUES(NULL,2)
>INSERT INTO #MyTable VALUES(' ',3)
>INSERT INTO #MyTable VALUES('a',4)", $conn) or die("error querying");
>
>$result = 0;
>
>function test($sql, $expected)
>{
>	global $conn, $result;
>
>	$res = mssql_query($sql, $conn) or die("query");
>	$row = mssql_fetch_assoc($res);
>	$s = $row['myfield'];
>
>	if (is_null($s))
>		$s = '(NULL)';
>	else if ($s == '')
>		$s = '(Empty String)';
>	else
>		$s = "'".str_replace("'", "''", $s)."'";
>	echo "$sql -> $s\n";
>	if ($s != $expected)
>	{
>		echo "error!\n";
>		$result = 1;
>	}
>}
>
>test("SELECT top 1 * FROM #MyTable WHERE n = 1", "(Empty String)");
>
>test("SELECT top 1 * FROM #MyTable WHERE n = 2", "(NULL)");
>
>test("SELECT top 1 * FROM #MyTable WHERE n = 3", "' '");
>
>test("SELECT top 1 * FROM #MyTable WHERE n = 4", "'a'");
>
>exit($result);
>?>
>

Actions: View

Attachments on bug 244736: 157322 | 157325