Error when updating the foreign key for table \"public\".\"jbid_io_attr\", err: ERROR #22P02 invalid input syntax for type bigint: \"\"

[faisaltheparttimecoder]

Error when updating the foreign key for table \"public\".\"jbid_io_attr\", err: ERROR #22P02 invalid input syntax for type bigint: \"\"

[faisaltheparttimecoder]

Yup mock-data would not have added any rows on the table jbid_attr_bin_value

 CREATE TABLE public.jbid_attr_bin_value (
    bin_value_id bigint NOT NULL,
    value oid
  );

since it contains a column oid that we don't support. You should have received a warning like this

https://github.com/pivotal-gss/mock-data/blob/master/worker.go#L183

on the screen, that we skipped the table. I believe we should support it since its a postgres inbuilt datatype, will add this to the list

[faisaltheparttimecoder]

Fixed added support for OID, will be available on the next release

[janpio]

Following through the code, it seems that whichRow is empty here:
https://github.com/pivotal-gss/mock-data/blob/ac23cf13044b2d697a9fa411cc6c18132c6002db/sql.go#L545

whichRow is filled via v.Row:
https://github.com/pivotal-gss/mock-data/blob/ac23cf13044b2d697a9fa411cc6c18132c6002db/constraintsRestore.go#L120-L122

How it should be filled in the function I unfortunately do not understand:
https://github.com/pivotal-gss/mock-data/blob/ac23cf13044b2d697a9fa411cc6c18132c6002db/sql.go#L516-L533

Any pointers?

[janpio]

Indeed:

...
time="2020-03-08 23:52:56" level=debug msg="Table \"public\".\"jbid_attr_bin_value\" skipped, since the column value, had unknown data type oid: unsupported datatypes found: oid" file="worker.go:138"
...
time="2020-03-08 23:53:01" level=debug msg="Table \"public\".\"jbid_creden_bin_value\" skipped, since the column value, had unknown data type oid: unsupported datatypes found: oid" file="worker.go:138"
...

With the many tables, and verbose output, it was super easy to miss.