10 lines
160 B
SQL
10 lines
160 B
SQL
CREATE TABLE t0(
|
|
c0 REAL,
|
|
c1 REAL GENERATED ALWAYS AS (c0)
|
|
);
|
|
|
|
INSERT INTO t0(c0) VALUES (1);
|
|
|
|
SELECT * FROM t0 GROUP BY c0;
|
|
|
|
INSERT INTO t0 DEFAULT VALUES; |