RhinoTrac
LassoSoft Ticket Tracking System
NOTE: If you are using Lasso Server 9.3 please Log your ticket directly via the LUX admin as this will give us more information about your issue.
Lasso 9 Issues
Ticket #7411: Odd result from query expression on nested data using multiple "with" statements
- Reported by:
- Brad Lindsay
- Date:
- 06 Jun, 2012
- Priority:
- minor
- Component:
- Lasso 9
- Version:
- 9.2
- Keywords:
- Platform:
On May 7, 2012, at 3:46 PM, Brad Lindsay wrote:
I was reading through the query expression guide and discovered that I should be able to use multiple "with" statements for nested data. Giving it a try, but I'm seeing unexpected behavior.
Mac OS X 10.8
Lasso 9 rev 2816
So, is my expectation off-base, or have I stumbled upon a bug?
It's a known issue. Sorry about that.
It has bugged me several times.
-Kyle
Please log in to your LassoSoft account to comment
I was reading through the query expression guide and discovered that I should be able to use multiple "with" statements for nested data. Giving it a try, but I'm seeing unexpected behavior.
// Example
with x in (:(:1,2,3),(:4,5,6),(:7,8,9)), y in #x select #y
// Result
2, 2, 2, 5, 5, 5, 8, 8, 8
// What I Expected
1, 2, 3, 4, 5, 6, 7, 8, 9
with x in (:(:1,2,3),(:4,5,6),(:7,8,9)), y in #x select #y
// Result
2, 2, 2, 5, 5, 5, 8, 8, 8
// What I Expected
1, 2, 3, 4, 5, 6, 7, 8, 9
Mac OS X 10.8
Lasso 9 rev 2816
So, is my expectation off-base, or have I stumbled upon a bug?
It's a known issue. Sorry about that.
It has bugged me several times.
-Kyle
