Skip to content

Instantly share code, notes, and snippets.

@rkitover
Created March 2, 2012 18:26
Show Gist options
  • Save rkitover/1960208 to your computer and use it in GitHub Desktop.
Save rkitover/1960208 to your computer and use it in GitHub Desktop.
rkitover@eeebox ~/src/dbic patchsets/ribas_cherry % prove -wl t/746mssql.t
DBIx::Class::ResultSet::all(): DBI Exception: DBD::ODBC::st execute failed: [Microsoft][SQL Server Native Client 10.0]COUNT field incorrect or syntax error (SQL-07002) [for Statement "SELECT me.id, me.name, books.id, books.source, books.owner, books.title, books.price FROM (SELECT TOP 3 id, name, ORDER__BY__1 AS name + ? FROM ( SELECT TOP 3 me.id, me.name, name + ? AS ORDER__BY__1 FROM owners me LEFT JOIN books books ON books.owner = me.id WHERE ( ( books.id IS NOT NULL AND me.name != ? ) ) GROUP BY me.id, me.name ORDER BY name + ? ASC, me.id ) me ORDER BY ORDER__BY__1 ASC, me.id) me LEFT JOIN books books ON books.owner = me.id WHERE ( ( books.id IS NOT NULL AND me.name != ? ) ) ORDER BY name + ? ASC, me.id, books.owner" with ParamValues: 1='x.x.x.', 2='s.o.m.e.b.o.g.u.s.s.t.r.i.n.g.', 3='x.x.x.', 4='s.o.m.e.b.o.g.u.s.s.t.r.i.n.g.', 5='x.x.x.', 6=undef] at t/746mssql.t line 409
# Tests were run but no plan was declared and done_testing() was not seen.
t/746mssql.t ..
Dubious, test returned 255 (wstat 65280, 0xff00)
All 28 subtests passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment