Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-5816

[QE] (7.0.z) [HHH-11073] Casting to boolean in query fails on MySQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.0.3.GA
    • None
    • Hibernate
    • None

    Description

      https://hibernate.atlassian.net/browse/HHH-11073

      Hibernate converts a query like:

      select cast( true as boolean ) ...

      to SQL:

      select cast ( 1 as bit ) ....

      Instead, Hibernate should be converted to SQL:

      select cast ( 1 as char ) ....

      Attachments

        Issue Links

          clones

          Bug - A problem that impairs or prevents the functions of the product. JBEAP-5815 [HHH-11073] Casting to boolean in query fails on MySQL

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Verified
          is incorporated by

          Component Upgrade - A task tracking an update to a bundled component or revision of component upstream of the project. JBEAP-4292 [GSS](7.0.z) Upgrade to Hibernate ORM 5.0.11.Final when available

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Verified
          relates to

          Bug - A problem that impairs or prevents the functions of the product. JBEAP-4614 [GSS] (7.0.z) HHH-10757 HHH-9021 : "select new ..." with CAST( NULL AS ...) fails with QuerySyntaxException: unexpected AST node: NULL

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Verified

          Activity

            People

              gbadner@redhat.com Gail Badner (Inactive)
              msimka@redhat.com Martin Simka
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: