Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

All SQL-related tests fail when tarantool < 2.0.0 is used #194

Closed
ylobankov opened this issue Nov 11, 2021 · 0 comments · Fixed by #195
Closed

All SQL-related tests fail when tarantool < 2.0.0 is used #194

ylobankov opened this issue Nov 11, 2021 · 0 comments · Fixed by #195
Assignees
@ylobankov
Labels
bug Something isn't working

Comments

@ylobankov
Copy link
Contributor

Tarantool version: 1.10.11.36.g3993bd37b-1

All SQL-related tests fail with the following error:

======================================================================
ERROR: test_dml_response (suites.test_execute.TestSuite_Execute)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/runner/work/tarantool/tarantool/test/suites/test_execute.py", line 59, in test_dml_response
    response = self._create_table(table_name)
  File "/home/runner/work/tarantool/tarantool/test/suites/test_execute.py", line 55, in _create_table
    return self.con.execute(self.ddl % table_name)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

======================================================================
ERROR: test_dql_response (suites.test_execute.TestSuite_Execute)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/runner/work/tarantool/tarantool/test/suites/test_execute.py", line 80, in test_dql_response
    self._create_table(table_name)
  File "/home/runner/work/tarantool/tarantool/test/suites/test_execute.py", line 55, in _create_table
    return self.con.execute(self.ddl % table_name)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

======================================================================
ERROR: test_None (suites.test_dbapi.TestSuite_DBAPI)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 784, in test_None
    self.executeDDL2(cur)
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 77, in executeDDL2
    cursor.execute(self.ddl2)
  File "/home/runner/work/tarantool/tarantool/tarantool/dbapi.py", line 64, in execute
    response = self._c.execute(query, params)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

======================================================================
ERROR: test_cursor_isolation (suites.test_dbapi.TestSuite_DBAPI)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 233, in test_cursor_isolation
    self.executeDDL1(cur1)
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 74, in executeDDL1
    cursor.execute(self.ddl1)
  File "/home/runner/work/tarantool/tarantool/tarantool/dbapi.py", line 64, in execute
    response = self._c.execute(query, params)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

======================================================================
ERROR: test_execute (suites.test_dbapi.TestSuite_DBAPI)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 353, in test_execute
    self._paraminsert(cur)
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 358, in _paraminsert
    self.executeDDL2(cur)
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 77, in executeDDL2
    cursor.execute(self.ddl2)
  File "/home/runner/work/tarantool/tarantool/tarantool/dbapi.py", line 64, in execute
    response = self._c.execute(query, params)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

======================================================================
ERROR: test_executemany (suites.test_dbapi.TestSuite_DBAPI)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 419, in test_executemany
    self.executeDDL1(cur)
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 74, in executeDDL1
    cursor.execute(self.ddl1)
  File "/home/runner/work/tarantool/tarantool/tarantool/dbapi.py", line 64, in execute
    response = self._c.execute(query, params)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

======================================================================
ERROR: test_fetchall (suites.test_dbapi.TestSuite_DBAPI)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 620, in test_fetchall
    self.executeDDL1(cur)
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 74, in executeDDL1
    cursor.execute(self.ddl1)
  File "/home/runner/work/tarantool/tarantool/tarantool/dbapi.py", line 64, in execute
    response = self._c.execute(query, params)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

======================================================================
ERROR: test_fetchmany (suites.test_dbapi.TestSuite_DBAPI)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 538, in test_fetchmany
    self.executeDDL1(cur)
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 74, in executeDDL1
    cursor.execute(self.ddl1)
  File "/home/runner/work/tarantool/tarantool/tarantool/dbapi.py", line 64, in execute
    response = self._c.execute(query, params)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

======================================================================
ERROR: test_fetchone (suites.test_dbapi.TestSuite_DBAPI)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 478, in test_fetchone
    self.executeDDL1(cur)
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 74, in executeDDL1
    cursor.execute(self.ddl1)
  File "/home/runner/work/tarantool/tarantool/tarantool/dbapi.py", line 64, in execute
    response = self._c.execute(query, params)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

======================================================================
ERROR: test_mixedfetch (suites.test_dbapi.TestSuite_DBAPI)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 664, in test_mixedfetch
    self.executeDDL1(cur)
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 74, in executeDDL1
    cursor.execute(self.ddl1)
  File "/home/runner/work/tarantool/tarantool/tarantool/dbapi.py", line 64, in execute
    response = self._c.execute(query, params)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

======================================================================
ERROR: test_rowcount (suites.test_dbapi.TestSuite_DBAPI)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/runner/work/tarantool/tarantool/test/suites/test_dbapi.py", line 57, in test_rowcount
    self.executeDDL1(cur)
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 74, in executeDDL1
    cursor.execute(self.ddl1)
  File "/home/runner/work/tarantool/tarantool/tarantool/dbapi.py", line 64, in execute
    response = self._c.execute(query, params)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

======================================================================
ERROR: test_setinputsizes (suites.test_dbapi.TestSuite_DBAPI)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 761, in test_setinputsizes
    self._paraminsert(cur) # Make sure cursor still works
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 358, in _paraminsert
    self.executeDDL2(cur)
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 77, in executeDDL2
    cursor.execute(self.ddl2)
  File "/home/runner/work/tarantool/tarantool/tarantool/dbapi.py", line 64, in execute
    response = self._c.execute(query, params)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

======================================================================
ERROR: test_setoutputsize_basic (suites.test_dbapi.TestSuite_DBAPI)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 772, in test_setoutputsize_basic
    self._paraminsert(cur) # Make sure the cursor still works
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 358, in _paraminsert
    self.executeDDL2(cur)
  File "/opt/hostedtoolcache/Python/3.7.12/x64/lib/python3.7/site-packages/dbapi20.py", line 77, in executeDDL2
    cursor.execute(self.ddl2)
  File "/home/runner/work/tarantool/tarantool/tarantool/dbapi.py", line 64, in execute
    response = self._c.execute(query, params)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 852, in execute
    response = self._send_request(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 381, in _send_request
    return self._send_request_wo_reconnect(request)
  File "/home/runner/work/tarantool/tarantool/tarantool/connection.py", line 296, in _send_request_wo_reconnect
    response = request.response_class(self, self._read_response())
  File "/home/runner/work/tarantool/tarantool/tarantool/response.py", line 124, in __init__
    raise DatabaseError(self._return_code, self._return_message)
tarantool.error.DatabaseError: (48, 'Unknown request type 11')

----------------------------------------------------------------------
Ran 93 tests in 10.555s

FAILED (errors=13, skipped=12)

Tarantool supports SQL only since the 2.0.0 version. So we need to skip SQL-related tests when tarantool < 2.0.0 is used.
@ylobankov ylobankov added the bug Something isn't working label Nov 11, 2021
@ylobankov ylobankov self-assigned this Nov 11, 2021
ylobankov added a commit that referenced this issue Nov 15, 2021
@ylobankov
Skip SQL tests if tarantool version < 2.0.0
aa24697 
Problem: all SQL-related tests fail with the following error
if tarantool < 2.0.0 is used:

    tarantool.error.DatabaseError: (48, 'Unknown request type 11')

Tarantool supports SQL-related stuff only since the 2.0.0 version.
So this patch adds a special decorator that will skip the test if
tarantool version < 2.0.0 is used.

Fixes #194
@ylobankov ylobankov mentioned this issue Nov 15, 2021
Merged
Totktonada pushed a commit that referenced this issue Nov 15, 2021
@ylobankov @Totktonada
Skip SQL tests if tarantool version < 2.0.0
6de4c53 
Problem: all SQL-related tests fail with the following error
if tarantool < 2.0.0 is used:

    tarantool.error.DatabaseError: (48, 'Unknown request type 11')

Tarantool supports SQL-related stuff only since the 2.0.0 version.
So this patch adds a special decorator that will skip the test if
tarantool version < 2.0.0 is used.

Fixes #194
ylobankov added a commit that referenced this issue Nov 15, 2021
@ylobankov
Skip SQL tests if tarantool version < 2.0.0
0f95f28 
Problem: all SQL-related tests fail with the following error
if tarantool < 2.0.0 is used:

    tarantool.error.DatabaseError: (48, 'Unknown request type 11')

Tarantool supports SQL-related stuff only since the 2.0.0 version.
So this patch adds a special decorator that will skip the test if
tarantool version < 2.0.0 is used.

Fixes #194
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ylobankov ylobankov

Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Skip SQL tests if tarantool version < 2.0.0 tarantool/tarantool-python
1 participant
@ylobankov