Running SQL Script with certain characters leads to big problems.

Details

Description

I have attached 2 scripts. They only differ in one character. If you try to import from SQL files in CUBRID Manager and select one of the files attached, then the outcome is the following:

  • test.sql : Success Count: 2, Fail Count: 0, Status: Finished
  • test2.sql : Success Count: 5, Fail Count: 0, Status: Finished

Because test.sql contains „ symbol, the script stops at that line and does not process the remaining lines nor give an error.

It is a blocker bug especially because:
1. it works in csql and in the new query window in CM
2. it does not give any error (it just states finished correctly)
3. the line containing the „ symbol and all the following lines are not imported (even if they don't contain the symbol).

  1. File
    test.sql
    14/Nov/12 4:25 AM
    2 kB
    Veliscu Ovidiu
  2. File
    test2.sql
    14/Nov/12 4:27 AM
    2 kB
    Veliscu Ovidiu

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Veliscu Ovidiu added a comment -

Same problem occurs for ” and ’ (and maybe other symbols also)

Show
Veliscu Ovidiu added a comment - Same problem occurs for ” and ’ (and maybe other symbols also)
Hide
Permalink
Laura Oh added a comment -

because of the issue, only part of records were inserted. Please look into the issue.

Show
Laura Oh added a comment - because of the issue, only part of records were inserted. Please look into the issue.
Hide
Permalink
Veliscu Ovidiu added a comment -

We found the problem occurrence. It is not due to the symbols.

For some reason, the import script -> add sql file fails when a content variable contains an odd number of double quotes (") inside it.

The reason test.sql fails is because there is only one " (double quote). It lead to a heap of problems trying to import the record data.

Example of record that failed to load correctly:
'test value here" with one double quote'

Show
Veliscu Ovidiu added a comment - We found the problem occurrence. It is not due to the symbols. For some reason, the import script -> add sql file fails when a content variable contains an odd number of double quotes (") inside it. The reason test.sql fails is because there is only one " (double quote). It lead to a heap of problems trying to import the record data. Example of record that failed to load correctly: 'test value here" with one double quote'
Hide
Permalink
Veliscu Ovidiu added a comment -

When I replaced ” and „ with double quotes, Run SQL File worked (even though import file still did not). With these 2 symbols instead of double quotes, the problem occurs for both Run SQL File and Import SQL File.

Show
Veliscu Ovidiu added a comment - When I replaced ” and „ with double quotes, Run SQL File worked (even though import file still did not). With these 2 symbols instead of double quotes, the problem occurs for both Run SQL File and Import SQL File.
Hide
Permalink
高艳铭 added a comment -

Fixed in CM8.4.3.3009

Show
高艳铭 added a comment - Fixed in CM8.4.3.3009
Hide
Permalink
高艳铭 added a comment -

Fixed in CQB8.4.3.3009

Show
高艳铭 added a comment - Fixed in CQB8.4.3.3009

People

  • Assignee:
    高艳铭
    Reporter:
    Veliscu Ovidiu
Vote (0)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved: