# Test STORAGE_FORMAT tuple
---
- CreateTable: t1 (id INT PRIMARY KEY NOT NULL, s VARCHAR(16)) STORAGE_FORMAT tuple
---
- Statement: INSERT INTO t1 VALUES(1,'Fred'),(2,'Wilma'),(3,'Pebbles'),(4,'Dino')
---
- Statement: SELECT * FROM t1
- output: [[1,'Fred'],[2,'Wilma'],[3,'Pebbles'],[4,'Dino']]
---
- Statement: CREATE INDEX t1_s ON t1(s) STORAGE_FORMAT tuple
---
- Statement: ALTER TABLE t1 ALL UPDATE STATISTICS
---
- Statement: SELECT * FROM t1
- output: [[4,'Dino'],[1,'Fred'],[3,'Pebbles'],[2,'Wilma']]
---
- Statement: SELECT * FROM t1 WHERE s >= 'M'
- output: [[3,'Pebbles'],[2,'Wilma']]
---
- Statement: SELECT * FROM t1 WHERE s >= 'M' ORDER BY s DESC
- output: [[2,'Wilma'],[3,'Pebbles']]
...
# Test STORAGE_FORMAT tuple
---
- CreateTable: t1 (id INT PRIMARY KEY NOT NULL, s VARCHAR(16)) STORAGE_FORMAT tuple
---
- Statement: INSERT INTO t1 VALUES(1,'Fred'),(2,'Wilma'),(3,'Pebbles'),(4,'Dino')
---
- Statement: SELECT * FROM t1
- output: [[1,'Fred'],[2,'Wilma'],[3,'Pebbles'],[4,'Dino']]
---
- Statement: CREATE INDEX t1_s ON t1(s) STORAGE_FORMAT tuple
---
- Statement: ALTER TABLE t1 ALL UPDATE STATISTICS
---
- Statement: SELECT * FROM t1
- output: [[4,'Dino'],[1,'Fred'],[3,'Pebbles'],[2,'Wilma']]
---
- Statement: SELECT * FROM t1 WHERE s >= 'M'
- output: [[3,'Pebbles'],[2,'Wilma']]
---
- Statement: SELECT * FROM t1 WHERE s >= 'M' ORDER BY s DESC
- output: [[2,'Wilma'],[3,'Pebbles']]
---
- Statement: SELECT * FROM t1 WHERE id = 2
- output: [[2,'Wilma']]
...
Add a test demonstrating the problem.
Add a test demonstrating the problem.
