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

Need a better error when accidentally using double quotes in INSERT INTO #4663

Closed
cjmatta opened this issue Feb 27, 2020 · 1 comment
Closed

Comments

@cjmatta
Copy link

cjmatta commented Feb 27, 2020

Is your feature request related to a problem? Please describe.
Trying to insert records into a stream:
create stream testregexp (id bigint, desc varchar) with (kafka_topic='testregexp', value_format='avro');

ksql> insert into testregexp (ROWKEY, ID, DESC) values ("1", 1, "Cut Cat Cot");
Failed to prepare statement: null

Describe the solution you'd like
Either accept the above input, or provide a helpful error like "Please use single quotes for strings when using INSERT INTO"

@agavra
Copy link
Contributor

agavra commented Apr 6, 2020

@cjmatta what version are you using? I can no longer reproduce this on the latest ksqlDB (0.8.1):

ksql> INSERT INTO TEST (rowkey, val) values (1, "foo");
Failed to insert values into 'TEST'. Code generation failed for insert value: Cannot find the select field in the available fields. field: `foo`, schema: [`VAL` STRING]. expression:foo, schema:`ROWKEY` INTEGER KEY, `VAL` STRING

I believe this may have already been fixed by #4926. Feel free to reopen this ticket if it was not fixed.

@agavra agavra closed this as completed Apr 6, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants