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

bug(source): source does not insert bigint #7446

Closed
kwannoel opened this issue Jan 17, 2023 · 1 comment · Fixed by #7447
Closed

bug(source): source does not insert bigint #7446

kwannoel opened this issue Jan 17, 2023 · 1 comment · Fixed by #7447
Assignees
Labels
help wanted Issues that need help from contributors priority/high type/bug Something isn't working

Comments

@kwannoel
Copy link
Contributor

kwannoel commented Jan 17, 2023

Describe the bug

bigint from source just results in a list of null values.

CREATE MATERIALIZED VIEW dwd_ethereum_erc20_transfer AS SELECT
"sysTimestamp" as sys_timestamp
FROM eth_erc20_event_source;
flush;
CREATE_SOURCE
CREATE_MATERIALIZED_VIEW
FLUSH
dev=> select * from dwd_ethereum_erc20_transfer limit 10;
 sys_timestamp
---------------
(0 rows)

dev=> select * from dwd_ethereum_erc20_transfer limit 10;
 sys_timestamp
---------------
(0 rows)

dev=>
dev=> flush;
FLUSH
dev=> select * from dwd_ethereum_erc20_transfer limit 10;
 sys_timestamp
---------------










(10 rows)

To Reproduce

Used the following branch to stub source values: #7445.

stub json payload:

{"sysTimestamp": 1673000000}
CREATE SOURCE eth_erc20_event_source (
"sysTimestamp" bigint
) with (...) ROW FORMAT JSON;

CREATE MATERIALIZED VIEW dwd_ethereum_erc20_transfer AS SELECT
"sysTimestamp" as sys_timestamp
FROM eth_erc20_event_source;

flush;
select * from dwd_ethereum_erc20_transfer limit 10;

Expected behavior

actual value to be inserted.

Additional context

No response

@kwannoel kwannoel added type/bug Something isn't working priority/high labels Jan 17, 2023
@github-actions github-actions bot added this to the release-0.1.16 milestone Jan 17, 2023
@kwannoel kwannoel added the help wanted Issues that need help from contributors label Jan 17, 2023
@kwannoel kwannoel self-assigned this Jan 17, 2023
@kwannoel
Copy link
Contributor Author

We should have some fuzzing for various source formats, previously mentioned by @neverchanje in #5164. Or test indirectly through benchmark for source also works.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Issues that need help from contributors priority/high type/bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant