Home
last modified time | relevance | path

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

/foundation/distributeddatamgr/relational_store/test/js/relationalstore/unittest/src/
H A DRdbstorePredicatesJoinBJsunit.test.js27 + "(id INTEGER PRIMARY KEY ,eName TEXT, jobId INTEGER , "
29 + "FOREIGN KEY (jobId) REFERENCES job (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
[all...]
/foundation/distributeddatamgr/relational_store/test/js/rdb/unittest/src/
H A DRdbstorePredicatesJoinBJsunit.test.js26 + "(id INTEGER PRIMARY KEY ,eName TEXT, jobId INTEGER , "
28 + "FOREIGN KEY (jobId) REFERENCES job (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
[all...]
/foundation/distributeddatamgr/relational_store/test/native/rdb/unittest/
H A Dcommon.h39 int jobId; member
H A Dcommon.cpp51 value.PutInt("jobId", rowDatas.jobId); in SetRowDatas()
H A Drdb_predicates_join_b_test.cpp66 std::string("(id INTEGER PRIMARY KEY ,eName TEXT, jobId INTEGER , ") +
68 std::string("FOREIGN KEY (jobId) REFERENCES job (id) ON UPDATE NO ACTION ON DELETE CASCADE,") +
281 int jobId; in HWTEST_F() local
282 EXPECT_EQ(E_OK, allDataTypes->GetInt(2, jobId)); in HWTEST_F()
283 EXPECT_EQ(4, jobId); in HWTEST_F()
328 clauses.push_back("t1.jobId = t2.id"); in HWTEST_F()
334 EXPECT_EQ("ON(t1.jobId = t2.id)", predicates.GetJoinConditions()[0]); in HWTEST_F()
423 clauses.push_back("t1.jobId = t2.id"); in HWTEST_F()
435 EXPECT_EQ("ON(t1.jobId = t2.id AND t1.deptId = t3.id AND t1.salary BETWEEN " in HWTEST_F()

Completed in 3 milliseconds