Hi, Thanks for the detailed information! I was able to reproduce the issue and find the root cause. I've created a ticket for this: https://issues.apache.org/jira/browse/IGNITE-12809
Evgenii чт, 19 мар. 2020 г. в 01:51, Dren Butković <[email protected]>: > Hi, > When the number of columns in table is bigger than 10, only first row have > colums values in correct order. > Second row and all other rows have messed up values. > Select via sqlline or jdbc is ok, I noticed this only when working with > python. > Same result is with pyignite and pygridgain module. > > CREATE TABLE TEST1 > ( > id integer, > col1 varchar(10), > col2 varchar(10), > col3 varchar(10), > col4 varchar(10), > col5 varchar(10), > col6 varchar(10), > col7 varchar(10), > col8 varchar(10), > col9 varchar(10), > col10 varchar(10), > col11 varchar(10), > col12 varchar(10), > PRIMARY KEY (id) > ) WITH "CACHE_NAME=TEST1, DATA_REGION=PersistDataRegion, > TEMPLATE=REPLICATED"; > > > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(1, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(2, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(3, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(4, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(5, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(6, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(7, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(8, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(9, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(10, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(11, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(12, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(13, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(14, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > INSERT INTO PUBLIC.TEST1 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8, COL9, COL10, COL11, COL12) VALUES(15, 'a', 'b', 'c', 'd', 'e', 'f', > 'g', 'h', 'i', 'j', 'k', 'l'); > > > CREATE TABLE TEST2 > ( > id integer, > col1 varchar(10), > col2 varchar(10), > col3 varchar(10), > col4 varchar(10), > col5 varchar(10), > col6 varchar(10), > col7 varchar(10), > col8 varchar(10), > PRIMARY KEY (id) > ) WITH "CACHE_NAME=TEST2, DATA_REGION=PersistDataRegion, > TEMPLATE=REPLICATED"; > > > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(1, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(2, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(3, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(4, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(5, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(6, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(7, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(8, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(9, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(10, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(11, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(12, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(13, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(14, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > INSERT INTO PUBLIC.TEST2 (ID, COL1, COL2, COL3, COL4, COL5, COL6, COL7, > COL8) VALUES(15, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'); > > > > > > > from pyignite import Client > > nodes = [('192.168.50.106', 10800)] > > client = Client(username='ignite', password='ignite', use_ssl=False) > client.connect(nodes) > > print('Connected to {}'.format(client)) > > # FETCH ALL FROM TEST1 > results = client.sql("select * from TEST1", include_field_names=True) > > for result in results: > print (result) > > # FETCH ALL FROM TEST2 > results = client.sql("select * from TEST2", include_field_names=True) > > for result in results: > print (result) > > > client.close() > > > > > [root@incumbosstest06 test]# python3.6 test.py > Connected to 192.168.50.106:10800 > ['ID', 'COL1', 'COL2', 'COL3', 'COL4', 'COL5', 'COL6', 'COL7', 'COL8', > 'COL9', 'COL10', 'COL11', 'COL12'] > [1, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l'] > [2, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [3, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [4, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [5, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [6, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [7, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [8, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [9, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [10, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [11, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [12, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [13, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [14, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > [15, 'a', 'j', 'k', 'l', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i'] > > ['ID', 'COL1', 'COL2', 'COL3', 'COL4', 'COL5', 'COL6', 'COL7', 'COL8'] > [1, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [2, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [3, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [4, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [5, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [6, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [7, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [8, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [9, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [10, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [11, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [12, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [13, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [14, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > [15, 'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] > > > Best regards > > Dren > >
