Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2385

Add support in clients for boolean, tinyint, largeint unsigned datatypes

    XMLWordPrintableJSON

Details

    Description

      Support for new datatypes was added for tinyint, boolean, largeint unsigned in sql engine.

      Those are tracked by following jiras:
      JIRA TRAFODION-2086 Add support for largeint unsigned datatype
      JIRA TRAFODION-2099 Add support for Boolean datatype
      JIRA TRAFODION-2060 Add support for native tinyint datatype

      Connectivity clients (odbc, jdbc t2/t4, linux, windows, trafci) need to
      enhanced to add this support. There may also be some work needed
      in mxosrvr layer. Until that is done, these datatypes cannot be used
      for reading values or input params from these clients.

      For now, these datatypes are converted to equivalent datatypes before input/output from clients.

      To enable these datatypes, use these cqds:

      For tinyint:
      cqd traf_tinyint_return_values 'ON';
      cqd traf_tinyint_input_params 'ON';

      For boolean:
      cqd traf_boolean_io 'ON';

      For unsigned largeint:
      cqd traf_largeint_unsigned_io 'ON';

      These cqds are turned ON when request comes in from sqlci.

      Once support for these datatypes is added to clients, they will be turned
      on by default.

      core/sql/regress/seabase/TEST003 contains examples of usage of these datatypes. First cut should be to make sure they work from trafci/jdbcT4.

      Attachments

        Activity

          People

            Unassigned Unassigned
            anoopsharma Anoop Sharma
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: