[teiid-issues] [JBoss JIRA] (TEIID-4992) Add OSDQ set functions

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13476057#comment-13476057 ] 

Steven Hawkins commented on TEIID-4992:
---------------------------------------

I think we need a formal definition of what is expected.

Using the example from before:

String[] first = new String[]{"vivek16","abcd","vivek44", "x", "xx"};
String[] second = new String[]{"vivek36","vivekkk","abcd","vivek445", "x"};

If we do something like:

{code}
      for (float f : Arrays.asList(0.0f, 1f, 1.1f)) {
            System.out.println(Arrays.toString(intersectionFuzzy(first,second,f)));
            System.out.println(Arrays.toString(intersectionFuzzy(second,first,f)));
            System.out.println(Arrays.toString(minusFuzzy(first,second,f)));
            System.out.println(Arrays.toString(minusFuzzy(second,first,f)));
            System.out.println(Arrays.toString(unionFuzzy(first,second,f)));
            System.out.println(Arrays.toString(unionFuzzy(second,first,f)));
      }
{code}

We see the output:

{code}
[abcd, x, xx]
[abcd, vivekkk, x]
[]
[]
[abcd]
[abcd]
[abcd, xx]
[abcd, x]
[vivek16, vivek44]
[vivek36, vivek445, vivekkk]
[abcd, vivek16, vivek36, vivek44, vivek445, vivekkk, x]
[abcd, vivek16, vivek36, vivek44, vivek445, vivekkk, x]
[abcd, x]
[abcd, x]
[vivek16, vivek44, xx]
[vivek36, vivek445, vivekkk]
[abcd, vivek16, vivek36, vivek44, vivek445, vivekkk, x, xx]
[abcd, vivek16, vivek36, vivek44, vivek445, vivekkk, x, xx]
{code}

Some things that may need clarifying are:

intersectionFuzzy(first,second,0.0f) - does not contain any vivek entry, but it does when the arguments are reversed.
intersectionFuzzy(first,second,0.0f) - with the arguments in either order contain more results than the similar unionFuzzy

intersectionFuzzy(first,second,1.0f) - has asymmetric results depending on the order of the inputs

> Add OSDQ set functions
> ----------------------
>
>                 Key: TEIID-4992
>                 URL: https://issues.jboss.org/browse/TEIID-4992
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 10.0
>
>         Attachments: SetUtil.java
>
>
> There will be a new osdq core library drop in maven central soon containing additional functions for Teiid to add.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)