Smalltalk › Cincom › VisualWorks

GHAdHocQueryTool broken for some values?

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Dave & Vicki Stevenson

GHAdHocQueryTool broken for some values?

I'm using VW 7.9.1

I have an Oracle column defined as NUMBER with the following values:
99999999999999999999999999999999999998
99999999999999999999999999999999999996
99999999999999999999999999999999999994

The following query works with AdHocQueryTool:
select myColumn from myTable where myColumn >
9999999999999999999999999999999999999

but it breaks in GHAdHocQueryTool with a subscript out of bounds error.

--
[hidden email]

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Dave & Vicki Stevenson

Re: GHAdHocQueryTool broken for some values?

My mistake. It does not happen with a type of data, but with the number
of rows returned. In #updateTable:columns: we get the widths:

dataWidths := self columnWidthsFromData: (list copyFrom: 1 to: 10).

But if there are fewer than 10 rows, it breaks. We could instead do:

dataWidths := self columnWidthsFromData: (list copyFrom: 1 to: (10
min: list size)).

[hidden email]

On 2/15/2013 10:11 AM, Dave wrote:

> I'm using VW 7.9.1
>
> I have an Oracle column defined as NUMBER with the following values:
> 99999999999999999999999999999999999998
> 99999999999999999999999999999999999996
> 99999999999999999999999999999999999994
>
> The following query works with AdHocQueryTool:
> select myColumn from myTable where myColumn >
> 9999999999999999999999999999999999999
>
> but it breaks in GHAdHocQueryTool with a subscript out of bounds error.
>

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Holger Guhl

Re: GHAdHocQueryTool broken for some values?

Here is my latest version (plus the isolated fix). I thought that we had the fix published for
VW791, but obviously that's not the case. Your fix goes in the right direction, but please don't
repeat those two errors that we made while fixing it ;-) .

Cheers

Am 15.02.2013 20:17, schrieb Dave:

> My mistake. It does not happen with a type of data, but with the number of rows returned. In
> #updateTable:columns: we get the widths:
>
> dataWidths := self columnWidthsFromData: (list copyFrom: 1 to: 10).
>
> But if there are fewer than 10 rows, it breaks. We could instead do:
>
> dataWidths := self columnWidthsFromData: (list copyFrom: 1 to: (10 min: list size)).
>
> [hidden email]
>
> On 2/15/2013 10:11 AM, Dave wrote:
>> I'm using VW 7.9.1
>>
>> I have an Oracle column defined as NUMBER with the following values:
>> 99999999999999999999999999999999999998
>> 99999999999999999999999999999999999996
>> 99999999999999999999999999999999999994
>>
>> The following query works with AdHocQueryTool:
>> select myColumn from myTable where myColumn > 9999999999999999999999999999999999999
>>
>> but it breaks in GHAdHocQueryTool with a subscript out of bounds error.
>>
>
> _______________________________________________
> vwnc mailing list
> [hidden email]
> http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
>

Holger Guhl
--
Senior Consultant * Certified Scrum Master * [hidden email]
Tel: +49 231 9 75 99 21 * Fax: +49 231 9 75 99 20
Georg Heeg eK Dortmund
Handelsregister: Amtsgericht Dortmund A 12812

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

GHAdHocQueryTool-7.9-9.zip (26K) Download Attachment

GHAdHocQueryTool-updateTablecolumns.st (2K) Download Attachment