From Ingres Community Wiki

This page provides a complete index (WIP :)) of all known feature requests. If you would like to work on a feature, please read the information at Code Contributor which contains information around developing features in Ingres.

Requests are reviewed, prioritized and placed on product roadmaps, if appropriate, in the planning phase of each release.

Features, as added, will be noted as to whether they are Easy or Challenging.

The following projects are currently being scoped. They are high priority projects that will be implemented in an upcoming version of Ingres.

Contents 1 High Priority Projects Awaiting Resources 2 High Priority Projects Under Discussion 3 Decision Support Projects 4 Performance Projects 5 DBMS 6 DBA Tools 7 Tools/Utilities 8 OpenROAD 9 Ingres Connectivity (Authentication, Ingres/Net, etc.) 10 JDBC 11 ODBC 12 .NET 13 PHP 14 Python 15 Ruby 16 OpenAPI

High Priority Projects Awaiting Resources

	Priority	Project	Team Lead	Availability
		Efficient Storage of Varchars and LOBs	Steve Ball	Currently Available in
	2	Auditing Improvements
	2	DBMS Enhancements for PHP Support		Currently Available in
	4	Improved ADF Efficiency		Currently Available in
	3	Expanded Query Cache		Currently Available in
	5	Copy.In Defaults		Currently Available in
		Ingres 64-bit Port on Windows	Viktoriya Driker	Currently Available in
		Configurable Installer	Durwin Wright	Not Started

High Priority Projects Under Discussion

	Project	Team Lead	Availability
	XML Enhancements	Teresa King
	DB admin commands Enhancements	usermod & optimizedb

RollforwardDB Enhancements

Decision Support Projects

	Project	Team Lead	Availability
	TPC-DS Adaptation	Dan Koren
	Intercept/Except
	OLAP Functions
	With Lists
	Enhanced Partitioning And Group by
	Implement Side Projects

Performance Projects

DBMS

DBMS Feature	Description
SQL Enhancements	Extend Ingres SQL support to provide user requested functionality, implement SQL-2003 non-core functionality and support a broader range of applications
132541	Implement Search condition boolean and boolean data types
132540	Implement scalar subqueries to SQL-2003 F471 specification
132356	New configuration parameter to override isolation level
108795	update from aggregate; i.e. update a table w/ the results of an aggregated select...update tablea set columna = (select sum(columnb) from tableb);
112485	SQL -s (Completely) Silent Enhancement request. Remove the lines between the titles, the column headers and +-----+ lines once a query is executed in Ingres
112926	Need ability for subselects in case statements; for example: select distinct table_name, case when table_owner in (select distinct table_owner from iitables) then 'a' else 'b' end as owner from iitables
115808	Pattern matching in LOCATE function. Can Ingres be enhanced so that either LOCATE can search for a pattern, or a new function introduced	Will be available in 9.3 for Linux/Windows; rolled out to all platforms with Ingres 10
121911	Enhancement request for subselects to be supported inside join syntax
123064	New aggregate function percentile_cont()
124644	Request for SQL function to generate statistics on individual table Function call example in proposed typical usage: modify table_name to btree on my_column1, my_column3; create index index_name1 on table_name (my_column4) create statistics on table_name on (all keys) / columns (my_column2, my_column5)
126138	INTERSECT, EXCEPT; Implement the ANSI-SQL extensions for standard INTERSECT and EXCEPT functionality
126139	Result query row counts; Basically, this is the ability to issue a query and return the rowCount independently and irrespective of whether they actually request the rows to be returned.
126515	Enhancement: SQL Function to determine whether table exists; both for session tables and real tables as well
126659	RAAT (Row at a Time) support with Ingres 64 bit (Needed for application Support - Manufacturing Knowledgebase - MK - and Masterpiece)
127940	Enhancement for select in Sql; We can do "SELECT FIRST 300 * FROM mytable" but there is no way to say start at 200.
132583	Support for Defacto Standards

New Performance Enhancements	Extend and enhance Ingres performance.
	First N Optimization
104221	Performance using or in select(or delete) stat
122520	4GB+ : tables display performance is poor for great 4GB+ tables when using the tables utility report option

Star Enhancements	Extend Ingres Star to provide more core DBMS functionality. As new features and functions are added to Ingres, an assessment should be made as to whether Star should also provide that functionality. The list below represents a set of features that should be considered for inclusion in Star ASAP.
107663	Using DBMSINFO it is not possible to get the session_id when using Ingres Star.
113246	Star issue 15488902. 3.0.3 does not start autom
125666	Enhancement request: Alllow the usage of sequence
125669	Enhancement Request: database links within Ingres
132310	Ingres Star and Row Returning Procedures

Install Enhancements	Provide a configurable, robust installer that will provide standalone drive installs as well as custom installers for rollout
132535	Set Auto Table Structure ON, Set Transaction Integrity ON
113583	Ingres/NET install on Shared directory
120244	Can we have a stand alone ODBC driver with Ingres
121541	QA Installer from Ingres 2.6 sp6 used several la
123912	QA upgrade leaves unupgraded components enabled
123920	Upgrading Ingres from II 2.6 to 2006 the Datasouce
126575	There is a need for a smaller footprint Ingres Net
127085	QA - install.sh, express install option should ask

Identifier Enhancements	Description
Long Identifiers	Ability to create an object name with > 32 Characters
127579	Creating Username in Email Format With Name > 32 Characters
120367	Ingres and username that starts with a digit.
120967	create user root-itsd with privileges... fails due
137032	CAllow using space ' ' and dot '.' within user name
125231	Accessdb fails to execute as user zsarmail.singh w

IMA Enhancements	Expand the current functionality of the Ingres Management Architecture to support Proactive Services
102729	Is there a column on a table where it contains the DATE a user was added to ingres using the accessdb utility
127998	ER - DMF420 Equivalent information from IMA
129032	Query IMA to see if a database is being checkpoint

Trace Enhancements	Extend and enhance Ingres trace capabilities.
114290	Enhancement request - The output from all Trace points output to a standard destination.
117618	ER: Please add Server Site Tracing for SQL Statame
127999	ER - set trace output to append rather than overwr
102217	Printqry trace should display date values for repeated, ABF and OpenROAD queries
102218	Printqry trace should display date values for repeated, ABF or OpenROAD queries

Backup Enhancements	Provide more flexibility for Ingres Hot Backup
120193	Checkpoint flag to simulate backup retention.
120569	DataWare House: ckpdb of 2 terabyte database to ma
121886	Enhancement Request to allow checkpoints be syncho
128183	Enhancement Request - Create config parameters to
131911	checkpoint template should allow to store the dire
132357	rollforwarddb could inform the user that an aaaaaaaa.rfc file is used

Trigger Enhancements	Expand trigger support
130204	Enhancement: make old value of large objects available in after rules
130205	Enhancement: Allow updating statements triggered by before rules

Stored Procedure Enhancements	Expand and enhance Ingres Stored Procedure support.
129241	ANSI Date defaults within a Database procedure are
129843	Database procedures to automatically check the error condition on entry

Bulk Loading Projects	Improve and enhance Ingres data loading and unloading capabilities.
107731	Copy From performance in Open API versus ESQL
117660	environment variables and reload
117830	Problem to use unloaddb (follows issue 115515)
118612	Enhancement request: Ingres Export Assistant - mor
131658	ER: unloaddb fails if db contains large number objects (memory exceeded)

Error Handling Enhancements	Improve and enhance Ingres error handling.
119170	installation of pre-compilers is not documented
110482	More Information Needed with "Security" messages: Add User ID to message
126382	E_DM008A_ERROR_GETTING_RECORD not required in errl
127000	Errorno : 26 reported error message should be more explicit.
128669	improved ingstart message
131813	It's possible to detect the constraint name or column which raised exception

Patch Enhancements	Improve and enhance Ingres patch distribution and application.
104335	STAR 14776131: Can we have a -backout flag for patchupdate that automatically backs out the patch
106277	STAR: 14884427 Please can we have patches for ALL
120421	APPLYING HP2 PATCH ON HPB INSTALLATION
121919	Anoying Patch-controls without questions during pa
129653	Enhancement request: Errorstatus when installing patch

Security Enhancements	Extend and enhance Ingres security capabilities.
	Enhanced row level auditing
107791	Request for FIPS 140-2 Compliance in Ingres 2006/2
119577	Implement MD5() cryptographic hash function with a 128-bit hash value
130953	Prevent reading table structurs via ODBC or sql

Replication Enhancements	Extend and enhance Ingres replication capabilities.
103540	Please add a "keep alive" option to replicator and/or NET.
120685	Start Replicator via Ingstart
122104	QA undocumented replicator commands
128768	repcfg functionality is incomplete

Miscellaneous Enhancements	Various enhancement requests.
SIR #	Description	Category
127579	Creating Username in Email Format With Name > 32 C	Long Names
109066	The ABF systax for the SELECT statement does not include the CASE	ABF
107358	STARTRAK ISSUE: 14187579;03 Each access to a table causes 4 audit messages to be generated to the Windows Security Log	Audit
129729	Need standalone infodb	Availability
102215	Increase length of printqry buffer from 2000 bytes	Limits
131374	limit of 67,108,863 Table IDs in Ingres	Limits
117663	Allow partitioned secondary indices	Partitioning
127315	Setting uppercase display attribut of Ingres form	QBF
110814	data generated by statdump or optimizedb -o cannot be reloaded into a database if the source databse was a Unicode database when statistics for byte data fields exists.	Unicode
101117	I'd like to suggest what I think would be a couple improvements to your usermod utility.	Utilities
114541	QA - vms cluster lacks load-balancing functionalit	VMS
107887	result of query can be exported as an xml file	XML
100616	Windows release requires a certain amount of virtu
100948	Modify to ISAM
101027	IVM RECOVERY SERVER RED (dmfrcp need not be registered with the iigcn )
106502	function _build which returns details of the date, machine and source path used to build the current installation
107431	Compress errlog.log and uncompress it while Ingres
107752	Numeric Overflow Handling setting/detection How do I set the numeric overflow handling from within my application
108797	ansi datetime compatibility w/ Ingres datetime
111982	creating table statistics for all tables regardless of owner
114088	QA - servicepassword not encrypted in a custom cre
114291	Q? INTERNATIONAL LANGUAGE SUPPORT II_LANGUAGE=FRA returns error
115196	QA - Ingres bundled with Icebreaker - IngresDBA service permanent failure errors in rAA UI Log and Shared Memory error when Ingres is shutdown.
116406	Ingres hangs during reboot
118448	Enhancement request: Abiliity to kill sessions in
118733	Keep on going opf_new_enum feature and do not log E_OP04C0_NEWENUMFAILURE in errlog.log.
118741	Is there a way to limit work disk on a per session
118965	International Language Message File Support
118971	the ability to set a database to read-only and bac
119372	Help for Visual DBA - II_PROMPT1 or II_PROMPTALL r
119925	Support Veritas Cluster
120668	Running of IIZIK/IIZCK on hybrid installations
120861	Need Long Nvarchar -> Long Varchar Coercion
121142	QA - automatic firewall rule updates with ingres i
121718	Create a dedicated age to Startup and Shutdown Ing
122820	ing_system_set on remote clients
124649	Issue with using float params calling C procedures
125628	Please can relocatedb relocate multiple locations
125821	Client needs to be able to delet more than 100 row
126053	ability to load all information needed to reproduce QEP
126415	Enhancement: Allow interval in SAVE statement
127458	vCBF allows incompatible configuration
127726	set norules - allow DBA to use without trace privilege
128346	Getting CBF to recognize increased CHANNELCNT
129108	Verifydb -mreport -odbms_catalogs reports misleadi
130852	ER: stats of consumption of GTT in memory vs. disk
131122	Client is asking to have qef_maxmemf like for opf_maxmemf
134121	Unable to materialize a LOB locator via a SCROLLABLE CURSOR

For additional features already in progress, go here.

DBA Tools

DBMS Feature	Description

Tool Enhancements	Provide a set of cross-platform, robust tools for managing Ingres. The requests below should be considered when designing the new toolset.
100973	IPM doesn't show Ingres servers with a server class d different from INGRES
101017	STARTRAK Issue 14092850 Definition: rmcmd doesn't report if execution of a command has failed (it doesn't provide the command exit code)
107792	usability for people that are visually impaired, such as - alternative keyboard navigation
108780	Accessdb refuses to allow me to create a location
115586	Ingres Visual Manager and errlog.log
117481	Usermod parameters "don't do empty tables"
117488	Usermod parameters - perform a full DB usermod
117661	create sql script with usermod
126649	How to get the full size of my database on disk ?
127313	isql tool to prompt before quitting when Quit function key is pressed
127950	VDBA allows create table with '-' in table name, b
101117	I'd like to suggest what I think would be a couple improvements to your usermod utility.

For additional features already in progress, go here.

Tools/Utilities

DBMS Feature	Description

113669	Star issue 15522479-01. genxml does not export Parent: 113671 #Child: 0
113671	Star issue 15522479-02. genxml crashes while ex Parent: #Child: 1

OpenROAD

OpenROAD Feature	Description

For additional features already in progress, go here.

Ingres Connectivity (Authentication, Ingres/Net, etc.)

Ingres Connectivity (Authentication, Ingres/Net, etc.) Feature	Description
111847	Enhancement required to configure Ingres on Solaris for LDAP authentication.
117659	LDAP for remote connections
128068	Enhancement required to configure Ingres on Linux for LDAP authentication
119327	DBMS password only User authentication: Allow a "DBMS password only" user authentication, when connecting to the database via Ingres/NET, JDBC, .NET etc.
118926	Make the GCC processes multithreaded
131895	Netutil: Increase password length allowed in Vnode Definition

DAS Feature	Description
118772	Enhancement RequestL JDBC & DAS Logs are stored in $II_SYSTEM/ingres/files by default
127694	Provide a way to configure the DAS server so connections from certain applications can be allowed/disallowed

For additional features already in progress, go here.

JDBC

JDBC Feature	Description
107357	copy table fails in java program on R3 and 2.5 d
118772	Enhancement RequestL JDBC & DAS Logs are stored in $II_SYSTEM/ingres/files by default
119214	JDBC: allow the usage of installation passwords
119327	DBMS password only User authentication: Allow a "DBMS password only" user authentication, when connecting to the database via Ingres/NET, JDBC, .NET etc.
127655	JDBC: problem with getPrimaryKeys()
128128	.NET/JDBC - Allow parameter markers in SELECT clau

For additional features already in progress, go here.

ODBC

ODBC Feature	Description
119327	DBMS password only User authentication: Allow a "DBMS password only" user authentication, when connecting to the database via Ingres/NET, JDBC, .NET etc.
119833	SQL-Long varchars up to 2000 in length could be mapped to Ingres Varchar instead of Ingres Long Varchar.
105164	COMMIT cannot be used in procedures called through ODBC by 'execute procedure'.

For additional features already in progress, go here.

.NET

.Net Feature	Description
107572	The ODBC Driver maps returns tinyint as int4. The .NET Data Provider returns tinyint as a Signed Byte. Provide an option for the .NET Data Provider to return tinyint as int4.
119327	DBMS password only User authentication: Allow a "DBMS password only" user authentication, when connecting to the database via Ingres/NET, JDBC, .NET etc.
117315	Strengthen the Ingres .NET Data Provider's integration with Visual Studio 2005/2008 web application development to the same level as the current Windows forms development.
132154	Ingres .NET Data Provider requires improved integration with MS-SQL 2008 Mangement Studio: Require integration of Ingres with SSIS and specifically with the Import and Export Wizard.

For additional features already in progress, go here.

PHP

PHP Feature	Description

For additional features already in progress, go here.

Python

Python Feature	Description

For additional features already in progress, go here.

Ruby

Ruby Feature	Description

For additional features already in progress, go here.

OpenAPI

OpenAPI Feature	Description
134121	Unable to materialize a LOB locator via a SCROLLABLE CURSOR

For additional features already in progress, go here.