1--TEST--
2PDO ODBC "long" columns
3--EXTENSIONS--
4pdo_odbc
5--SKIPIF--
6<?php
7// make sure there is an ODBC driver and a DSN, or the test will fail
8include 'ext/pdo/tests/pdo_test.inc';
9$config = PDOTest::get_config('ext/pdo_odbc/tests/common.phpt');
10if (!isset($config['ENV']['PDOTEST_DSN']) || $config['ENV']['PDOTEST_DSN']===false) print 'skip';
11?>
12--FILE--
13<?php
14// setup: set PDOTEST_DSN environment variable
15//        for MyODBC (MySQL) and MS SQL Server, you need to also set PDOTEST_USER and PDOTEST_PASS
16//
17// can use MS SQL Server on Linux - using unixODBC
18//   -RHEL6.2
19//   -download & instructions: http://www.microsoft.com/en-us/download/details.aspx?id=28160
20//      -Linux6\sqlncli-11.0.1790.0.tar.gz (it calls RHEL6.x 'Linux6' for some reason)
21//   -follow instructions on web page and install script
22//   -may have to specify connection info in connection string without using a DSN (DSN-less connection)
23//      -for example:
24//            set PDOTEST_DSN='odbc:Driver=SQL Server Native Client 11.0;Server=10.200.51.179;Database=testdb'
25//            set PDOTEST_USER=sa
26//            set PDOTEST_PASS=Password01
27//
28// on Windows, the easy way to do this:
29// 1. install MS Access (part of MS Office) and include ODBC (Development tools feature)
30//       install the x86 build of the Drivers. You might not be able to load the x64 drivers.
31// 2. in Control Panel, search for ODBC and open "Setup data sources (ODBC)"
32// 3. click on System DSN tab
33// 4. click Add and choose "Microsoft Access Driver (*.mdb, *.accdb)" driver
34// 5. enter a DSN, ex: accdb12
35// 6. click 'Create' and select a file to save the database as
36//       -otherwise, you'll have to open MS Access, create a database, then load that file in this Window to map it to a DSN
37// 7. set the environment variable PDOTEST_DSN="odbc:<system dsn from step 5>" ex: SET PDOTEST_DSN=odbc:accdb12
38//         -note: on Windows, " is included in environment variable
39//
40// easy way to compile:
41// configure --disable-all --enable-cli --enable-zts --enable-pdo --with-pdo-odbc --enable-debug
42// configure --disable-all --enable-cli --enable-pdo --with-pdo-odbc=unixODBC,/usr,/usr --with-unixODBC=/usr --enable-debug
43//
44
45require 'ext/pdo/tests/pdo_test.inc';
46$db = PDOTest::test_factory('ext/pdo_odbc/tests/common.phpt');
47$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
48
49if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data CLOB)')) {
50    if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data longtext)')) {
51        if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data varchar(4000))')) {
52            die("BORK: don't know how to create a long column here:\n" . implode(", ", $db->errorInfo()));
53        }
54    }
55}
56
57$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
58
59// the driver reads columns in blocks of 255 bytes and then reassembles those blocks into a single buffer.
60// test sizes around 255 to make sure that the reassembly works (and that the column is split into 255 byte blocks by the database)
61// also, test sizes below 255 to make sure that they work - and are not treated as a long column (should be read in a single read)
62$sizes = array(32, 53, 64, 79, 128, 253, 254, 255, 256, 257, 258, 1022, 1023, 1024, 1025, 1026, 510, 511, 512, 513, 514, 1278, 1279, 1280, 1281, 1282, 2046, 2047, 2048, 2049, 2050, 1534, 1535, 1536, 1537, 1538, 3070, 3071, 3072, 3073, 3074, 3998, 3999, 4000);
63
64function alpha_repeat($len) {
65    // use the alphabet instead of 'i' characters to make sure the blocks don't overlap when they are reassembled
66    $out = "";
67    while (strlen($out) < $len) {
68        $out .= "abcdefghijklmnopqrstuvwxyz";
69    }
70    return substr($out, 0, $len);
71}
72
73// don't use Prepared Statements. that fails on MS SQL server (works with Access, MyODBC), which is a separate failure, feature/code-path from what
74// this test does - nice to be able to test using MS SQL server
75foreach ($sizes as $num) {
76    $text = alpha_repeat($num);
77    $db->exec("INSERT INTO TEST VALUES($num, '$text')");
78}
79
80// verify data
81foreach ($db->query('SELECT id, data from TEST ORDER BY LEN(data) ASC') as $row) {
82    $expect = alpha_repeat($row[0]);
83    if (strcmp($expect, $row[1])) {
84        echo "Failed on size $row[id]:\n";
85        printf("Expected %d bytes, got %d\n", strlen($expect), strlen($row['data']));
86        echo ($expect) . "\n";
87        echo ($row['data']) . "\n";
88    } else {
89        echo "Passed on size $row[id]\n";
90    }
91}
92
93echo "Finished\n";
94?>
95--EXPECT--
96Passed on size 32
97Passed on size 53
98Passed on size 64
99Passed on size 79
100Passed on size 128
101Passed on size 253
102Passed on size 254
103Passed on size 255
104Passed on size 256
105Passed on size 257
106Passed on size 258
107Passed on size 510
108Passed on size 511
109Passed on size 512
110Passed on size 513
111Passed on size 514
112Passed on size 1022
113Passed on size 1023
114Passed on size 1024
115Passed on size 1025
116Passed on size 1026
117Passed on size 1278
118Passed on size 1279
119Passed on size 1280
120Passed on size 1281
121Passed on size 1282
122Passed on size 1534
123Passed on size 1535
124Passed on size 1536
125Passed on size 1537
126Passed on size 1538
127Passed on size 2046
128Passed on size 2047
129Passed on size 2048
130Passed on size 2049
131Passed on size 2050
132Passed on size 3070
133Passed on size 3071
134Passed on size 3072
135Passed on size 3073
136Passed on size 3074
137Passed on size 3998
138Passed on size 3999
139Passed on size 4000
140Finished
141