1/286:
SQL Type: [boolean]
Python Value: [None(NoneType)]
Result Python Value: [None]
2/286:
SQL Type: [boolean]
Python Value: [True(bool)]
Result Python Value: [True]
3/286:
SQL Type: [boolean]
Python Value: [1(int)]
Result Python Value: [None]
4/286:
SQL Type: [boolean]
Python Value: [a(str)]
Result Python Value: [None]
5/286:
SQL Type: [boolean]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
6/286:
SQL Type: [boolean]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
7/286:
SQL Type: [boolean]
Python Value: [1.0(float)]
Result Python Value: [None]
8/286:
SQL Type: [boolean]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
9/286:
SQL Type: [boolean]
Python Value: [[1](list)]
Result Python Value: [None]
10/286:
SQL Type: [boolean]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
11/286:
SQL Type: [boolean]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [None]
12/286:
SQL Type: [boolean]
Python Value: [1(Decimal)]
Result Python Value: [None]
13/286:
SQL Type: [boolean]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
14/286:
SQL Type: [tinyint]
Python Value: [None(NoneType)]
Result Python Value: [None]
15/286:
SQL Type: [tinyint]
Python Value: [True(bool)]
Result Python Value: [None]
16/286:
SQL Type: [tinyint]
Python Value: [1(int)]
Result Python Value: [1]
17/286:
SQL Type: [tinyint]
Python Value: [a(str)]
Result Python Value: [None]
18/286:
SQL Type: [tinyint]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
19/286:
SQL Type: [tinyint]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
20/286:
SQL Type: [tinyint]
Python Value: [1.0(float)]
Result Python Value: [None]
21/286:
SQL Type: [tinyint]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
22/286:
SQL Type: [tinyint]
Python Value: [[1](list)]
Result Python Value: [None]
23/286:
SQL Type: [tinyint]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
24/286:
SQL Type: [tinyint]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [None]
25/286:
SQL Type: [tinyint]
Python Value: [1(Decimal)]
Result Python Value: [None]
26/286:
SQL Type: [tinyint]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
27/286:
SQL Type: [smallint]
Python Value: [None(NoneType)]
Result Python Value: [None]
28/286:
SQL Type: [smallint]
Python Value: [True(bool)]
Result Python Value: [None]
29/286:
SQL Type: [smallint]
Python Value: [1(int)]
Result Python Value: [1]
30/286:
SQL Type: [smallint]
Python Value: [a(str)]
Result Python Value: [None]
31/286:
SQL Type: [smallint]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
32/286:
SQL Type: [smallint]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
33/286:
SQL Type: [smallint]
Python Value: [1.0(float)]
Result Python Value: [None]
34/286:
SQL Type: [smallint]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
35/286:
SQL Type: [smallint]
Python Value: [[1](list)]
Result Python Value: [None]
36/286:
SQL Type: [smallint]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
37/286:
SQL Type: [smallint]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [None]
38/286:
SQL Type: [smallint]
Python Value: [1(Decimal)]
Result Python Value: [None]
39/286:
SQL Type: [smallint]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
40/286:
SQL Type: [int]
Python Value: [None(NoneType)]
Result Python Value: [None]
41/286:
SQL Type: [int]
Python Value: [True(bool)]
Result Python Value: [None]
42/286:
SQL Type: [int]
Python Value: [1(int)]
Result Python Value: [1]
43/286:
SQL Type: [int]
Python Value: [a(str)]
Result Python Value: [None]
44/286:
SQL Type: [int]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
45/286:
SQL Type: [int]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
46/286:
SQL Type: [int]
Python Value: [1.0(float)]
Result Python Value: [None]
47/286:
SQL Type: [int]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
48/286:
SQL Type: [int]
Python Value: [[1](list)]
Result Python Value: [None]
49/286:
SQL Type: [int]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
50/286:
SQL Type: [int]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [None]
51/286:
SQL Type: [int]
Python Value: [1(Decimal)]
Result Python Value: [None]
52/286:
SQL Type: [int]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
53/286:
SQL Type: [bigint]
Python Value: [None(NoneType)]
Result Python Value: [None]
54/286:
SQL Type: [bigint]
Python Value: [True(bool)]
Result Python Value: [None]
55/286:
SQL Type: [bigint]
Python Value: [1(int)]
Result Python Value: [1]
56/286:
SQL Type: [bigint]
Python Value: [a(str)]
Result Python Value: [None]
57/286:
SQL Type: [bigint]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
58/286:
SQL Type: [bigint]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
59/286:
SQL Type: [bigint]
Python Value: [1.0(float)]
Result Python Value: [None]
60/286:
SQL Type: [bigint]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
61/286:
SQL Type: [bigint]
Python Value: [[1](list)]
Result Python Value: [None]
62/286:
SQL Type: [bigint]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
63/286:
SQL Type: [bigint]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [None]
64/286:
SQL Type: [bigint]
Python Value: [1(Decimal)]
Result Python Value: [None]
65/286:
SQL Type: [bigint]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
66/286:
SQL Type: [string]
Python Value: [None(NoneType)]
Result Python Value: [None]
67/286:
SQL Type: [string]
Python Value: [True(bool)]
Result Python Value: ['true']
68/286:
SQL Type: [string]
Python Value: [1(int)]
Result Python Value: ['1']
69/286:
SQL Type: [string]
Python Value: [a(str)]
Result Python Value: ['a']
70/286:
SQL Type: [string]
Python Value: [1970-01-01(date)]
Result Python Value: ['java.util.GregorianCalendar[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Etc/UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=?,YEAR=1970,MONTH=0,WEEK_OF_YEAR=?,WEEK_OF_MONTH=?,DAY_OF_MONTH=1,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK_IN_MONTH=?,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=?,ZONE_OFFSET=?,DST_OFFSET=?]']
71/286:
SQL Type: [string]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: ['java.util.GregorianCalendar[time=?,areFieldsSet=false,areAllFieldsSet=false,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Etc/UTC",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=?,YEAR=1970,MONTH=0,WEEK_OF_YEAR=?,WEEK_OF_MONTH=?,DAY_OF_MONTH=1,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK_IN_MONTH=?,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=?,DST_OFFSET=?]']
72/286:
SQL Type: [string]
Python Value: [1.0(float)]
Result Python Value: ['1.0']
73/286:
SQL Type: [string]
Python Value: [array('i', [1])(array)]
Result Python Value: ['[I@456971fd']
74/286:
SQL Type: [string]
Python Value: [[1](list)]
Result Python Value: ['[1]']
75/286:
SQL Type: [string]
Python Value: [(1,)(tuple)]
Result Python Value: ['[Ljava.lang.Object;@f1da338']
76/286:
SQL Type: [string]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: ['[B@7c4c4a12']
77/286:
SQL Type: [string]
Python Value: [1(Decimal)]
Result Python Value: ['1']
78/286:
SQL Type: [string]
Python Value: [{'a': 1}(dict)]
Result Python Value: ['{a=1}']
79/286:
SQL Type: [date]
Python Value: [None(NoneType)]
Result Python Value: [None]
80/286:
SQL Type: [date]
Python Value: [True(bool)]
Result Python Value: [X]
81/286:
SQL Type: [date]
Python Value: [1(int)]
Result Python Value: [X]
82/286:
SQL Type: [date]
Python Value: [a(str)]
Result Python Value: [X]
83/286:
SQL Type: [date]
Python Value: [1970-01-01(date)]
Result Python Value: [datetime.date(1970, 1, 1)]
84/286:
SQL Type: [date]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [datetime.date(1970, 1, 1)]
85/286:
SQL Type: [date]
Python Value: [1.0(float)]
Result Python Value: [X]
86/286:
SQL Type: [date]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
87/286:
SQL Type: [date]
Python Value: [[1](list)]
Result Python Value: [X]
88/286:
SQL Type: [date]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
89/286:
SQL Type: [date]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
90/286:
SQL Type: [date]
Python Value: [1(Decimal)]
Result Python Value: [X]
91/286:
SQL Type: [date]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
92/286:
SQL Type: [timestamp]
Python Value: [None(NoneType)]
Result Python Value: [None]
93/286:
SQL Type: [timestamp]
Python Value: [True(bool)]
Result Python Value: [X]
94/286:
SQL Type: [timestamp]
Python Value: [1(int)]
Result Python Value: [X]
95/286:
SQL Type: [timestamp]
Python Value: [a(str)]
Result Python Value: [X]
96/286:
SQL Type: [timestamp]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
97/286:
SQL Type: [timestamp]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [datetime.datetime(1970, 1, 1, 0, 0)]
98/286:
SQL Type: [timestamp]
Python Value: [1.0(float)]
Result Python Value: [X]
99/286:
SQL Type: [timestamp]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
100/286:
SQL Type: [timestamp]
Python Value: [[1](list)]
Result Python Value: [X]
101/286:
SQL Type: [timestamp]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
102/286:
SQL Type: [timestamp]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
103/286:
SQL Type: [timestamp]
Python Value: [1(Decimal)]
Result Python Value: [X]
104/286:
SQL Type: [timestamp]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
105/286:
SQL Type: [float]
Python Value: [None(NoneType)]
Result Python Value: [None]
106/286:
SQL Type: [float]
Python Value: [True(bool)]
Result Python Value: [None]
107/286:
SQL Type: [float]
Python Value: [1(int)]
Result Python Value: [None]
108/286:
SQL Type: [float]
Python Value: [a(str)]
Result Python Value: [None]
109/286:
SQL Type: [float]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
110/286:
SQL Type: [float]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
111/286:
SQL Type: [float]
Python Value: [1.0(float)]
Result Python Value: [1.0]
112/286:
SQL Type: [float]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
113/286:
SQL Type: [float]
Python Value: [[1](list)]
Result Python Value: [None]
114/286:
SQL Type: [float]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
115/286:
SQL Type: [float]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [None]
116/286:
SQL Type: [float]
Python Value: [1(Decimal)]
Result Python Value: [None]
117/286:
SQL Type: [float]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
118/286:
SQL Type: [double]
Python Value: [None(NoneType)]
Result Python Value: [None]
119/286:
SQL Type: [double]
Python Value: [True(bool)]
Result Python Value: [None]
120/286:
SQL Type: [double]
Python Value: [1(int)]
Result Python Value: [None]
121/286:
SQL Type: [double]
Python Value: [a(str)]
Result Python Value: [None]
122/286:
SQL Type: [double]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
123/286:
SQL Type: [double]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
124/286:
SQL Type: [double]
Python Value: [1.0(float)]
Result Python Value: [1.0]
125/286:
SQL Type: [double]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
126/286:
SQL Type: [double]
Python Value: [[1](list)]
Result Python Value: [None]
127/286:
SQL Type: [double]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
128/286:
SQL Type: [double]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [None]
129/286:
SQL Type: [double]
Python Value: [1(Decimal)]
Result Python Value: [None]
130/286:
SQL Type: [double]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
131/286:
SQL Type: [binary]
Python Value: [None(NoneType)]
Result Python Value: [None]
132/286:
SQL Type: [binary]
Python Value: [True(bool)]
Result Python Value: [None]
133/286:
SQL Type: [binary]
Python Value: [1(int)]
Result Python Value: [None]
134/286:
SQL Type: [binary]
Python Value: [a(str)]
Result Python Value: [bytearray(b'a')]
135/286:
SQL Type: [binary]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
136/286:
SQL Type: [binary]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
137/286:
SQL Type: [binary]
Python Value: [1.0(float)]
Result Python Value: [None]
138/286:
SQL Type: [binary]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
139/286:
SQL Type: [binary]
Python Value: [[1](list)]
Result Python Value: [None]
140/286:
SQL Type: [binary]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
141/286:
SQL Type: [binary]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [bytearray(b'ABC')]
142/286:
SQL Type: [binary]
Python Value: [1(Decimal)]
Result Python Value: [None]
143/286:
SQL Type: [binary]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
144/286:
SQL Type: [decimal(10,0)]
Python Value: [None(NoneType)]
Result Python Value: [None]
145/286:
SQL Type: [decimal(10,0)]
Python Value: [True(bool)]
Result Python Value: [None]
146/286:
SQL Type: [decimal(10,0)]
Python Value: [1(int)]
Result Python Value: [None]
147/286:
SQL Type: [decimal(10,0)]
Python Value: [a(str)]
Result Python Value: [None]
148/286:
SQL Type: [decimal(10,0)]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
149/286:
SQL Type: [decimal(10,0)]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
150/286:
SQL Type: [decimal(10,0)]
Python Value: [1.0(float)]
Result Python Value: [None]
151/286:
SQL Type: [decimal(10,0)]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
152/286:
SQL Type: [decimal(10,0)]
Python Value: [[1](list)]
Result Python Value: [None]
153/286:
SQL Type: [decimal(10,0)]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
154/286:
SQL Type: [decimal(10,0)]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [None]
155/286:
SQL Type: [decimal(10,0)]
Python Value: [1(Decimal)]
Result Python Value: [Decimal('1')]
156/286:
SQL Type: [decimal(10,0)]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
157/286:
SQL Type: [interval year to month]
Python Value: [None(NoneType)]
Result Python Value: [None]
158/286:
SQL Type: [interval year to month]
Python Value: [True(bool)]
Result Python Value: [None]
159/286:
SQL Type: [interval year to month]
Python Value: [1(int)]
Result Python Value: [None]
160/286:
SQL Type: [interval year to month]
Python Value: [a(str)]
Result Python Value: [None]
161/286:
SQL Type: [interval year to month]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
162/286:
SQL Type: [interval year to month]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
163/286:
SQL Type: [interval year to month]
Python Value: [1.0(float)]
Result Python Value: [None]
164/286:
SQL Type: [interval year to month]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
165/286:
SQL Type: [interval year to month]
Python Value: [[1](list)]
Result Python Value: [None]
166/286:
SQL Type: [interval year to month]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
167/286:
SQL Type: [interval year to month]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [None]
168/286:
SQL Type: [interval year to month]
Python Value: [1(Decimal)]
Result Python Value: [None]
169/286:
SQL Type: [interval year to month]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
170/286:
SQL Type: [interval day to second]
Python Value: [None(NoneType)]
Result Python Value: [None]
171/286:
SQL Type: [interval day to second]
Python Value: [True(bool)]
Result Python Value: [X]
172/286:
SQL Type: [interval day to second]
Python Value: [1(int)]
Result Python Value: [X]
173/286:
SQL Type: [interval day to second]
Python Value: [a(str)]
Result Python Value: [X]
174/286:
SQL Type: [interval day to second]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
175/286:
SQL Type: [interval day to second]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
176/286:
SQL Type: [interval day to second]
Python Value: [1.0(float)]
Result Python Value: [X]
177/286:
SQL Type: [interval day to second]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
178/286:
SQL Type: [interval day to second]
Python Value: [[1](list)]
Result Python Value: [X]
179/286:
SQL Type: [interval day to second]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
180/286:
SQL Type: [interval day to second]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
181/286:
SQL Type: [interval day to second]
Python Value: [1(Decimal)]
Result Python Value: [X]
182/286:
SQL Type: [interval day to second]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
183/286:
SQL Type: [timestamp_ntz]
Python Value: [None(NoneType)]
Result Python Value: [None]
184/286:
SQL Type: [timestamp_ntz]
Python Value: [True(bool)]
Result Python Value: [X]
185/286:
SQL Type: [timestamp_ntz]
Python Value: [1(int)]
Result Python Value: [X]
186/286:
SQL Type: [timestamp_ntz]
Python Value: [a(str)]
Result Python Value: [X]
187/286:
SQL Type: [timestamp_ntz]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
188/286:
SQL Type: [timestamp_ntz]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [datetime.datetime(1970, 1, 1, 0, 0)]
189/286:
SQL Type: [timestamp_ntz]
Python Value: [1.0(float)]
Result Python Value: [X]
190/286:
SQL Type: [timestamp_ntz]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
191/286:
SQL Type: [timestamp_ntz]
Python Value: [[1](list)]
Result Python Value: [X]
192/286:
SQL Type: [timestamp_ntz]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
193/286:
SQL Type: [timestamp_ntz]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
194/286:
SQL Type: [timestamp_ntz]
Python Value: [1(Decimal)]
Result Python Value: [X]
195/286:
SQL Type: [timestamp_ntz]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
196/286:
SQL Type: [void]
Python Value: [None(NoneType)]
Result Python Value: [None]
197/286:
SQL Type: [void]
Python Value: [True(bool)]
Result Python Value: [None]
198/286:
SQL Type: [void]
Python Value: [1(int)]
Result Python Value: [None]
199/286:
SQL Type: [void]
Python Value: [a(str)]
Result Python Value: [None]
200/286:
SQL Type: [void]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
201/286:
SQL Type: [void]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
202/286:
SQL Type: [void]
Python Value: [1.0(float)]
Result Python Value: [None]
203/286:
SQL Type: [void]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
204/286:
SQL Type: [void]
Python Value: [[1](list)]
Result Python Value: [None]
205/286:
SQL Type: [void]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
206/286:
SQL Type: [void]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [None]
207/286:
SQL Type: [void]
Python Value: [1(Decimal)]
Result Python Value: [None]
208/286:
SQL Type: [void]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
209/286:
SQL Type: [char(1)]
Python Value: [None(NoneType)]
Result Python Value: [X]
210/286:
SQL Type: [char(1)]
Python Value: [True(bool)]
Result Python Value: [X]
211/286:
SQL Type: [char(1)]
Python Value: [1(int)]
Result Python Value: [X]
212/286:
SQL Type: [char(1)]
Python Value: [a(str)]
Result Python Value: [X]
213/286:
SQL Type: [char(1)]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
214/286:
SQL Type: [char(1)]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
215/286:
SQL Type: [char(1)]
Python Value: [1.0(float)]
Result Python Value: [X]
216/286:
SQL Type: [char(1)]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
217/286:
SQL Type: [char(1)]
Python Value: [[1](list)]
Result Python Value: [X]
218/286:
SQL Type: [char(1)]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
219/286:
SQL Type: [char(1)]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
220/286:
SQL Type: [char(1)]
Python Value: [1(Decimal)]
Result Python Value: [X]
221/286:
SQL Type: [char(1)]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
222/286:
SQL Type: [varchar(1)]
Python Value: [None(NoneType)]
Result Python Value: [X]
223/286:
SQL Type: [varchar(1)]
Python Value: [True(bool)]
Result Python Value: [X]
224/286:
SQL Type: [varchar(1)]
Python Value: [1(int)]
Result Python Value: [X]
225/286:
SQL Type: [varchar(1)]
Python Value: [a(str)]
Result Python Value: [X]
226/286:
SQL Type: [varchar(1)]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
227/286:
SQL Type: [varchar(1)]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
228/286:
SQL Type: [varchar(1)]
Python Value: [1.0(float)]
Result Python Value: [X]
229/286:
SQL Type: [varchar(1)]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
230/286:
SQL Type: [varchar(1)]
Python Value: [[1](list)]
Result Python Value: [X]
231/286:
SQL Type: [varchar(1)]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
232/286:
SQL Type: [varchar(1)]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
233/286:
SQL Type: [varchar(1)]
Python Value: [1(Decimal)]
Result Python Value: [X]
234/286:
SQL Type: [varchar(1)]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
235/286:
SQL Type: [tinyint]
Python Value: [None(NoneType)]
Result Python Value: [None]
236/286:
SQL Type: [tinyint]
Python Value: [True(bool)]
Result Python Value: [None]
237/286:
SQL Type: [tinyint]
Python Value: [1(int)]
Result Python Value: [1]
238/286:
SQL Type: [tinyint]
Python Value: [a(str)]
Result Python Value: [None]
239/286:
SQL Type: [tinyint]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
240/286:
SQL Type: [tinyint]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
241/286:
SQL Type: [tinyint]
Python Value: [1.0(float)]
Result Python Value: [None]
242/286:
SQL Type: [tinyint]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
243/286:
SQL Type: [tinyint]
Python Value: [[1](list)]
Result Python Value: [None]
244/286:
SQL Type: [tinyint]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
245/286:
SQL Type: [tinyint]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [None]
246/286:
SQL Type: [tinyint]
Python Value: [1(Decimal)]
Result Python Value: [None]
247/286:
SQL Type: [tinyint]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
248/286:
SQL Type: [map<string,int>]
Python Value: [None(NoneType)]
Result Python Value: [None]
249/286:
SQL Type: [map<string,int>]
Python Value: [True(bool)]
Result Python Value: [None]
250/286:
SQL Type: [map<string,int>]
Python Value: [1(int)]
Result Python Value: [None]
251/286:
SQL Type: [map<string,int>]
Python Value: [a(str)]
Result Python Value: [None]
252/286:
SQL Type: [map<string,int>]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
253/286:
SQL Type: [map<string,int>]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
254/286:
SQL Type: [map<string,int>]
Python Value: [1.0(float)]
Result Python Value: [None]
255/286:
SQL Type: [map<string,int>]
Python Value: [array('i', [1])(array)]
Result Python Value: [None]
256/286:
SQL Type: [map<string,int>]
Python Value: [[1](list)]
Result Python Value: [None]
257/286:
SQL Type: [map<string,int>]
Python Value: [(1,)(tuple)]
Result Python Value: [None]
258/286:
SQL Type: [map<string,int>]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [None]
259/286:
SQL Type: [map<string,int>]
Python Value: [1(Decimal)]
Result Python Value: [None]
260/286:
SQL Type: [map<string,int>]
Python Value: [{'a': 1}(dict)]
Result Python Value: [{'a': 1}]
261/286:
SQL Type: [array<int>]
Python Value: [None(NoneType)]
Result Python Value: [None]
262/286:
SQL Type: [array<int>]
Python Value: [True(bool)]
Result Python Value: [None]
263/286:
SQL Type: [array<int>]
Python Value: [1(int)]
Result Python Value: [None]
264/286:
SQL Type: [array<int>]
Python Value: [a(str)]
Result Python Value: [None]
265/286:
SQL Type: [array<int>]
Python Value: [1970-01-01(date)]
Result Python Value: [None]
266/286:
SQL Type: [array<int>]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [None]
267/286:
SQL Type: [array<int>]
Python Value: [1.0(float)]
Result Python Value: [None]
268/286:
SQL Type: [array<int>]
Python Value: [array('i', [1])(array)]
Result Python Value: [[1]]
269/286:
SQL Type: [array<int>]
Python Value: [[1](list)]
Result Python Value: [[1]]
270/286:
SQL Type: [array<int>]
Python Value: [(1,)(tuple)]
Result Python Value: [[1]]
271/286:
SQL Type: [array<int>]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [[65, 66, 67]]
272/286:
SQL Type: [array<int>]
Python Value: [1(Decimal)]
Result Python Value: [None]
273/286:
SQL Type: [array<int>]
Python Value: [{'a': 1}(dict)]
Result Python Value: [None]
274/286:
SQL Type: [struct<>]
Python Value: [None(NoneType)]
Result Python Value: [None]
275/286:
SQL Type: [struct<>]
Python Value: [True(bool)]
Result Python Value: [X]
276/286:
SQL Type: [struct<>]
Python Value: [1(int)]
Result Python Value: [X]
277/286:
SQL Type: [struct<>]
Python Value: [a(str)]
Result Python Value: [X]
278/286:
SQL Type: [struct<>]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
279/286:
SQL Type: [struct<>]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
280/286:
SQL Type: [struct<>]
Python Value: [1.0(float)]
Result Python Value: [X]
281/286:
SQL Type: [struct<>]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
282/286:
SQL Type: [struct<>]
Python Value: [[1](list)]
Result Python Value: [X]
283/286:
SQL Type: [struct<>]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
284/286:
SQL Type: [struct<>]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
285/286:
SQL Type: [struct<>]
Python Value: [1(Decimal)]
Result Python Value: [X]
286/286:
SQL Type: [struct<>]
Python Value: [{'a': 1}(dict)]
Result Python Value: [Row()]
# +-----------------------------+--------------+----------+------+---------------+--------------------+-----------------------------+----------+----------------------+---------+--------------------+----------------------------+------------+--------------+ # noqa
# |SQL Type \ Python Value(Type)|None(NoneType)|True(bool)|1(int)| a(str)| 1970-01-01(date)|1970-01-01 00:00:00(datetime)|1.0(float)|array('i', [1])(array)|[1](list)| (1,)(tuple)|bytearray(b'ABC')(bytearray)| 1(Decimal)|{'a': 1}(dict)| # noqa
# +-----------------------------+--------------+----------+------+---------------+--------------------+-----------------------------+----------+----------------------+---------+--------------------+----------------------------+------------+--------------+ # noqa
# | boolean| None| True| None| None| None| None| None| None| None| None| None| None| None| # noqa
# | tinyint| None| None| 1| None| None| None| None| None| None| None| None| None| None| # noqa
# | smallint| None| None| 1| None| None| None| None| None| None| None| None| None| None| # noqa
# | int| None| None| 1| None| None| None| None| None| None| None| None| None| None| # noqa
# | bigint| None| None| 1| None| None| None| None| None| None| None| None| None| None| # noqa
# | string| None| 'true'| '1'| 'a'|'java.util.Gregor...| 'java.util.Gregor...| '1.0'| '[I@456971fd'| '[1]'|'[Ljava.lang.Obje...| '[B@7c4c4a12'| '1'| '{a=1}'| # noqa
# | date| None| X| X| X|datetime.date(197...| datetime.date(197...| X| X| X| X| X| X| X| # noqa
# | timestamp| None| X| X| X| X| datetime.datetime...| X| X| X| X| X| X| X| # noqa
# | float| None| None| None| None| None| None| 1.0| None| None| None| None| None| None| # noqa
# | double| None| None| None| None| None| None| 1.0| None| None| None| None| None| None| # noqa
# | binary| None| None| None|bytearray(b'a')| None| None| None| None| None| None| bytearray(b'ABC')| None| None| # noqa
# | decimal(10,0)| None| None| None| None| None| None| None| None| None| None| None|Decimal('1')| None| # noqa
# | interval year to ...| None| None| None| None| None| None| None| None| None| None| None| None| None| # noqa
# | interval day to s...| None| X| X| X| X| X| X| X| X| X| X| X| X| # noqa
# | timestamp_ntz| None| X| X| X| X| datetime.datetime...| X| X| X| X| X| X| X| # noqa
# | void| None| None| None| None| None| None| None| None| None| None| None| None| None| # noqa
# | char(1)| X| X| X| X| X| X| X| X| X| X| X| X| X| # noqa
# | varchar(1)| X| X| X| X| X| X| X| X| X| X| X| X| X| # noqa
# | tinyint| None| None| 1| None| None| None| None| None| None| None| None| None| None| # noqa
# | map<string,int>| None| None| None| None| None| None| None| None| None| None| None| None| {'a': 1}| # noqa
# | array<int>| None| None| None| None| None| None| None| [1]| [1]| [1]| [65, 66, 67]| None| None| # noqa
# | struct<>| None| X| X| X| X| X| X| X| X| X| X| X| Row()| # noqa
# +-----------------------------+--------------+----------+------+---------------+--------------------+-----------------------------+----------+----------------------+---------+--------------------+----------------------------+------------+--------------+ # noqa
1/286:
SQL Type: [boolean]
Python Value: [None(NoneType)]
Result Python Value: [None]
2/286:
SQL Type: [boolean]
Python Value: [True(bool)]
Result Python Value: [True]
3/286:
SQL Type: [boolean]
Python Value: [1(int)]
Result Python Value: [True]
4/286:
SQL Type: [boolean]
Python Value: [a(str)]
Result Python Value: [X]
5/286:
SQL Type: [boolean]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
6/286:
SQL Type: [boolean]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
7/286:
SQL Type: [boolean]
Python Value: [1.0(float)]
Result Python Value: [True]
8/286:
SQL Type: [boolean]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
9/286:
SQL Type: [boolean]
Python Value: [[1](list)]
Result Python Value: [X]
10/286:
SQL Type: [boolean]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
11/286:
SQL Type: [boolean]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
12/286:
SQL Type: [boolean]
Python Value: [1(Decimal)]
Result Python Value: [X]
13/286:
SQL Type: [boolean]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
14/286:
SQL Type: [tinyint]
Python Value: [None(NoneType)]
Result Python Value: [None]
15/286:
SQL Type: [tinyint]
Python Value: [True(bool)]
Result Python Value: [1]
16/286:
SQL Type: [tinyint]
Python Value: [1(int)]
Result Python Value: [1]
17/286:
SQL Type: [tinyint]
Python Value: [a(str)]
Result Python Value: [X]
18/286:
SQL Type: [tinyint]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
19/286:
SQL Type: [tinyint]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
20/286:
SQL Type: [tinyint]
Python Value: [1.0(float)]
Result Python Value: [1]
21/286:
SQL Type: [tinyint]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
22/286:
SQL Type: [tinyint]
Python Value: [[1](list)]
Result Python Value: [X]
23/286:
SQL Type: [tinyint]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
24/286:
SQL Type: [tinyint]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
25/286:
SQL Type: [tinyint]
Python Value: [1(Decimal)]
Result Python Value: [1]
26/286:
SQL Type: [tinyint]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
27/286:
SQL Type: [smallint]
Python Value: [None(NoneType)]
Result Python Value: [None]
28/286:
SQL Type: [smallint]
Python Value: [True(bool)]
Result Python Value: [1]
29/286:
SQL Type: [smallint]
Python Value: [1(int)]
Result Python Value: [1]
30/286:
SQL Type: [smallint]
Python Value: [a(str)]
Result Python Value: [X]
31/286:
SQL Type: [smallint]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
32/286:
SQL Type: [smallint]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
33/286:
SQL Type: [smallint]
Python Value: [1.0(float)]
Result Python Value: [1]
34/286:
SQL Type: [smallint]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
35/286:
SQL Type: [smallint]
Python Value: [[1](list)]
Result Python Value: [X]
36/286:
SQL Type: [smallint]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
37/286:
SQL Type: [smallint]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
38/286:
SQL Type: [smallint]
Python Value: [1(Decimal)]
Result Python Value: [1]
39/286:
SQL Type: [smallint]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
40/286:
SQL Type: [int]
Python Value: [None(NoneType)]
Result Python Value: [None]
41/286:
SQL Type: [int]
Python Value: [True(bool)]
Result Python Value: [1]
42/286:
SQL Type: [int]
Python Value: [1(int)]
Result Python Value: [1]
43/286:
SQL Type: [int]
Python Value: [a(str)]
Result Python Value: [X]
44/286:
SQL Type: [int]
Python Value: [1970-01-01(date)]
Result Python Value: [0]
45/286:
SQL Type: [int]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
46/286:
SQL Type: [int]
Python Value: [1.0(float)]
Result Python Value: [1]
47/286:
SQL Type: [int]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
48/286:
SQL Type: [int]
Python Value: [[1](list)]
Result Python Value: [X]
49/286:
SQL Type: [int]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
50/286:
SQL Type: [int]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
51/286:
SQL Type: [int]
Python Value: [1(Decimal)]
Result Python Value: [1]
52/286:
SQL Type: [int]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
53/286:
SQL Type: [bigint]
Python Value: [None(NoneType)]
Result Python Value: [None]
54/286:
SQL Type: [bigint]
Python Value: [True(bool)]
Result Python Value: [1]
55/286:
SQL Type: [bigint]
Python Value: [1(int)]
Result Python Value: [1]
56/286:
SQL Type: [bigint]
Python Value: [a(str)]
Result Python Value: [X]
57/286:
SQL Type: [bigint]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
58/286:
SQL Type: [bigint]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [0]
59/286:
SQL Type: [bigint]
Python Value: [1.0(float)]
Result Python Value: [1]
60/286:
SQL Type: [bigint]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
61/286:
SQL Type: [bigint]
Python Value: [[1](list)]
Result Python Value: [X]
62/286:
SQL Type: [bigint]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
63/286:
SQL Type: [bigint]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
64/286:
SQL Type: [bigint]
Python Value: [1(Decimal)]
Result Python Value: [1]
65/286:
SQL Type: [bigint]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
66/286:
SQL Type: [string]
Python Value: [None(NoneType)]
Result Python Value: [None]
67/286:
SQL Type: [string]
Python Value: [True(bool)]
Result Python Value: ['True']
68/286:
SQL Type: [string]
Python Value: [1(int)]
Result Python Value: ['1']
69/286:
SQL Type: [string]
Python Value: [a(str)]
Result Python Value: ['a']
70/286:
SQL Type: [string]
Python Value: [1970-01-01(date)]
Result Python Value: ['1970-01-01']
71/286:
SQL Type: [string]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: ['1970-01-01 00:00:00']
72/286:
SQL Type: [string]
Python Value: [1.0(float)]
Result Python Value: ['1.0']
73/286:
SQL Type: [string]
Python Value: [array('i', [1])(array)]
Result Python Value: ["array('i', [1])"]
74/286:
SQL Type: [string]
Python Value: [[1](list)]
Result Python Value: ['[1]']
75/286:
SQL Type: [string]
Python Value: [(1,)(tuple)]
Result Python Value: ['(1,)']
76/286:
SQL Type: [string]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: ["bytearray(b'ABC')"]
77/286:
SQL Type: [string]
Python Value: [1(Decimal)]
Result Python Value: ['1']
78/286:
SQL Type: [string]
Python Value: [{'a': 1}(dict)]
Result Python Value: ["{'a': 1}"]
79/286:
SQL Type: [date]
Python Value: [None(NoneType)]
Result Python Value: [None]
80/286:
SQL Type: [date]
Python Value: [True(bool)]
Result Python Value: [X]
81/286:
SQL Type: [date]
Python Value: [1(int)]
Result Python Value: [X]
82/286:
SQL Type: [date]
Python Value: [a(str)]
Result Python Value: [X]
83/286:
SQL Type: [date]
Python Value: [1970-01-01(date)]
Result Python Value: [datetime.date(1970, 1, 1)]
84/286:
SQL Type: [date]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [datetime.date(1970, 1, 1)]
85/286:
SQL Type: [date]
Python Value: [1.0(float)]
Result Python Value: [X]
86/286:
SQL Type: [date]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
87/286:
SQL Type: [date]
Python Value: [[1](list)]
Result Python Value: [X]
88/286:
SQL Type: [date]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
89/286:
SQL Type: [date]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
90/286:
SQL Type: [date]
Python Value: [1(Decimal)]
Result Python Value: [datetime.date(1970, 1, 2)]
91/286:
SQL Type: [date]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
92/286:
SQL Type: [timestamp]
Python Value: [None(NoneType)]
Result Python Value: [None]
93/286:
SQL Type: [timestamp]
Python Value: [True(bool)]
Result Python Value: [X]
94/286:
SQL Type: [timestamp]
Python Value: [1(int)]
Result Python Value: [datetime.datetime(1970, 1, 1, 0, 0, 0, 1)]
95/286:
SQL Type: [timestamp]
Python Value: [a(str)]
Result Python Value: [X]
96/286:
SQL Type: [timestamp]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
97/286:
SQL Type: [timestamp]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [datetime.datetime(1970, 1, 1, 0, 0)]
98/286:
SQL Type: [timestamp]
Python Value: [1.0(float)]
Result Python Value: [X]
99/286:
SQL Type: [timestamp]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
100/286:
SQL Type: [timestamp]
Python Value: [[1](list)]
Result Python Value: [X]
101/286:
SQL Type: [timestamp]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
102/286:
SQL Type: [timestamp]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
103/286:
SQL Type: [timestamp]
Python Value: [1(Decimal)]
Result Python Value: [datetime.datetime(1970, 1, 1, 0, 0, 0, 1)]
104/286:
SQL Type: [timestamp]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
105/286:
SQL Type: [float]
Python Value: [None(NoneType)]
Result Python Value: [None]
106/286:
SQL Type: [float]
Python Value: [True(bool)]
Result Python Value: [1.0]
107/286:
SQL Type: [float]
Python Value: [1(int)]
Result Python Value: [1.0]
108/286:
SQL Type: [float]
Python Value: [a(str)]
Result Python Value: [X]
109/286:
SQL Type: [float]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
110/286:
SQL Type: [float]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
111/286:
SQL Type: [float]
Python Value: [1.0(float)]
Result Python Value: [1.0]
112/286:
SQL Type: [float]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
113/286:
SQL Type: [float]
Python Value: [[1](list)]
Result Python Value: [X]
114/286:
SQL Type: [float]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
115/286:
SQL Type: [float]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
116/286:
SQL Type: [float]
Python Value: [1(Decimal)]
Result Python Value: [1.0]
117/286:
SQL Type: [float]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
118/286:
SQL Type: [double]
Python Value: [None(NoneType)]
Result Python Value: [None]
119/286:
SQL Type: [double]
Python Value: [True(bool)]
Result Python Value: [1.0]
120/286:
SQL Type: [double]
Python Value: [1(int)]
Result Python Value: [1.0]
121/286:
SQL Type: [double]
Python Value: [a(str)]
Result Python Value: [X]
122/286:
SQL Type: [double]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
123/286:
SQL Type: [double]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
124/286:
SQL Type: [double]
Python Value: [1.0(float)]
Result Python Value: [1.0]
125/286:
SQL Type: [double]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
126/286:
SQL Type: [double]
Python Value: [[1](list)]
Result Python Value: [X]
127/286:
SQL Type: [double]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
128/286:
SQL Type: [double]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
129/286:
SQL Type: [double]
Python Value: [1(Decimal)]
Result Python Value: [1.0]
130/286:
SQL Type: [double]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
131/286:
SQL Type: [binary]
Python Value: [None(NoneType)]
Result Python Value: [None]
132/286:
SQL Type: [binary]
Python Value: [True(bool)]
Result Python Value: [bytearray(b'\x00')]
133/286:
SQL Type: [binary]
Python Value: [1(int)]
Result Python Value: [bytearray(b'\x00')]
134/286:
SQL Type: [binary]
Python Value: [a(str)]
Result Python Value: [X]
135/286:
SQL Type: [binary]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
136/286:
SQL Type: [binary]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
137/286:
SQL Type: [binary]
Python Value: [1.0(float)]
Result Python Value: [X]
138/286:
SQL Type: [binary]
Python Value: [array('i', [1])(array)]
Result Python Value: [bytearray(b'\x01\x00\x00\x00')]
139/286:
SQL Type: [binary]
Python Value: [[1](list)]
Result Python Value: [bytearray(b'\x01')]
140/286:
SQL Type: [binary]
Python Value: [(1,)(tuple)]
Result Python Value: [bytearray(b'\x01')]
141/286:
SQL Type: [binary]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [bytearray(b'ABC')]
142/286:
SQL Type: [binary]
Python Value: [1(Decimal)]
Result Python Value: [X]
143/286:
SQL Type: [binary]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
144/286:
SQL Type: [decimal(10,0)]
Python Value: [None(NoneType)]
Result Python Value: [None]
145/286:
SQL Type: [decimal(10,0)]
Python Value: [True(bool)]
Result Python Value: [X]
146/286:
SQL Type: [decimal(10,0)]
Python Value: [1(int)]
Result Python Value: [X]
147/286:
SQL Type: [decimal(10,0)]
Python Value: [a(str)]
Result Python Value: [X]
148/286:
SQL Type: [decimal(10,0)]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
149/286:
SQL Type: [decimal(10,0)]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
150/286:
SQL Type: [decimal(10,0)]
Python Value: [1.0(float)]
Result Python Value: [Decimal('1')]
151/286:
SQL Type: [decimal(10,0)]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
152/286:
SQL Type: [decimal(10,0)]
Python Value: [[1](list)]
Result Python Value: [X]
153/286:
SQL Type: [decimal(10,0)]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
154/286:
SQL Type: [decimal(10,0)]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
155/286:
SQL Type: [decimal(10,0)]
Python Value: [1(Decimal)]
Result Python Value: [Decimal('1')]
156/286:
SQL Type: [decimal(10,0)]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
157/286:
SQL Type: [interval year to month]
Python Value: [None(NoneType)]
Result Python Value: [X]
158/286:
SQL Type: [interval year to month]
Python Value: [True(bool)]
Result Python Value: [X]
159/286:
SQL Type: [interval year to month]
Python Value: [1(int)]
Result Python Value: [X]
160/286:
SQL Type: [interval year to month]
Python Value: [a(str)]
Result Python Value: [X]
161/286:
SQL Type: [interval year to month]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
162/286:
SQL Type: [interval year to month]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
163/286:
SQL Type: [interval year to month]
Python Value: [1.0(float)]
Result Python Value: [X]
164/286:
SQL Type: [interval year to month]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
165/286:
SQL Type: [interval year to month]
Python Value: [[1](list)]
Result Python Value: [X]
166/286:
SQL Type: [interval year to month]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
167/286:
SQL Type: [interval year to month]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
168/286:
SQL Type: [interval year to month]
Python Value: [1(Decimal)]
Result Python Value: [X]
169/286:
SQL Type: [interval year to month]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
170/286:
SQL Type: [interval day to second]
Python Value: [None(NoneType)]
Result Python Value: [None]
171/286:
SQL Type: [interval day to second]
Python Value: [True(bool)]
Result Python Value: [X]
172/286:
SQL Type: [interval day to second]
Python Value: [1(int)]
Result Python Value: [datetime.timedelta(microseconds=1)]
173/286:
SQL Type: [interval day to second]
Python Value: [a(str)]
Result Python Value: [X]
174/286:
SQL Type: [interval day to second]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
175/286:
SQL Type: [interval day to second]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
176/286:
SQL Type: [interval day to second]
Python Value: [1.0(float)]
Result Python Value: [X]
177/286:
SQL Type: [interval day to second]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
178/286:
SQL Type: [interval day to second]
Python Value: [[1](list)]
Result Python Value: [X]
179/286:
SQL Type: [interval day to second]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
180/286:
SQL Type: [interval day to second]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
181/286:
SQL Type: [interval day to second]
Python Value: [1(Decimal)]
Result Python Value: [datetime.timedelta(microseconds=1)]
182/286:
SQL Type: [interval day to second]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
183/286:
SQL Type: [timestamp_ntz]
Python Value: [None(NoneType)]
Result Python Value: [None]
184/286:
SQL Type: [timestamp_ntz]
Python Value: [True(bool)]
Result Python Value: [X]
185/286:
SQL Type: [timestamp_ntz]
Python Value: [1(int)]
Result Python Value: [datetime.datetime(1970, 1, 1, 0, 0, 0, 1)]
186/286:
SQL Type: [timestamp_ntz]
Python Value: [a(str)]
Result Python Value: [X]
187/286:
SQL Type: [timestamp_ntz]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
188/286:
SQL Type: [timestamp_ntz]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [datetime.datetime(1970, 1, 1, 0, 0)]
189/286:
SQL Type: [timestamp_ntz]
Python Value: [1.0(float)]
Result Python Value: [X]
190/286:
SQL Type: [timestamp_ntz]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
191/286:
SQL Type: [timestamp_ntz]
Python Value: [[1](list)]
Result Python Value: [X]
192/286:
SQL Type: [timestamp_ntz]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
193/286:
SQL Type: [timestamp_ntz]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
194/286:
SQL Type: [timestamp_ntz]
Python Value: [1(Decimal)]
Result Python Value: [datetime.datetime(1970, 1, 1, 0, 0, 0, 1)]
195/286:
SQL Type: [timestamp_ntz]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
196/286:
SQL Type: [void]
Python Value: [None(NoneType)]
Result Python Value: [None]
197/286:
SQL Type: [void]
Python Value: [True(bool)]
Result Python Value: [X]
198/286:
SQL Type: [void]
Python Value: [1(int)]
Result Python Value: [X]
199/286:
SQL Type: [void]
Python Value: [a(str)]
Result Python Value: [X]
200/286:
SQL Type: [void]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
201/286:
SQL Type: [void]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
202/286:
SQL Type: [void]
Python Value: [1.0(float)]
Result Python Value: [X]
203/286:
SQL Type: [void]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
204/286:
SQL Type: [void]
Python Value: [[1](list)]
Result Python Value: [X]
205/286:
SQL Type: [void]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
206/286:
SQL Type: [void]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
207/286:
SQL Type: [void]
Python Value: [1(Decimal)]
Result Python Value: [X]
208/286:
SQL Type: [void]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
209/286:
SQL Type: [char(1)]
Python Value: [None(NoneType)]
Result Python Value: [X]
210/286:
SQL Type: [char(1)]
Python Value: [True(bool)]
Result Python Value: [X]
211/286:
SQL Type: [char(1)]
Python Value: [1(int)]
Result Python Value: [X]
212/286:
SQL Type: [char(1)]
Python Value: [a(str)]
Result Python Value: [X]
213/286:
SQL Type: [char(1)]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
214/286:
SQL Type: [char(1)]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
215/286:
SQL Type: [char(1)]
Python Value: [1.0(float)]
Result Python Value: [X]
216/286:
SQL Type: [char(1)]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
217/286:
SQL Type: [char(1)]
Python Value: [[1](list)]
Result Python Value: [X]
218/286:
SQL Type: [char(1)]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
219/286:
SQL Type: [char(1)]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
220/286:
SQL Type: [char(1)]
Python Value: [1(Decimal)]
Result Python Value: [X]
221/286:
SQL Type: [char(1)]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
222/286:
SQL Type: [varchar(1)]
Python Value: [None(NoneType)]
Result Python Value: [X]
223/286:
SQL Type: [varchar(1)]
Python Value: [True(bool)]
Result Python Value: [X]
224/286:
SQL Type: [varchar(1)]
Python Value: [1(int)]
Result Python Value: [X]
225/286:
SQL Type: [varchar(1)]
Python Value: [a(str)]
Result Python Value: [X]
226/286:
SQL Type: [varchar(1)]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
227/286:
SQL Type: [varchar(1)]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
228/286:
SQL Type: [varchar(1)]
Python Value: [1.0(float)]
Result Python Value: [X]
229/286:
SQL Type: [varchar(1)]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
230/286:
SQL Type: [varchar(1)]
Python Value: [[1](list)]
Result Python Value: [X]
231/286:
SQL Type: [varchar(1)]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
232/286:
SQL Type: [varchar(1)]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
233/286:
SQL Type: [varchar(1)]
Python Value: [1(Decimal)]
Result Python Value: [X]
234/286:
SQL Type: [varchar(1)]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
235/286:
SQL Type: [tinyint]
Python Value: [None(NoneType)]
Result Python Value: [None]
236/286:
SQL Type: [tinyint]
Python Value: [True(bool)]
Result Python Value: [1]
237/286:
SQL Type: [tinyint]
Python Value: [1(int)]
Result Python Value: [1]
238/286:
SQL Type: [tinyint]
Python Value: [a(str)]
Result Python Value: [X]
239/286:
SQL Type: [tinyint]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
240/286:
SQL Type: [tinyint]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
241/286:
SQL Type: [tinyint]
Python Value: [1.0(float)]
Result Python Value: [1]
242/286:
SQL Type: [tinyint]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
243/286:
SQL Type: [tinyint]
Python Value: [[1](list)]
Result Python Value: [X]
244/286:
SQL Type: [tinyint]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
245/286:
SQL Type: [tinyint]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
246/286:
SQL Type: [tinyint]
Python Value: [1(Decimal)]
Result Python Value: [1]
247/286:
SQL Type: [tinyint]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
248/286:
SQL Type: [map<string,int>]
Python Value: [None(NoneType)]
Result Python Value: [None]
249/286:
SQL Type: [map<string,int>]
Python Value: [True(bool)]
Result Python Value: [X]
250/286:
SQL Type: [map<string,int>]
Python Value: [1(int)]
Result Python Value: [X]
251/286:
SQL Type: [map<string,int>]
Python Value: [a(str)]
Result Python Value: [X]
252/286:
SQL Type: [map<string,int>]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
253/286:
SQL Type: [map<string,int>]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
254/286:
SQL Type: [map<string,int>]
Python Value: [1.0(float)]
Result Python Value: [X]
255/286:
SQL Type: [map<string,int>]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
256/286:
SQL Type: [map<string,int>]
Python Value: [[1](list)]
Result Python Value: [X]
257/286:
SQL Type: [map<string,int>]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
258/286:
SQL Type: [map<string,int>]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
259/286:
SQL Type: [map<string,int>]
Python Value: [1(Decimal)]
Result Python Value: [X]
260/286:
SQL Type: [map<string,int>]
Python Value: [{'a': 1}(dict)]
Result Python Value: [{'a': 1}]
261/286:
SQL Type: [array<int>]
Python Value: [None(NoneType)]
Result Python Value: [None]
262/286:
SQL Type: [array<int>]
Python Value: [True(bool)]
Result Python Value: [X]
263/286:
SQL Type: [array<int>]
Python Value: [1(int)]
Result Python Value: [X]
264/286:
SQL Type: [array<int>]
Python Value: [a(str)]
Result Python Value: [X]
265/286:
SQL Type: [array<int>]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
266/286:
SQL Type: [array<int>]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
267/286:
SQL Type: [array<int>]
Python Value: [1.0(float)]
Result Python Value: [X]
268/286:
SQL Type: [array<int>]
Python Value: [array('i', [1])(array)]
Result Python Value: [[1]]
269/286:
SQL Type: [array<int>]
Python Value: [[1](list)]
Result Python Value: [[1]]
270/286:
SQL Type: [array<int>]
Python Value: [(1,)(tuple)]
Result Python Value: [[1]]
271/286:
SQL Type: [array<int>]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [[65, 66, 67]]
272/286:
SQL Type: [array<int>]
Python Value: [1(Decimal)]
Result Python Value: [X]
273/286:
SQL Type: [array<int>]
Python Value: [{'a': 1}(dict)]
Result Python Value: [X]
274/286:
SQL Type: [struct<>]
Python Value: [None(NoneType)]
Result Python Value: [None]
275/286:
SQL Type: [struct<>]
Python Value: [True(bool)]
Result Python Value: [X]
276/286:
SQL Type: [struct<>]
Python Value: [1(int)]
Result Python Value: [X]
277/286:
SQL Type: [struct<>]
Python Value: [a(str)]
Result Python Value: [X]
278/286:
SQL Type: [struct<>]
Python Value: [1970-01-01(date)]
Result Python Value: [X]
279/286:
SQL Type: [struct<>]
Python Value: [1970-01-01 00:00:00(datetime)]
Result Python Value: [X]
280/286:
SQL Type: [struct<>]
Python Value: [1.0(float)]
Result Python Value: [X]
281/286:
SQL Type: [struct<>]
Python Value: [array('i', [1])(array)]
Result Python Value: [X]
282/286:
SQL Type: [struct<>]
Python Value: [[1](list)]
Result Python Value: [X]
283/286:
SQL Type: [struct<>]
Python Value: [(1,)(tuple)]
Result Python Value: [X]
284/286:
SQL Type: [struct<>]
Python Value: [bytearray(b'ABC')(bytearray)]
Result Python Value: [X]
285/286:
SQL Type: [struct<>]
Python Value: [1(Decimal)]
Result Python Value: [X]
286/286:
SQL Type: [struct<>]
Python Value: [{'a': 1}(dict)]
Result Python Value: [Row()]
# +-----------------------------+--------------+------------------+--------------------+------+--------------------+-----------------------------+------------+----------------------+------------------+------------------+----------------------------+--------------------+--------------+ # noqa
# |SQL Type \ Python Value(Type)|None(NoneType)| True(bool)| 1(int)|a(str)| 1970-01-01(date)|1970-01-01 00:00:00(datetime)| 1.0(float)|array('i', [1])(array)| [1](list)| (1,)(tuple)|bytearray(b'ABC')(bytearray)| 1(Decimal)|{'a': 1}(dict)| # noqa
# +-----------------------------+--------------+------------------+--------------------+------+--------------------+-----------------------------+------------+----------------------+------------------+------------------+----------------------------+--------------------+--------------+ # noqa
# | boolean| None| True| True| X| X| X| True| X| X| X| X| X| X| # noqa
# | tinyint| None| 1| 1| X| X| X| 1| X| X| X| X| 1| X| # noqa
# | smallint| None| 1| 1| X| X| X| 1| X| X| X| X| 1| X| # noqa
# | int| None| 1| 1| X| 0| X| 1| X| X| X| X| 1| X| # noqa
# | bigint| None| 1| 1| X| X| 0| 1| X| X| X| X| 1| X| # noqa
# | string| None| 'True'| '1'| 'a'| '1970-01-01'| '1970-01-01 00:00...| '1.0'| "array('i', [1])"| '[1]'| '(1,)'| "bytearray(b'ABC')"| '1'| "{'a': 1}"| # noqa
# | date| None| X| X| X|datetime.date(197...| datetime.date(197...| X| X| X| X| X|datetime.date(197...| X| # noqa
# | timestamp| None| X|datetime.datetime...| X| X| datetime.datetime...| X| X| X| X| X|datetime.datetime...| X| # noqa
# | float| None| 1.0| 1.0| X| X| X| 1.0| X| X| X| X| 1.0| X| # noqa
# | double| None| 1.0| 1.0| X| X| X| 1.0| X| X| X| X| 1.0| X| # noqa
# | binary| None|bytearray(b'\x00')| bytearray(b'\x00')| X| X| X| X| bytearray(b'\x01\...|bytearray(b'\x01')|bytearray(b'\x01')| bytearray(b'ABC')| X| X| # noqa
# | decimal(10,0)| None| X| X| X| X| X|Decimal('1')| X| X| X| X| Decimal('1')| X| # noqa
# | interval year to ...| X| X| X| X| X| X| X| X| X| X| X| X| X| # noqa
# | interval day to s...| None| X|datetime.timedelt...| X| X| X| X| X| X| X| X|datetime.timedelt...| X| # noqa
# | timestamp_ntz| None| X|datetime.datetime...| X| X| datetime.datetime...| X| X| X| X| X|datetime.datetime...| X| # noqa
# | void| None| X| X| X| X| X| X| X| X| X| X| X| X| # noqa
# | char(1)| X| X| X| X| X| X| X| X| X| X| X| X| X| # noqa
# | varchar(1)| X| X| X| X| X| X| X| X| X| X| X| X| X| # noqa
# | tinyint| None| 1| 1| X| X| X| 1| X| X| X| X| 1| X| # noqa
# | map<string,int>| None| X| X| X| X| X| X| X| X| X| X| X| {'a': 1}| # noqa
# | array<int>| None| X| X| X| X| X| X| [1]| [1]| [1]| [65, 66, 67]| X| X| # noqa
# | struct<>| None| X| X| X| X| X| X| X| X| X| X| X| Row()| # noqa
# +-----------------------------+--------------+------------------+--------------------+------+--------------------+-----------------------------+------------+----------------------+------------------+------------------+----------------------------+--------------------+--------------+ # noqa
Python UDF - Type Coercion
The notebook contains