Re: TCs updated

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


> 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

Received on Tuesday, 28 February 2012 04:08:52 UTC