SELECT * FROM DROPTABLE3;
NO DATA
包含非法的元数据直接返回FAILURE就可以了
SELECT * FROM DATETABLE WHERE UDATE='2017-2-29';
ID | U_DATE
SELECT * FROM DATETABLE WHERE UDATE='2017-21-29';
ID | U_DATE
SELECT * FROM DATETABLE WHERE UDATE='2017-12-32';
ID | U_DATE
SELECT * FROM DATETABLE WHERE UDATE='2017-11-31';
ID | U_DATE
非法日期直接返回FAILURE就可以了。
SELECT SELECTTABLES2.AGE FROM SELECTTABLES1,SELECTTABLES2 WHERE SELECTTABLES1.AGE<18 AND SELECTTABLES2.UNAME='C' AND SELECTTABLES1.ID=SELECTTABLES_2.ID;
这个没有返回结果
SELECT MIN(*) FROM AGGREGATION_FUNC;
MIN(*)
1
SELECT MAX(*) FROM AGGREGATION_FUNC;
MAX(*)
4
SELECT AVG(*) FROM AGGREGATION_FUNC;
AVG(*)
2.5
这些非法的场景没有检查出来
INSERT INTO DATE_TABLE VALUES (1,'2020-01-21');
FAILURE
INSERT INTO DATE_TABLE VALUES (2,'2020-10-21');
FAILURE
日期无法插入。
agg的测试表，有date字段
插入失败的值，在select的时候，可以看到
INSERT INTO INSERT_TABLE VALUES (4,'N4',1,1),(1,1,1);
FAILURE
INSERT INTO INSERT_TABLE VALUES (4,'N4',1,1),(1,1,1,1);
FAILURE
SELECT * FROM NULL_TABLE WHERE 1 IS NULL;
FAILURE
SELECT AVG(NUM) FROM AGGREGATION_FUNC;
AVG(NUM)
0
NUM是整数类型
2 | NULL | 20 | 2010-01-11^B
看不出来数据后面多了个什么符号
[ 47%] Building CXX object src/observer/CMakeFiles/observer.dir/sql/executor/execute_stage.cpp.o
In file included from /root/dask/test-tmp/rainays/miniob/src/observer/sql/executor/execute_stage.cpp:18:
/test/dask/test-tmp/rainays/miniob/src/observer/sql/executor/execute_stage.h:29:31: 错误：‘std::vector’尚未声明
std::string vec2string(std::vector<std::string> &vecstr, std::string &tagstr);
SELECT * FROM TORDERBY WHERE ID=3 AND NAME>='A' ORDER BY SCORE DESC, NAME;
ID | SCORE | NAME
3 | 1 | A
3 | 2 | F
3 | 2 | C
3 | 3 | D
3 | 4 | C
Panlisong，麻烦老师看一下select-tables测试，从前能过做完选做过不了了QAQ
Coding-Hammer : passed basic,update,select-meta,drop-table, commit id=59ed9c078034b6b106747f16ddf8a751bd60072d, date=2021-10-29 09:57:21
帮忙看一下Date错在哪里了，谢谢🙏 https://github.com/Coding-Hammer/miniob
确实不对,看群里前提错误日期 我测试了,我也遇到了.类似情况.
能请问下前辈这个 “2 | NULL | 20 | 2010-01-11^B” 这行是什么查询语句下产生的吗？