d1
-12345678901234567890123456789012345678
12345678901234567890123456789012345678
-99999999999999999999999999999999999998
CALSHOWPARTITIONS('cs1', 'd1')
Part#     Min                                       Max                                       Status\n  0.0.1     -99999999999999999999999999999999999998   12345678901234567890123456789012345678    Enabled
CALSETTRACE(1)
0
Level	Code	Message
Note	9999	Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-0; CacheI/O-0; BlocksTouched-0; PartitionBlocksEliminated-1; MsgBytesIn-0B; MsgBytesOut-356B; Mode-Distributed
d1
-12345678901234567890123456789012345678
12345678901234567890123456789012345678
Level	Code	Message
Note	9999	Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-0; CacheI/O-1; BlocksTouched-1; PartitionBlocksEliminated-0; MsgBytesIn-163B; MsgBytesOut-417B; Mode-Distributed
Level	Code	Message
Note	9999	Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-0; CacheI/O-0; BlocksTouched-0; PartitionBlocksEliminated-1; MsgBytesIn-0B; MsgBytesOut-374B; Mode-Distributed
d1
-1234567890123456789012345678.9012345678
1234567890123456789012345678.9012345678
-9999999999999999999999999999.9999999998
CALSHOWPARTITIONS('cs2', 'd1')
Part#     Min                                       Max                                       Status\n  0.0.1     -9999999999999999999999999999.9999999998  1234567890123456789012345678.9012345678   Enabled
CALSETTRACE(1)
1
Level	Code	Message
Note	9999	Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-0; CacheI/O-0; BlocksTouched-0; PartitionBlocksEliminated-1; MsgBytesIn-0B; MsgBytesOut-356B; Mode-Distributed
d1
-1234567890123456789012345678.9012345678
1234567890123456789012345678.9012345678
Level	Code	Message
Note	9999	Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-0; CacheI/O-1; BlocksTouched-1; PartitionBlocksEliminated-0; MsgBytesIn-163B; MsgBytesOut-417B; Mode-Distributed
Level	Code	Message
Note	9999	Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-0; CacheI/O-0; BlocksTouched-0; PartitionBlocksEliminated-1; MsgBytesIn-0B; MsgBytesOut-374B; Mode-Distributed
d1
-0.12345678901234567890123456789012345678
0.12345678901234567890123456789012345678
-0.99999999999999999999999999999999999998
CALSHOWPARTITIONS('cs3', 'd1')
Part#     Min                                       Max                                       Status\n  0.0.1     -0.99999999999999999999999999999999999998 0.12345678901234567890123456789012345678  Enabled
CALSETTRACE(1)
1
Level	Code	Message
Note	9999	Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-0; CacheI/O-0; BlocksTouched-0; PartitionBlocksEliminated-1; MsgBytesIn-0B; MsgBytesOut-356B; Mode-Distributed
d1
-0.12345678901234567890123456789012345678
0.12345678901234567890123456789012345678
Level	Code	Message
Note	9999	Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-0; CacheI/O-1; BlocksTouched-1; PartitionBlocksEliminated-0; MsgBytesIn-163B; MsgBytesOut-417B; Mode-Distributed
Level	Code	Message
Note	9999	Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-0; CacheI/O-0; BlocksTouched-0; PartitionBlocksEliminated-1; MsgBytesIn-0B; MsgBytesOut-374B; Mode-Distributed