[ic] Userdb is View of Union - query / scan problems

[Paul Jordan]

> From: peter at pajamian.dhs.org
> To: interchange-users at icdevgroup.org
> Subject: Re: [ic] Userdb is View of Union - query / scan problems
>
> On 08/12/10 08:17, Paul Jordan wrote:
> >
> > IC 5.7.6
> > Mysql 5.0.77
> >
> > I have a userdb that is a Mysql View of a Union. The union ties together
> > TableA and TableB.
> >
> > Using the [Query] and [search-region] I can only retrieve records from
> > this userdb that are from the TableA member of the Union.
> >
> > However, in Admin, I can see all records in userdb (TableA's and
> > tableB's) just fine, and I believe it uses scan to search this.
> >
> > Is there something fundamentally different with [query] that would make
> > it have trouble working on a Union? I don't need to do anything fancy, I
> > really just select a value.
> >
> > No errors in Cat or Vend error.log
>
> What happens if you run the same queries on the view in the mysql shell?

 
 
Peter, the same query runs fine in Mysql Workbench (administration software from Mysql) -  which I assume is just like shell? I am not very good at mysql shell, but I'll try to figure it out so we can test that.
 
Paul