You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Stefan Kuhn <sk...@ai-ag.de> on 2018/10/30 12:23:47 UTC

Sorting of solr.CurrencyFieldType in 7.3.1

Hi,

last week I found an error in the result sorting regarding a field of the type "solr.CurrencyFieldType" in solr version 7.3.1.

There are multiple documents which I must sort with this field, but the order of the result is apparently not correctly sorted after the sorting parameters (price_net asc). Other sorting parameters work fine.

Response (field price_net, sorted by "price_net asc"):
"6252.40000,EUR"
"5978.00000,EUR"
"5917.00000,EUR"
"6660.00000,EUR"
"5570.00000,EUR"
"999999999999999.00000,EUR"

Is there a known bug regarding sorting of "solr.CurrencyFieldType" type fields that I am not aware of?


Additional information:

Sorting parameter: price_net asc

The field definition in the used schema:
<field name="price_net" type="currency" multiValued="false" indexed="true" required="false" stored="true"/>

The definition oft he field type:
<fieldType name="currency" class="solr.CurrencyFieldType" currencyConfig="currency.xml"
      amountLongSuffix="_l_ns" codeStrSuffix="_s_ns" defaultCurrency="EUR"/>
<dynamicField name="*_l_ns"  type="plong"   indexed="true"  stored="false"/>
<dynamicField name="*_s_ns"  type="string"  indexed="true"  stored="false" />

Best regards,
Stefan



Besuchen Sie uns auf folgenden Veranstaltungen:
20.11.2018             Smart-Country-Convention, Messe Berlin, Konferenz A, Halle A
                               (11:30 - 12:00 Uhr Vortrag zum Thema "Smart Public procurement - eVergabe")

Gerne k?nnen Sie im Vorfeld Termine vereinbaren: vertrieb@ai-ag.de<ma...@ai-ag.de>. Wir freuen uns auf Ihren Besuch.

Administration Intelligence AG | Ein Unternehmen der Prof. Thome Gruppe
Steinbachtal 2b | 97082 W?rzburg | Telefon: +49 931 730 46-200 | Fax: +49 931 73046-99-200
Vorstand: Dr. Christian Schneider (Vors.), Christian Baltes, Frank Linneberg, Alexander N. M?ller
Aufsichtsratsvorsitzender: Prof. Dr. Rainer Thome | HRB 7176 Amtsgericht W?rzburg

Re: Sorting of solr.CurrencyFieldType in 7.3.1

Posted by Erick Erickson <er...@gmail.com>.
Chris:

Please follow the instructions here:
http://lucene.apache.org/solr/community.html#mailing-lists-irc. You
must use the _exact_ same e-mail as you used to subscribe.

If the initial try doesn't work and following the suggestions at the
"problems" link doesn't work for you, let us know. But note you need
to show us the _entire_ return header to allow anyone to diagnose the
problem.

Best,
Erick
On Tue, Oct 30, 2018 at 5:59 AM Chris Gerke <ch...@gmail.com> wrote:
>
> UNSUBSCRIBE
>
> On Tue, 30 Oct 2018 at 8:24 pm, Stefan Kuhn <sk...@ai-ag.de> wrote:
>
> > Hi,
> >
> > last week I found an error in the result sorting regarding a field of the
> > type "solr.CurrencyFieldType" in solr version 7.3.1.
> >
> > There are multiple documents which I must sort with this field, but the
> > order of the result is apparently not correctly sorted after the sorting
> > parameters (price_net asc). Other sorting parameters work fine.
> >
> > Response (field price_net, sorted by "price_net asc"):
> > "6252.40000,EUR"
> > "5978.00000,EUR"
> > "5917.00000,EUR"
> > "6660.00000,EUR"
> > "5570.00000,EUR"
> > "999999999999999.00000,EUR"
> >
> > Is there a known bug regarding sorting of "solr.CurrencyFieldType" type
> > fields that I am not aware of?
> >
> >
> > Additional information:
> >
> > Sorting parameter: price_net asc
> >
> > The field definition in the used schema:
> > <field name="price_net" type="currency" multiValued="false" indexed="true"
> > required="false" stored="true"/>
> >
> > The definition oft he field type:
> > <fieldType name="currency" class="solr.CurrencyFieldType"
> > currencyConfig="currency.xml"
> >       amountLongSuffix="_l_ns" codeStrSuffix="_s_ns"
> > defaultCurrency="EUR"/>
> > <dynamicField name="*_l_ns"  type="plong"   indexed="true"
> > stored="false"/>
> > <dynamicField name="*_s_ns"  type="string"  indexed="true"  stored="false"
> > />
> >
> > Best regards,
> > Stefan
> >
> >
> >
> > Besuchen Sie uns auf folgenden Veranstaltungen:
> > 20.11.2018             Smart-Country-Convention, Messe Berlin, Konferenz
> > A, Halle A
> >                                (11:30 - 12:00 Uhr Vortrag zum Thema "Smart
> > Public procurement - eVergabe")
> >
> > Gerne k?nnen Sie im Vorfeld Termine vereinbaren: vertrieb@ai-ag.de<mailto:
> > vertrieb@ai-ag.de>. Wir freuen uns auf Ihren Besuch.
> >
> > Administration Intelligence AG | Ein Unternehmen der Prof. Thome Gruppe
> > Steinbachtal 2b | 97082
> > <https://maps.google.com/?q=Steinbachtal+2b+%7C+97082&entry=gmail&source=g>
> > W?rzburg | Telefon: +49 931 730 46-200 | Fax: +49 931 73046-99-200
> > Vorstand: Dr. Christian Schneider (Vors.), Christian Baltes, Frank
> > Linneberg, Alexander N. M?ller
> > Aufsichtsratsvorsitzender: Prof. Dr. Rainer Thome | HRB 7176 Amtsgericht
> > W?rzburg
> >

Re: Sorting of solr.CurrencyFieldType in 7.3.1

Posted by Chris Gerke <ch...@gmail.com>.
UNSUBSCRIBE

On Tue, 30 Oct 2018 at 8:24 pm, Stefan Kuhn <sk...@ai-ag.de> wrote:

> Hi,
>
> last week I found an error in the result sorting regarding a field of the
> type "solr.CurrencyFieldType" in solr version 7.3.1.
>
> There are multiple documents which I must sort with this field, but the
> order of the result is apparently not correctly sorted after the sorting
> parameters (price_net asc). Other sorting parameters work fine.
>
> Response (field price_net, sorted by "price_net asc"):
> "6252.40000,EUR"
> "5978.00000,EUR"
> "5917.00000,EUR"
> "6660.00000,EUR"
> "5570.00000,EUR"
> "999999999999999.00000,EUR"
>
> Is there a known bug regarding sorting of "solr.CurrencyFieldType" type
> fields that I am not aware of?
>
>
> Additional information:
>
> Sorting parameter: price_net asc
>
> The field definition in the used schema:
> <field name="price_net" type="currency" multiValued="false" indexed="true"
> required="false" stored="true"/>
>
> The definition oft he field type:
> <fieldType name="currency" class="solr.CurrencyFieldType"
> currencyConfig="currency.xml"
>       amountLongSuffix="_l_ns" codeStrSuffix="_s_ns"
> defaultCurrency="EUR"/>
> <dynamicField name="*_l_ns"  type="plong"   indexed="true"
> stored="false"/>
> <dynamicField name="*_s_ns"  type="string"  indexed="true"  stored="false"
> />
>
> Best regards,
> Stefan
>
>
>
> Besuchen Sie uns auf folgenden Veranstaltungen:
> 20.11.2018             Smart-Country-Convention, Messe Berlin, Konferenz
> A, Halle A
>                                (11:30 - 12:00 Uhr Vortrag zum Thema "Smart
> Public procurement - eVergabe")
>
> Gerne k?nnen Sie im Vorfeld Termine vereinbaren: vertrieb@ai-ag.de<mailto:
> vertrieb@ai-ag.de>. Wir freuen uns auf Ihren Besuch.
>
> Administration Intelligence AG | Ein Unternehmen der Prof. Thome Gruppe
> Steinbachtal 2b | 97082
> <https://maps.google.com/?q=Steinbachtal+2b+%7C+97082&entry=gmail&source=g>
> W?rzburg | Telefon: +49 931 730 46-200 | Fax: +49 931 73046-99-200
> Vorstand: Dr. Christian Schneider (Vors.), Christian Baltes, Frank
> Linneberg, Alexander N. M?ller
> Aufsichtsratsvorsitzender: Prof. Dr. Rainer Thome | HRB 7176 Amtsgericht
> W?rzburg
>