neilzhu 6dd8e59864 first commit 1 month ago
..
README.md 6dd8e59864 first commit 1 month ago
aggregate.slt 6dd8e59864 first commit 1 month ago
alias_types.slt 6dd8e59864 first commit 1 month ago
alter_column_type.slt 6dd8e59864 first commit 1 month ago
alter_table.slt 6dd8e59864 first commit 1 month ago
apply_join.slt 6dd8e59864 first commit 1 month ago
array.slt 6dd8e59864 first commit 1 month ago
as_of.slt 6dd8e59864 first commit 1 month ago
bit.slt 6dd8e59864 first commit 1 month ago
builtin_function.slt 6dd8e59864 first commit 1 month ago
bytes.slt 6dd8e59864 first commit 1 month ago
case_sensitive_names.slt 6dd8e59864 first commit 1 month ago
collatedstring.slt 6dd8e59864 first commit 1 month ago
collatedstring_constraint.slt 6dd8e59864 first commit 1 month ago
collatedstring_index1.slt 6dd8e59864 first commit 1 month ago
collatedstring_index2.slt 6dd8e59864 first commit 1 month ago
collatedstring_normalization.slt 6dd8e59864 first commit 1 month ago
collatedstring_nullinindex.slt 6dd8e59864 first commit 1 month ago
collatedstring_uniqueindex1.slt 6dd8e59864 first commit 1 month ago
collatedstring_uniqueindex2.slt 6dd8e59864 first commit 1 month ago
computed.slt 6dd8e59864 first commit 1 month ago
conditional.slt 6dd8e59864 first commit 1 month ago
create_as.slt 6dd8e59864 first commit 1 month ago
custom_escape_character.slt 6dd8e59864 first commit 1 month ago
database.slt 6dd8e59864 first commit 1 month ago
datetime.slt 6dd8e59864 first commit 1 month ago
decimal.slt 6dd8e59864 first commit 1 month ago
delete.slt 6dd8e59864 first commit 1 month ago
discard.slt 6dd8e59864 first commit 1 month ago
distinct_on.slt 6dd8e59864 first commit 1 month ago
drop_database.slt 6dd8e59864 first commit 1 month ago
drop_table.slt 6dd8e59864 first commit 1 month ago
drop_user.slt 6dd8e59864 first commit 1 month ago
drop_view.slt 6dd8e59864 first commit 1 month ago
errors.slt 6dd8e59864 first commit 1 month ago
exec_hash_join.slt 6dd8e59864 first commit 1 month ago
exec_merge_join.slt 6dd8e59864 first commit 1 month ago
exec_window.slt 6dd8e59864 first commit 1 month ago
extract.slt 6dd8e59864 first commit 1 month ago
float.slt 6dd8e59864 first commit 1 month ago
inet.slt 6dd8e59864 first commit 1 month ago
information_schema.slt 6dd8e59864 first commit 1 month ago
insert.slt 6dd8e59864 first commit 1 month ago
int_size.slt 6dd8e59864 first commit 1 month ago
join.slt 6dd8e59864 first commit 1 month ago
json.slt 6dd8e59864 first commit 1 month ago
json_builtins.slt 6dd8e59864 first commit 1 month ago
like.slt 6dd8e59864 first commit 1 month ago
limit.slt 6dd8e59864 first commit 1 month ago
lookup_join.slt 6dd8e59864 first commit 1 month ago
namespace.slt 6dd8e59864 first commit 1 month ago
no_primary_key.slt 6dd8e59864 first commit 1 month ago
order_by.slt 6dd8e59864 first commit 1 month ago
ordinal_references.slt 6dd8e59864 first commit 1 month ago
ordinality.slt 6dd8e59864 first commit 1 month ago
orms-opt.slt 6dd8e59864 first commit 1 month ago
orms.slt 6dd8e59864 first commit 1 month ago
pg_catalog.slt 6dd8e59864 first commit 1 month ago
pgoidtype.slt 6dd8e59864 first commit 1 month ago
postgres_jsonb.slt 6dd8e59864 first commit 1 month ago
postgresjoin.slt 6dd8e59864 first commit 1 month ago
prepare.slt 6dd8e59864 first commit 1 month ago
rename_column.slt 6dd8e59864 first commit 1 month ago
rename_constraint.slt 6dd8e59864 first commit 1 month ago
rename_database.slt 6dd8e59864 first commit 1 month ago
rename_table.slt 6dd8e59864 first commit 1 month ago
rename_view.slt 6dd8e59864 first commit 1 month ago
returning.slt 6dd8e59864 first commit 1 month ago
rows_from.slt 6dd8e59864 first commit 1 month ago
scale.slt 6dd8e59864 first commit 1 month ago
select.slt 6dd8e59864 first commit 1 month ago
select_index.slt 6dd8e59864 first commit 1 month ago
select_index_flags.slt 6dd8e59864 first commit 1 month ago
select_index_span_ranges.slt 6dd8e59864 first commit 1 month ago
select_search_path.slt 6dd8e59864 first commit 1 month ago
select_table_alias.slt 6dd8e59864 first commit 1 month ago
shift.slt 6dd8e59864 first commit 1 month ago
sqlsmith.slt 6dd8e59864 first commit 1 month ago
srfs.slt 6dd8e59864 first commit 1 month ago
statement_source.slt 6dd8e59864 first commit 1 month ago
suboperators.slt 6dd8e59864 first commit 1 month ago
subquery-opt.slt 6dd8e59864 first commit 1 month ago
subquery.slt 6dd8e59864 first commit 1 month ago
subquery_correlated.slt 6dd8e59864 first commit 1 month ago
table.slt 6dd8e59864 first commit 1 month ago
target_names.slt 6dd8e59864 first commit 1 month ago
time.slt 6dd8e59864 first commit 1 month ago
timestamp.slt 6dd8e59864 first commit 1 month ago
truncate.slt 6dd8e59864 first commit 1 month ago
tuple.slt 6dd8e59864 first commit 1 month ago
typing.slt 6dd8e59864 first commit 1 month ago
union-opt.slt 6dd8e59864 first commit 1 month ago
union.slt 6dd8e59864 first commit 1 month ago
update.slt 6dd8e59864 first commit 1 month ago
upsert.slt 6dd8e59864 first commit 1 month ago
uuid.slt 6dd8e59864 first commit 1 month ago
values.slt 6dd8e59864 first commit 1 month ago
views.slt 6dd8e59864 first commit 1 month ago
where.slt 6dd8e59864 first commit 1 month ago
window.slt 6dd8e59864 first commit 1 month ago
with.slt 6dd8e59864 first commit 1 month ago
zero.slt 6dd8e59864 first commit 1 month ago

README.md

Cockroach SQL Logic Tests

These tests are derived from CockroachDB's in-house SQL logic tests. The tests use an extended version of the "sqllogictest" format. The only documentation for these extensions is CockroachDB's in-house sqllogictest runner.

Many CockroachDB tests are not applicable to Materialize. Tests that exercise CockroachDB internal concepts, like "ranges" and "zones", have been deleted outright. Tests that exercise features that we may support someday, like collations, have been retained, but the files are skipped with an unconditional halt directive at the top.

Legal details

The test files were retrieved on June 10, 2019 from:

https://github.com/cockroachdb/cockroach/tree/d2f7fbf5dd1fc1a099bbad790a2e1f7c60a66cc3/pkg/sql/logictest/testdata/logic_test

Please note that this commit was carefully chosen to precede Cockroach Labs's decision to relicense CockroachDB under the Business Source License (BSL). (For more details about the BSL, see the blog post, "Why We're Relicensing CockroachDB".)