PageRenderTime 49ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/hphp/test/zend/bad/ext/mysql/tests/mysql_fetch_array.php

http://github.com/facebook/hiphop-php
PHP | 274 lines | 209 code | 59 blank | 6 comment | 40 complexity | d7a3c36e37e3cf624799ca01cfe9b51c MD5 | raw file
Possible License(s): LGPL-2.1, BSD-2-Clause, BSD-3-Clause, MPL-2.0-no-copyleft-exception, MIT, LGPL-2.0, Apache-2.0 
    

  1. <?php
    2. 

  2. include_once "connect.inc";
    3. 

  3. 

  4. $tmp    = NULL;
    5. 

  5. $link   = NULL;
    6. 

  6. 

  7. if (NULL !== ($tmp = @mysql_fetch_array()))
    8. 

  8. 	printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
    9. 

  9. 

  10. if (NULL != ($tmp = @mysql_fetch_array($link)))
    11. 

  11. 	printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
    12. 

  12. 

  13. require('table.inc');
    14. 

  14. if (!$res = mysql_query("SELECT * FROM test ORDER BY id LIMIT 5", $link)) {
    15. 

  15. 	printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link));
    16. 

  16. }
    17. 

  17. 

  18. print "[005]\n";
    19. 

  19. var_dump(mysql_fetch_array($res));
    20. 

  20. 

  21. print "[006]\n";
    22. 

  22. var_dump(mysql_fetch_array($res, MYSQL_NUM));
    23. 

  23. 

  24. print "[007]\n";
    25. 

  25. var_dump(mysql_fetch_array($res, MYSQL_BOTH));
    26. 

  26. 

  27. print "[008]\n";
    28. 

  28. var_dump(mysql_fetch_array($res, MYSQL_ASSOC));
    29. 

  29. 

  30. print "[009]\n";
    31. 

  31. var_dump(mysql_fetch_array($res));
    32. 

  32. 

  33. mysql_free_result($res);
    34. 

  34. 

  35. if (!$res = mysql_query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e", $link)) {
    36. 

  36. 	printf("[010] Cannot run query, [%d] %s\n", mysql_errno($link), mysql_error($link));
    37. 

  37. }
    38. 

  38. print "[011]\n";
    39. 

  39. var_dump(mysql_fetch_array($res, MYSQL_BOTH));
    40. 

  40. 

  41. mysql_free_result($res);
    42. 

  42. if (!$res = mysql_query("SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS C", $link)) {
    43. 

  43. 	printf("[012] Cannot run query, [%d] %s\n",
    44. 

  44. 		mysql_errno($link), $mysql_error($link));
    45. 

  45. 	exit(1);
    46. 

  46. }
    47. 

  47. 

  48. do {
    49. 

  49. 	$illegal_mode = mt_rand(0, 10000);
    50. 

  50. } while (in_array($illegal_mode, array(MYSQL_ASSOC, MYSQL_NUM, MYSQL_BOTH)));
    51. 

  51. $tmp = mysql_fetch_array($res, $illegal_mode);
    52. 

  52. if (!is_array($tmp))
    53. 

  53. 	printf("[013] Expecting array, got %s/%s. [%d] %s\n",
    54. 

  54. 		gettype($tmp), $tmp, mysql_errno($link), mysql_error($link));
    55. 

  55. 

  56. $tmp = @mysql_fetch_array($res, $illegal_mode);
    57. 

  57. if (false !== $tmp)
    58. 

  58. 	printf("[014] Expecting boolean/false, got %s/%s. [%d] %s\n",
    59. 

  59. 		gettype($tmp), $tmp, mysql_errno($link), mysql_error($link));
    60. 

  60. 

  61. mysql_free_result($res);
    62. 

  62. 

  63. function func_mysql_fetch_array($link, $engine, $sql_type, $sql_value, $php_value, $offset, $regexp_comparison = NULL, $binary_type = false) {
    64. 

  64. 

  65. 	if (!mysql_query("DROP TABLE IF EXISTS test", $link)) {
    66. 

  66. 		printf("[%04d] [%d] %s\n", $offset, mysql_errno($link), mysql_error($link));
    67. 

  67. 		return false;
    68. 

  68. 	}
    69. 

  69. 

  70. 	if (!mysql_query($sql = sprintf("CREATE TABLE test(id INT NOT NULL, label %s, PRIMARY KEY(id)) ENGINE = %s", $sql_type, $engine), $link)) {
    71. 

  71. 		// don't bail, engine might not support the datatype
    72. 

  72. 		return false;
    73. 

  73. 	}
    74. 

  74. 

  75. 	if (is_null($php_value) && !mysql_query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"), $link)) {
    76. 

  76. 		printf("[%04d] [%d] %s\n", $offset + 1, mysql_errno($link), mysql_error($link));
    77. 

  77. 		return false;
    78. 

  78. 	}
    79. 

  79. 

  80. 	if (!is_null($php_value)) {
    81. 

  81. 		if (is_int($sql_value) && !mysql_query(sprintf("INSERT INTO test(id, label) VALUES (1, '%d')", $sql_value), $link)) {
    82. 

  82. 			printf("[%04d] [%d] %s\n", $offset + 1, mysql_errno($link), mysql_error($link));
    83. 

  83. 			return false;
    84. 

  84. 		} else if (!is_int($sql_value) && !mysql_query(sprintf("INSERT INTO test(id, label) VALUES (1, '%s')", $sql_value), $link)) {
    85. 

  85. 			printf("[%04d] [%d] %s\n", $offset + 1, mysql_errno($link), mysql_error($link));
    86. 

  86. 			return false;
    87. 

  87. 		}
    88. 

  88. 	}
    89. 

  89. 

  90. 	if (!$res = mysql_query("SELECT id, label FROM test", $link)) {
    91. 

  91. 		printf("[%04d] [%d] %s\n", $offset + 2, mysql_errno($link), mysql_error($link));
    92. 

  92. 		return false;
    93. 

  93. 	}
    94. 

  94. 

  95. 	if (!$row = mysql_fetch_array($res, MYSQL_BOTH)) {
    96. 

  96. 		printf("[%04d] [%d] %s\n", $offset + 3, mysql_errno($link), mysql_error($link));
    97. 

  97. 		return false;
    98. 

  98. 	}
    99. 

  99. 

  100. 	if ($regexp_comparison) {
    101. 

  101. 		if (!preg_match($regexp_comparison, (string)$row['label']) || !preg_match($regexp_comparison, (string)$row[1])) {
    102. 

  102. 		printf("[%04d] Expecting %s/%s [reg exp = %s], got %s/%s resp. %s/%s. [%d] %s\n", $offset + 4,
    103. 

  103. 			gettype($php_value), $php_value, $regexp_comparison,
    104. 

  104. 			gettype($row[1]), $row[1],
    105. 

  105. 			gettype($row['label']), $row['label'], mysql_errno($link), mysql_error($link));
    106. 

  106. 		return false;
    107. 

  107. 		}
    108. 

  108. 	} else if ((gettype($php_value) == 'unicode') && $binary_type) {
    109. 

  109. 		// Unicode is on and we are told that the MySQL column type is a binary type.
    110. 

  110. 		// Don't expect a unicode value from the database, you'll get binary string
    111. 

  111. 		if (($row['label'] != $php_value) || ($row[1] != $php_value)) {
    112. 

  112. 			printf("[%04d] Expecting %s/%s, got %s/%s resp. %s/%s. [%d] %s\n", $offset + 5,
    113. 

  113. 				gettype($php_value), $php_value,
    114. 

  114. 				gettype($row[1]), $row[1],
    115. 

  115. 				gettype($row['label']), $row['label'], mysql_errno($link), mysql_error($link));
    116. 

  116. 			return false;
    117. 

  117. 		}
    118. 

  118. 		if (gettype($row['label']) == 'unicode') {
    119. 

  119. 			printf("[%04d] SQL Type: '%s', binary columns are supposed to return binary string and not unicode\n",
    120. 

  120. 				$offset + 6, $sql_type);
    121. 

  121. 			return false;
    122. 

  122. 		}
    123. 

  123. 	} else {
    124. 

  124. 		if (($row['label'] !== $php_value) || ($row[1] != $php_value)) {
    125. 

  125. 			printf("[%04d] Expecting %s/%s, got %s/%s resp. %s/%s. [%d] %s\n", $offset + 7,
    126. 

  126. 				gettype($php_value), $php_value,
    127. 

  127. 				gettype($row[1]), $row[1],
    128. 

  128. 				gettype($row['label']), $row['label'], mysql_errno($link), mysql_error($link));
    129. 

  129. 			return false;
    130. 

  130. 		}
    131. 

  131. 	}
    132. 

  132. 

  133. 	return true;
    134. 

  134. }
    135. 

  135. 

  136. function func_mysql_fetch_array_make_string($len) {
    137. 

  137. 

  138. 	$ret = '';
    139. 

  139. 	for ($i = 0; $i < $len; $i++)
    140. 

  140. 		$ret .= chr(mt_rand(65, 90));
    141. 

  141. 

  142. 	return $ret;
    143. 

  143. }
    144. 

  144. 

  145. func_mysql_fetch_array($link, $engine, "TINYINT", -11, "-11", 20);
    146. 

  146. func_mysql_fetch_array($link, $engine, "TINYINT", NULL, NULL, 30);
    147. 

  147. func_mysql_fetch_array($link, $engine, "TINYINT UNSIGNED", 1, "1", 40);
    148. 

  148. func_mysql_fetch_array($link, $engine, "TINYINT UNSIGNED", NULL, NULL, 50);
    149. 

  149. 

  150. func_mysql_fetch_array($link, $engine, "BOOL", 1, "1", 60);
    151. 

  151. func_mysql_fetch_array($link, $engine, "BOOL", NULL, NULL, 70);
    152. 

  152. func_mysql_fetch_array($link, $engine, "BOOLEAN", 0, "0", 80);
    153. 

  153. func_mysql_fetch_array($link, $engine, "BOOLEAN", NULL, NULL, 90);
    154. 

  154. 

  155. func_mysql_fetch_array($link, $engine, "SMALLINT", -32768, "-32768", 100);
    156. 

  156. func_mysql_fetch_array($link, $engine, "SMALLINT", 32767, "32767", 110);
    157. 

  157. func_mysql_fetch_array($link, $engine, "SMALLINT", NULL, NULL, 120);
    158. 

  158. func_mysql_fetch_array($link, $engine, "SMALLINT UNSIGNED", 65535, "65535", 130);
    159. 

  159. func_mysql_fetch_array($link, $engine, "SMALLINT UNSIGNED", NULL, NULL, 140);
    160. 

  160. 

  161. func_mysql_fetch_array($link, $engine, "MEDIUMINT", -8388608, "-8388608", 150);
    162. 

  162. func_mysql_fetch_array($link, $engine, "MEDIUMINT", 8388607, "8388607", 160);
    163. 

  163. func_mysql_fetch_array($link, $engine, "MEDIUMINT", NULL, NULL, 170);
    164. 

  164. func_mysql_fetch_array($link, $engine, "MEDIUMINT UNSIGNED", 16777215, "16777215", 180);
    165. 

  165. func_mysql_fetch_array($link, $engine, "MEDIUMINT UNSIGNED", NULL, NULL, 190);
    166. 

  166. 

  167. func_mysql_fetch_array($link, $engine, "INTEGER", -2147483648, "-2147483648", 200);
    168. 

  168. func_mysql_fetch_array($link, $engine, "INTEGER", 2147483647, "2147483647", 210);
    169. 

  169. func_mysql_fetch_array($link, $engine, "INTEGER", NULL, NULL, 220);
    170. 

  170. func_mysql_fetch_array($link, $engine, "INTEGER UNSIGNED", 4294967295, "4294967295", 230);
    171. 

  171. func_mysql_fetch_array($link, $engine, "INTEGER UNSIGNED", NULL, NULL, 240);
    172. 

  172. 

  173. // func_mysql_fetch_array($link, $engine, "BIGINT", -9223372036854775808, "-9.22337e+018", 250, "/-9\.22337e\+[0]?18/iu");
    174. 

  174. func_mysql_fetch_array($link, $engine, "BIGINT", NULL, NULL, 260);
    175. 

  175. // func_mysql_fetch_array($link, $engine, "BIGINT UNSIGNED", 18446744073709551615, "1.84467e+019", 270, "/1\.84467e\+[0]?19/iu");
    176. 

  176. func_mysql_fetch_array($link, $engine, "BIGINT UNSIGNED", NULL, NULL, 280);
    177. 

  177. 

  178. func_mysql_fetch_array($link, $engine, "FLOAT", -9223372036854775808 - 1.1, "-9.22337e+18", 290, "/-9\.22337e\+?[0]?18/iu");
    179. 

  179. func_mysql_fetch_array($link, $engine, "FLOAT", NULL, NULL, 300);
    180. 

  180. func_mysql_fetch_array($link, $engine, "FLOAT UNSIGNED", 18446744073709551615 + 1.1, "1.84467e+19", 310, "/1\.84467e\+?[0]?19/iu");
    181. 

  181. func_mysql_fetch_array($link, $engine, "FLOAT UNSIGNED ", NULL, NULL, 320);
    182. 

  182. 

  183. func_mysql_fetch_array($link, $engine, "DOUBLE(10,2)", -99999999.99, "-99999999.99", 330);
    184. 

  184. func_mysql_fetch_array($link, $engine, "DOUBLE(10,2)", NULL, NULL, 340);
    185. 

  185. func_mysql_fetch_array($link, $engine, "DOUBLE(10,2) UNSIGNED", 99999999.99, "99999999.99", 350);
    186. 

  186. func_mysql_fetch_array($link, $engine, "DOUBLE(10,2) UNSIGNED", NULL, NULL, 360);
    187. 

  187. 

  188. func_mysql_fetch_array($link, $engine, "DECIMAL(10,2)", -99999999.99, "-99999999.99", 370);
    189. 

  189. func_mysql_fetch_array($link, $engine, "DECIMAL(10,2)", NULL, NULL, 380);
    190. 

  190. func_mysql_fetch_array($link, $engine, "DECIMAL(10,2)", 99999999.99, "99999999.99", 390);
    191. 

  191. func_mysql_fetch_array($link, $engine, "DECIMAL(10,2)", NULL, NULL, 400);
    192. 

  192. 

  193. // don't care about date() strict TZ warnings...
    194. 

  194. func_mysql_fetch_array($link, $engine, "DATE", @date('Y-m-d'), @date('Y-m-d'), 410);
    195. 

  195. func_mysql_fetch_array($link, $engine, "DATE NOT NULL", @date('Y-m-d'), @date('Y-m-d'), 420);
    196. 

  196. func_mysql_fetch_array($link, $engine, "DATE", NULL, NULL, 430);
    197. 

  197. 

  198. func_mysql_fetch_array($link, $engine, "DATETIME", @date('Y-m-d H:i:s'), @date('Y-m-d H:i:s'), 440);
    199. 

  199. func_mysql_fetch_array($link, $engine, "DATETIME NOT NULL", @date('Y-m-d H:i:s'), @date('Y-m-d H:i:s'), 450);
    200. 

  200. func_mysql_fetch_array($link, $engine, "DATETIME", NULL, NULL, 460);
    201. 

  201. 

  202. func_mysql_fetch_array($link, $engine, "TIMESTAMP", @date('Y-m-d H:i:s'), @date('Y-m-d H:i:s'), 470);
    203. 

  203. 

  204. func_mysql_fetch_array($link, $engine, "TIME", @date('H:i:s'), @date('H:i:s'), 480);
    205. 

  205. func_mysql_fetch_array($link, $engine, "TIME NOT NULL", @date('H:i:s'), @date('H:i:s'), 490);
    206. 

  206. func_mysql_fetch_array($link, $engine, "TIME", NULL, NULL, 500);
    207. 

  207. 

  208. func_mysql_fetch_array($link, $engine, "YEAR", @date('Y'), @date('Y'), 510);
    209. 

  209. func_mysql_fetch_array($link, $engine, "YEAR NOT NULL", @date('Y'), @date('Y'), 520);
    210. 

  210. func_mysql_fetch_array($link, $engine, "YEAR", NULL, NULL, 530);
    211. 

  211. 

  212. $string255 = func_mysql_fetch_array_make_string(255);
    213. 

  213. 

  214. func_mysql_fetch_array($link, $engine, "CHAR(1)", "a", "a", 540);
    215. 

  215. func_mysql_fetch_array($link, $engine, "CHAR(255)", $string255,  $string255, 550);
    216. 

  216. func_mysql_fetch_array($link, $engine, "CHAR(1) NOT NULL", "a", "a", 560);
    217. 

  217. func_mysql_fetch_array($link, $engine, "CHAR(1)", NULL, NULL, 570);
    218. 

  218. 

  219. $string65k = func_mysql_fetch_array_make_string(65400);
    220. 

  220. 

  221. func_mysql_fetch_array($link, $engine, "VARCHAR(1)", "a", "a", 580);
    222. 

  222. func_mysql_fetch_array($link, $engine, "VARCHAR(255)", $string255, $string255, 590);
    223. 

  223. func_mysql_fetch_array($link, $engine, "VARCHAR(65400)", $string65k, $string65k, 600);
    224. 

  224. func_mysql_fetch_array($link, $engine, "VARCHAR(1) NOT NULL", "a", "a", 610);
    225. 

  225. func_mysql_fetch_array($link, $engine, "VARCHAR(1)", NULL, NULL, 620);
    226. 

  226. 

  227. func_mysql_fetch_array($link, $engine, "BINARY(1)", "a", "a", 630, null , true);
    228. 

  228. func_mysql_fetch_array($link, $engine, "BINARY(1) NOT NULL", "b", "b", 650, null , true);
    229. 

  229. func_mysql_fetch_array($link, $engine, "BINARY(1)", NULL, NULL, 660, null , true);
    230. 

  230. 

  231. func_mysql_fetch_array($link, $engine, "VARBINARY(1)", "a", "a", 670, null , true);
    232. 

  232. func_mysql_fetch_array($link, $engine, "VARBINARY(1) NOT NULL", "b", "b", 690, null , true);
    233. 

  233. func_mysql_fetch_array($link, $engine, "VARBINARY(1)", NULL, NULL, 700, null , true);
    234. 

  234. 

  235. func_mysql_fetch_array($link, $engine, "TINYBLOB", "a", "a", 710, null , true);
    236. 

  236. func_mysql_fetch_array($link, $engine, "TINYBLOB NOT NULL", "b", "b", 730, null , true);
    237. 

  237. func_mysql_fetch_array($link, $engine, "TINYBLOB", NULL, NULL, 740, null , true);
    238. 

  238. 

  239. func_mysql_fetch_array($link, $engine, "TINYTEXT", "a", "a", 750);
    240. 

  240. func_mysql_fetch_array($link, $engine, "TINYTEXT NOT NULL", "a", "a", 760);
    241. 

  241. func_mysql_fetch_array($link, $engine, "TINYTEXT", NULL, NULL, 770);
    242. 

  242. 

  243. func_mysql_fetch_array($link, $engine, "BLOB", "a", "a", 780, null , true);
    244. 

  244. func_mysql_fetch_array($link, $engine, "BLOB", NULL, NULL, 790, null , true);
    245. 

  245. 

  246. func_mysql_fetch_array($link, $engine, "TEXT", "a", "a", 800);
    247. 

  247. func_mysql_fetch_array($link, $engine, "TEXT", NULL, NULL, 820);
    248. 

  248. 

  249. func_mysql_fetch_array($link, $engine, "MEDIUMBLOB", "a", "a", 830, null , true);
    250. 

  250. func_mysql_fetch_array($link, $engine, "MEDIUMBLOB", NULL, NULL, 850, null , true);
    251. 

  251. 

  252. func_mysql_fetch_array($link, $engine, "MEDIUMTEXT", "a", "a", 860);
    253. 

  253. func_mysql_fetch_array($link, $engine, "MEDIUMTEXT", NULL, NULL, 880);
    254. 

  254. 

  255. func_mysql_fetch_array($link, $engine, "LONGBLOB", "a", "a", 890, null , true);
    256. 

  256. func_mysql_fetch_array($link, $engine, "LONGBLOB", NULL, NULL, 910, null , true);
    257. 

  257. 

  258. func_mysql_fetch_array($link, $engine, "ENUM('a', 'b')", "a", "a", 920);
    259. 

  259. func_mysql_fetch_array($link, $engine, "ENUM('a', 'b')", NULL, NULL, 930);
    260. 

  260. 

  261. func_mysql_fetch_array($link, $engine, "SET('a', 'b')", "a", "a", 940);
    262. 

  262. func_mysql_fetch_array($link, $engine, "SET('a', 'b')", NULL, NULL, 950);
    263. 

  263. 

  264. mysql_close($link);
    265. 

  265. 

  266. if (false !== ($tmp = mysql_fetch_array($res, MYSQL_ASSOC)))
    267. 

  267. printf("[015] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
    268. 

  268. 

  269. print "done!";
    270. 

  270. ?>
    271. 

  271. <?php error_reporting(0); ?>
    272. 

  272. <?php
    273. 

  273. require_once("clean_table.inc");
    274. 

  274. ?>
    275.