db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Myers <david.myers.scibearsp...@gmail.com>
Subject Error 42x71:Type de donnÚes 'BOOLEAN' non valide: when doing a Create Table [table] as Select * from [otherTable] with no data
Date Thu, 06 Sep 2012 08:45:44 GMT
Hello all.

I suspect this may be a bug, but how to test!

below is the following command I entered into IJ

create table admin.GROSSESSE as select * from S1.GROSSESSE with no data;
ERREUR 42X71 : Type de donnÚes 'BOOLEAN' non valide pour la colonne 'ECHO'.

Just to demonstrate that the table S1.Grossesse exists I ran a
describe... here is the result

ij> describe S1.Grossesse;
COLUMN_NAME         |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
QGROSSESSE          |INTEGER  |0   |10  |10    |NULL      |NULL      |NO
OBS                 |VARCHAR  |NULL|NULL|9     |NULL      |18        |NO
DDR                 |TIMESTAMP|9   |10  |29    |NULL      |NULL      |YES
TERME               |TIMESTAMP|9   |10  |29    |NULL      |NULL      |YES
FECNORM             |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
FECINVIVO           |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
QANOMALIE           |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
DEXAM               |TIMESTAMP|9   |10  |29    |NULL      |NULL      |YES
ECHO                |BOOLEAN  |NULL|NULL|1     |NULL      |NULL      |YES
AMNIO               |BOOLEAN  |NULL|NULL|1     |NULL      |NULL      |YES
AFP                 |BOOLEAN  |NULL|NULL|1     |NULL      |NULL      |YES
AUTRE               |BOOLEAN  |NULL|NULL|1     |NULL      |NULL      |YES
EXINFO              |VARCHAR  |NULL|NULL|255   |NULL      |510       |YES
NPREVAB             |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
MED                 |VARCHAR  |NULL|NULL|255   |NULL      |510       |YES
SORTIE              |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
FACEVO              |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
FACDETAIL           |LONG VAR&|NULL|NULL|32700 |NULL      |NULL      |YES
GNOM                |VARCHAR  |NULL|NULL|100   |NULL      |200       |YES
GPNOM               |VARCHAR  |NULL|NULL|100   |NULL      |200       |YES
GADDR               |VARCHAR  |NULL|NULL|100   |NULL      |200       |YES
GTYPE               |VARCHAR  |NULL|NULL|50    |NULL      |100       |YES
GTEL                |VARCHAR  |NULL|NULL|14    |NULL      |28        |YES
GFAX                |VARCHAR  |NULL|NULL|14    |NULL      |28        |YES

And to confirm that the schema 'admin' really exists...

ij> show tables in admin;
TABLE_SCHEM         |TABLE_NAME                    |REMARKS
------------------------------------------------------------------------
ADMIN               |CAPSULE                       |
ADMIN               |CL_AINT                       |
ADMIN               |CL_ALD                        |
ADMIN               |CL_AP                         |
ADMIN               |CL_AUM                        |
ADMIN               |CL_BOOLYN                     |
ADMIN               |CL_CMAGE                      |
ADMIN               |CL_CMLOC                      |
ADMIN               |CL_CMTYP                      |
ADMIN               |CL_DSI                        |
ADMIN               |CL_HBIBE                      |
ADMIN               |CL_HBIDA                      |
ADMIN               |CL_HBIMA                      |
ADMIN               |CL_LONG                       |
ADMIN               |CL_MOTIF                      |
ADMIN               |CL_Q1A6                       |
ADMIN               |CL_SEX                        |
ADMIN               |CL_STOMIE                     |
ADMIN               |CL_USER_TYPE                  |
ADMIN               |CM                            |
ADMIN               |DM                            |
ADMIN               |DVD                           |
ADMIN               |EQUIPE_INFO                   |
ADMIN               |EX                            |

So the schema exists:

So I did a quick test, creating a new table 'boolTest'

create table app.boolTest (boolTest Boolean);
0 lignes insÚrÚes/mises Ó jour/supprimÚes
describe app.boolTest;
COLUMN_NAME         |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
BOOLTEST            |BOOLEAN  |NULL|NULL|1     |NULL      |NULL      |YES

So the 'boolean' word definately works, just not in the instance of a
create table as statement.

Anyone got any ideas?

David
What else can I now do?

Mime
View raw message