Menu

#55 Fix row counter sql generation

v1.0_(example)
closed-fixed
nobody
None
1
2025-10-10
2025-10-01
Anonymous
No
Fix row couter sql.

diff --git a/src/main/gui/net/sf/jailer/ui/databrowser/RowCounter.java b/src/main/gui/net/sf/jailer/ui/databrowser/RowCounter.java
index bd9c3089e..b8b081f46 100644
--- a/src/main/gui/net/sf/jailer/ui/databrowser/RowCounter.java
+++ b/src/main/gui/net/sf/jailer/ui/databrowser/RowCounter.java
@@ -251,7 +251,7 @@ public class RowCounter {

        if (association != null) {
            olapPrefix += " From (Select distinct ";
  • olapSuffix += ") S2 Where S2." + ROWNUMBERALIAS + " <= \" + limit";
  • olapSuffix += ") S2 Where S2." + ROWNUMBERALIAS + " <= " + limit;
    boolean f = true;
    for (Column pkColumn: rowIdSupport.getPrimaryKey(association.destination).getColumns()) {
    if (!f) {

Discussion

  • Anonymous

    Anonymous - 2025-10-01
    commit cee86d6f0ae16b56a2c32e48e22c110a8727ac7b
    Author: Jean-François Veillette <jveillette@apple.com>
    Date:   Wed Oct 1 17:15:59 2025 -0400
    
        Fix row couter sql.
    
    diff --git a/src/main/gui/net/sf/jailer/ui/databrowser/RowCounter.java b/src/main/gui/net/sf/jailer/ui/databrowser/RowCounter.java
    index bd9c3089e..b8b081f46 100644
    --- a/src/main/gui/net/sf/jailer/ui/databrowser/RowCounter.java
    +++ b/src/main/gui/net/sf/jailer/ui/databrowser/RowCounter.java
    @@ -251,7 +251,7 @@ public class RowCounter {
    
                if (association != null) {
                    olapPrefix += " From (Select distinct ";
    
    -               olapSuffix += ") S2 Where S2." + ROWNUMBERALIAS + " <= \" + limit";
    +               olapSuffix += ") S2 Where S2." + ROWNUMBERALIAS + " <= " + limit;
                    boolean f = true;
                    for (Column pkColumn: rowIdSupport.getPrimaryKey(association.destination).getColumns()) {
                        if (!f) {
    
     
  • Ralf Wisser

    Ralf Wisser - 2025-10-01

    Thank you very much.

     
  • Ralf Wisser

    Ralf Wisser - 2025-10-10
    • status: open --> closed-fixed
     
  • Ralf Wisser

    Ralf Wisser - 2025-10-10

    Fixed in 16.9.2

     

    Last edit: Ralf Wisser 2025-10-10

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB