[CONPY-281] unittest test_conpy175 fails with sql_mode="NO_BACKSLASH_ESCAPES" Created: 2024-02-01  Updated: 2024-02-01  Resolved: 2024-02-01

Status: Closed
Project: MariaDB Connector/Python
Component/s: Tests
Affects Version/s: 1.1.9
Fix Version/s: 1.1.10

Type: Bug Priority: Minor
Reporter: Georg Richter Assignee: Georg Richter
Resolution: Fixed Votes: 0
Labels: None

Python Version: 3.10

 Description   

test_conpy175 unittest fails, if tests are running against server with sql_mode=NO_BACKSLASH_ESCAPES.

Proposal:

    def test_conpy175(self):
 
        default_conf = conf()
 
        c1 = mariadb.connect(**default_conf)
 
        str = "Bob's"
 
        newstr = c1.escape_string(str)
 
        if c1.server_status & STATUS.NO_BACKSLASH_ESCAPES:
 
            self.assertEqual(newstr, "Bob''s")
 
        else:
 
            self.assertEqual(newstr, "Bob\\'s")
 
        c1.close()


Generated at Thu Feb 08 03:31:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.