Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20023

Implement Oracle TRUNC() function

    XMLWordPrintable

Details

    Description

      This function is commonly used in Oracle PL/SQL or queries to truncate various data types for instance;

      1. TRUNCATE a fraction from a number
      2. TRUNCATE a timestamp portion of a date/datetime/timestamp values

      TRUNC(DATE/DATETIME/TIMESTAMP): https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions201.htm

      TRUNC(NUMBER): https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions200.htm

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37414 SIGSEGV in Binary_string::c_ptr | Item_func_trunc::get_date

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-35973 Oracle Compatibility Project 1 for 2025

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Activity

            People

              monty Michael Widenius
              Faisal Faisal Saeed (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0.5d Original Estimate - 0.5d
                  0.5d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 3d 6.5h
                  3d 6.5h

                  Git Integration

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