Re: TCs updated

Hi Juan, Eric, all

AFAIK "||" follows the SQL standard … however, I can be wrong, since I don't have access to that standard ….

I have updated the TCs [1], and created a snapshot of the DM TCs [2]

Thanks

Boris


[1] http://www.w3.org/2001/sw/rdb2rdf/test-cases/
[2] http://www.w3.org/2001/sw/rdb2rdf/wiki/DM_TC

On Feb 28, 2012, at 7:12 AM, Juan Sequeda wrote:

> 
> 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
>