42 lines
634 B
SQL
42 lines
634 B
SQL
-- 检查最近创建的工单
|
|
SELECT
|
|
id,
|
|
name,
|
|
test_order_id,
|
|
order_id,
|
|
test_eut_id,
|
|
test_category_id,
|
|
test_item_id,
|
|
creator,
|
|
create_time,
|
|
test_status,
|
|
test_step
|
|
FROM test_work_order
|
|
ORDER BY id DESC
|
|
LIMIT 20;
|
|
|
|
-- 检查 test_order_id 为 NULL 的工单
|
|
SELECT
|
|
id,
|
|
name,
|
|
test_order_id,
|
|
order_id,
|
|
test_eut_id,
|
|
create_time
|
|
FROM test_work_order
|
|
WHERE test_order_id IS NULL
|
|
ORDER BY id DESC
|
|
LIMIT 10;
|
|
|
|
-- 检查最近创建的 test_eut 记录
|
|
SELECT
|
|
id,
|
|
test_order_id,
|
|
test_flow_id,
|
|
sn,
|
|
version,
|
|
memo
|
|
FROM test_eut
|
|
ORDER BY id DESC
|
|
LIMIT 10;
|