@@ 34-51 (lines=18) @@ | ||
31 | $this->assertEquals(true, $result[0]['foo']); |
|
32 | } |
|
33 | ||
34 | public function testBooleanSet() |
|
35 | { |
|
36 | self::$connection->query('CREATE TABLE BooleanSetTest (foo boolean PRIMARY KEY, bar set<boolean>)'); |
|
37 | self::$connection->query( |
|
38 | 'INSERT INTO BooleanSetTest (foo, bar) VALUES (:foo, :bar)', |
|
39 | ['foo' => true, 'bar' => [true, false]] |
|
40 | ); |
|
41 | $result = self::$connection->query('SELECT * FROM BooleanSetTest WHERE foo = :foo', ['foo' => true]); |
|
42 | $this->assertEquals([false, true], $result[0]['bar']); |
|
43 | $this->assertEquals(true, $result[0]['foo']); |
|
44 | //according to Spec, this should always be returned alphabetically. |
|
45 | self::$connection->query( |
|
46 | 'INSERT INTO BooleanSetTest (foo, bar) VALUES (:foo, :bar)', |
|
47 | ['foo' => true, 'bar' => [false, true]] |
|
48 | ); |
|
49 | $result = self::$connection->query('SELECT * FROM BooleanSetTest WHERE foo = :foo', ['foo' => true]); |
|
50 | $this->assertEquals([false, true], $result[0]['bar']); |
|
51 | } |
|
52 | ||
53 | public function testBooleanList() |
|
54 | { |
|
@@ 53-70 (lines=18) @@ | ||
50 | $this->assertEquals([false, true], $result[0]['bar']); |
|
51 | } |
|
52 | ||
53 | public function testBooleanList() |
|
54 | { |
|
55 | self::$connection->query('CREATE TABLE BooleanListTest (foo boolean PRIMARY KEY, bar list<boolean>)'); |
|
56 | self::$connection->query( |
|
57 | 'INSERT INTO BooleanListTest (foo, bar) VALUES (:foo, :bar)', |
|
58 | ['foo' => true, 'bar' => [false, true]] |
|
59 | ); |
|
60 | $result = self::$connection->query('SELECT * FROM BooleanListTest WHERE foo = :foo', ['foo' => true]); |
|
61 | $this->assertEquals([false, true], $result[0]['bar']); |
|
62 | $this->assertEquals(true, $result[0]['foo']); |
|
63 | //according to Spec, this should be returned in index order - seems for booleans it just doesn't care |
|
64 | self::$connection->query( |
|
65 | 'INSERT INTO BooleanListTest (foo, bar) VALUES (:foo, :bar)', |
|
66 | ['foo' => false, 'bar' => [true, false]] |
|
67 | ); |
|
68 | $result = self::$connection->query('SELECT * FROM BooleanListTest WHERE foo = :foo', ['foo' => false]); |
|
69 | $this->assertEquals([false, true], $result[0]['bar']); |
|
70 | } |
|
71 | ||
72 | } |