equal
deleted
inserted
replaced
1234 peid2 = self.execute("INSERT Personne Y: Y nom 'hop', Y tel 2")[0][0] |
1234 peid2 = self.execute("INSERT Personne Y: Y nom 'hop', Y tel 2")[0][0] |
1235 rset = self.execute("SET X tel 3 WHERE X tel TEL HAVING TEL&1=1") |
1235 rset = self.execute("SET X tel 3 WHERE X tel TEL HAVING TEL&1=1") |
1236 self.assertEqual(tuplify(rset.rows), [(peid1, 3)]) |
1236 self.assertEqual(tuplify(rset.rows), [(peid1, 3)]) |
1237 |
1237 |
1238 def test_insert_having(self): |
1238 def test_insert_having(self): |
1239 self.skip('unsupported yet') |
1239 self.skipTest('unsupported yet') |
1240 self.execute("INSERT Personne Y: Y nom 'hop', Y tel 1")[0][0] |
1240 self.execute("INSERT Personne Y: Y nom 'hop', Y tel 1")[0][0] |
1241 with self.debugged('DBG_SQL'): |
1241 with self.debugged('DBG_SQL'): |
1242 self.assertFalse(self.execute("INSERT Personne Y: Y nom 'hop', Y tel 2 WHERE X tel XT HAVING XT&2=2")) |
1242 self.assertFalse(self.execute("INSERT Personne Y: Y nom 'hop', Y tel 2 WHERE X tel XT HAVING XT&2=2")) |
1243 self.assertTrue(self.execute("INSERT Personne Y: Y nom 'hop', Y tel 2 WHERE X tel XT HAVING XT&1=1")) |
1243 self.assertTrue(self.execute("INSERT Personne Y: Y nom 'hop', Y tel 2 WHERE X tel XT HAVING XT&1=1")) |
1244 |
1244 |