kaltura / dwh

1 stars 3 forks source link

Incorrect INSERT on kalturadw_ds.parameters creation #11

Closed DBezemer closed 8 years ago

DBezemer commented 10 years ago

https://github.com/kaltura/dwh/blob/master/ddl/ds/parameters.sql

the second INSERT doesnt specify a proces_id where as the table has a requirement that proces_id is NOT NULL. Without a default value for proces_id this fails.

Also I think this could all be merged in one query, that correct contain INSERT INTO