0
Fixed

Errors when creating model from sql (redshift)

Tech secure Moveon 6 months ago updated by Rafał Strzaliński (Senior Engineer) 6 months ago 7

All sql I've tried to use results in the same error:

VARCHAR[null]ERROR: Error while parsing data type parameter.

This has happened on very simple create table statements as well as more complex versions. 

Example sql 

CREATE TABLE addresses (
address_id bigint NOT NULL ,
address_line_1 varchar(250) NOT NULL
);

Error message:

ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]ERROR: Error while parsing data type parameter: VARCHAR[null]

GOOD, I'M SATISFIED
Satisfaction mark by Tech secure Moveon 6 months ago
-1
Fixed

Hi,

It is fixed now. Sorry for any inconvenience.

I'm still getting errors. How is this fixed?

Started

Thanks for the report. It looks like its  a related to your session or misbehaving node. We look at it.

Hello- do you have any updates?

I tried to create a model from sql today and have found I am able to do so twice per browser before the 'create model' button becomes is grayed out and varchar[NULL] errors start. Unfortunately, my successful attempts were simple tests and not the full set of tables. Clearing cookies did not help.


Hi,

We're working on it.   There was a bug in  the parser.  It is fixed and waits for QA for acceptance.  The fix will be available for your you next week.