junit.framework.AssertionFailedError: expected query [select `customer`.`gender` as `c0` from `customer` as `customer`, `sales_fact_1997` as `sales_fact_1997` where `sales_fact_1997`.`customer_id` = `customer`.`customer_id` group by `customer`.`gender` order by ISNULL('c0') ASC, `c0` ASC] did not occur

GitHub | lucboudreau | 1 month ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    GitHub comment 808#271703263

    GitHub | 1 month ago | lucboudreau
    junit.framework.AssertionFailedError: expected query [select `customer`.`gender` as `c0` from `customer` as `customer`, `sales_fact_1997` as `sales_fact_1997` where `sales_fact_1997`.`customer_id` = `customer`.`customer_id` group by `customer`.`gender` order by ISNULL('c0') ASC, `c0` ASC] did not occur
  2. 0

    GitHub comment 795#265075392

    GitHub | 2 months ago | wingman-pentaho
    junit.framework.AssertionFailedError: expected query [select `store`.`store_country` as `c0`, `store`.`store_state` as `c1` from `store` as `store` group by `store`.`store_country`, `store`.`store_state` having UPPER(c1) REGEXP '.*CA.*' order by ISNULL(`store`.`store_country`) ASC, `store`.`store_country` ASC, ISNULL(`store`.`store_state`) ASC, `store`.`store_state` ASC] did not occur
  3. 0

    PA_CR_PA-3.9.X_presto-0.100 - Pentaho Analysis - Pentaho Wiki

    pentaho.com | 6 months ago
    java.lang.AssertionError: Expected sql was not executed: select sum(agg_c_10_sales_fact_1997.customer_count) m0 from agg_c_10_sales_fact_1997 agg_c_10_sales_fact_1997
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I have the error at app.error called "cannot open file at line 30090 "

    Stack Overflow | 1 year ago | patil
    java.lang.RuntimeException: java.sql.SQLException: Problems executing Android query: SELECT * FROM `master_customer` WHERE `Id` = 5125
  6. 0

    A StarColumnPredicate references RolapStar.Column when used in an AggStar. The result is that the incorrect SQL is generated. For example, set Bug.<thisbug>Fixed=true and run mondrian.rolap.FastBatchingCellReaderTest.testAggregateDistinctCount3 with aggregates enabled, and you get the following error. mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select "store"."store_state" as "c0", "agg_c_14_sales_fact_1997"."the_year" as "c1", "agg_c_14_sales_fact_1997"."quarter" as "c2", sum("agg_c_14_sales_fact_1997"."unit_sales") as "m0" from "store" "store", "agg_c_14_sales_fact_1997" "agg_c_14_sales_fact_1997" where "agg_c_14_sales_fact_1997"."store_id" = "store"."store_id" and "store"."store_state" = 'CA' and "time_by_day"."the_year" = 1997 and "time_by_day"."quarter" in ('Q1', 'Q2') group by "store"."store_state", "agg_c_14_sales_fact_1997"."the_year", "agg_c_14_sales_fact_1997"."quarter"] at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755) at mondrian.olap.Util.newInternal(Util.java:1104) at mondrian.olap.Util.newError(Util.java:1120) at mondrian.rolap.SqlStatement.handle(SqlStatement.java:208) at mondrian.rolap.SqlStatement.execute(SqlStatement.java:138) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:284) at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:245) at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:337) at mondrian.rolap.agg.SegmentLoader.load(SegmentLoader.java:74) ... Note that "time_by_day"."quarter" occurs in the query. This column from the regular star schema is used in a predicate, but the predicate should have been translated to refer to columns in the AggStar. One way to fix this would do the long-deferred unification of RolapStar and AggStar. The class AggStar.Table.Column would go away, so predicates in an AggStar query could legimately refer to RolapStar.Column objects.

    Pentaho BI Platform Tracking | 10 years ago | Julian Hyde
    mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select "store"."store_state" as "c0", "agg_c_14_sales_fact_1997"."the_year" as "c1", "agg_c_14_sales_fact_1997"."quarter" as "c2", sum("agg_c_14_sales_fact_1997"."unit_sales") as "m0" from "store" "store", "agg_c_14_sales_fact_1997" "agg_c_14_sales_fact_1997" where "agg_c_14_sales_fact_1997"."store_id" = "store"."store_id" and "store"."store_state" = 'CA' and "time_by_day"."the_year" = 1997 and "time_by_day"."quarter" in ('Q1', 'Q2') group by "store"."store_state", "agg_c_14_sales_fact_1997"."the_year", "agg_c_14_sales_fact_1997"."quarter"]

  1. Adrien 6 times, last 2 weeks ago
  2. treefolk 1 times, last 1 month ago
  3. andyglick 1 times, last 2 months ago
4 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. junit.framework.AssertionFailedError

    expected query [select `customer`.`gender` as `c0` from `customer` as `customer`, `sales_fact_1997` as `sales_fact_1997` where `sales_fact_1997`.`customer_id` = `customer`.`customer_id` group by `customer`.`gender` order by ISNULL('c0') ASC, `c0` ASC] did not occur

    at junit.framework.Assert.fail()
  2. JUnit
    Assert.fail
    1. junit.framework.Assert.fail(Assert.java:47)
    1 frame
  3. mondrian.rolap
    BatchTestCase.assertQuerySqlOrNot
    1. mondrian.rolap.BatchTestCase.assertQuerySqlOrNot(BatchTestCase.java:523)
    1 frame