xref: /PHP-8.3/ext/odbc/tests/bug73725.phpt (revision 8726ae06)
1--TEST--
2Bug #73725 Unable to retrieve value of varchar(max) type
3--EXTENSIONS--
4odbc
5--SKIPIF--
6<?php include 'skipif.inc'; ?>
7--FILE--
8<?php
9
10include __DIR__ . "/config.inc";
11
12$conn = odbc_connect($dsn, $user, $pass);
13
14odbc_do($conn, "CREATE TABLE bug73725(i int, txt varchar(max), k int)");
15
16odbc_do($conn, "INSERT INTO bug73725 VALUES(101,'Any text', 33), (102,'Lorem ipsum dolor', 34)");
17
18$rc = odbc_do($conn, "SELECT i, txt, k FROM bug73725");
19
20$r = odbc_fetch_array($rc);
21var_dump($r);
22
23$r = odbc_fetch_array($rc);
24var_dump($r);
25
26?>
27--CLEAN--
28<?php
29include 'config.inc';
30
31$conn = odbc_connect($dsn, $user, $pass);
32
33odbc_exec($conn, 'DROP TABLE bug73725');
34
35odbc_close($conn);
36
37?>
38--EXPECT--
39array(3) {
40  ["i"]=>
41  string(3) "101"
42  ["txt"]=>
43  string(8) "Any text"
44  ["k"]=>
45  string(2) "33"
46}
47array(3) {
48  ["i"]=>
49  string(3) "102"
50  ["txt"]=>
51  string(17) "Lorem ipsum dolor"
52  ["k"]=>
53  string(2) "34"
54}
55