memory engine table can be inserted but select query gets no result in version 2.2.0b0

[l1t1]

Please make sure that the version you're using is still supported (you can find the list here).

You have to provide the following information whenever possible.

Describe what's wrong
I did as following in a docker container. and found memory engine table can be inserted but select query gets no result

pip install chdb==2.2.0b0 -i https://pypi.tuna.tsinghua.edu.cn/simple/
(base) root@74f853bd04cb:/# python
Python 3.11.4 (main, Jul  5 2023, 13:36:48) [GCC 11.2.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import chdb
>>> from chdb import session as chs
>>> 
>>> ## Create DB, Table, View in temp session, auto cleanup when session is deleted.
>>> sess = chs.Session()
>>> sess.query("CREATE DATABASE IF NOT EXISTS db_xxx ENGINE = Atomic")

>>> sess.query("CREATE TABLE IF NOT EXISTS db_xxx.log_table_xxx (x String, y Int) ENGINE = Log;")

>>> sess.query("INSERT INTO db_xxx.log_table_xxx VALUES ('a', 1), ('b', 3), ('c', 2), ('d', 5);")

>>> sess.query(
...     "CREATE VIEW db_xxx.view_xxx AS SELECT * FROM db_xxx.log_table_xxx LIMIT 4;"
... )

>>> print(sess.query("SELECT * FROM db_xxx.view_xxx"))
"a",1
"b",3
"c",2
"d",5

>>> sess.query("CREATE TABLE IF NOT EXISTS db_xxx.log_table_mem (x String, y Int) ENGINE = Memory;")

>>> sess.query("INSERT INTO db_xxx.log_table_mem VALUES ('a', 1), ('b', 3), ('c', 2), ('d', 5);")

>>> print(sess.query("SELECT * FROM db_xxx.log_table_mem"))

>>> 

[Daniel-Robbins]

chdb.Session has not migrated to the new engine. I'll do it in next release please use chdb.dbapi or chdb.connect API set

…

On Mon, Dec 2, 2024 at 12:19 PM l1t1 ***@***.***> wrote: Please make sure that the version you're using is still supported (you can find the list here <https://github.com/ClickHouse/ClickHouse/blob/master/SECURITY.md#scope-and-supported-versions> ). You have to provide the following information whenever possible. *Describe what's wrong* I did as following in a docker container. and found memory engine table can be inserted but select query gets no result pip install chdb==2.2.0b0 -i https://pypi.tuna.tsinghua.edu.cn/simple/ (base) ***@***.***:/# python Python 3.11.4 (main, Jul 5 2023, 13:36:48) [GCC 11.2.0] on linux Type "help", "copyright", "credits" or "license" for more information. >>> import chdb >>> from chdb import session as chs >>> >>> ## Create DB, Table, View in temp session, auto cleanup when session is deleted. >>> sess = chs.Session() >>> sess.query("CREATE DATABASE IF NOT EXISTS db_xxx ENGINE = Atomic") >>> sess.query("CREATE TABLE IF NOT EXISTS db_xxx.log_table_xxx (x String, y Int) ENGINE = Log;") >>> sess.query("INSERT INTO db_xxx.log_table_xxx VALUES ('a', 1), ('b', 3), ('c', 2), ('d', 5);") >>> sess.query( ... "CREATE VIEW db_xxx.view_xxx AS SELECT * FROM db_xxx.log_table_xxx LIMIT 4;" ... ) >>> print(sess.query("SELECT * FROM db_xxx.view_xxx")) "a",1 "b",3 "c",2 "d",5 >>> sess.query("CREATE TABLE IF NOT EXISTS db_xxx.log_table_mem (x String, y Int) ENGINE = Memory;") >>> sess.query("INSERT INTO db_xxx.log_table_mem VALUES ('a', 1), ('b', 3), ('c', 2), ('d', 5);") >>> print(sess.query("SELECT * FROM db_xxx.log_table_mem")) >>> — Reply to this email directly, view it on GitHub <#288>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AKNDKFDZW7M52SZQA2KHZ6D2DPNT7AVCNFSM6AAAAABS2PMS2SVHI2DSMVQWIX3LMV43ASLTON2WKOZSG4YTANBQGYZTANY> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>