• Sign In
  1. Messages

more hard tables / studydata

LabKey Support Forum (Inactive)

View Message

view list print
more hard tables / studydata Ben Bimber  2010-10-14 11:03
Status: Closed
 
one of our pages runs executeSql() study data. this statement:

"SELECT DISTINCT s.Id FROM study.studydata s WHERE s.LSID IN ('urn:lsid:primate.wisc.edu:Study.Data-108:1047.2.0100922E7.r95061.34f573ec-17a0-102e-8c2a-9926f351b9ae')"

throws this error:

ERROR: UNION types text and integer cannot be matched Position: 1458

seems like it might be related to the other studyData bug i posted earlier?
 
 
marki responded:  2010-10-14 11:12
Yes, this is almost certainly the same problem. The studydata table in 10.3 is now a union of hard tables rather than a physical table.

The query you sent last time is the one that is causing the problem.

I don't have your data & I know that Michael wanted to try & repro with the same data. Alternately we could try to isolate the problem in the query you sent last time by sending portions of the UNION clause to postgres directly.