Home
last modified time | relevance | path

Searched refs:deptId (Results 1 - 5 of 5) sorted by relevance

/foundation/distributeddatamgr/relational_store/test/js/relationalstore/unittest/src/
H A DRdbstorePredicatesJoinBJsunit.test.js28 + "mgr INTEGER, joinDate TEXT, salary REAL, bonus REAL, deptId INTEGER,"
30 + "FOREIGN KEY (deptId) REFERENCES dept (id) ON UPDATE NO ACTION ON DELETE CASCADE)";
108 {id:1001, eName:"SunWuKong", jobId:4, mgr:1004, joinDate:"2000-12-17", salary:8000.00, bonus:null, deptId:20},
109 {id:1002, eName:"LuJunYi", jobId:3, mgr:1006, joinDate:"2001-02-20", salary:16000.00, bonus:3000.00, deptId:30},
110 {id:1003, eName:"LinChong", jobId:3, mgr:1006, joinDate:"2001-02-22", salary:12500.00, bonus:5000.00, deptId:30},
111 {id:1004, eName:"TangCeng", jobId:2, mgr:1009, joinDate:"2001-04-02", salary:29750.00, bonus:null, deptId:20},
112 {id:1005, eName:"LiKui", jobId:4, mgr:1006, joinDate:"2001-09-28", salary:12500.00, bonus:14000.00, deptId:30},
113 {id:1006, eName:"SongJiang", jobId:2, mgr:1009, joinDate:"2001-05-01", salary:28500.00, bonus:null, deptId:30},
114 {id:1007, eName:"LiuBei", jobId:2, mgr:1009, joinDate:"2001-09-01", salary:24500.00, bonus:null, deptId:10},
115 {id:1008, eName:"ZhuBaJie", jobId:4, mgr:1004, joinDate:"2007-04-19", salary:30000.00, bonus:null, deptId
[all...]
/foundation/distributeddatamgr/relational_store/test/js/rdb/unittest/src/
H A DRdbstorePredicatesJoinBJsunit.test.js27 + "mgr INTEGER, joinDate TEXT, salary REAL, bonus REAL, deptId INTEGER,"
29 + "FOREIGN KEY (deptId) REFERENCES dept (id) ON UPDATE NO ACTION ON DELETE CASCADE)";
105 {id:1001, eName:"SunWuKong", jobId:4, mgr:1004, joinDate:"2000-12-17", salary:8000.00, bonus:null, deptId:20},
106 {id:1002, eName:"LuJunYi", jobId:3, mgr:1006, joinDate:"2001-02-20", salary:16000.00, bonus:3000.00, deptId:30},
107 {id:1003, eName:"LinChong", jobId:3, mgr:1006, joinDate:"2001-02-22", salary:12500.00, bonus:5000.00, deptId:30},
108 {id:1004, eName:"TangCeng", jobId:2, mgr:1009, joinDate:"2001-04-02", salary:29750.00, bonus:null, deptId:20},
109 {id:1005, eName:"LiKui", jobId:4, mgr:1006, joinDate:"2001-09-28", salary:12500.00, bonus:14000.00, deptId:30},
110 {id:1006, eName:"SongJiang", jobId:2, mgr:1009, joinDate:"2001-05-01", salary:28500.00, bonus:null, deptId:30},
111 {id:1007, eName:"LiuBei", jobId:2, mgr:1009, joinDate:"2001-09-01", salary:24500.00, bonus:null, deptId:10},
112 {id:1008, eName:"ZhuBaJie", jobId:4, mgr:1004, joinDate:"2007-04-19", salary:30000.00, bonus:null, deptId
[all...]
/foundation/distributeddatamgr/relational_store/test/native/rdb/unittest/
H A Dcommon.h44 int deptId; member
H A Dcommon.cpp74 value.PutInt("deptId", rowDatas.deptId); in SetRowDatas()
H A Drdb_predicates_join_b_test.cpp67 std::string("mgr INTEGER, joinDate TEXT, salary REAL, bonus REAL, deptId INTEGER,") +
69 std::string("FOREIGN KEY (deptId) REFERENCES dept (id) ON UPDATE NO ACTION ON DELETE CASCADE)");
256 clauses.push_back("emp.deptId = dept.id"); in HWTEST_F()
264 EXPECT_EQ("ON(emp.deptId = dept.id)", predicates.GetJoinConditions()[0]); in HWTEST_F()
265 EXPECT_EQ("CROSS JOIN dept ON(emp.deptId = dept.id)", predicates.GetJoinClause()); in HWTEST_F()
301 int deptId; in HWTEST_F() local
302 EXPECT_EQ(E_OK, allDataTypes->GetInt(7, deptId)); in HWTEST_F()
303 EXPECT_EQ(20, deptId); in HWTEST_F()
424 clauses.push_back("t1.deptId = t3.id"); in HWTEST_F()
435 EXPECT_EQ("ON(t1.jobId = t2.id AND t1.deptId in HWTEST_F()
[all...]

Completed in 2 milliseconds