db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kasper, Kay" <kay.kas...@ckc.de>
Subject null-columns in select-statement
Date Thu, 07 Jun 2007 14:26:25 GMT
Hi,

i try to use a select-statement like this

"(select col1, col2, null, col4 from tablex)"

in an insert-statement.

As a result i get an SQLException with state 42X01, code 30000 that says
syntax error at null.

Even if i use a very simple statement like (i created a table like DUAL in
Oracle)

"select 'x', null from dual"

i get the same message.

I tried null-columns in select-statements with UNION ALL, which is very
common, i get the syntax error.

Whats wrong? In my opinion this should work without any problems.


Thanks for your help.

Kay



--------------------------
ckc ag
Sitz:
Industriestr. 10
38110 Braunschweig

Telefon 05307 / 80 20 0
Telefax 05307 / 80 20 444
http://www.ckc.de

Amtsgericht Braunschweig
HRB 5405

Vorstand:
H.-G. Christian Krentel
(Vorsitzender)

Aufsichtsrat:
Dr. Heinz-Werner Weinrich
(Vorsitzender)
Hans Bodenstein
Dr. Rita Schulz
--------------------------


Mime
View raw message