|
Replies:
2
-
Pages:
1
-
Last Post:
Aug 28, 2012 9:29 AM
by: Scott M. Sanders
|
|
|
Posts:
2
Registered:
4/16/12
|
|
|
|
BUG in ALTER TABLE SQL Script
Posted:
Apr 16, 2012 6:37 AM
|
|
|
This option generates incorrect SQL
ALTER TABLE table
CHANGE bAcrive bAcrive BIT DEFAULT '0';
Corrrect SQL:
ALTER TABLE table
CHANGE bAcrive bAcrive BIT DEFAULT b'0';
|
|
|
Posts:
2
Registered:
4/16/12
|
|
|
|
Re: BUG in ALTER TABLE SQL Script
Posted:
Apr 16, 2012 6:42 AM
in response to: przemyslaw.rach...
|
|
|
Another bug
When using ALTER TABLE from Menu I have got
ALTER TABLE table
CHANGE bAcrive bAcrtive BIT DEFAULT 'b\'1\'';
Valid SQL is:
ALTER TABLE table
CHANGE bAcrive bAcrtive BIT DEFAULT b'1';
|
|
|
Posts:
40
Registered:
1/27/11
|
|
|
|
Re: BUG in ALTER TABLE SQL Script
Posted:
Aug 28, 2012 9:29 AM
in response to: przemyslaw.rach...
|
|
|
Bump: Fix please? It happens in the latest 6.3.
I have to copy the alter table SQL to an Editor, correct it myself, and execute it from there.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
