Python thin client - messed up values

classic Classic list List threaded Threaded
2 messages Options
dbutkovic dbutkovic
Reply | Threaded
Open this post in threaded view
|

Python thin client - messed up values

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

ezhuravlev ezhuravlev
Reply | Threaded
Open this post in threaded view
|

Re: Python thin client - messed up values

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ć <[hidden email]>:
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