KSQL doesn't support Avro schema with non-ascii characters in column name

[oisene]

Table created in Oracle:

create table ksql_test(id number(38,0), foo_key varchar2(200), fooå varchar2(200));

Note the last character in the last column name. The JDBC connector is configured using AVRO. When running this statement in KSQL:

create stream ksql_test with(kafka_topic='ora_KSQL_TEST',value_format='AVRO',key='FOO_KEY');

KSQL returns with:

io.confluent.ksql.parser.exception.ParseFailedException: line 2:21: extraneous input 'Å' expecting {'ADD'...

Same thing with create table. This however returns without error:

create stream ksql_test (id int, foo_key varchar) with(kafka_topic='ora_KSQL_TEST',value_format='AVRO',key='FOO_KEY');

I'm testing this with: CLI v5.0.0, Server v5.0.0

[apurvam]

thanks for reporting @oisene . Maybe related #1293

cc @big-andy-coates . This may be one to add to the quoted identifiers uber issue.