mirror of
https://github.com/RGBCube/serenity
synced 2025-05-14 11:14:58 +00:00
f3a9d61891
These files contain the same SQL statements as the similarly named tests in Tests/LibSQL/TestSqlStatementExecution.cpp test suite. They can be fed to the sql utility to assist in troubleshooting failing tests.
26 lines
616 B
SQL
26 lines
616 B
SQL
CREATE SCHEMA TestSchema;
|
|
CREATE TABLE TestSchema.TestTable1
|
|
(
|
|
TextColumn1 text,
|
|
IntColumn integer
|
|
);
|
|
CREATE TABLE TestSchema.TestTable2
|
|
(
|
|
TextColumn2 text,
|
|
IntColumn integer
|
|
);
|
|
INSERT INTO TestSchema.TestTable1 (TextColumn1, IntColumn)
|
|
VALUES ('Test_1', 42),
|
|
('Test_3', 44),
|
|
('Test_2', 43),
|
|
('Test_4', 45),
|
|
('Test_5', 46);
|
|
INSERT INTO TestSchema.TestTable2 (TextColumn2, IntColumn)
|
|
VALUES ('Test_10', 40),
|
|
('Test_11', 41),
|
|
('Test_12', 42),
|
|
('Test_13', 47),
|
|
('Test_14', 48);
|
|
SELECT *
|
|
FROM TestSchema.TestTable1,
|
|
TestSchema.TestTable2;
|