Re: TCs updated

On Mon, Feb 27, 2012 at 10:08 PM, Eric Prud'hommeaux <eric@w3.org> wrote:

> * Juan Sequeda <juanfederico@gmail.com> [2012-02-27 21:35-0600]
> > Boris,
> >
> > I understand that the SQL that is being used in the test cases
> corresponds
> > to the standard sql. However, I'm currently testing with MSSQL and some
> > things don't run out of the box. For example, boolean is not a datatype
> in
> > MSSQL. The operator "||" is not concat, it's "+". And I can't contact a
>
> iirc, "||" is an oracle idiom.
> does concat("a", "b") work in MSSQL? can we just use that?
>

ugh. No. Well... concat() just showed up in SQL Server 2012.

I guess we can talk over this tomorrow to see if it's worth having
vendor-specific r2rml files when it comes to using rr:sqlQuery


>
> > string with an int. I need to cast it. I haven't tried with other RDBMS
> yet
> > (I will this week), so I'm not sure if issues like this are going to show
> > up.
> >
> > Is there a way to add vendor specific r2rml files for mappings that
> include
> > rr:sqlQuery. Or should everybody testing on different vendors need to do
> > create vendor-specific r2rml files themselves.
> >
> > Juan Sequeda
> > +1-575-SEQ-UEDA
> > www.juansequeda.com
> >
> >
> > On Mon, Feb 27, 2012 at 7:53 PM, Boris Villazon-Terrazas <
> > bvillazon@fi.upm.es> wrote:
> >
> > > Hi all
> > >
> > > This week I've included a new DirectGraph/R2RML TCs:
> > >
> > > - Eric's I18NnoSpecialChars DirectGraph
> > > - Richard suggestions about data errors (sent by email)
> > > - Juan: char vs. varchar (thanks for checking the TCs)
> > >
> > > The updated TCs are available at [1]
> > >
> > > The snapshot of the current status (R2RML TCs), that includes the
> > > information of simple and not simple TCs is available here [2]
> > > Tomorrow I'll send the snapshot of the DM TCs.
> > >
> > > I've also updated the Submitting_Test_Results wiki page [3] (thanks
> > > Tthibodeau and Nuno for your contributions).
> > >
> > > Thanks
> > >
> > > Boris
> > >
> > > [1] http://www.w3.org/2001/sw/rdb2rdf/test-cases/
> > > [2] http://www.w3.org/2001/sw/rdb2rdf/wiki/R2RML_TC
> > > [3] http://www.w3.org/2001/sw/rdb2rdf/wiki/Submitting_Test_Results
> > >
>
> --
> -ericP
>