Skip to content
This repository has been archived by the owner on Jan 13, 2022. It is now read-only.

SQL Decimal type does not work correctly #41

Open
kutsurak opened this issue May 20, 2019 · 0 comments
Open

SQL Decimal type does not work correctly #41

kutsurak opened this issue May 20, 2019 · 0 comments
Assignees
Labels
Milestone

Comments

@kutsurak
Copy link
Member

Querying inserted decimals does not return correct results. The problem is probably in insert.

>>> import monetdblite as mdbl
>>> c = mdbl.make_connection('/tmp/tstdb')
>>> c.set_autocommit(True)
>>> cc = c.cursor()
>>> cc.execute("CREATE TABLE v (f decimal(3,2))")
0
>>> cc.insert('v', {'f': [1.3]})
>>> cc.execute('select * from v')
1
>>> cc.fetchall()
[[0.01]]

The result should be [[1.3]].

@kutsurak kutsurak added the bug label May 20, 2019
@kutsurak kutsurak added this to the 0.6.4 milestone May 20, 2019
@kutsurak kutsurak self-assigned this May 20, 2019
kutsurak added a commit that referenced this issue Jun 3, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Development

No branches or pull requests

1 participant