[Info-ingres] Re: SV: SV: [Info-ingres] A varchar with no length

#1

Hi Henrik,

Quote:

It seems like it's still possible to create a table with our Ingres
2.6-release (patched uptil july 2005) but it's not crashing the
server, or destroying a select, as it used to :-)

Created on Ingres 2.6/0305 (axp.osf/00) Patch 10967 with this simple
but stupid select. Anybody out there feel like testing on Ingres 2006?

Create table hgstab as select table_type, dummy = null from iitables;
I've just tested that on II2.6/0305 patch 10993 and patch 11450

and in the both cases the create fails with:
E_US07E0 CREATE TABLE: Improper use of NULL in the target list;
use conversion function to specify data type of the null value.
(Wed Mar 22 11:38:07 2006)

It also fails with that error on II 2.6/0305 (int.lnx/00) patch 9892

Ditto on II 3.0.2 (a64.lnx/111)

Marty

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[Info-ingres] Re: SV: SV: [Info-ingres] A varchar with no length

comp.databases.ingres comp.databases.ingres

[Info-ingres] Re: SV: SV: [Info-ingres] A varchar with no length - 03-22-2006 , 05:45 AM