modules/sql-engine/src/integrationTest/sql/group1/insert/test_insert.test

# name: test/sql/insert/test_insert.test
# description: Test insert into and updates of constant values
# group: [insert]

statement ok
CREATE TABLE integers(i INTEGER)

statement ok
INSERT INTO integers VALUES (1), (2), (3), (4), (5)

# insert a constant 1 for every uneven value in "integers"
statement ok
CREATE TABLE i2(i INTEGER)

statement ok
INSERT INTO i2 SELECT 1 AS i FROM integers WHERE i % 2 <> 0

query I
SELECT * FROM i2 ORDER BY 1
----
1
1
1

# now update the table with a constant
statement ok
UPDATE i2 SET i=NULL

query I
SELECT * FROM i2 ORDER BY 1
----
NULL
NULL
NULL

# Test insert with long string constant
# found by Pedro Holanda
statement ok
CREATE TABLE IF NOT EXISTS presentations(presentation_date Date NOT NULL, author VARCHAR NOT NULL, title VARCHAR NOT NULL, bio VARCHAR, abstract VARCHAR, zoom_link VARCHAR);

statement ok
insert into presentations values (date '2020-05-29', 'Eduardo Pena', 'Analytical Query Processing Based on Continuous Compression of Intermediates', NULL, 'Modern in-memory column-stores are widely accepted as the adequate database architecture for the efficient processing of complex analytical queries over large relational data volumes. These systems keep their entire data in main memory and typically employ lightweight compression to address the bottleneck between main memory and CPU. Numerous lightweight compression algorithms have been proposed in the past years, but none of them is suitable in all cases. While lightweight compression is already well established for base data, the efficient representation of intermediate results generated during query processing has attracted insufficient attention so far, although in in-memory systems, accessing intermeFdiates is as expensive as accessing base data. Thus, our vision is a continuous use of lightweight compression for all intermediates in a query execution plan, whereby a suitable compression algorithm should be selected for each intermediate. In this talk, I will provide an overview of our research in the context of this vision, including an experimental survey of lightweight compression algorithms, our compression-enabled processing model, and our compression-aware query optimization strategies.', 'https://zoom.us/j/7845983526');