Community
Participate
Working Groups
Validation prevents get from a result set into list of primitive scalars with following validation message: Description Resource Path Location Type IWN.VAL.8518.e 41/8 The with clause is required when the action target is a list of expressions that map to columns of zero or multiple tables in a data base. GetFromRSntoScalarsValidationError.egl /test.edt.sql.test/EGLSource/sql/test/defects line 41 EDT Problem With get from rs, the with clause is specified on the open, not the get. I am not sure why the check is needed even for get from ds. It's just as easy to code an incorrect primitive into list with a with clause as without one.
Created attachment 206070 [details] library for loading database for test program
Created attachment 206071 [details] Test case
Tim, can you verify that what Paul says is true? This check was made based on a conversation we had a few weeks ago. The update to the spec can be seen in bug 360021 comment 14: "For GET statements: If the targets are primitives mapping to columns and they do not all map to a single table, then the WITH clause is required."
When the from is an SQLResultSet the scalars don't need to map to a table because we don't need to create SQL, the rs already contains the data.
Moving old fixed bugs from the RESOLVED state to CLOSED.
