greptimedb/tests/cases/standalone/common/select/projection_names.result

-- Migrated from DuckDB test: test/sql/select/test_projection_names.test
-- Description: Test projection lists
-- Note: Adapted for GreptimeDB - testing column selection and naming
CREATE TABLE integers(COL1 INTEGER, COL2 INTEGER, ts TIMESTAMP TIME INDEX);

Affected Rows: 0

INSERT INTO integers VALUES (1, 10, 1000), (2, 20, 2000);

Affected Rows: 2

-- Test 1: SELECT * projection
SELECT * FROM integers ORDER BY ts;

+------+------+---------------------+
| col1 | col2 | ts                  |
+------+------+---------------------+
| 1    | 10   | 1970-01-01T00:00:01 |
| 2    | 20   | 1970-01-01T00:00:02 |
+------+------+---------------------+

-- Test 2: Explicit column projection
SELECT COL1, COL2 FROM integers ORDER BY COL1;

+------+------+
| col1 | col2 |
+------+------+
| 1    | 10   |
| 2    | 20   |
+------+------+

-- Test 3: Table-qualified column reference
SELECT integers.COL1, integers.COL2 FROM integers ORDER BY COL1;

+------+------+
| col1 | col2 |
+------+------+
| 1    | 10   |
| 2    | 20   |
+------+------+

-- Test 4: Column alias
SELECT COL1 as c1, COL2 as c2 FROM integers ORDER BY c1;

+----+----+
| c1 | c2 |
+----+----+
| 1  | 10 |
| 2  | 20 |
+----+----+

-- Test 5: Mixed qualified and unqualified references
SELECT integers.COL1, COL2 FROM integers ORDER BY COL1;

+------+------+
| col1 | col2 |
+------+------+
| 1    | 10   |
| 2    | 20   |
+------+------+

-- Clean up
DROP TABLE integers;

Affected Rows: 0