Visitar URL original
bpo-44822: Don't truncate `str`s with embedded NULL chars returned by `sqlite3` UDF callbacks by erlend-aasland · Pull Request #27588 · python/cpython · GitHub
Skip to content

bpo-44822: Don't truncate strs with embedded NULL chars returned by sqlite3 UDF callbacks #27588

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

Merged
serhiy-storchaka merged 8 commits into from
Aug 5, 2021
Merged

bpo-44822: Don't truncate strs with embedded NULL chars returned by sqlite3 UDF callbacks #27588

Changes from 1 commit
Commits
Show all changes
8 commits
Select commit Hold shift + click to select a range
2241795
bpo-44822: Pass string size to sqlite3_result_text()
Aug 3, 2021
58d3244
Raise OverflowError if size > INT_MAX
Aug 4, 2021
73639f1
Add test
Aug 4, 2021
60d94f9
Add NEWS entry
Aug 4, 2021
10fbc4b
Don't capitalize error string
Aug 4, 2021
a483052
Add aggregate test
Aug 4, 2021
55963ca
Address review: reword NEWS entry
Aug 4, 2021
7a2c279
Apply suggestions from code review
serhiy-storchaka Aug 5, 2021
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
Add aggregate test
  • Loading branch information
Erlend E. Aasland
Erlend E. Aasland committed Aug 4, 2021
commit a4830525c0aecb58839f9fe9c5173903dfebdcbc
19 changes: 19 additions & 0 deletions Lib/sqlite3/test/userfunctions.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -165,6 +165,15 @@ def step(self, val):
def finalize(self):
return self.val

class AggrText:
def __init__(self):
self.txt = ""
def step(self, txt):
self.txt = self.txt + txt
def finalize(self):
return self.txt


class FunctionTests(unittest.TestCase):
def setUp(self):
self.con = sqlite.connect(":memory:")
Expand Down Expand Up @@ -399,6 +408,7 @@ def setUp(self):
self.con.create_aggregate("checkType", 2, AggrCheckType)
self.con.create_aggregate("checkTypes", -1, AggrCheckTypes)
self.con.create_aggregate("mysum", 1, AggrSum)
self.con.create_aggregate("aggtxt", 1, AggrText)

def tearDown(self):
#self.cur.close()
Expand Down Expand Up @@ -495,6 +505,15 @@ def test_aggr_no_match(self):
val = cur.fetchone()[0]
self.assertIsNone(val)

def test_aggr_text(self):
cur = self.con.cursor()
for txt in ["foo", "1\x002"]:
with self.subTest(txt=txt):
cur.execute("select aggtxt(?) from test", (txt,))
val = cur.fetchone()[0]
self.assertEqual(val, txt)


class AuthorizerTests(unittest.TestCase):
@staticmethod
def authorizer_cb(action, arg1, arg2, dbname, source):
Expand Down