Build fails about sqlpp11 HOT 5 CLOSED

Ooops, sorry and thanks for letting me know!

Pushed new release (and tested with a freshly cloned repository).

On 2014-07-28 17:09, matthijs wrote:

Hello Roland,

I tried to build the tests but they fail with the following error:

-- The C compiler identification is GNU 4.9.1
-- The CXX compiler identification is GNU 4.9.1
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Using /usr/bin/c++ (compiler id: GNU)
-- Configuring done
CMake Error at tests/CMakeLists.txt:5 (add_executable):
Cannot find source file:

ResultTest.cpp

Tried extensions .c .C .c++ .cc .cpp .cxx .m .M .mm .h .hh .h++ .hm .hpp
.hxx .in .txx
Call Stack (most recent call first):
tests/CMakeLists.txt:18 (build_and_run)

-- Build files have been written to: /home/matthijs/sqlpp11/build

Regards, Matthijs

—
Reply to this email directly or view it on GitHub
#7.

from sqlpp11.

Ok, that fixed it, thanks.

I do however have another question, I have the following query:

auto qry = select(nf.id, nf.url, st_nf.stock_id)
    .from(nf.join(st_nf).on(nf.id == st_nf.newsfeed_id))
    //  .where(true);
    .where(nf.id == 24);
for(const auto &row: db.run(qry)) {
    std::cout << row.id << ": " << row.url << std::endl;
}

That one worked with the previous version but now it fails to compile. I can create a testcase if you want.

Regards, Matthijs

from sqlpp11.

Hi Matthijs,

I think I found the problem. I committed two changes in develop that
should make it compile again (159b4c7 and 4be53d9).

Some background: The library is now calculating for each result field
and for sub selects whether or not it can be NULL (this can have
influence on the interface of result fields, depending on the
connector). The calculation is done by

• a recursively track anything in an expression that can be NULL by
  definition (e.g. a table column that can be null)
• checking if a column depends on a table which is in an outer join

Your example encountered two problems:

1. The calculation of the intersect of required tables by an expression
   and the tables provided by an outer join was incorrect
2. The calculation should have yielded a bool, but yielded a size_t

Both should be solved by the aforementioned commits.

If your code should still fail to compile, please send me a test case.

Cheers,

Roland

from sqlpp11.

Hi Roland,

I was already writing a testcase but you fixed it and added a testcase for it. Thanks!

I was hit by the second problem, that it yielded a size_t instead of a bool.

I will close this ticket.

Regards, Matthijs

from sqlpp11.

On 2014-07-29 09:18, matthijs wrote:

I was already writing a testcase but you fixed it and added a testcase
for it. Thanks!

Actually, you did the heavy lifting by finding and reporting the problem :-)

from sqlpp11.