Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-409

PowerBI measure with text filter raises SQL syntax error

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.1.20
    • None
    • General
    • None
    • Power BI Desktop

    Description

      Hello,

      I have an error when working with one of my column, every others are fine. I attached it.
      I don't know if that can help, but when I do the exact same thing on other columns of the database it works fine, but for this specific column 'ad' it isn't working. It is a CHAR column with a maximum size of 1.

      I can't share access to the database here as it is public, but I would happily share the access via mail.
      If you have any question you can ask me.

      have a good day
      Florian

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. ODBC-312 PowerBI import data with text filter raises SQL syntax error (Reproducible!)

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. ODBC-358 PowerBI mixed mode SQL with cast() in WHERE clause

          • Major - Major loss of function.
          • Open

          Activity

            Lawrin Lawrin Novitsky added a comment -

            Thank you for your report. There is no need to give us access to the database. What we would need is problematic table structure and how to re-create the problem in PowerBI. Other useful thing could be ODBC trace for the issue.

            There were couple of somehow similar issues, in some cases people could find a workaround. I will link them here

            Lawrin Lawrin Novitsky added a comment - Thank you for your report. There is no need to give us access to the database. What we would need is problematic table structure and how to re-create the problem in PowerBI. Other useful thing could be ODBC trace for the issue. There were couple of somehow similar issues, in some cases people could find a workaround. I will link them here

            People

              Lawrin Lawrin Novitsky
              frieupet Florian Rieupet
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.