|
@@ 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 |
|
} |