FB 2.1 using isql, connect with utf8 to a database with default charset
utf8. Then try this (commits excluded for brevity):
create table "Temp" ("Dummy" int);
insert into "Temp" ("Dummy") values (1);
select * from "Temp";
alter table "Temp" add "New" timestamp default '0001-01-01' not null;
select * from "Temp";
This will result in an error (actual transcript):
----------------------------------------------------------
SQL> select * from "Temp";
Dummy New
============ =========================
Statement failed, SQLCODE = -413
conversion error from string "00"
----------------------------------------------------------
If I try it without specifying a connection charset there's no error and
the expected default is returned upon select.
I tried also with e.g. '1901-01-01' and then it complains about "19"
instead, so it appears to be (at least) the century that causes problems.
Seems like some kind of bug to me.
Is it?
If yes, is it already known, or should I report it?
A workaround:
update "Temp" set "New" = '0001-01-01';
After that it seems to work.
Regards,
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kj...@datadia.se <mailto:kjell%40datadia.se>
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
__._,_.___
Reply to sender
<mailto:kjell.ri...@datadia.se?subject=Re%3A%20default%20for%20timestamp%20col%20causes%20error%3F>
| Reply to group
<mailto:firebird-supp...@yahoogroups.com?subject=Re%3A%20default%20for%20timestamp%20col%20causes%20error%3F>
| Reply via web post
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJya2Y2N3JzBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExMzE4MgRzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzMDM5MTY4MzE-?act=reply&messageNum=113182>
| Start a New Topic
<http://groups.yahoo.com/group/firebird-support/post;_ylc=X3oDMTJlOHIydG9vBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTMwMzkxNjgzMQ-->
Messages in this topic
<http://groups.yahoo.com/group/firebird-support/message/113182;_ylc=X3oDMTM4aWRoOXI4BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzExMzE4MgRzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzMDM5MTY4MzEEdHBjSWQDMTEzMTgy>
(1)
Recent Activity:
* New Members
<http://groups.yahoo.com/group/firebird-support/members;_ylc=X3oDMTJmMGVycmJrBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzEzMDM5MTY4MzA-?o=6>
6
Visit Your Group
<http://groups.yahoo.com/group/firebird-support;_ylc=X3oDMTJlMTc0MGFzBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTMwMzkxNjgzMA-->
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
MARKETPLACE
Stay on top of your group activity without leaving the page you're on -
Get the Yahoo! Toolbar now.
<http://global.ard.yahoo.com/SIG=15oes24q7/M=493064.14543979.14365478.13298430/D=groups/S=1705115386:MKP1/Y=YAHOO/EXP=1303924031/L=073ebdba-70e0-11e0-93a9-4bbd7ab25ec0/B=.zIUW0wNPGA-/J=1303916831801398/K=OyBWw0Z3.hwpF3csQheYpg/A=6060255/R=0/SIG=1194m4keh/*http://us.toolbar.yahoo.com/?.cpdl=grpj>
------------------------------------------------------------------------
Find useful articles and helpful tips on living with Fibromyalgia. Visit
the Fibromyalgia Zone today!
<http://global.ard.yahoo.com/SIG=15o20f1sa/M=493064.14543977.14365476.10835568/D=groups/S=1705115386:MKP1/Y=YAHOO/EXP=1303924031/L=073ebdba-70e0-11e0-93a9-4bbd7ab25ec0/B=_DIUW0wNPGA-/J=1303916831801398/K=OyBWw0Z3.hwpF3csQheYpg/A=6260316/R=0/SIG=11bc8n8gt/*http://custom.yahoo.com/fibromyalgiazone/>
Yahoo! Groups
<http://groups.yahoo.com/;_ylc=X3oDMTJkbzQ0NHMzBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzAzOTE2ODMx>
Switch to: Text-Only
<mailto:firebird-support-traditio...@yahoogroups.com?subject=Change%20Delivery%20Format:%20Traditional>,
Daily Digest
<mailto:firebird-support-dig...@yahoogroups.com?subject=Email%20Delivery:%20Digest>
• Unsubscribe
<mailto:firebird-support-unsubscr...@yahoogroups.com?subject=Unsubscribe> •
Terms of Use <http://docs.yahoo.com/info/terms/>
.
__,_._,___
--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell.ri...@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
