Annotation of embedaddon/php/ext/sybase_ct/tests/test_types.phpt, revision 1.1.1.2
1.1 misho 1: --TEST--
2: Sybase-CT select and types
3: --SKIPIF--
4: <?php require('skipif.inc'); ?>
5: --FILE--
6: <?php
7: /* This file is part of PHP test framework for ext/sybase_ct
8: *
1.1.1.2 ! misho 9: * $Id$
1.1 misho 10: */
11:
12: require('test.inc');
13:
14: define('LONG_MAX', is_int(2147483648) ? 9223372036854775807 : 2147483647);
15: define('LONG_MIN', -LONG_MAX - 1);
16:
17: $db= sybase_connect_ex();
18: var_dump(sybase_select_ex($db, 'select
19: 1 as "integer",
20: '.(LONG_MIN).' as "integer_min",
21: '.(LONG_MIN - 1).' as "integer_min_exceed",
22: '.(LONG_MAX).' as "integer_max",
23: '.(LONG_MAX + 1).' as "integer_max_exceed",
24: 1.0 as "float",
25: 12345678901234567890123456789012.123456 as "large_float",
26: $22.36 as "money",
27: "Binford" as "string",
28: convert(datetime, "2004-01-23") as "date",
29: NULL as "null",
30: convert(bit, 1) as "bit",
31: convert(smalldatetime, "2004-01-23") as "smalldate",
32: convert(char(10), "char") as "char10"
33: '));
34:
35: sybase_close($db);
36: ?>
37: --EXPECTF--
38: >>> Query: select
39: 1 as "integer",
40: -%s as "integer_min",
41: -%s as "integer_min_exceed",
42: %s as "integer_max",
43: %s as "integer_max_exceed",
44: 1.0 as "float",
45: 12345678901234567890123456789012.123456 as "large_float",
46: $22.36 as "money",
47: "Binford" as "string",
48: convert(datetime, "2004-01-23") as "date",
49: NULL as "null",
50: convert(bit, 1) as "bit",
51: convert(smalldatetime, "2004-01-23") as "smalldate",
52: convert(char(10), "char") as "char10"
53:
54: <<< Return: resource
55: array(1) {
56: [0]=>
57: array(%d) {
58: ["integer"]=>
59: int(1)
60: ["integer_min"]=>
61: int(-%s)
62: ["integer_min_exceed"]=>
63: float(-%s)
64: ["integer_max"]=>
65: int(%s)
66: ["integer_max_exceed"]=>
67: float(%s)
68: ["float"]=>
69: float(1)
70: ["large_float"]=>
71: string(39) "12345678901234567890123456789012.123456"
72: ["money"]=>
73: float(22.36)
74: ["string"]=>
75: string(7) "Binford"
76: ["date"]=>
77: string(19) "Jan 23 2004 12:00AM"
78: ["null"]=>
79: NULL
80: ["bit"]=>
81: int(1)
82: ["smalldate"]=>
83: string(19) "Jan 23 2004 12:00AM"
84: ["char10"]=>
85: string(10) "char "
86: }
87: }
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>