Skip to content

Latest commit

 

History

History
 
 

cockroach

Folders and files

NameName
Last commit message
Last commit date

parent directory

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

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".)