676 self.execute("SET S evaluee N WHERE S nom 'bidule', N para 'troc'") |
676 self.execute("SET S evaluee N WHERE S nom 'bidule', N para 'troc'") |
677 rset = self.execute('DISTINCT Any A,N WHERE A concerne S, S evaluee N') |
677 rset = self.execute('DISTINCT Any A,N WHERE A concerne S, S evaluee N') |
678 self.assertEqual(len(rset.rows), 1, rset.rows) |
678 self.assertEqual(len(rset.rows), 1, rset.rows) |
679 |
679 |
680 def test_select_ordered_distinct_1(self): |
680 def test_select_ordered_distinct_1(self): |
681 self.execute("INSERT Affaire X: X sujet 'cool', X ref '1'") |
681 self.assertRaises(BadRQLQuery, |
682 self.execute("INSERT Affaire X: X sujet 'cool', X ref '2'") |
682 self.execute, 'DISTINCT Any S ORDERBY R WHERE A is Affaire, A sujet S, A ref R') |
683 rset = self.execute('DISTINCT Any S ORDERBY R WHERE A is Affaire, A sujet S, A ref R') |
|
684 self.assertEqual(rset.rows, [['cool']]) |
|
685 |
683 |
686 def test_select_ordered_distinct_2(self): |
684 def test_select_ordered_distinct_2(self): |
687 self.execute("INSERT Affaire X: X sujet 'minor'") |
685 self.execute("INSERT Affaire X: X sujet 'minor'") |
688 self.execute("INSERT Affaire X: X sujet 'important'") |
686 self.execute("INSERT Affaire X: X sujet 'important'") |
689 self.execute("INSERT Affaire X: X sujet 'normal'") |
687 self.execute("INSERT Affaire X: X sujet 'normal'") |