SELECT ID, AVG(SCORE) FROM T_GROUP_BY GROUP BY ID; 后面没有数据了,可能是程序core,或者死循环 3. DELETE DATA DELETE FROM DATE_TABLE WHERE U_DATE>'2012-2-29'; SUCCESS SELECT * FROM DATE_TABLE; 2 | 2020-10-21 4 | 2020-01-01 5 | 2019-12-21 7 | 1970-01-01 8 | 2000-01-01 ID | U_DATE 看起来数据没有删除掉。
请问来哥,查询支持表达式中,表达式可以是int和float混合计算吗,比如select t1.f+ t2.id from t1, t2 where t1.f+t2.id > 10.9
select * from join_table_large_1 inner join join_table_large_2 on join_table_large_1.id=join_table_large_2.id inner join join_table_large_3 on join_table_large_1.id=join_table_large_3.id inner join join_table_large_4 on join_table_large_3.id=join_table_large_4.id inner join join_table_large_5 on 1=1 inner join join_table_large_6 on join_table_large_5.id=join_table_large_6.id where join_table_large_3.num3 <10 and join_table_large_5.num5>90; 每个表都有100个数据,但是没有任何数据返回
改好了,谢谢来哥,2333
SELECT NULL_TABLE.NUM,NULL_TABLE2.NUM,NULL_TABLE.BIRTHDAY FRO SELECT null_table.num,null_table2.num,null_table.birthday FRO 18 | 18 | 2020-01-01 18 | 18 | 2020-01-01 NULL | NULL | 2010-01-11 < NULL_TABLE.NUM | NULL_TABLE2.NUM | NULL_TABLE.BIRTHDAY NULL_TABLE.NUM | NULL_TABLE2.NUM | NULL_TABLE.BIRTHDAY 3. CHECK THE ACCURACY OF DROPPING TABLE 3. CHECK THE ACCURACY OF DROPPING TABLE CREATE TABLE DROP_TABLE_3(ID INT, T_NAME CHAR); CREATE TABLE Drop_table_3(id int, t_name char); SUCCESS SUCCESS INSERT INTO DROP_TABLE_3 VALUES (1,'OB'); INSERT INTO Drop_table_3 VALUES (1,'OB'); SUCCESS SUCCESS SELECT * FROM DROP_TABLE_3; SELECT * FROM Drop_table_3; 1 | OB 1 | OB ID | T_NAME ID | T_NAME DROP TABLE DROP_TABLE_3; DROP TABLE Drop_table_3; SUCCESS SUCCESS INSERT INTO DROP_TABLE_3 VALUES (1,'OB'); INSERT INTO Drop_table_3 VALUES (1,'OB'); > FAILURE
idvzchusvol 来哥可以帮忙看看超长字段是哪个case挂了吗
你的github账号是多少?
注意提交的时候目录中不要包含 build目录、CMakeCache.txt编译出来的结果文件
表达式要考虑整数和浮点数的比较。
UPDATE TEXT_TABLE SET INFO='A TMP DATA' WHERE ID = 2;
FAILURE
更新失败了
来哥,添加了一个unique功能过了但是drop-table挂了,可以看下https://github.com/JameyWoo/miniob.git的drop-table咋回事吗
运来哥,改了一下多表,发现聚合运算过不去了,能看一下聚合运算和多表挂在哪里了吗 https://github.com/rainays/OceanBase-competition
那请问这里创建索引的语句是什么样的呢?我本地试了几种多列索引没有遇到这个少数据的问题
运来大哥哥,给孩子看看JayL-zxl的null吧,不返回no data了,但是还是过不了
--- /test/dask/test-tmp/JameyWoo/result/primary-drop-table.result.tmp 2021-11-02 11:21:37.937758417 +0800
+++ /test/dask/miniob-test/result/primary-drop-table.result 2021-10-28 12:03:57.726558099 +0800
@@ -23,3 +23,47 @@
DROP TABLE DROPTABLE3;
SUCCESS
INSERT INTO DROPTABLE3 VALUES (1,'OB');
+FAILURE
2. CONDITIONAL QUERY SELECT * FROM SELECT_TABLES_1,SELECT_TABLES_2,SELECT_TABLES_3 WHERE SELECT_TABLES_1.U_NAME=SELECT_TABLES_2.U_NAME AND SELECT_TABLES_2.U_NAME=SELECT_TABLES_3.U_NAME; +1 | 18 | A | 1 | 20 | A | 1 | 35 | A +1 | 18 | A | 1 | 20 | A | 2 | 37 | A +SELECT_TABLES_1.ID | SELECT_TABLES_1.AGE | SELECT_TABLES_1.U_NAME | SELECT_TABLES_2.ID | SELECT_TABLES_2.AGE | SELECT_TABLES_2.U_NAME | SELECT_TABLES_3.ID | SELECT_TABLES_3.RES | SELECT_TABLES_3.U_NAME
可以看看"查询条件支持表达式"的问题吗,https://github.com/lhcmaple/miniob
CREATE INDEX I_1_12 ON MULTI_INDEX(COL1,COL2); CREATE INDEX I_1_345 ON MULTI_INDEX(COL3, COL4, COL5); CREATE INDEX I_1_56 ON MULTI_INDEX(COL5, COL6); CREATE INDEX I_1_456 ON MULTI_INDEX(COL4, COL5, COL6);
SELECT NULL_TABLE.NUM,NULL_TABLE2.NUM,NULL_TABLE.BIRTHDAY FROM NULL_TABLE,NULL_TABLE2 WHERE NULL_TABLE.NUM=NULL_TABLE2.NUM; 18 | 18 | 2020-01-01 -NULL | NULL | 2010-01-11 NULL_TABLE.NUM | NULL_TABLE2.NUM | NULL_TABLE.BIRTHDAY
ID | COL1 | COL2 | COL3 | COL4 | 6-(COL2*(1+COL1))+(COL4+2)/(1+COL1*4+COL3*2) SELECT ID,COL1,COL2,COL3,COL4,3*COL1/(COL2+2) FROM EXP_TABLE WHERE 3*COL1/(COL2+2) > 1; +3 | 3 | 4 | 5 | 4 | 1.5 +ID | COL1 | COL2 | COL3 | COL4 | 3*COL1/(COL2+2) +select id,3*col1/(col2+2) from exp_table where 3*col1/(col2+2)+1/0 > 1; +ID | 3*COL1/(COL2+2) +select * from exp_table where 1/0 = 1/0; +ID | COL1 | COL2 | COL3 | COL4
这个看不太懂哎, 有没有更直白的