Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BREAKING] Implicit cast rules for integer literals, and parameterized ANY for binding #10194

Merged
merged 14 commits into from
Jan 10, 2024
Merged
Prev Previous commit
Next Next commit
Test fixes
  • Loading branch information
Mytherin committed Jan 9, 2024
commit d756f7df313ee184610c96e9f6ffd4cc2ec489ee
2 changes: 1 addition & 1 deletion test/sql/storage/test_large_parquet_storage.test_slow
Original file line number Diff line number Diff line change
Expand Up @@ -7,7 +7,7 @@ require parquet
require 64bit

statement ok
COPY (SELECT ((i::UBIGINT*129371982737)%2478526729)::BIGINT a, ((i::UBIGINT*12937198273679)%2478527)::BIGINT::VARCHAR b FROM range(150000000) t(i)) TO '__TEST_DIR__/big.parquet' (FORMAT PARQUET, COMPRESSION UNCOMPRESSED);
COPY (SELECT ((i::DOUBLE*129371982737)%2478526729)::BIGINT a, ((i::DOUBLE*12937198273679)%2478527)::BIGINT::VARCHAR b FROM range(150000000) t(i)) TO '__TEST_DIR__/big.parquet' (FORMAT PARQUET, COMPRESSION UNCOMPRESSED);

query I
SELECT COUNT(*) FROM '__TEST_DIR__/big.parquet'
Expand Down
Original file line number Diff line number Diff line change
Expand Up @@ -64,7 +64,7 @@ SELECT COUNT(*), SUM(i), MIN(i), MAX(i) FROM integers

# 732K..910K - delete every 3 entries but based on the hash to make it more random
query I
DELETE FROM integers WHERE hash(i)%3=0 AND i>=721377 AND i<909999
DELETE FROM integers WHERE hash(i)::DOUBLE%3=0 AND i>=721377 AND i<909999
----
62853

Expand All @@ -75,7 +75,7 @@ SELECT COUNT(*), SUM(i), MIN(i), MAX(i) FROM integers

# 732K..910K - delete every 2 entries but based on the hash to make it more random
query I
DELETE FROM integers WHERE hash(i)%2=0 AND i>=909999
DELETE FROM integers WHERE hash(i)::DOUBLE%2=0 AND i>=909999
----
89983

Expand Down
2 changes: 1 addition & 1 deletion test/sql/storage_version/generate_storage_version.sql
Original file line number Diff line number Diff line change
Expand Up @@ -82,7 +82,7 @@ FROM
integral_values;
CREATE VIEW test3.v2 AS
SELECT
(i + 2) * 3
((i + 2) * 3)::INT
FROM
integral_values;
-- bigger tables
Expand Down
Binary file modified test/sql/storage_version/storage_version.db
Binary file not shown.