DB into() does not compile for more than 20 members in a tuple

[stephb9959]

Compiling on OS/X Everything is fine. This project has been working for months.

Here is some code that will not compile:

std::string St1{"select * from users where email=?"};
typedef Poco::Tuple<    int, int , int, int , int , int, int , int , int , int , int , int ,
                    int, int , int, int , int , int, int , int , int , int , int , int > RInfo;
std::vector<RInfo> Records;
            
Statement << St1 ,
                Poco::Data::Keywords::into(Records),
                Poco::Data::Keywords::use(email);
 Statement.execute();

This code breaks as soon as you get to 21 entries in your tuple. It only breaks in into(). The rest of the code compiles where we use up to 29 entries in our tuple. I have not been able to find a limit in the documentation

If this is a limit, are there plans on removing it? Is there another way to achieve what we need to achieve?

Thanks

[stephb9959]

After looking at the code, TypeHandler is the issue. It only accepts up to 20 entries. Even though Tuple<> accepts up to 40 entries, Typehandler<> will not. This is in 10.1.

Any ideas on how to circumvent this issue?

Thanks

[bas524]

Workaround for you is declare custom TypeHandler in your code

namespace Poco {
namespace Data {
template <class T0, class T1, class T2, class T3, class T4, class T5, class T6,
          class T7, class T8, class T9, class T10, class T11, class T12,
          class T13, class T14, class T15, class T16, class T17, class T18,
          class T19, class T20, class T21, class T22, class T23>
class TypeHandler<
    Poco::Tuple<T0, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14,
                T15, T16, T17, T18, T19, T20, T21, T22, T23>> {
public:
  using TupleConstRef = typename Poco::TypeWrapper<Poco::Tuple<
      T0, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16,
      T17, T18, T19, T20, T21, T22, T23>>::CONSTREFTYPE;
  using TupleRef = typename Poco::TypeWrapper<
      Poco::Tuple<T0, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13,
                  T14, T15, T16, T17, T18, T19, T20, T21, T22, T23>>::REFTYPE;

  static void bind(std::size_t pos, TupleConstRef tuple,
                   AbstractBinder::Ptr pBinder, AbstractBinder::Direction dir) {
    poco_assert_dbg(!pBinder.isNull());
    tupleBind<TupleConstRef, T0, 0>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T1, 1>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T2, 2>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T3, 3>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T4, 4>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T5, 5>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T6, 6>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T7, 7>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T8, 8>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T9, 9>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T10, 10>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T11, 11>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T12, 12>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T13, 13>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T14, 14>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T15, 15>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T16, 16>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T17, 17>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T18, 18>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T19, 19>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T20, 20>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T21, 21>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T22, 22>(pos, tuple, pBinder, dir);
    tupleBind<TupleConstRef, T23, 23>(pos, tuple, pBinder, dir);
  }

  static void prepare(std::size_t pos, TupleConstRef tuple,
                      AbstractPreparator::Ptr pPreparator) {
    poco_assert_dbg(!pPreparator.isNull());
    tuplePrepare<TupleConstRef, T0, 0>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T1, 1>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T2, 2>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T3, 3>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T4, 4>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T5, 5>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T6, 6>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T7, 7>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T8, 8>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T9, 9>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T10, 10>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T11, 11>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T12, 12>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T13, 13>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T14, 14>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T15, 15>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T16, 16>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T17, 17>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T18, 18>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T19, 19>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T20, 20>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T21, 21>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T22, 22>(pos, tuple, pPreparator);
    tuplePrepare<TupleConstRef, T23, 23>(pos, tuple, pPreparator);
  }

  static std::size_t size() {
    return TypeHandler<T0>::size() + TypeHandler<T1>::size() +
           TypeHandler<T2>::size() + TypeHandler<T3>::size() +
           TypeHandler<T4>::size() + TypeHandler<T5>::size() +
           TypeHandler<T6>::size() + TypeHandler<T7>::size() +
           TypeHandler<T8>::size() + TypeHandler<T9>::size() +
           TypeHandler<T10>::size() + TypeHandler<T11>::size() +
           TypeHandler<T12>::size() + TypeHandler<T13>::size() +
           TypeHandler<T14>::size() + TypeHandler<T15>::size() +
           TypeHandler<T16>::size() + TypeHandler<T17>::size() +
           TypeHandler<T18>::size() + TypeHandler<T19>::size() +
           TypeHandler<T20>::size() + TypeHandler<T21>::size() +
           TypeHandler<T22>::size() + TypeHandler<T23>::size();
  }

  static void extract(std::size_t pos, TupleRef tuple, TupleConstRef defVal,
                      AbstractExtractor::Ptr pExt) {
    poco_assert_dbg(!pExt.isNull());
    tupleExtract<TupleRef, TupleConstRef, T0, 0>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T1, 1>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T2, 2>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T3, 3>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T4, 4>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T5, 5>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T6, 6>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T7, 7>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T8, 8>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T9, 9>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T10, 10>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T11, 11>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T12, 12>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T13, 13>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T14, 14>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T15, 15>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T16, 16>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T17, 17>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T18, 18>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T19, 19>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T20, 20>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T21, 21>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T22, 22>(pos, tuple, defVal, pExt);
    tupleExtract<TupleRef, TupleConstRef, T23, 23>(pos, tuple, defVal, pExt);
  }

private:
  TypeHandler(const TypeHandler &);
  TypeHandler &operator=(const TypeHandler &);
};
} // namespace Data
} // namespace Poco

[stephb9959]

Thanks Alexander. I actually created a modified file that supports everything up to 40, so it matches the definition for a tuple. I would like to contribute that back into the project.

…

On Fri, Aug 20, 2021 at 7:07 AM Alexander B ***@***.***> wrote: Workaround for you is declare custom TypeHandler in your code namespace Poco {namespace Data {template <class T0, class T1, class T2, class T3, class T4, class T5, class T6, class T7, class T8, class T9, class T10, class T11, class T12, class T13, class T14, class T15, class T16, class T17, class T18, class T19, class T20, class T21, class T22, class T23>class TypeHandler< Poco::Tuple<T0, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22, T23>> {public: using TupleConstRef = typename Poco::TypeWrapper<Poco::Tuple< T0, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22, T23>>::CONSTREFTYPE; using TupleRef = typename Poco::TypeWrapper< Poco::Tuple<T0, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22, T23>>::REFTYPE; static void bind(std::size_t pos, TupleConstRef tuple, AbstractBinder::Ptr pBinder, AbstractBinder::Direction dir) { poco_assert_dbg(!pBinder.isNull()); tupleBind<TupleConstRef, T0, 0>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T1, 1>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T2, 2>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T3, 3>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T4, 4>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T5, 5>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T6, 6>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T7, 7>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T8, 8>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T9, 9>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T10, 10>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T11, 11>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T12, 12>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T13, 13>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T14, 14>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T15, 15>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T16, 16>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T17, 17>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T18, 18>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T19, 19>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T20, 20>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T21, 21>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T22, 22>(pos, tuple, pBinder, dir); tupleBind<TupleConstRef, T23, 23>(pos, tuple, pBinder, dir); } static void prepare(std::size_t pos, TupleConstRef tuple, AbstractPreparator::Ptr pPreparator) { poco_assert_dbg(!pPreparator.isNull()); tuplePrepare<TupleConstRef, T0, 0>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T1, 1>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T2, 2>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T3, 3>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T4, 4>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T5, 5>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T6, 6>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T7, 7>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T8, 8>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T9, 9>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T10, 10>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T11, 11>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T12, 12>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T13, 13>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T14, 14>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T15, 15>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T16, 16>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T17, 17>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T18, 18>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T19, 19>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T20, 20>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T21, 21>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T22, 22>(pos, tuple, pPreparator); tuplePrepare<TupleConstRef, T23, 23>(pos, tuple, pPreparator); } static std::size_t size() { return TypeHandler<T0>::size() + TypeHandler<T1>::size() + TypeHandler<T2>::size() + TypeHandler<T3>::size() + TypeHandler<T4>::size() + TypeHandler<T5>::size() + TypeHandler<T6>::size() + TypeHandler<T7>::size() + TypeHandler<T8>::size() + TypeHandler<T9>::size() + TypeHandler<T10>::size() + TypeHandler<T11>::size() + TypeHandler<T12>::size() + TypeHandler<T13>::size() + TypeHandler<T14>::size() + TypeHandler<T15>::size() + TypeHandler<T16>::size() + TypeHandler<T17>::size() + TypeHandler<T18>::size() + TypeHandler<T19>::size() + TypeHandler<T20>::size() + TypeHandler<T21>::size() + TypeHandler<T22>::size() + TypeHandler<T23>::size(); } static void extract(std::size_t pos, TupleRef tuple, TupleConstRef defVal, AbstractExtractor::Ptr pExt) { poco_assert_dbg(!pExt.isNull()); tupleExtract<TupleRef, TupleConstRef, T0, 0>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T1, 1>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T2, 2>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T3, 3>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T4, 4>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T5, 5>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T6, 6>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T7, 7>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T8, 8>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T9, 9>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T10, 10>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T11, 11>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T12, 12>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T13, 13>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T14, 14>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T15, 15>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T16, 16>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T17, 17>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T18, 18>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T19, 19>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T20, 20>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T21, 21>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T22, 22>(pos, tuple, defVal, pExt); tupleExtract<TupleRef, TupleConstRef, T23, 23>(pos, tuple, defVal, pExt); } private: TypeHandler(const TypeHandler &); TypeHandler &operator=(const TypeHandler &); }; } // namespace Data } // namespace Poco — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#3342 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAOF7REK6FYVZGKSOOKJVEDT5ZOQHANCNFSM477PU43Q> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&utm_campaign=notification-email> .

-- Stéphane Bourque