0
Fixed

Errors when creating model from sql (redshift)

Tech secure Moveon 12 місяців тому оновлено Rafał Strzaliński (Senior Engineer) 12 місяців тому 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]

ДОБРЕ, Я ЗАДОВОЛЕНИЙ
Позначка задоволеності від Tech secure Moveon 12 місяців тому
Started

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

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.