45 lines
703 B
Text
45 lines
703 B
Text
statement ok
|
|
CREATE TABLE kanto.myschema.mytable (a BIGINT NOT NULL, b BIGINT, PRIMARY KEY(a));
|
|
|
|
statement ok
|
|
INSERT INTO kanto.myschema.mytable (a, b) VALUES (42, 7), (13, 34);
|
|
|
|
statement ok
|
|
INSERT INTO kanto.myschema.mytable (b, a) VALUES (9, 15);
|
|
|
|
query II
|
|
SELECT * FROM kanto.myschema.mytable ORDER BY a;
|
|
----
|
|
13 34
|
|
15 9
|
|
42 7
|
|
|
|
query II
|
|
SELECT a, b FROM kanto.myschema.mytable ORDER BY a;
|
|
----
|
|
13 34
|
|
15 9
|
|
42 7
|
|
|
|
query II
|
|
SELECT a, b FROM kanto.myschema.mytable ORDER BY b;
|
|
----
|
|
42 7
|
|
15 9
|
|
13 34
|
|
|
|
query II
|
|
SELECT b, a FROM kanto.myschema.mytable ORDER BY b;
|
|
----
|
|
7 42
|
|
9 15
|
|
34 13
|
|
|
|
hash-threshold 100
|
|
|
|
query III
|
|
SELECT b, b AS b2, b AS b3 FROM kanto.myschema.mytable ORDER BY b;
|
|
----
|
|
7 7 7
|
|
9 9 9
|
|
34 34 34
|