@@ 43-60 (lines=18) @@ | ||
40 | $this->assertEquals('22', $result[0]['foo']); |
|
41 | } |
|
42 | ||
43 | public function testVarIntSet() |
|
44 | { |
|
45 | self::$connection->query('CREATE TABLE VarIntSetTest (foo varint PRIMARY KEY, bar set<varint>)'); |
|
46 | self::$connection->query( |
|
47 | 'INSERT INTO VarIntSetTest (foo, bar) VALUES (:foo, :bar)', |
|
48 | ['foo' => '2', 'bar' => ['25', '14156250080000000000003002', '52']] |
|
49 | ); |
|
50 | $result = self::$connection->query('SELECT * FROM VarIntSetTest WHERE foo = :foo', ['foo' => '2']); |
|
51 | $this->assertEquals(['25', '52', '14156250080000000000003002'], $result[0]['bar']); |
|
52 | $this->assertEquals('2', $result[0]['foo']); |
|
53 | //according to Spec, this should always be returned alphabetically. |
|
54 | self::$connection->query( |
|
55 | 'INSERT INTO VarIntSetTest (foo, bar) VALUES (:foo, :bar)', |
|
56 | ['foo' => '22', 'bar' => ['52', '14156250080000000000003002', '25']] |
|
57 | ); |
|
58 | $result = self::$connection->query('SELECT * FROM VarIntSetTest WHERE foo = :foo', ['foo' => '22']); |
|
59 | $this->assertEquals(['25', '52', '14156250080000000000003002'], $result[0]['bar']); |
|
60 | } |
|
61 | ||
62 | public function testVarIntList() |
|
63 | { |
|
@@ 62-79 (lines=18) @@ | ||
59 | $this->assertEquals(['25', '52', '14156250080000000000003002'], $result[0]['bar']); |
|
60 | } |
|
61 | ||
62 | public function testVarIntList() |
|
63 | { |
|
64 | self::$connection->query('CREATE TABLE VarIntListTest (foo varint PRIMARY KEY, bar list<varint>)'); |
|
65 | self::$connection->query( |
|
66 | 'INSERT INTO VarIntListTest (foo, bar) VALUES (:foo, :bar)', |
|
67 | ['foo' => '2', 'bar' => ['52', '25', '14156250080000000000003002']] |
|
68 | ); |
|
69 | $result = self::$connection->query('SELECT * FROM VarIntListTest WHERE foo = :foo', ['foo' => '2']); |
|
70 | $this->assertEquals(['52', '25', '14156250080000000000003002'], $result[0]['bar']); |
|
71 | $this->assertEquals('2', $result[0]['foo']); |
|
72 | //according to Spec, this should be returned in index order |
|
73 | self::$connection->query( |
|
74 | 'INSERT INTO VarIntListTest (foo, bar) VALUES (:foo, :bar)', |
|
75 | ['foo' => '22', 'bar' => ['25', '52', '14156250080000000000003002']] |
|
76 | ); |
|
77 | $result = self::$connection->query('SELECT * FROM VarIntListTest WHERE foo = :foo', ['foo' => '22']); |
|
78 | $this->assertEquals(['25', '52', '14156250080000000000003002'], $result[0]['bar']); |
|
79 | } |
|
80 | ||
81 | } |