SQL

SELECT Hash

SELECT로 Hash 데이터를 조회

SELECT로 Hash 데이터를 조회합니다.

테스트 데이터 입력: Redis 명령으로 입력

Example

명령>	hset myname1 name kim age 25 birthday 1995-01-01 city Seoul
결과>	4
명령>	hset myname2 name kang age 30 birthday 1990-01-01 city Daejeon
결과>	4
명령>	hset myname3 name park age 20 birthday 2000-01-01 city Seoul hobby ski,bike
결과>	5
명령>	hset myname4 name choe age 30 birthday 1990-01-01 city Daejeon
결과>	4
명령>	hset myname5 name lee age 35 birthday 1985-01-01 city Busan
결과>	4
명령>	hset subject1 name kim kor 90 eng 80 math 70
결과>	4
명령>	hset subject2 name kang kor 80 eng 90 math 60 science 70
결과>	5
명령>	hset subject3 name park kor 70 eng 80 math 90 history 60
결과>	5
명령>	hset subject4 name lee kor 30 eng 40 math 40 history 50 science 40
결과>	6

SQL Insert 문으로 입력

Example

명령>	insert into hash values('myname1', 'name', 'kim', 'age', 25, 'birthday', '1995-01-01', 'city', 'Seoul');
결과>	1 inserted
명령>	insert into hash values('myname2', 'name', 'kang', 'age', 30, 'birthday', '1990-01-01', 'city', 'Daejeon');
결과>	1 inserted
명령>	insert into hash values('myname3', 'name', 'park', 'age', 20, 'birthday', '2000-01-01', 'city', 'Seoul', 'hobby', 'ski,bike');
결과>	1 inserted
명령>	insert into hash values('myname4', 'name', 'choe', 'age', 30, 'birthday', '1990-01-01', 'city', 'Daejeon');
결과>	1 inserted
명령>	insert into hash values('myname5', 'name', 'lee', 'age', 35, 'birthday', '1985-01-01', 'city', 'Busan');
결과>	1 inserted
명령>	insert into hash values('subject1', 'name', 'kim', 'kor', 90, 'eng', 80, 'math', 70);
결과>	1 inserted
명령>	insert into hash values('subject2', 'name', 'kang', 'kor', 80, 'eng', 90, 'math', 60, 'science', 70);
결과>	1 inserted
명령>	insert into hash values('subject3', 'name', 'park', 'kor', 70, 'eng', 80, 'math', 90, 'history', 60);
결과>	1 inserted
명령>	insert into hash values('subject4', 'name', 'lee', 'kor', 30, 'eng', 40, 'math', 40, 'history', 50, 'science', 40);
결과>	1 inserted

SELECT

SELECT * : 포함된 모든 필드를 조회합니다.
SELECT key, field1, field2 : 조회할 필드를 지정합니다.
SELECT field1 name1 or field1 AS name1 --> alias(별명) 사용 가능

FROM

FROM hash.*
FROM hash.myhash*
FROM hash.myhash1

SELECT * FROM HASH.MYHASH*

Hash에서 키와 필드를 조회한다.

Example

명령>	select * from hash.myname1; opcode
결과>	0) key\|name\|age\|birthday\|city 1) myname1\|kim\|25\|1995-01-01\|Seoul
명령>	select key,name,city from hash.myname1; opcode
결과>	0) key\|name\|city 1) myname1\|kim\|Seoul
명령>	select * from hash.myname*; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname1\|kim\|25\|1995-01-01\|Seoul\| 2) myname2\|kang\|30\|1990-01-01\|Daejeon\| 3) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike 4) myname4\|choe\|30\|1990-01-01\|Daejeon\| 5) myname5\|lee\|35\|1985-01-01\|Busan\|

ORDER BY

정렬(sort)해서 보여준다.

Example

명령>	select * from hash.myname* order by name; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname4\|choe\|30\|1990-01-01\|Daejeon\| 2) myname2\|kang\|30\|1990-01-01\|Daejeon\| 3) myname1\|kim\|25\|1995-01-01\|Seoul\| 4) myname5\|lee\|35\|1985-01-01\|Busan\| 5) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike
명령>	select * from hash.myname* order by age; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike 2) myname1\|kim\|25\|1995-01-01\|Seoul\| 3) myname2\|kang\|30\|1990-01-01\|Daejeon\| 4) myname4\|choe\|30\|1990-01-01\|Daejeon\| 5) myname5\|lee\|35\|1985-01-01\|Busan\|
명령>	select * from hash.myname* order by age desc; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname5\|lee\|35\|1985-01-01\|Busan\| 2) myname2\|kang\|30\|1990-01-01\|Daejeon\| 3) myname4\|choe\|30\|1990-01-01\|Daejeon\| 4) myname1\|kim\|25\|1995-01-01\|Seoul\| 5) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike

NULLS FIRST/LAST

Example

명령>	select * from hash.subject* order by science; opcode
결과>	0) key\|name\|kor\|eng\|math\|science\|history 1) subject1\|kim\|90\|80\|70\|(nil)\|(nil) 2) subject3\|park\|70\|80\|90\|(nil)\|60 3) subject4\|lee\|30\|40\|40\|40\|50 4) subject2\|kang\|80\|90\|60\|70\|(nil)
명령>	select * from hash.subject* order by science nulls last; opcode
결과>	0) key\|name\|kor\|eng\|math\|science\|history 1) subject4\|lee\|30\|40\|40\|40\|50 2) subject2\|kang\|80\|90\|60\|70\|(nil) 3) subject1\|kim\|90\|80\|70\|(nil)\|(nil) 4) subject3\|park\|70\|80\|90\|(nil)\|60

LIMIT

출력 행 수를 제한한다.

Example

명령>	select * from hash.myname* limit 3; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname1\|kim\|25\|1995-01-01\|Seoul\| 2) myname2\|kang\|30\|1990-01-01\|Daejeon\| 3) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike
명령>	select * from hash.myname* order by name limit 3; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname4\|choe\|30\|1990-01-01\|Daejeon\| 2) myname2\|kang\|30\|1990-01-01\|Daejeon\| 3) myname1\|kim\|25\|1995-01-01\|Seoul\|

LIMIT OFFSET

몇 행 건너 출력

Example

명령>	select * from hash.myname* limit 3 offset 2; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike 2) myname4\|choe\|30\|1990-01-01\|Daejeon\| 3) myname5\|lee\|35\|1985-01-01\|Busan\|
명령>	select * from hash.myname* limit 2, 3; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike 2) myname4\|choe\|30\|1990-01-01\|Daejeon\| 3) myname5\|lee\|35\|1985-01-01\|Busan\|

FUNCTIONS

COUNT(), LEN()

개수를 조회한다. len()은 value(값)의 개수를 구합니다.

Example

명령>	select *count()** from hash.myname*; opcode
결과>	0) count(*) 1) 5
명령>	select count(key) from hash.myname*;
결과>	0) count(key) 1) 5
명령>	select key, len(key) from hash.myname*;
결과>	0) key\|len(key) 1) myname1\|4 2) myname2\|4 3) myname3\|5 4) myname4\|4 5) myname5\|4
명령>	select *key, count()** from hash.myname* group by key;
결과>	0) key\|count(*) 1) myname1\|1 2) myname2\|1 3) myname3\|1 4) myname4\|1 5) myname5\|1

MAX(), MIN()

최댓값, 최솟값을 조회한다.

Example

명령>	select max(name),max(age) from hash.myname*; opcode
결과>	0) max(name)\|max(age) 1) park\|35
명령>	select min(name),min(age) from hash.myname*; opcode
결과>	0) min(name)\|min(age) 1) choe\|20
명령>	select min(age),max(age) from hash.myname*; opcode
결과>	0) min(age)\|max(age) 1) 20\|35

이렇게 사용해도 됩니다.
MAX()와 필드를 같이 조회할 경우: MAX()에 해당하는 필드가 조회됩니다.

Example

명령>	select max(name), * from hash.myname*; opcode
결과>	0) max(name)\|key\|name\|age\|birthday\|city\|hobby 1) park\|myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike

숫자 함수

SUM(), AVG()

합계, 평균을 구한다.

Example

명령>	select sum(kor),sum(eng) from hash.subject*; opcode
결과>	0) sum(kor)\|sum(eng) 1) 270\|290
명령>	select avg(kor),avg(eng) from hash.subject*; opcode
결과>	0) avg(kor)\|avg(eng) 1) 67.5\|72.5
명령>	select sum(history),avg(history),count() from hash.sub where history >= 0; opcode
결과>	0) sum(history)\|avg(history)\|count(*) 1) 110\|55.0\|2

WHERE 조건

비교: =, <, <=, >, >=, !=, <>

키 비교

Example

명령>	select * from hash.myname* where key >= 'myname3'; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike 2) myname4\|choe\|30\|1990-01-01\|Daejeon\|(nil) 3) myname5\|lee\|35\|1985-01-01\|Busan\|(nil)
명령>	select * from hash.myname* where key > 'myname3'; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname4\|choe\|30\|1990-01-01\|Daejeon\|(nil) 2) myname5\|lee\|35\|1985-01-01\|Busan\|(nil)

값(value) 비교

Example

명령>	select * from hash.myname* where age = 30; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname2\|kang\|30\|1990-01-01\|Daejeon\|(nil) 2) myname4\|choe\|30\|1990-01-01\|Daejeon\|(nil)
명령>	select * from hash.myname* where age >= 30; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname2\|kang\|30\|1990-01-01\|Daejeon\|(nil) 2) myname4\|choe\|30\|1990-01-01\|Daejeon\|(nil) 3) myname5\|lee\|35\|1985-01-01\|Busan\|(nil)
명령>	select * from hash.myname* where age < 30; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname1\|kim\|25\|1995-01-01\|Seoul\|(nil) 2) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike
명령>	select * from hash.myname* where age != 30; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname1\|kim\|25\|1995-01-01\|Seoul\|(nil) 2) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike 3) myname5\|lee\|35\|1985-01-01\|Busan\|(nil)

AND, OR

Example

명령>	select * from hash.myname* where age >= 25 and city = 'Seoul'; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname1\|kim\|25\|1995-01-01\|Seoul\|(nil)
명령>	select * from hash.myname* where age > 30 or city = 'Seoul'; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname1\|kim\|25\|1995-01-01\|Seoul\|(nil) 2) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike 3) myname5\|lee\|35\|1985-01-01\|Busan\|(nil)

BETWEEN

Example

명령>	select * from hash.myname* where age between 25 and 30; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname1\|kim\|25\|1995-01-01\|Seoul\|(nil) 2) myname2\|kang\|30\|1990-01-01\|Daejeon\|(nil) 3) myname4\|choe\|30\|1990-01-01\|Daejeon\|(nil)

IS NULL, IS NOT NULL

Example

명령>	select * from hash.subject* where science is null; opcode
결과>	0) key\|name\|kor\|eng\|math\|science\|history 1) subject1\|kim\|90\|80\|70\|(nil)\|(nil) 2) subject3\|park\|70\|80\|90\|(nil)\|60
명령>	select * from hash.subject* where science is not null; opcode
결과>	0) key\|name\|kor\|eng\|math\|science\|history 1) subject2\|kang\|80\|90\|60\|70\|(nil) 2) subject4\|lee\|30\|40\|40\|40\|50

GLOB

*(별표), ?(물음표)
대소문자를 구분한다.

Example

명령>	select * from hash.myname* where *name glob 'k';** opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname1\|kim\|25\|1995-01-01\|Seoul\|(nil) 2) myname2\|kang\|30\|1990-01-01\|Daejeon\|(nil)
명령>	select * from hash.myname* where *birthday glob '19?5';** opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname1\|kim\|25\|1995-01-01\|Seoul\|(nil) 2) myname5\|lee\|35\|1985-01-01\|Busan\|(nil)

LIKE

%(퍼센트), _(밑줄)
대소문자를 구분하지 않는다.

Example

명령>	select * from hash.myname* where name like 'K%'; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname1\|kim\|25\|1995-01-01\|Seoul\|(nil) 2) myname2\|kang\|30\|1990-01-01\|Daejeon\|(nil)
명령>	select * from hash.myname* where birthday like '1990%'; opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname2\|kang\|30\|1990-01-01\|Daejeon\|(nil) 2) myname4\|choe\|30\|1990-01-01\|Daejeon\|(nil)

IN

Example

명령>	select * from hash.myname* where key in ('myname1','myname3'); opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname1\|kim\|25\|1995-01-01\|Seoul\|(nil) 2) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike
명령>	select * from hash.myname* where city in ('Seoul','Busan'); opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname1\|kim\|25\|1995-01-01\|Seoul\|(nil) 2) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike 3) myname5\|lee\|35\|1985-01-01\|Busan\|(nil)
명령>	select * from hash.myname* where age in (20,30); opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname2\|kang\|30\|1990-01-01\|Daejeon\|(nil) 2) myname3\|park\|20\|2000-01-01\|Seoul\|ski,bike 3) myname4\|choe\|30\|1990-01-01\|Daejeon\|(nil)

NOT IN

Example

명령>	select * from hash.myname* where key not in ('myname1','myname3'); opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname2\|kang\|30\|1990-01-01\|Daejeon\|(nil) 2) myname4\|choe\|30\|1990-01-01\|Daejeon\|(nil) 3) myname5\|lee\|35\|1985-01-01\|Busan\|(nil)
명령>	select * from hash.myname* where city not in ('Seoul','Busan'); opcode
결과>	0) key\|name\|age\|birthday\|city\|hobby 1) myname2\|kang\|30\|1990-01-01\|Daejeon\|(nil) 2) myname4\|choe\|30\|1990-01-01\|Daejeon\|(nil)

GROUP BY

Example

명령>	select city,count() from hash.myname group by city; opcode
결과>	0) city\|count(*) 1) Busan\|1 2) Daejeon\|2 3) Seoul\|2
명령>	select city,min(age),max(age) from hash.myname* group by city; opcode
결과>	0) city\|count(*) 1) Busan\|35\|35 2) Daejeon\|30\|30 3) Seoul\|20\|25

GROUP BY HAVING

Example

명령>	select city,sum(age) from hash.myname* group by city having sum(age) > 40; opcode
결과>	0) city\|sum(age) 1) Daejeon\|60 2) Seoul\|45

OPCODE

select * from hash.myname1;

0) key|name|age|birthday|city 1) myname1|kim|25|1995-01-01|Seoul # ------------------------------------------------------- # select * from hash.myname1; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:1,p2:5,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:2,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:11,p3:0,p4type:NOTUSED # sql:"select * from hash.myname1;" -> 1 rows # used_memory:1555136, total_diff:24

select key,name,city from hash.myname1;

0) key|name|city 1) myname1|kim|Seoul # ------------------------------------------------------- # select key,name,city from hash.myname1; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:1,p2:3,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:2,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:9,p3:0,p4type:NOTUSED # sql:"select key,name,city from hash.myname1;" -> 1 rows # used_memory:1555576, total_diff:24

select * from hash.myname*;

0) key|name|age|birthday|city|hobby 1) myname1|kim|25|1995-01-01|Seoul|(nil) 2) myname2|kang|30|1990-01-01|Daejeon|(nil) 3) myname3|park|20|2000-01-01|Seoul|ski,bike 4) myname4|choe|30|1990-01-01|Daejeon|(nil) 5) myname5|lee|35|1985-01-01|Busan|(nil) # ------------------------------------------------------- # select * from hash.myname*; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:1,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:2,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:12,p3:0,p4type:NOTUSED # sql:"select * from hash.myname*;" -> 5 rows # used_memory:1556000, total_diff:24

ORDER BY

select * from hash.myname* order by name;

0) key|name|age|birthday|city|hobby 1) myname4|choe|30|1990-01-01|Daejeon|(nil) 2) myname2|kang|30|1990-01-01|Daejeon|(nil) 3) myname1|kim|25|1995-01-01|Seoul|(nil) 4) myname5|lee|35|1985-01-01|Busan|(nil) 5) myname3|park|20|2000-01-01|Seoul|ski,bike # ------------------------------------------------------- # select * from hash.myname* order by name; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 3 OP_SorterNext, p1:1,p2:15,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:2,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:1,p3:2,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:0,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:2,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:3,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:4,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:5,p3:7,p4type:NOTUSED # opcode:125 OP_SorterData, p1:1,p2:9,p3:2,p4type:NOTUSED # opcode: 35 OP_SorterSort, p1:1,p2:-5,p3:0,p4type:NOTUSED # opcode:114 OP_OpenPseudo, p1:2,p2:9,p3:8,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode:130 OP_SorterInsert, p1:1,p2:8,p3:1,p4type:INT32 # opcode: 91 OP_MakeRecord, p1:1,p2:6,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:1,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:2,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode:111 OP_SorterOpen, p1:1,p2:8,p3:0,p4type:KEYINFO # opcode: 62 OP_Init, p1:0,p2:25,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* order by name;" -> 5 rows # used_memory:1556440, total_diff:24

select * from hash.myname* order by age;

0) key|name|age|birthday|city|hobby 1) myname3|park|20|2000-01-01|Seoul|ski,bike 2) myname1|kim|25|1995-01-01|Seoul|(nil) 3) myname2|kang|30|1990-01-01|Daejeon|(nil) 4) myname4|choe|30|1990-01-01|Daejeon|(nil) 5) myname5|lee|35|1985-01-01|Busan|(nil) # ------------------------------------------------------- # select * from hash.myname* order by age; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 3 OP_SorterNext, p1:1,p2:15,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:2,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:1,p3:2,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:2,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:0,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:3,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:4,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:5,p3:7,p4type:NOTUSED # opcode:125 OP_SorterData, p1:1,p2:9,p3:2,p4type:NOTUSED # opcode: 35 OP_SorterSort, p1:1,p2:-5,p3:0,p4type:NOTUSED # opcode:114 OP_OpenPseudo, p1:2,p2:9,p3:8,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode:130 OP_SorterInsert, p1:1,p2:8,p3:1,p4type:INT32 # opcode: 91 OP_MakeRecord, p1:1,p2:6,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:1,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:2,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode:111 OP_SorterOpen, p1:1,p2:8,p3:0,p4type:KEYINFO # opcode: 62 OP_Init, p1:0,p2:25,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* order by age;" -> 5 rows # used_memory:1556880, total_diff:24

select * from hash.myname* order by age desc;

0) key|name|age|birthday|city|hobby 1) myname5|lee|35|1985-01-01|Busan|(nil) 2) myname2|kang|30|1990-01-01|Daejeon|(nil) 3) myname4|choe|30|1990-01-01|Daejeon|(nil) 4) myname1|kim|25|1995-01-01|Seoul|(nil) 5) myname3|park|20|2000-01-01|Seoul|ski,bike # ------------------------------------------------------- # select * from hash.myname* order by age desc; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 3 OP_SorterNext, p1:1,p2:15,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:2,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:1,p3:2,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:2,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:0,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:3,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:4,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:5,p3:7,p4type:NOTUSED # opcode:125 OP_SorterData, p1:1,p2:9,p3:2,p4type:NOTUSED # opcode: 35 OP_SorterSort, p1:1,p2:-5,p3:0,p4type:NOTUSED # opcode:114 OP_OpenPseudo, p1:2,p2:9,p3:8,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode:130 OP_SorterInsert, p1:1,p2:8,p3:1,p4type:INT32 # opcode: 91 OP_MakeRecord, p1:1,p2:6,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:1,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:2,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode:111 OP_SorterOpen, p1:1,p2:8,p3:0,p4type:KEYINFO # opcode: 62 OP_Init, p1:0,p2:25,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* order by age desc;" -> 5 rows # used_memory:1557328, total_diff:24

NULLS FIRST/LAST

select * from hash.subject* order by science;

0) key|name|kor|eng|math|science|history 1) subject1|kim|90|80|70|(nil)|(nil) 2) subject3|park|70|80|90|(nil)|60 3) subject4|lee|30|40|40|40|50 4) subject2|kang|80|90|60|70|(nil) # ------------------------------------------------------- # select * from hash.subject* order by science; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 3 OP_SorterNext, p1:1,p2:16,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:2,p2:7,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:1,p3:2,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:2,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:3,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:4,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:5,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:0,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:6,p3:8,p4type:NOTUSED # opcode:125 OP_SorterData, p1:1,p2:10,p3:2,p4type:NOTUSED # opcode: 35 OP_SorterSort, p1:1,p2:-5,p3:0,p4type:NOTUSED # opcode:114 OP_OpenPseudo, p1:2,p2:10,p3:9,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode:130 OP_SorterInsert, p1:1,p2:9,p3:1,p4type:INT32 # opcode: 91 OP_MakeRecord, p1:1,p2:7,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:1,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:6,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:2,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode:111 OP_SorterOpen, p1:1,p2:9,p3:0,p4type:KEYINFO # opcode: 62 OP_Init, p1:0,p2:27,p3:0,p4type:NOTUSED # sql:"select * from hash.subject* order by science;" -> 4 rows # used_memory:1557776, total_diff:24

select * from hash.subject* order by science nulls last;

0) key|name|kor|eng|math|science|history 1) subject4|lee|30|40|40|40|50 2) subject2|kang|80|90|60|70|(nil) 3) subject1|kim|90|80|70|(nil)|(nil) 4) subject3|park|70|80|90|(nil)|60 # ------------------------------------------------------- # select * from hash.subject* order by science nulls last; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 3 OP_SorterNext, p1:1,p2:16,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:2,p2:7,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:1,p3:2,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:2,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:3,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:4,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:5,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:0,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:6,p3:8,p4type:NOTUSED # opcode:125 OP_SorterData, p1:1,p2:10,p3:2,p4type:NOTUSED # opcode: 35 OP_SorterSort, p1:1,p2:-5,p3:0,p4type:NOTUSED # opcode:114 OP_OpenPseudo, p1:2,p2:10,p3:9,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode:130 OP_SorterInsert, p1:1,p2:9,p3:1,p4type:INT32 # opcode: 91 OP_MakeRecord, p1:1,p2:7,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:1,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:6,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:2,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode:111 OP_SorterOpen, p1:1,p2:9,p3:0,p4type:KEYINFO # opcode: 62 OP_Init, p1:0,p2:27,p3:0,p4type:NOTUSED # sql:"select * from hash.subject* order by science nulls last;" -> 4 rows # used_memory:1558232, total_diff:24

LIMIT

select * from hash.myname* limit 3;

0) key|name|age|birthday|city|hobby 1) myname1|kim|25|1995-01-01|Seoul|(nil) 2) myname2|kang|30|1990-01-01|Daejeon|(nil) 3) myname3|park|20|2000-01-01|Seoul|ski,bike # ------------------------------------------------------- # select * from hash.myname* limit 3; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode: 59 OP_DecrJumpZero, p1:1,p2:-2,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:2,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:2,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 69 OP_Integer, p1:3,p2:1,p3:0,p4type:NOTUSED # opcode: 62 OP_Init, p1:0,p2:14,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* limit 3;" -> 3 rows # used_memory:1558664, total_diff:24

select * from hash.myname* order by name limit 3;

0) key|name|age|birthday|city|hobby 1) myname4|choe|30|1990-01-01|Daejeon|(nil) 2) myname2|kang|30|1990-01-01|Daejeon|(nil) 3) myname1|kim|25|1995-01-01|Seoul|(nil) # ------------------------------------------------------- # select * from hash.myname* order by name limit 3; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:1,p2:20,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:4,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:1,p2:2,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:1,p2:0,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:1,p2:3,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:1,p2:4,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:1,p2:5,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:1,p2:6,p3:9,p4type:NOTUSED # opcode: 36 OP_Sort, p1:1,p2:-5,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:5,p3:0,p4type:NOTUSED # opcode:131 OP_IdxInsert, p1:1,p2:10,p3:2,p4type:INT32 # opcode: 91 OP_MakeRecord, p1:2,p2:7,p3:10,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:4,p4type:NOTUSED # opcode:122 OP_Delete, p1:1,p2:0,p3:0,p4type:NOTUSED # opcode: 38 OP_IdxLE, p1:1,p2:-4,p3:2,p4type:INT32 # opcode: 33 OP_Last, p1:1,p2:0,p3:0,p4type:NOTUSED # opcode: 49 OP_IfNotZero, p1:1,p2:11,p3:0,p4type:NOTUSED # opcode:119 OP_Sequence, p1:1,p2:3,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:2,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 69 OP_Integer, p1:3,p2:1,p3:0,p4type:NOTUSED # opcode:100 OP_OpenEphemeral, p1:1,p2:8,p3:0,p4type:KEYINFO # opcode: 62 OP_Init, p1:0,p2:29,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* order by name limit 3;" -> 3 rows # used_memory:1559112, total_diff:24

select * from hash.myname* limit 3 offset 2;

0) key|name|age|birthday|city|hobby 1) myname3|park|20|2000-01-01|Seoul|ski,bike 2) myname4|choe|30|1990-01-01|Daejeon|(nil) 3) myname5|lee|35|1985-01-01|Busan|(nil) # ------------------------------------------------------- # select * from hash.myname* limit 3 offset 2; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:7,p3:0,p4type:NOTUSED # opcode: 59 OP_DecrJumpZero, p1:1,p2:-2,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:4,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:4,p4type:NOTUSED # opcode: 48 OP_IfPos, p1:2,p2:-4,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode:152 OP_OffsetLimit, p1:1,p2:3,p3:2,p4type:NOTUSED # opcode: 15 OP_MustBeInt, p1:2,p2:0,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:2,p2:2,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:3,p2:1,p3:0,p4type:NOTUSED # opcode: 62 OP_Init, p1:0,p2:18,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* limit 3 offset 2;" -> 3 rows # used_memory:1561120, total_diff:24

select * from hash.myname* limit 2, 3;

0) key|name|age|birthday|city|hobby 1) myname3|park|20|2000-01-01|Seoul|ski,bike 2) myname4|choe|30|1990-01-01|Daejeon|(nil) 3) myname5|lee|35|1985-01-01|Busan|(nil) # ------------------------------------------------------- # select * from hash.myname* limit 2, 3; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:7,p3:0,p4type:NOTUSED # opcode: 59 OP_DecrJumpZero, p1:1,p2:-2,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:4,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:4,p4type:NOTUSED # opcode: 48 OP_IfPos, p1:2,p2:-4,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode:152 OP_OffsetLimit, p1:1,p2:3,p3:2,p4type:NOTUSED # opcode: 15 OP_MustBeInt, p1:2,p2:0,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:2,p2:2,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:3,p2:1,p3:0,p4type:NOTUSED # opcode: 62 OP_Init, p1:0,p2:18,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* limit 2, 3;" -> 3 rows # used_memory:1561560, total_diff:24

FUNCTIONS

select count() from hash.myname;

0) count(*) 1) 5 # ------------------------------------------------------- # select count(*) from hash.myname*; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:2,p2:1,p3:0,p4type:NOTUSED # opcode: 77 OP_Copy, p1:1,p2:2,p3:0,p4type:NOTUSED # opcode:116 OP_Close, p1:1,p2:0,p3:0,p4type:NOTUSED # opcode: 92 OP_Count, p1:1,p2:1,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:1,p2:1,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:7,p3:0,p4type:NOTUSED # sql:"select count(*) from hash.myname*;" -> 1 rows # used_memory:1561992, total_diff:24

select max(name),max(age) from hash.myname*;

0) max(name)|max(age) 1) park|35 # ------------------------------------------------------- # select max(name),max(age) from hash.myname*; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:6,p2:2,p3:0,p4type:NOTUSED # opcode: 77 OP_Copy, p1:1,p2:6,p3:1,p4type:NOTUSED # opcode:157 OP_AggFinal, p1:2,p2:1,p3:0,p4type:FUNCDEF # opcode:157 OP_AggFinal, p1:1,p2:1,p3:0,p4type:FUNCDEF # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:5,p3:2,p4type:FUNCDEF # opcode: 81 OP_CollSeq, p1:0,p2:0,p3:0,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:2,p3:5,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:5,p3:1,p4type:FUNCDEF # opcode: 81 OP_CollSeq, p1:0,p2:0,p3:0,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:1,p3:5,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-4,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 72 OP_Null, p1:0,p2:1,p3:4,p4type:NOTUSED # opcode: 62 OP_Init, p1:0,p2:16,p3:0,p4type:NOTUSED # sql:"select max(name),max(age) from hash.myname*;" -> 1 rows # used_memory:1562432, total_diff:24

select min(name),min(age) from hash.myname*;

0) min(name)|min(age) 1) choe|20 # ------------------------------------------------------- # select min(name),min(age) from hash.myname*; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:6,p2:2,p3:0,p4type:NOTUSED # opcode: 77 OP_Copy, p1:1,p2:6,p3:1,p4type:NOTUSED # opcode:157 OP_AggFinal, p1:2,p2:1,p3:0,p4type:FUNCDEF # opcode:157 OP_AggFinal, p1:1,p2:1,p3:0,p4type:FUNCDEF # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:5,p3:2,p4type:FUNCDEF # opcode: 81 OP_CollSeq, p1:0,p2:0,p3:0,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:2,p3:5,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:5,p3:1,p4type:FUNCDEF # opcode: 81 OP_CollSeq, p1:0,p2:0,p3:0,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:1,p3:5,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-4,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 72 OP_Null, p1:0,p2:1,p3:4,p4type:NOTUSED # opcode: 62 OP_Init, p1:0,p2:16,p3:0,p4type:NOTUSED # sql:"select min(name),min(age) from hash.myname*;" -> 1 rows # used_memory:1562872, total_diff:24

select min(age),max(age) from hash.myname*;

0) min(age)|max(age) 1) 20|35 # ------------------------------------------------------- # select min(age),max(age) from hash.myname*; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:5,p2:2,p3:0,p4type:NOTUSED # opcode: 77 OP_Copy, p1:1,p2:5,p3:1,p4type:NOTUSED # opcode:157 OP_AggFinal, p1:2,p2:1,p3:0,p4type:FUNCDEF # opcode:157 OP_AggFinal, p1:1,p2:1,p3:0,p4type:FUNCDEF # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:4,p3:2,p4type:FUNCDEF # opcode: 81 OP_CollSeq, p1:0,p2:0,p3:0,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:2,p3:4,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:4,p3:1,p4type:FUNCDEF # opcode: 81 OP_CollSeq, p1:0,p2:0,p3:0,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:2,p3:4,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-4,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 72 OP_Null, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 62 OP_Init, p1:0,p2:16,p3:0,p4type:NOTUSED # sql:"select min(age),max(age) from hash.myname*;" -> 1 rows # used_memory:1563312, total_diff:24

select max(name), * from hash.myname*;

0) max(name)|key|name|age|birthday|city|hobby 1) park|myname3|park|20|2000-01-01|Seoul|ski,bike # ------------------------------------------------------- # select max(name), * from hash.myname*; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:10,p2:7,p3:0,p4type:NOTUSED # opcode: 77 OP_Copy, p1:1,p2:10,p3:6,p4type:NOTUSED # opcode:157 OP_AggFinal, p1:1,p2:1,p3:0,p4type:FUNCDEF # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:2,p4type:NOTUSED # opcode: 18 OP_If, p1:9,p2:14,p3:0,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:8,p3:1,p4type:FUNCDEF # opcode: 81 OP_CollSeq, p1:9,p2:0,p3:0,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:1,p3:8,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-4,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 72 OP_Null, p1:0,p2:1,p3:7,p4type:NOTUSED # opcode: 62 OP_Init, p1:0,p2:19,p3:0,p4type:NOTUSED # sql:"select max(name), * from hash.myname*;" -> 1 rows # used_memory:1563752, total_diff:24

SUM(),AVG()

select sum(kor),sum(eng) from hash.subject*;

0) sum(kor)|sum(eng) 1) 270|290 # ------------------------------------------------------- # select sum(kor),sum(eng) from hash.subject*; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:6,p2:2,p3:0,p4type:NOTUSED # opcode: 77 OP_Copy, p1:1,p2:6,p3:1,p4type:NOTUSED # opcode:157 OP_AggFinal, p1:2,p2:1,p3:0,p4type:FUNCDEF # opcode:157 OP_AggFinal, p1:1,p2:1,p3:0,p4type:FUNCDEF # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:5,p3:2,p4type:FUNCDEF # opcode: 89 OP_Column, p1:0,p2:3,p3:5,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:5,p3:1,p4type:FUNCDEF # opcode: 89 OP_Column, p1:0,p2:2,p3:5,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-4,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 72 OP_Null, p1:0,p2:1,p3:4,p4type:NOTUSED # opcode: 62 OP_Init, p1:0,p2:14,p3:0,p4type:NOTUSED # sql:"select sum(kor),sum(eng) from hash.subject*;" -> 1 rows # used_memory:1564192, total_diff:24

select avg(kor),avg(eng) from hash.subject*;

0) avg(kor)|avg(eng) 1) 67.5|72.5 # ------------------------------------------------------- # select avg(kor),avg(eng) from hash.subject*; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:6,p2:2,p3:0,p4type:NOTUSED # opcode: 77 OP_Copy, p1:1,p2:6,p3:1,p4type:NOTUSED # opcode:157 OP_AggFinal, p1:2,p2:1,p3:0,p4type:FUNCDEF # opcode:157 OP_AggFinal, p1:1,p2:1,p3:0,p4type:FUNCDEF # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:5,p3:2,p4type:FUNCDEF # opcode: 89 OP_Column, p1:0,p2:3,p3:5,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:5,p3:1,p4type:FUNCDEF # opcode: 89 OP_Column, p1:0,p2:2,p3:5,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-4,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 72 OP_Null, p1:0,p2:1,p3:4,p4type:NOTUSED # opcode: 62 OP_Init, p1:0,p2:14,p3:0,p4type:NOTUSED # sql:"select avg(kor),avg(eng) from hash.subject*;" -> 1 rows # used_memory:1564632, total_diff:24

select sum(history),avg(history),count() from hash.sub where history >= 0;

0) sum(history)|avg(history)|count(*) 1) 110|55.0|2 # ------------------------------------------------------- # select sum(history),avg(history),count(*) from hash.sub* where history >= 0; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:0,p2:6,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:7,p2:3,p3:0,p4type:NOTUSED # opcode: 77 OP_Copy, p1:1,p2:7,p3:2,p4type:NOTUSED # opcode:157 OP_AggFinal, p1:3,p2:0,p3:0,p4type:FUNCDEF # opcode:157 OP_AggFinal, p1:2,p2:1,p3:0,p4type:FUNCDEF # opcode:157 OP_AggFinal, p1:1,p2:1,p3:0,p4type:FUNCDEF # opcode: 5 OP_Next, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:0,p3:3,p4type:FUNCDEF # opcode:154 OP_AggStep, p1:0,p2:5,p3:2,p4type:FUNCDEF # opcode: 89 OP_Column, p1:0,p2:6,p3:5,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:5,p3:1,p4type:FUNCDEF # opcode: 89 OP_Column, p1:0,p2:6,p3:5,p4type:NOTUSED # opcode: 56 OP_Lt, p1:6,p2:-5,p3:5,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:6,p3:5,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-4,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 72 OP_Null, p1:0,p2:1,p3:4,p4type:NOTUSED # opcode: 62 OP_Init, p1:0,p2:18,p3:0,p4type:NOTUSED # sql:"select sum(history),avg(history),count(*) from hash.sub* where history >= 0;" -> 1 rows # used_memory:1565104, total_diff:24

WHERE

select * from hash.myname* where key >= 'myname3';

0) key|name|age|birthday|city|hobby 1) myname3|park|20|2000-01-01|Seoul|ski,bike 2) myname4|choe|30|1990-01-01|Daejeon|(nil) 3) myname5|lee|35|1985-01-01|Busan|(nil) # ------------------------------------------------------- # select * from hash.myname* where key >= 'myname3'; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:1,p2:5,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:2,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:1,p2:0,p3:2,p4type:NOTUSED # opcode:133 OP_DeferredSeek, p1:1,p2:0,p3:0,p4type:NOTUSED # opcode: 24 OP_SeekGE, p1:1,p2:-3,p3:1,p4type:INT32 # opcode:115 OP_String8, p1:0,p2:1,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 96 OP_OpenRead, p1:1,p2:1,p3:0,p4type:INDEX # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:15,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where key >= 'myname3';" -> 3 rows # used_memory:1565552, total_diff:24

select * from hash.myname* where key > 'myname3';

0) key|name|age|birthday|city|hobby 1) myname4|choe|30|1990-01-01|Daejeon|(nil) 2) myname5|lee|35|1985-01-01|Busan|(nil) # ------------------------------------------------------- # select * from hash.myname* where key > 'myname3'; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:1,p2:5,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:2,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:1,p2:0,p3:2,p4type:NOTUSED # opcode:133 OP_DeferredSeek, p1:1,p2:0,p3:0,p4type:NOTUSED # opcode: 25 OP_SeekGT, p1:1,p2:-3,p3:1,p4type:INT32 # opcode:115 OP_String8, p1:0,p2:1,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 96 OP_OpenRead, p1:1,p2:1,p3:0,p4type:INDEX # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:15,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where key > 'myname3';" -> 2 rows # used_memory:1566000, total_diff:24

select * from hash.myname* where age = 30;

0) key|name|age|birthday|city|hobby 1) myname2|kang|30|1990-01-01|Daejeon|(nil) 2) myname4|choe|30|1990-01-01|Daejeon|(nil) # ------------------------------------------------------- # select * from hash.myname* where age = 30; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:30,p2:2,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:3,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:3,p4type:NOTUSED # opcode: 52 OP_Ne, p1:2,p2:-4,p3:1,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:2,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:14,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where age = 30;" -> 2 rows # used_memory:1566440, total_diff:24

select * from hash.myname* where age >= 30;

0) key|name|age|birthday|city|hobby 1) myname2|kang|30|1990-01-01|Daejeon|(nil) 2) myname4|choe|30|1990-01-01|Daejeon|(nil) 3) myname5|lee|35|1985-01-01|Busan|(nil) # ------------------------------------------------------- # select * from hash.myname* where age >= 30; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:30,p2:2,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:3,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:3,p4type:NOTUSED # opcode: 56 OP_Lt, p1:2,p2:-4,p3:1,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:2,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:14,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where age >= 30;" -> 3 rows # used_memory:1566880, total_diff:24

select * from hash.myname* where age < 30;

select * from hash.myname* where age != 30;

0) key|name|age|birthday|city|hobby 1) myname1|kim|25|1995-01-01|Seoul|(nil) 2) myname3|park|20|2000-01-01|Seoul|ski,bike 3) myname5|lee|35|1985-01-01|Busan|(nil) # ------------------------------------------------------- # select * from hash.myname* where age != 30; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:30,p2:2,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:3,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:3,p4type:NOTUSED # opcode: 53 OP_Eq, p1:2,p2:-4,p3:1,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:2,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:14,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where age != 30;" -> 3 rows # used_memory:1567760, total_diff:24

select * from hash.myname* where age >= 25 and city = 'Seoul';

0) key|name|age|birthday|city|hobby 1) myname1|kim|25|1995-01-01|Seoul|(nil) # ------------------------------------------------------- # select * from hash.myname* where age >= 25 and city = 'Seoul'; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode:115 OP_String8, p1:0,p2:3,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 69 OP_Integer, p1:25,p2:2,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:4,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:4,p4type:NOTUSED # opcode: 52 OP_Ne, p1:3,p2:-4,p3:1,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:4,p3:1,p4type:NOTUSED # opcode: 56 OP_Lt, p1:2,p2:-4,p3:1,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:2,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:16,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where age >= 25 and city = 'Seoul';" -> 1 rows # used_memory:1568232, total_diff:24

select * from hash.myname* where age > 30 or city = 'Seoul';

0) key|name|age|birthday|city|hobby 1) myname1|kim|25|1995-01-01|Seoul|(nil) 2) myname3|park|20|2000-01-01|Seoul|ski,bike 3) myname5|lee|35|1985-01-01|Busan|(nil) # ------------------------------------------------------- # select * from hash.myname* where age > 30 or city = 'Seoul'; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode:115 OP_String8, p1:0,p2:3,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 69 OP_Integer, p1:30,p2:2,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:4,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:4,p4type:NOTUSED # opcode: 52 OP_Ne, p1:3,p2:-4,p3:1,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:4,p3:1,p4type:NOTUSED # opcode: 54 OP_Gt, p1:2,p2:-5,p3:1,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:2,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:16,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where age > 30 or city = 'Seoul';" -> 3 rows # used_memory:1568688, total_diff:24

BETWEEN

select * from hash.myname* where age between 25 and 30;

0) key|name|age|birthday|city|hobby 1) myname1|kim|25|1995-01-01|Seoul|(nil) 2) myname2|kang|30|1990-01-01|Daejeon|(nil) 3) myname4|choe|30|1990-01-01|Daejeon|(nil) # ------------------------------------------------------- # select * from hash.myname* where age between 25 and 30; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:30,p2:4,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:25,p2:3,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:5,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:10,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:5,p4type:NOTUSED # opcode: 54 OP_Gt, p1:4,p2:-4,p3:1,p4type:COLLSEQ # opcode: 56 OP_Lt, p1:3,p2:-4,p3:1,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:2,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:15,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where age between 25 and 30;" -> 3 rows # used_memory:1569144, total_diff:24

IS NULL, IS NOT NULL

select * from hash.subject* where science is null;

0) key|name|kor|eng|math|science|history 1) subject1|kim|90|80|70|(nil)|(nil) 2) subject3|park|70|80|90|(nil)|60 # ------------------------------------------------------- # select * from hash.subject* where science is null; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:2,p2:7,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:6,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:2,p4type:NOTUSED # opcode: 51 OP_NotNull, p1:1,p2:-4,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:15,p3:0,p4type:NOTUSED # sql:"select * from hash.subject* where science is null;" -> 2 rows # used_memory:1569592, total_diff:24

select * from hash.subject* where science is not null;

0) key|name|kor|eng|math|science|history 1) subject2|kang|80|90|60|70|(nil) 2) subject4|lee|30|40|40|40|50 # ------------------------------------------------------- # select * from hash.subject* where science is not null; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:2,p2:7,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:6,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:4,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:2,p4type:NOTUSED # opcode: 50 OP_IsNull, p1:1,p2:-4,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:15,p3:0,p4type:NOTUSED # sql:"select * from hash.subject* where science is not null;" -> 2 rows # used_memory:1570048, total_diff:24

GLOB

select * from hash.myname* where name glob 'k*';

0) key|name|age|birthday|city|hobby 1) myname1|kim|25|1995-01-01|Seoul|(nil) 2) myname2|kang|30|1990-01-01|Daejeon|(nil) # ------------------------------------------------------- # select * from hash.myname* where name glob 'k*'; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode:115 OP_String8, p1:0,p2:2,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:4,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:4,p4type:NOTUSED # opcode: 20 OP_IfNot, p1:1,p2:-4,p3:1,p4type:NOTUSED # opcode: 64 OP_Function, p1:1,p2:2,p3:1,p4type:FUNCCTX # opcode: 89 OP_Column, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:15,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where name glob 'k*';" -> 2 rows # used_memory:1570496, total_diff:24

select * from hash.myname* where birthday glob '19?5*';

0) key|name|age|birthday|city|hobby 1) myname1|kim|25|1995-01-01|Seoul|(nil) 2) myname5|lee|35|1985-01-01|Busan|(nil) # ------------------------------------------------------- # select * from hash.myname* where birthday glob '19?5*'; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode:115 OP_String8, p1:0,p2:2,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:4,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:4,p4type:NOTUSED # opcode: 20 OP_IfNot, p1:1,p2:-4,p3:1,p4type:NOTUSED # opcode: 64 OP_Function, p1:1,p2:2,p3:1,p4type:FUNCCTX # opcode: 89 OP_Column, p1:0,p2:3,p3:3,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:15,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where birthday glob '19?5*';" -> 2 rows # used_memory:1570952, total_diff:24

LIKE

select * from hash.myname* where name like 'K%';

0) key|name|age|birthday|city|hobby 1) myname1|kim|25|1995-01-01|Seoul|(nil) 2) myname2|kang|30|1990-01-01|Daejeon|(nil) # ------------------------------------------------------- # select * from hash.myname* where name like 'K%'; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode:115 OP_String8, p1:0,p2:2,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:4,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:4,p4type:NOTUSED # opcode: 20 OP_IfNot, p1:1,p2:-4,p3:1,p4type:NOTUSED # opcode: 64 OP_Function, p1:1,p2:2,p3:1,p4type:FUNCCTX # opcode: 89 OP_Column, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:15,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where name like 'K%';" -> 2 rows # used_memory:1571400, total_diff:24

select * from hash.myname* where birthday like '1990%';

0) key|name|age|birthday|city|hobby 1) myname2|kang|30|1990-01-01|Daejeon|(nil) 2) myname4|choe|30|1990-01-01|Daejeon|(nil) # ------------------------------------------------------- # select * from hash.myname* where birthday like '1990%'; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode:115 OP_String8, p1:0,p2:2,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:4,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:4,p4type:NOTUSED # opcode: 20 OP_IfNot, p1:1,p2:-4,p3:1,p4type:NOTUSED # opcode: 64 OP_Function, p1:1,p2:2,p3:1,p4type:FUNCCTX # opcode: 89 OP_Column, p1:0,p2:3,p3:3,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:15,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where birthday like '1990%';" -> 2 rows # used_memory:1571856, total_diff:24

IN

select * from hash.myname* where key in ('myname1','myname3');

0) key|name|age|birthday|city|hobby 1) myname1|kim|25|1995-01-01|Seoul|(nil) 2) myname3|park|20|2000-01-01|Seoul|ski,bike # ------------------------------------------------------- # select * from hash.myname* where key in ('myname1','myname3'); # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:2,p2:14,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:1,p2:19,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:6,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:11,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:10,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:1,p2:0,p3:6,p4type:NOTUSED # opcode:133 OP_DeferredSeek, p1:1,p2:0,p3:0,p4type:NOTUSED # opcode: 39 OP_IdxGT, p1:1,p2:-5,p3:1,p4type:INT32 # opcode: 24 OP_SeekGE, p1:1,p2:-5,p3:1,p4type:INT32 # opcode: 50 OP_IsNull, p1:2,p2:29,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:0,p3:2,p4type:NOTUSED # opcode: 50 OP_IsNull, p1:1,p2:29,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:0,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:2,p2:30,p3:0,p4type:NOTUSED # opcode: 65 OP_Return, p1:3,p2:0,p3:0,p4type:NOTUSED # opcode:131 OP_IdxInsert, p1:2,p2:5,p3:4,p4type:INT32 # opcode: 91 OP_MakeRecord, p1:4,p2:1,p3:5,p4type:FREE_IF_LE/DYNAMIC # opcode:115 OP_String8, p1:0,p2:4,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode:131 OP_IdxInsert, p1:2,p2:5,p3:4,p4type:INT32 # opcode: 91 OP_MakeRecord, p1:4,p2:1,p3:5,p4type:FREE_IF_LE/DYNAMIC # opcode:115 OP_String8, p1:0,p2:4,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode:100 OP_OpenEphemeral, p1:2,p2:1,p3:0,p4type:KEYINFO # opcode: 17 OP_Once, p1:0,p2:12,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:12,p2:3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:1,p2:1,p3:0,p4type:INDEX # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:31,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where key in ('myname1','myname3');" -> 2 rows # used_memory:1572328, total_diff:24

select * from hash.myname* where city in ('Seoul','Busan');

0) key|name|age|birthday|city|hobby 1) myname1|kim|25|1995-01-01|Seoul|(nil) 2) myname3|park|20|2000-01-01|Seoul|ski,bike 3) myname5|lee|35|1985-01-01|Busan|(nil) # ------------------------------------------------------- # select * from hash.myname* where city in ('Seoul','Busan'); # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode:115 OP_String8, p1:0,p2:3,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode:115 OP_String8, p1:0,p2:2,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:4,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:4,p4type:NOTUSED # opcode: 52 OP_Ne, p1:1,p2:-4,p3:3,p4type:COLLSEQ # opcode: 53 OP_Eq, p1:1,p2:-5,p3:2,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:4,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:15,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where city in ('Seoul','Busan');" -> 3 rows # used_memory:1572784, total_diff:24

select * from hash.myname* where age in (20,30);

0) key|name|age|birthday|city|hobby 1) myname2|kang|30|1990-01-01|Daejeon|(nil) 2) myname3|park|20|2000-01-01|Seoul|ski,bike 3) myname4|choe|30|1990-01-01|Daejeon|(nil) # ------------------------------------------------------- # select * from hash.myname* where age in (20,30); # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:30,p2:3,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:20,p2:2,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:4,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:5,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:4,p4type:NOTUSED # opcode: 52 OP_Ne, p1:1,p2:-4,p3:3,p4type:COLLSEQ # opcode: 53 OP_Eq, p1:1,p2:-5,p3:2,p4type:COLLSEQ # opcode: 89 OP_Column, p1:0,p2:2,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:15,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where age in (20,30);" -> 3 rows # used_memory:1573232, total_diff:24

NOT IN

select * from hash.myname* where key not in ('myname1','myname3');

0) key|name|age|birthday|city|hobby 1) myname2|kang|30|1990-01-01|Daejeon|(nil) 2) myname4|choe|30|1990-01-01|Daejeon|(nil) 3) myname5|lee|35|1985-01-01|Busan|(nil) # ------------------------------------------------------- # select * from hash.myname* where key not in ('myname1','myname3'); # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode:115 OP_String8, p1:0,p2:4,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode:115 OP_String8, p1:0,p2:3,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:5,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:10,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:5,p4type:NOTUSED # opcode: 11 OP_Goto, p1:0,p2:-4,p3:0,p4type:NOTUSED # opcode: 11 OP_Goto, p1:0,p2:-5,p3:0,p4type:NOTUSED # opcode: 50 OP_IsNull, p1:2,p2:-4,p3:0,p4type:NOTUSED # opcode: 53 OP_Eq, p1:1,p2:-6,p3:4,p4type:COLLSEQ # opcode: 53 OP_Eq, p1:1,p2:-6,p3:3,p4type:COLLSEQ # opcode:101 OP_BitAnd, p1:1,p2:1,p3:2,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:19,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where key not in ('myname1','myname3');" -> 3 rows # used_memory:1573704, total_diff:24

select * from hash.myname* where city not in ('Seoul','Busan');

0) key|name|age|birthday|city|hobby 1) myname2|kang|30|1990-01-01|Daejeon|(nil) 2) myname4|choe|30|1990-01-01|Daejeon|(nil) # ------------------------------------------------------- # select * from hash.myname* where city not in ('Seoul','Busan'); # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode:115 OP_String8, p1:0,p2:4,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode:115 OP_String8, p1:0,p2:3,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:5,p2:6,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:5,p3:10,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:9,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:3,p3:8,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:7,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:1,p3:6,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:0,p3:5,p4type:NOTUSED # opcode: 11 OP_Goto, p1:0,p2:-4,p3:0,p4type:NOTUSED # opcode: 11 OP_Goto, p1:0,p2:-5,p3:0,p4type:NOTUSED # opcode: 50 OP_IsNull, p1:2,p2:-4,p3:0,p4type:NOTUSED # opcode: 53 OP_Eq, p1:1,p2:-6,p3:4,p4type:COLLSEQ # opcode: 53 OP_Eq, p1:1,p2:-6,p3:3,p4type:COLLSEQ # opcode:101 OP_BitAnd, p1:1,p2:1,p3:2,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:1,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-3,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:19,p3:0,p4type:NOTUSED # sql:"select * from hash.myname* where city not in ('Seoul','Busan');" -> 2 rows # used_memory:1574176, total_diff:24

GROUP BY

select city,count() from hash.myname group by city;

0) city|count(*) 1) Busan|1 2) Daejeon|2 3) Seoul|2 # ------------------------------------------------------- # select city,count(*) from hash.myname* group by city; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 65 OP_Return, p1:6,p2:0,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:0,p2:3,p3:0,p4type:NOTUSED # opcode: 72 OP_Null, p1:0,p2:1,p3:2,p4type:NOTUSED # opcode: 65 OP_Return, p1:5,p2:0,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:11,p2:2,p3:0,p4type:NOTUSED # opcode: 77 OP_Copy, p1:1,p2:11,p3:1,p4type:NOTUSED # opcode:157 OP_AggFinal, p1:2,p2:0,p3:0,p4type:FUNCDEF # opcode: 65 OP_Return, p1:5,p2:0,p3:0,p4type:NOTUSED # opcode: 48 OP_IfPos, p1:3,p2:32,p3:0,p4type:NOTUSED # opcode: 65 OP_Return, p1:5,p2:0,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:1,p2:4,p3:0,p4type:NOTUSED # opcode: 11 OP_Goto, p1:0,p2:-2,p3:0,p4type:NOTUSED # opcode: 12 OP_Gosub, p1:5,p2:-3,p3:0,p4type:NOTUSED # opcode: 3 OP_SorterNext, p1:1,p2:13,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:1,p2:3,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:0,p3:1,p4type:NOTUSED # opcode: 18 OP_If, p1:3,p2:24,p3:0,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:0,p3:2,p4type:FUNCDEF # opcode: 12 OP_Gosub, p1:6,p2:-4,p3:0,p4type:NOTUSED # opcode: 48 OP_IfPos, p1:4,p2:-2,p3:0,p4type:NOTUSED # opcode: 12 OP_Gosub, p1:5,p2:-3,p3:0,p4type:NOTUSED # opcode: 76 OP_Move, p1:8,p2:7,p3:1,p4type:NOTUSED # opcode: 16 OP_Jump, p1:17,p2:21,p3:17,p4type:NOTUSED # opcode: 86 OP_Compare, p1:7,p2:8,p3:1,p4type:KEYINFO # opcode: 89 OP_Column, p1:2,p2:0,p3:8,p4type:NOTUSED # opcode:125 OP_SorterData, p1:1,p2:9,p3:2,p4type:NOTUSED # opcode: 35 OP_SorterSort, p1:1,p2:-2,p3:0,p4type:NOTUSED # opcode:114 OP_OpenPseudo, p1:2,p2:9,p3:1,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:7,p3:0,p4type:NOTUSED # opcode:130 OP_SorterInsert, p1:1,p2:10,p3:0,p4type:NOTUSED # opcode: 91 OP_MakeRecord, p1:9,p2:1,p3:10,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:9,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-6,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 12 OP_Gosub, p1:6,p2:-4,p3:0,p4type:NOTUSED # opcode: 72 OP_Null, p1:0,p2:7,p3:7,p4type:NOTUSED # opcode: 69 OP_Integer, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode:111 OP_SorterOpen, p1:1,p2:1,p3:0,p4type:KEYINFO # opcode: 62 OP_Init, p1:0,p2:40,p3:0,p4type:NOTUSED # sql:"select city,count(*) from hash.myname* group by city;" -> 3 rows # used_memory:1574632, total_diff:24

select city,min(age),max(age) from hash.myname* group by city;

0) city|min(age)|max(age) 1) Busan|35|35 2) Daejeon|30|30 3) Seoul|20|25 # ------------------------------------------------------- # select city,min(age),max(age) from hash.myname* group by city; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 65 OP_Return, p1:8,p2:0,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:0,p2:5,p3:0,p4type:NOTUSED # opcode: 72 OP_Null, p1:0,p2:1,p3:4,p4type:NOTUSED # opcode: 65 OP_Return, p1:7,p2:0,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:16,p2:3,p3:0,p4type:NOTUSED # opcode: 77 OP_Copy, p1:1,p2:16,p3:2,p4type:NOTUSED # opcode:157 OP_AggFinal, p1:3,p2:1,p3:0,p4type:FUNCDEF # opcode:157 OP_AggFinal, p1:2,p2:1,p3:0,p4type:FUNCDEF # opcode: 65 OP_Return, p1:7,p2:0,p3:0,p4type:NOTUSED # opcode: 48 OP_IfPos, p1:5,p2:38,p3:0,p4type:NOTUSED # opcode: 65 OP_Return, p1:7,p2:0,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:1,p2:6,p3:0,p4type:NOTUSED # opcode: 11 OP_Goto, p1:0,p2:-2,p3:0,p4type:NOTUSED # opcode: 12 OP_Gosub, p1:7,p2:-3,p3:0,p4type:NOTUSED # opcode: 3 OP_SorterNext, p1:1,p2:14,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:1,p2:5,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:0,p3:1,p4type:NOTUSED # opcode: 18 OP_If, p1:15,p2:30,p3:0,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:14,p3:3,p4type:FUNCDEF # opcode: 81 OP_CollSeq, p1:15,p2:0,p3:0,p4type:COLLSEQ # opcode: 89 OP_Column, p1:2,p2:1,p3:14,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:14,p3:2,p4type:FUNCDEF # opcode: 81 OP_CollSeq, p1:15,p2:0,p3:0,p4type:COLLSEQ # opcode: 89 OP_Column, p1:2,p2:1,p3:14,p4type:NOTUSED # opcode: 12 OP_Gosub, p1:8,p2:-4,p3:0,p4type:NOTUSED # opcode: 48 OP_IfPos, p1:6,p2:-2,p3:0,p4type:NOTUSED # opcode: 12 OP_Gosub, p1:7,p2:-3,p3:0,p4type:NOTUSED # opcode: 76 OP_Move, p1:10,p2:9,p3:1,p4type:NOTUSED # opcode: 16 OP_Jump, p1:18,p2:22,p3:18,p4type:NOTUSED # opcode: 86 OP_Compare, p1:9,p2:10,p3:1,p4type:KEYINFO # opcode: 89 OP_Column, p1:2,p2:0,p3:10,p4type:NOTUSED # opcode:125 OP_SorterData, p1:1,p2:13,p3:2,p4type:NOTUSED # opcode: 35 OP_SorterSort, p1:1,p2:-2,p3:0,p4type:NOTUSED # opcode:114 OP_OpenPseudo, p1:2,p2:13,p3:2,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:7,p3:0,p4type:NOTUSED # opcode:130 OP_SorterInsert, p1:1,p2:13,p3:0,p4type:NOTUSED # opcode: 91 OP_MakeRecord, p1:11,p2:2,p3:13,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:12,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:11,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-6,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 12 OP_Gosub, p1:8,p2:-4,p3:0,p4type:NOTUSED # opcode: 72 OP_Null, p1:0,p2:9,p3:9,p4type:NOTUSED # opcode: 69 OP_Integer, p1:0,p2:6,p3:0,p4type:NOTUSED # opcode:111 OP_SorterOpen, p1:1,p2:2,p3:0,p4type:KEYINFO # opcode: 62 OP_Init, p1:0,p2:47,p3:0,p4type:NOTUSED # sql:"select city,min(age),max(age) from hash.myname* group by city;" -> 3 rows # used_memory:1575104, total_diff:24

select city,sum(age) from hash.myname* group by city having sum(age) > 40;

0) city|sum(age) 1) Daejeon|60 2) Seoul|45 # ------------------------------------------------------- # select city,sum(age) from hash.myname* group by city having sum(age) > 40; # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:40,p2:14,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:0,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 65 OP_Return, p1:7,p2:0,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:0,p2:4,p3:0,p4type:NOTUSED # opcode: 72 OP_Null, p1:0,p2:1,p3:3,p4type:NOTUSED # opcode: 65 OP_Return, p1:6,p2:0,p3:0,p4type:NOTUSED # opcode: 80 OP_ResultRow, p1:15,p2:2,p3:0,p4type:NOTUSED # opcode: 77 OP_Copy, p1:1,p2:15,p3:1,p4type:NOTUSED # opcode: 55 OP_Le, p1:14,p2:33,p3:2,p4type:NOTUSED # opcode:157 OP_AggFinal, p1:2,p2:1,p3:0,p4type:FUNCDEF # opcode: 65 OP_Return, p1:6,p2:0,p3:0,p4type:NOTUSED # opcode: 48 OP_IfPos, p1:4,p2:34,p3:0,p4type:NOTUSED # opcode: 65 OP_Return, p1:6,p2:0,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:1,p2:5,p3:0,p4type:NOTUSED # opcode: 11 OP_Goto, p1:0,p2:-2,p3:0,p4type:NOTUSED # opcode: 12 OP_Gosub, p1:6,p2:-3,p3:0,p4type:NOTUSED # opcode: 3 OP_SorterNext, p1:1,p2:14,p3:0,p4type:NOTUSED # opcode: 69 OP_Integer, p1:1,p2:4,p3:0,p4type:NOTUSED # opcode: 89 OP_Column, p1:2,p2:0,p3:1,p4type:NOTUSED # opcode: 18 OP_If, p1:4,p2:26,p3:0,p4type:NOTUSED # opcode:154 OP_AggStep, p1:0,p2:13,p3:2,p4type:FUNCDEF # opcode: 89 OP_Column, p1:2,p2:1,p3:13,p4type:NOTUSED # opcode: 12 OP_Gosub, p1:7,p2:-4,p3:0,p4type:NOTUSED # opcode: 48 OP_IfPos, p1:5,p2:-2,p3:0,p4type:NOTUSED # opcode: 12 OP_Gosub, p1:6,p2:-3,p3:0,p4type:NOTUSED # opcode: 76 OP_Move, p1:9,p2:8,p3:1,p4type:NOTUSED # opcode: 16 OP_Jump, p1:18,p2:22,p3:18,p4type:NOTUSED # opcode: 86 OP_Compare, p1:8,p2:9,p3:1,p4type:KEYINFO # opcode: 89 OP_Column, p1:2,p2:0,p3:9,p4type:NOTUSED # opcode:125 OP_SorterData, p1:1,p2:12,p3:2,p4type:NOTUSED # opcode: 35 OP_SorterSort, p1:1,p2:-2,p3:0,p4type:NOTUSED # opcode:114 OP_OpenPseudo, p1:2,p2:12,p3:2,p4type:NOTUSED # opcode: 5 OP_Next, p1:0,p2:7,p3:0,p4type:NOTUSED # opcode:130 OP_SorterInsert, p1:1,p2:12,p3:0,p4type:NOTUSED # opcode: 91 OP_MakeRecord, p1:10,p2:2,p3:12,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:2,p3:11,p4type:NOTUSED # opcode: 89 OP_Column, p1:0,p2:4,p3:10,p4type:NOTUSED # opcode: 37 OP_Rewind, p1:0,p2:-6,p3:0,p4type:NOTUSED # opcode: 96 OP_OpenRead, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 12 OP_Gosub, p1:7,p2:-4,p3:0,p4type:NOTUSED # opcode: 72 OP_Null, p1:0,p2:8,p3:8,p4type:NOTUSED # opcode: 69 OP_Integer, p1:0,p2:5,p3:0,p4type:NOTUSED # opcode:111 OP_SorterOpen, p1:1,p2:2,p3:0,p4type:KEYINFO # opcode: 62 OP_Init, p1:0,p2:43,p3:0,p4type:NOTUSED # sql:"select city,sum(age) from hash.myname* group by city having sum(age) > 40;" -> 2 rows # used_memory:1575576, total_diff:24

<< Select ZSet	Select Hash	Select Stream >>

Email 답글이 올라오면 이메일로 알려드리겠습니다.