snowflake-connector-python SNOW-654931: Driver implicitly converts query results into string while expecting to get an int

SNOW-654931: Driver implicitly converts query results into string while expecting to get an int

Open ni-todo-spot opened this issue 3 years ago • 0 comments

Please answer these questions before submitting your issue. Thanks!

What version of Python are you using? Python 3.8.7
What operating system and processor architecture are you using? macOS-12.5.1-x86_64-i386-64bit
What are the component versions in the environment (pip freeze)?

asn1crypto==1.5.1
certifi==2022.6.15
cffi==1.15.1
charset-normalizer==2.1.1
cryptography==36.0.2
filelock==3.8.0
idna==3.3
oscrypto==1.3.0
pycparser==2.21
pycryptodomex==3.15.0
PyJWT==2.4.0
pyOpenSSL==22.0.0
pytz==2022.2.1
requests==2.28.1
snowflake-connector-python==2.7.12
typing-extensions==4.3.0
urllib3==1.26.12

What did you do?

import snowflake.connector

if __name__ == '__main__':
    p = {'account': '...', 'database': '...', 'password': '...', 'user': '...', 'warehouse': '...'}
    c = snowflake.connector.connect(**p)
    with c:
        with c.cursor() as cu:
            cu.execute(
                "select TYPEOF(VALUE) as TYPE_NAME, VALUE AS VALUE from table(flatten(input => array_construct(1, 3)))")
            # my use case is actually using the cu.fetch_pandas_all() method, but this simpler example also reproduces:
            actual = cu.fetchall()
    
    expected = [('INTEGER', 1), ('INTEGER', 3)]
    
    # will fail since 1 & 3 are fetched as strings
    assert actual == expected

What did you expect to see? expected = [('INTEGER', 1), ('INTEGER', 3)]

What should have happened and what happened instead?

actual = [('INTEGER', '1'), ('INTEGER', '3')]

Can you set logging to DEBUG and collect the logs? I changed some of the parameters for confidential reasons

2022-09-01 11:49:10,546 - MainThread connection.py:270 - __init__() - INFO - Snowflake Connector for Python Version: 2.7.12, Python Version: 3.8.7, Platform: macOS-12.5.1-x86_64-i386-64bit
2022-09-01 11:49:10,546 - MainThread connection.py:512 - connect() - DEBUG - connect
2022-09-01 11:49:10,546 - MainThread connection.py:802 - __config() - DEBUG - __config
2022-09-01 11:49:10,546 - MainThread connection.py:926 - __config() - INFO - This connection is in OCSP Fail Open Mode. TLS Certificates would be checked for validity and revocation status. Any other Certificate Revocation related exceptions or OCSP Responder failures would be disregarded in favor of connectivity.
2022-09-01 11:49:10,546 - MainThread connection.py:944 - __config() - INFO - Setting use_openssl_only mode to False
2022-09-01 11:49:10,546 - MainThread converter.py:145 - __init__() - DEBUG - use_numpy: False
2022-09-01 11:49:10,546 - MainThread connection.py:705 - __open_connection() - DEBUG - REST API object was created: ab12345.west-europe.azure.snowflakecomputing.com:443
2022-09-01 11:49:10,546 - MainThread auth.py:170 - authenticate() - DEBUG - authenticate
2022-09-01 11:49:10,546 - MainThread auth.py:200 - authenticate() - DEBUG - assertion content: *********
2022-09-01 11:49:10,547 - MainThread auth.py:203 - authenticate() - DEBUG - account=ab12345, user=SOME_USER, database=my_db, schema=None, warehouse=my_WH, role=None, request_id=abcdef12-3456-7890-abcd-1234567890ab
2022-09-01 11:49:10,547 - MainThread auth.py:236 - authenticate() - DEBUG - body['data']: {'CLIENT_APP_ID': 'PythonConnector', 'CLIENT_APP_VERSION': '2.7.12', 'SVN_REVISION': None, 'ACCOUNT_NAME': 'ab12345', 'LOGIN_NAME': 'SOME_USER', 'CLIENT_ENVIRONMENT': {'APPLICATION': 'PythonConnector', 'OS': 'Darwin', 'OS_VERSION': 'macOS-12.5.1-x86_64-i386-64bit', 'PYTHON_VERSION': '3.8.7', 'PYTHON_RUNTIME': 'CPython', 'PYTHON_COMPILER': 'Clang 12.0.5 (clang-1205.0.22.9)', 'OCSP_MODE': 'FAIL_OPEN', 'TRACING': 10, 'LOGIN_TIMEOUT': 120, 'NETWORK_TIMEOUT': None}, 'SESSION_PARAMETERS': {'CLIENT_PREFETCH_THREADS': 4}}
2022-09-01 11:49:10,547 - MainThread auth.py:254 - authenticate() - DEBUG - Timeout set to 120
2022-09-01 11:49:10,547 - MainThread retry.py:351 - from_int() - DEBUG - Converted retries value: 1 -> Retry(total=1, connect=None, read=None, redirect=None, status=None)
2022-09-01 11:49:10,547 - MainThread retry.py:351 - from_int() - DEBUG - Converted retries value: 1 -> Retry(total=1, connect=None, read=None, redirect=None, status=None)
2022-09-01 11:49:10,547 - MainThread network.py:1147 - _use_requests_session() - DEBUG - Session status for SessionPool 'ab12345.west-europe.azure.snowflakecomputing.com', SessionPool 1/1 active sessions
2022-09-01 11:49:10,547 - MainThread network.py:827 - _request_exec_wrapper() - DEBUG - remaining request timeout: 120, retry cnt: 1
2022-09-01 11:49:10,547 - MainThread network.py:808 - add_request_guid() - DEBUG - Request guid: fedcba21-6543-0987-dcba-0987654321ba
2022-09-01 11:49:10,547 - MainThread network.py:1006 - _request_exec() - DEBUG - socket timeout: 60
2022-09-01 11:49:10,641 - MainThread connectionpool.py:1003 - _new_conn() - DEBUG - Starting new HTTPS connection (1): ab12345.west-europe.azure.snowflakecomputing.com:443
2022-09-01 11:49:11,051 - MainThread cache.py:490 - _save() - DEBUG - acquiring /Users/SomeUser/Library/Caches/Snowflake/ocsp_cache.lock timed out, skipping saving...
2022-09-01 11:49:11,052 - MainThread ocsp_snowflake.py:507 - reset_cache_dir() - DEBUG - cache directory: /Users/SomeUser/Library/Caches/Snowflake
2022-09-01 11:49:11,141 - MainThread ssl_wrap_socket.py:80 - ssl_wrap_socket_with_ocsp() - DEBUG - OCSP Mode: FAIL_OPEN, OCSP response cache file name: None
2022-09-01 11:49:11,141 - MainThread ocsp_snowflake.py:549 - reset_ocsp_response_cache_uri() - DEBUG - ocsp_response_cache_uri: file:///Users/SomeUser/Library/Caches/Snowflake/ocsp_response_cache.json
2022-09-01 11:49:11,141 - MainThread ocsp_snowflake.py:550 - reset_ocsp_response_cache_uri() - DEBUG - OCSP_VALIDATION_CACHE size: 0
2022-09-01 11:49:11,141 - MainThread ocsp_snowflake.py:332 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP response cache server is enabled: http://ocsp.snowflakecomputing.com/ocsp_response_cache.json
2022-09-01 11:49:11,141 - MainThread ocsp_snowflake.py:368 - reset_ocsp_dynamic_cache_server_url() - DEBUG - OCSP dynamic cache server RETRY URL: None
2022-09-01 11:49:11,144 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-09-15 19:41:06+00:00
2022-09-01 11:49:11,145 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-09-15 19:45:34+00:00
2022-09-01 11:49:11,146 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-06-22 07:00:00+00:00
2022-09-01 11:49:11,148 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-05-12 23:58:59+00:00
2022-09-01 11:49:11,149 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2025-05-12 23:58:59+00:00
2022-09-01 11:49:11,151 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2022-10-15 00:00:00+00:00
2022-09-01 11:49:11,173 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 16:47:06+00:00
2022-09-01 11:49:11,174 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 16:47:06+00:00
2022-09-01 11:49:11,176 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 15:48:31+00:00
2022-09-01 11:49:11,177 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 16:47:06+00:00
2022-09-01 11:49:11,178 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 16:47:06+00:00
2022-09-01 11:49:11,181 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 15:48:31+00:00
2022-09-01 11:49:11,182 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 15:48:31+00:00
2022-09-01 11:49:11,185 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 15:48:31+00:00
2022-09-01 11:49:11,186 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 15:48:31+00:00
2022-09-01 11:49:11,187 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 16:47:06+00:00
2022-09-01 11:49:11,188 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 16:47:06+00:00
2022-09-01 11:49:11,189 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 15:48:31+00:00
2022-09-01 11:49:11,190 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 16:47:06+00:00
2022-09-01 11:49:11,191 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 16:47:06+00:00
2022-09-01 11:49:11,192 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 16:47:06+00:00
2022-09-01 11:49:11,194 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 15:48:31+00:00
2022-09-01 11:49:11,195 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 15:48:31+00:00
2022-09-01 11:49:11,196 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 15:48:31+00:00
2022-09-01 11:49:11,197 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 15:48:31+00:00
2022-09-01 11:49:11,198 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 15:48:31+00:00
2022-09-01 11:49:11,200 - MainThread ocsp_asn1crypto.py:238 - is_valid_time() - DEBUG - Verifying the attached certificate is signed by the issuer. Valid Not After: 2023-07-15 16:47:06+00:00
2022-09-01 11:49:11,201 - MainThread ocsp_snowflake.py:585 - read_ocsp_response_cache_file() - DEBUG - Read OCSP response cache file: /Users/SomeUser/Library/Caches/Snowflake/ocsp_response_cache.json, count=186
2022-09-01 11:49:11,201 - MainThread ocsp_snowflake.py:1118 - validate() - DEBUG - validating certificate: ab12345.west-europe.azure.snowflakecomputing.com
2022-09-01 11:49:11,201 - MainThread ocsp_asn1crypto.py:439 - extract_certificate_chain() - DEBUG - # of certificates: 2
2022-09-01 11:49:11,201 - MainThread ocsp_asn1crypto.py:444 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Inc.'), ('common_name', '*.west-europe.azure.snowflakecomputing.com')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert TLS RSA SHA256 2020 CA1')])
2022-09-01 11:49:11,202 - MainThread ocsp_asn1crypto.py:444 - extract_certificate_chain() - DEBUG - subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert TLS RSA SHA256 2020 CA1')]), issuer: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2022-09-01 11:49:11,202 - MainThread ocsp_asn1crypto.py:123 - read_cert_bundle() - DEBUG - reading certificate bundle: /Users/SomeUser/Projects/snow_bug/venv/lib/python3.8/site-packages/certifi/cacert.pem
2022-09-01 11:49:11,214 - MainThread ocsp_asn1crypto.py:465 - create_pair_issuer_subject() - DEBUG - not found issuer_der: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('organizational_unit_name', 'www.digicert.com'), ('common_name', 'DigiCert Global Root CA')])
2022-09-01 11:49:11,216 - MainThread ocsp_snowflake.py:725 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('state_or_province_name', 'California'), ('locality_name', 'San Mateo'), ('organization_name', 'Snowflake Inc.'), ('common_name', '*.west-europe.azure.snowflakecomputing.com')])
2022-09-01 11:49:11,216 - MainThread ocsp_snowflake.py:725 - find_cache() - DEBUG - hit cache for subject: OrderedDict([('country_name', 'US'), ('organization_name', 'DigiCert Inc'), ('common_name', 'DigiCert TLS RSA SHA256 2020 CA1')])
2022-09-01 11:49:11,218 - MainThread ocsp_snowflake.py:647 - write_ocsp_response_cache_file() - DEBUG - writing OCSP response cache file to /Users/SomeUser/Library/Caches/Snowflake/ocsp_response_cache.json
2022-09-01 11:49:11,218 - MainThread ocsp_snowflake.py:1794 - encode_ocsp_response_cache() - DEBUG - encoding OCSP response cache to JSON
2022-09-01 11:49:11,240 - MainThread ocsp_snowflake.py:1175 - _validate() - DEBUG - ok
2022-09-01 11:49:11,611 - MainThread connectionpool.py:456 - _make_request() - DEBUG - https://ab12345.west-europe.azure.snowflakecomputing.com:443 "POST /session/v1/login-request?request_id=abcdef12-3456-7890-abcd-1234567890ab&databaseName=my_db&warehouse=my_WH&request_guid=fedcba21-6543-0987-dcba-0987654321ba HTTP/1.1" 200 None
2022-09-01 11:49:11,613 - MainThread network.py:1032 - _request_exec() - DEBUG - SUCCESS
2022-09-01 11:49:11,613 - MainThread network.py:1152 - _use_requests_session() - DEBUG - Session status for SessionPool 'ab12345.west-europe.azure.snowflakecomputing.com', SessionPool 0/1 active sessions
2022-09-01 11:49:11,614 - MainThread network.py:715 - _post_request() - DEBUG - ret[code] = None, after post request
2022-09-01 11:49:11,614 - MainThread auth.py:373 - authenticate() - DEBUG - completed authentication
2022-09-01 11:49:11,614 - MainThread auth.py:416 - authenticate() - DEBUG - token = ******
2022-09-01 11:49:11,614 - MainThread auth.py:419 - authenticate() - DEBUG - master_token = ******
2022-09-01 11:49:11,614 - MainThread auth.py:423 - authenticate() - DEBUG - id_token = NULL
2022-09-01 11:49:11,614 - MainThread auth.py:427 - authenticate() - DEBUG - mfa_token = NULL
2022-09-01 11:49:11,614 - MainThread connection.py:624 - cursor() - DEBUG - cursor
2022-09-01 11:49:11,614 - MainThread cursor.py:630 - execute() - DEBUG - executing SQL/command
2022-09-01 11:49:11,615 - MainThread cursor.py:669 - execute() - DEBUG - binding: [select TYPEOF(VALUE) as TYPE_NAME, VALUE AS VALUE from table(flatten(input => ar...] with input=[None], processed=[{}]
2022-09-01 11:49:11,615 - MainThread cursor.py:715 - execute() - INFO - query: [select TYPEOF(VALUE) as TYPE_NAME, VALUE AS VALUE from table(flatten(input => ar...]
2022-09-01 11:49:11,615 - MainThread connection.py:1302 - _next_sequence_counter() - DEBUG - sequence counter: 1
2022-09-01 11:49:11,615 - MainThread cursor.py:460 - _execute_helper() - DEBUG - Request id: 70b072ad-3595-4f4c-ad89-5eed989e9204
2022-09-01 11:49:11,615 - MainThread cursor.py:462 - _execute_helper() - DEBUG - running query [select TYPEOF(VALUE) as TYPE_NAME, VALUE AS VALUE from table(flatten(input => ar...]
2022-09-01 11:49:11,615 - MainThread cursor.py:471 - _execute_helper() - DEBUG - is_file_transfer: False
2022-09-01 11:49:11,615 - MainThread connection.py:972 - cmd_query() - DEBUG - _cmd_query
2022-09-01 11:49:11,615 - MainThread connection.py:995 - cmd_query() - DEBUG - sql=[select TYPEOF(VALUE) as TYPE_NAME, VALUE AS VALUE from table(flatten(input => ar...], sequence_id=[1], is_file_transfer=[False]
2022-09-01 11:49:11,616 - MainThread network.py:1147 - _use_requests_session() - DEBUG - Session status for SessionPool 'ab12345.west-europe.azure.snowflakecomputing.com', SessionPool 1/1 active sessions
2022-09-01 11:49:11,616 - MainThread network.py:827 - _request_exec_wrapper() - DEBUG - remaining request timeout: None, retry cnt: 1
2022-09-01 11:49:11,616 - MainThread network.py:808 - add_request_guid() - DEBUG - Request guid: 65049755-6751-41f5-8f8c-b1c1c38c36a6
2022-09-01 11:49:11,616 - MainThread network.py:1006 - _request_exec() - DEBUG - socket timeout: 60
2022-09-01 11:49:11,779 - MainThread connectionpool.py:456 - _make_request() - DEBUG - https://ab12345.west-europe.azure.snowflakecomputing.com:443 "POST /queries/v1/query-request?requestId=70b072ad-3595-4f4c-ad89-5eed989e9204&request_guid=65049755-6751-41f5-8f8c-b1c1c38c36a6 HTTP/1.1" 200 None
2022-09-01 11:49:11,780 - MainThread network.py:1032 - _request_exec() - DEBUG - SUCCESS
2022-09-01 11:49:11,781 - MainThread network.py:1152 - _use_requests_session() - DEBUG - Session status for SessionPool 'ab12345.west-europe.azure.snowflakecomputing.com', SessionPool 0/1 active sessions
2022-09-01 11:49:11,781 - MainThread network.py:715 - _post_request() - DEBUG - ret[code] = None, after post request
2022-09-01 11:49:11,781 - MainThread network.py:739 - _post_request() - DEBUG - Query id: 5537953e-1305-4b03-80d2-67f5cdfa942e
2022-09-01 11:49:11,782 - MainThread cursor.py:737 - execute() - DEBUG - sfqid: 5537953e-1305-4b03-80d2-67f5cdfa942e
2022-09-01 11:49:11,782 - MainThread cursor.py:739 - execute() - INFO - query execution done
2022-09-01 11:49:11,782 - MainThread cursor.py:741 - execute() - DEBUG - SUCCESS
2022-09-01 11:49:11,782 - MainThread cursor.py:744 - execute() - DEBUG - PUT OR GET: None
2022-09-01 11:49:11,782 - MainThread cursor.py:841 - _init_result_and_meta() - DEBUG - Query result format: arrow
2022-09-01 11:49:11,783 - MainThread arrow_iterator.cpython-38-darwin.so:0 - __cinit__() - DEBUG - Batches read: 1
2022-09-01 11:49:11,783 - MainThread CArrowIterator.cpp:16 - CArrowIterator() - DEBUG - Arrow BatchSize: 1
2022-09-01 11:49:11,783 - MainThread CArrowChunkIterator.cpp:50 - CArrowChunkIterator() - DEBUG - Arrow chunk info: batchCount 1, columnCount 2, use_numpy: 0
2022-09-01 11:49:11,783 - MainThread result_set.py:58 - result_set_iterator() - DEBUG - beginning to schedule result batch downloads
2022-09-01 11:49:11,784 - MainThread CArrowChunkIterator.cpp:74 - next() - DEBUG - Current batch index: 0, rows in current batch: 2
2022-09-01 11:49:11,784 - MainThread connection.py:557 - close() - INFO - closed
2022-09-01 11:49:11,784 - MainThread telemetry.py:151 - close() - DEBUG - Closing telemetry client.
2022-09-01 11:49:11,785 - MainThread telemetry.py:116 - send_batch() - DEBUG - Sending 1 logs to telemetry. Data is {'logs': [{'message': {'type': 'client_time_consume_first_result', 'source': 'PythonConnector', 'query_id': '5537953e-1305-4b03-80d2-67f5cdfa942e', 'value': -162}, 'timestamp': '1662022151782'}, {'message': {'type': 'client_time_consume_last_result', 'source': 'PythonConnector', 'query_id': '5537953e-1305-4b03-80d2-67f5cdfa942e', 'value': 2}, 'timestamp': '1662022151784'}]}.
2022-09-01 11:49:11,785 - MainThread network.py:1147 - _use_requests_session() - DEBUG - Session status for SessionPool 'ab12345.west-europe.azure.snowflakecomputing.com', SessionPool 1/1 active sessions
2022-09-01 11:49:11,785 - MainThread network.py:827 - _request_exec_wrapper() - DEBUG - remaining request timeout: 5, retry cnt: 1
2022-09-01 11:49:11,785 - MainThread network.py:808 - add_request_guid() - DEBUG - Request guid: 4bd0de64-8e5a-48e1-9cc7-22dcb4d4e449
2022-09-01 11:49:11,785 - MainThread network.py:1006 - _request_exec() - DEBUG - socket timeout: 60
2022-09-01 11:49:11,958 - MainThread connectionpool.py:456 - _make_request() - DEBUG - https://ab12345.west-europe.azure.snowflakecomputing.com:443 "POST /telemetry/send?request_guid=4bd0de64-8e5a-48e1-9cc7-22dcb4d4e449 HTTP/1.1" 200 86
2022-09-01 11:49:11,959 - MainThread network.py:1032 - _request_exec() - DEBUG - SUCCESS
2022-09-01 11:49:11,959 - MainThread network.py:1152 - _use_requests_session() - DEBUG - Session status for SessionPool 'ab12345.west-europe.azure.snowflakecomputing.com', SessionPool 0/1 active sessions
2022-09-01 11:49:11,959 - MainThread network.py:715 - _post_request() - DEBUG - ret[code] = None, after post request
2022-09-01 11:49:11,959 - MainThread telemetry.py:140 - send_batch() - DEBUG - Successfully uploading metrics to telemetry.
2022-09-01 11:49:11,960 - MainThread connection.py:560 - close() - INFO - No async queries seem to be running, deleting session
2022-09-01 11:49:11,960 - MainThread network.py:1147 - _use_requests_session() - DEBUG - Session status for SessionPool 'ab12345.west-europe.azure.snowflakecomputing.com', SessionPool 1/1 active sessions
2022-09-01 11:49:11,960 - MainThread network.py:827 - _request_exec_wrapper() - DEBUG - remaining request timeout: 5, retry cnt: 1
2022-09-01 11:49:11,960 - MainThread network.py:808 - add_request_guid() - DEBUG - Request guid: 1473e163-9ce6-488a-ad51-2b2ad74f3854
2022-09-01 11:49:11,960 - MainThread network.py:1006 - _request_exec() - DEBUG - socket timeout: 60
2022-09-01 11:49:12,108 - MainThread connectionpool.py:456 - _make_request() - DEBUG - https://ab12345.west-europe.azure.snowflakecomputing.com:443 "POST /session?delete=true&request_guid=1473e163-9ce6-488a-ad51-2b2ad74f3854 HTTP/1.1" 200 76
2022-09-01 11:49:12,109 - MainThread network.py:1032 - _request_exec() - DEBUG - SUCCESS
2022-09-01 11:49:12,109 - MainThread network.py:1152 - _use_requests_session() - DEBUG - Session status for SessionPool 'ab12345.west-europe.azure.snowflakecomputing.com', SessionPool 0/1 active sessions
2022-09-01 11:49:12,109 - MainThread network.py:715 - _post_request() - DEBUG - ret[code] = None, after post request
2022-09-01 11:49:12,112 - MainThread connection.py:571 - close() - DEBUG - Session is closed

Sep 01 '22 09:09 ni-todo-spot

snowflake-connector-python snowflake-connector-python copied to clipboard

SNOW-654931: Driver implicitly converts query results into string while expecting to get an int

snowflake-connector-python
snowflake-connector-python copied to clipboard